On the Production of Anorexic Plan Diagrams

A "plan diagram" is a pictorial enumeration of the execution plan choices of a database query optimizer over the relational selectivity space. We have shown recently that, for industrial-strength database engines, these diagrams are often remarkably complex and dense, with a large number of plans covering the space. However, they can often be reduced to much simpler pictures, featuring significantly fewer plans, without materially affecting the query processing quality. Plan reduction has useful implications for the design and usage of query optimizers, including quantifying redundancy in the plan search space, enhancing useability of parametric query optimization, identifying error-resistant and least-expected-cost plans, and minimizing the overheads of multi-plan approaches. We investigate here the plan reduction issue from theoretical, statistical and empirical perspectives. Our analysis shows that optimal plan reduction, w.r.t. minimizing the number of plans, is an NP-hard problem in general, and remains so even for a storage-constrained variant. We then present a greedy reduction algorithm with tight and optimal performance guarantees, whose complexity scales linearly with the number of plans in the diagram for a given resolution. Next, we devise fast estimators for locating the best tradeoff between the reduction in plan cardinality and the impact on query processing quality. Finally, extensive experimentation with a suite of multi-dimensional TPCH-based query templates on industrial-strength optimizers demonstrates that complex plan diagrams easily reduce to "anorexic" (small absolute number of plans) levels incurring only marginal increases in the estimated query processing costs.

Biofuel production and implications for land use, food production and environment in India

There is a large interest in biofuels in India as a substitute to petroleum-based fuels, with a purpose of enhancing energy security and promoting rural development. India has announced an ambitious target of substituting 20% of fossil fuel consumption by biodiesel and bioethanol by 2017. India has announced a national biofuel policy and launched a large program to promote biofuel production, particularly on wastelands: its implications need to be studied intensively considering the fact that India is a large developing country with high population density and large rural population depending upon land for their livelihood. Another factor is that Indian economy is experiencing high growth rate, which may lead to enhanced demand for food, livestock products, timber, paper, etc., with implications for land use. Studies have shown that area under agriculture and forest has nearly stabilized over the past 2-3 decades. This paper presents an assessment of the implications of projected large-scale biofuel production on land available for food production, water, biodiversity, rural development and GHG emissions. The assessment will be largely focused on first generation biofuel crops, since the Indian program is currently dominated by these crops. Technological and policy options required for promoting sustainable biofuel production will be discussed. (C) 2010 Elsevier Ltd. All rights reserved.

Ferromagnetic transition and specific heat of Pr(0.6)Sr(0.4)MnO(3)

The critical properties of orthorhombic Pr(0.6)Sr(0.4)MnO(3) single crystals were investigated by a series of static magnetization measurements along the three different crystallographic axes as well as by specific heat measurements. A careful range-of-fitting-analysis of the magnetization and susceptibility data obtained from the modified Arrott plots shows that Pr(0.6)Sr(0.4)MnO(3) has a very narrow critical regime. Nevertheless, the system belongs to the three-dimensional (3D) Heisenberg universality class with short-range exchange. The critical exponents obey Widom scaling and are in excellent agreement with the single scaling equation of state M(H,epsilon) = vertical bar epsilon vertical bar(beta) f(+/-)(H/vertical bar epsilon vertical bar((beta+gamma)); with f(+) for T > T(c) and f(-) for T < T(c). A detailed analysis of the specific heat that account for all relevant contributions allows us to extract and analyze the contribution related to the magnetic phase transition. The specific heat indicates the presence of a linear electronic term at low temperatures and a prominent contribution from crystal field excitations of Pr. A comparison with data from literature for PrMnO(3) shows that a Pr-Mn magnetic exchange is responsible for a sizable shift in the lowest lying excitation.

Thermodynamic properties of Ln-O (Ln = La, Pr, Nd) solid solutions and their deoxidation by molten salt electrolysis

The lanthanide metals lanthanum, praseodymium and neodymium containing 2,200, 2,600, 1,850 mass ppm oxygen, respectively, were deoxidized to 20-30 ppm level at 1,073 K by an electrochemical method. The metal to be deoxidized was used as the cathode in an electrolysis cell which consisted of a graphite anode and molten CaCl2 electrolyte. The calcium metal produced at the cathode by electrolysis effectively deoxidized the lanthanide metal. Calcium oxide produced by deoxidation, dissolved in the melt. The liberation of carbon monoxide/dioxide at the anode was found to prevent accumulation of oxygen in the melt. For a quantitative discussion of the limits of deoxidation achievable by this technique, a thermodynamic investigation of the lanthanide-oxygen (Ln-O ; Ln = La, Pr, Nd) solid solutions was conducted. The lanthanide metal, yttrium and titanium samples were immersed in calcium-saturated CaCl2 melt, containing a small quantity of dissolved CaO, at 1,093 K. The oxygen potential of the melt and the Ln-O solid solutions were obtained from the oxygen content of yttrium samples at equilibrium, and the known thermodynamic properties of yttrium-oxygen solid solution. The results were confirmed by using Y/Y2O3 equilibrium to control the oxygen potential of the molten salt reservoir. The oxygen affinity of the metals was found to decrease in the order : Y > Ti > Nd > Pr > La. The deoxidation results are consistent with the thermodynamic properties of the RE-O solid solutions.

Production of niobium powder by electronically mediated reaction (EMR) using calcium as a reductant

Explored in this study is an electronically mediated reaction (EMR) route for the production of niobium powder using calcium as a reductant for niobium oxide (Nb2O5). Feed material, Nb2O5, and reductant calcium alloy containing aluminum and nickel were charged into electronically isolated locations in a molten salt (e.g. CaCl2) at 1173 K. The current flow through an external path between the feed and reductant locations was monitored. A current approximately 0.4 A was measured during the reaction in the external circuit connecting cathode and anode location. Niobium powder with low aluminum and nickel content was obtained although liquid Ca–Al–Ni alloy was used as the reductant. This clearly demonstrates that niobium metal powder can be produced by an electronically mediated reaction (EMR), without direct physical contact between feed (Nb2O5) and reductant (calcium). Mechanism of calciothermic reduction of Nb2O5 in the molten salt is discussed using an isothermal chemical potential diagram.

Anderson transitions in Ln1-x Sr x CoO3 (Ln═Pr or Nd)

Electrical conductivity measurements show that Ln1-x Sr x CoO3, (Ln = Pr or Nd) undergoes a non-metal-metal transition when x≈0 3. The d.c. conductivity of compositions with 0