Identifying Robust Plans through Plan Diagram Reduction

Estimates of predicate selectivities by database query optimizers often differ significantly from those actually encountered during query execution, leading to poor plan choices and inflated response times. In this paper, we investigate mitigating this problem by replacing selectivity error-sensitive plan choices with alternative plans that provide robust performance. Our approach is based on the recent observation that even the complex and dense "plan diagrams" associated with industrial-strength optimizers can be efficiently reduced to "anorexic" equivalents featuring only a few plans, without materially impacting query processing quality. Extensive experimentation with a rich set of TPC-H and TPC-DS-based query templates in a variety of database environments indicate that plan diagram reduction typically retains plans that are substantially resistant to selectivity errors on the base relations. However, it can sometimes also be severely counter-productive, with the replacements performing much worse. We address this problem through a generalized mathematical characterization of plan cost behavior over the parameter space, which lends itself to efficient criteria of when it is safe to reduce. Our strategies are fully non-invasive and have been implemented in the Picasso optimizer visualization tool.

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.

Ru(4+) ion in CeO(2) (Ce(0.95)Ru(0.05)O(2-delta)): A non-deactivating, non-platinum catalyst for water gas shift reaction

Hydrogen is a clean energy carrier and highest energy density fuel. Water gas shift (WGS) reaction is an important reaction to generate hydrogen from steam reforming of CO. A new WGS catalyst, Ce(1-x)Ru(x)O(2-delta) (0 <= x <= 0.1) was prepared by hydrothermal method using melamine as a complexing agent. The Catalyst does not require any pre-treatment. Among the several compositions prepared and tested, Ce(0.95)Ru(0.05)O(2-delta) (5% Ru(4+) ion substituted in CeO(2)) showed very high WGS activity in terms of high conversion rate (20.5 mu mol.g(-1).s(-1) at 275 degrees C) and low activation energy (12.1 kcal/mol). Over 99% conversion of CO to CO(2) by H(2)O is observed with 100% H(2) selectivity at >= 275 degrees C. In presence of externally fed CO(2) and H(2) also, complete conversion of CO to CO(2) was observed with 100% H(2) selectivity in the temperature range of 305-385 degrees C. Catalyst does not deactivate in long duration on/off WGS reaction cycle due to absence of surface carbon and carbonate formation and sintering of Ru. Due to highly acidic nature of Ru(4+) ion, surface carbonate formation is also inhibited. Sintering of noble metal (Ru) is avoided in this catalyst because Ru remains in Ru(4+) ionic state in the Ce(1-x)Ru(x)O(2-delta) catalyst.

Ce(0.67)Fe(0.33)O(2-delta) and Ce(0.65)Fe(0.33)Pt(0.02)O(2-delta): New water gas shift (WGS) catalysts

Ce(0.65)Fe(0.33)Pt(0.02)O(2-delta) and Ce(0.67)Fe(0.33)O(2-delta) have been synthesized by a new low temperature sonochemical method using diethylenetriamine as a complexing agent. Due to the substitution of Fe and Pt ions in CeO(2), lattice oxygen is activated in Ce(0.67)Fe(0.33)O(2-delta) and Ce(0.65)Fe(0.33)Pt(0.02)O(2-delta). Hydrogen uptake studies show strong reduction peaks at 125 C in Ce(0.65)Fe(0.33)Pt(0.02)O(2-delta) against a hydrogen uptake peak at 420 degrees C in Ce(0.67)Fe(0.33)O(2-delta). Fe substituted ceria, Ce(0.67)Fe(0.33)O(2-delta) itself acts as a catalyst for CO oxidation and water gas shift (WGS) reactions at moderate temperatures. The rate of CO conversion in WGS with Pt free Ce(0.65)Fe(0.33)O(2-delta) is 2.8 mu mol g(-1) s(-1) at 450 C and with Pt substituted Ce(0.65)Fe(0.33)Pt(0.02)O(2-delta) is 4.05 mu mol g(-1) s(-1) at 275 degrees C. Due to the synergistic interaction of the Pt ion with Ce and Fe ions in Ce(0.65)Fe(0.33)Pt(0.02)O(2-delta), the catalyst showed much higher activity for CO oxidation and WGS reactions compared to Ce(0.67)Fe(0.33)O(2-delta). A reverse WGS reaction does not occur over Ce(0.65)Fe(0.33)Pt(0.02)O(2-delta). The catalyst also does not deactivate even when operated for a long time. Nearly 100% conversion of CO to CO(2) with 100% H(2) selectivity is observed in WGS reactions even up to 550 degrees C. (C) 2011 Elsevier B.V. All rights reserved.

La-Doped Ba2In2O5 Electrolyte: Pechini Synthesis, Microstructure, Electrical Conductivity, and Application for CO Gas Sensing

Dense (Ba1―xLax)2In2O5+x (BLIO) electrolytes with different compositions (x = 0.4, 0.5, 0.6) were fabricated using powders obtained by the Pechini method. The formation of BLIO powders was investigated by using X-ray diffraction and scanning electron microscopy coupled with energy-dispersive X-ray spectroscopy. The calcination temperature and time were optimized. The sintered (Ba1―xLax)2In2O5+x electrolytes showed a relative density greater than ∼97%, and the major phase of three electrolyte compositions was indexed as a cubic perovskite. The electrical conductivity of BLIO ceramics at elevated temperatures in air was measured by ac-impedance spectroscopy. The activation energies for conduction in BLIO were 102 kJ mol―1 between 473 and 666 K and 118 kJ mol―1 between 769 and 873 K, which are comparable to that for 8 mol % yttria-stabilized cubic zirconia. Mixed-potential gas sensors utilizing BLIO-based electrolytes exhibited good sensitivity to different CO concentrations from ∼100 to ∼500 ppm and excellent selectivity to methane at around 873 K.

Self-Assembly of Metallamacrocycles Using a Dinuclear Organometallic Acceptor: Synthesis, Characterization, and Sensing Study

A dinuclear organometallic acceptor 4,4'-bis[trans-Pt(PEt(3))(2)(O(3)SCF(3))(ethynyl)]biphenyl (1) containing Pt-ethynyl functionality is synthesized. Multinuclear NMR ((1)H, (31)P, and (13)C), infrared (IR), and electrospray ionization mass spectrometry (ESI-MS) including single-crystal X-ray diffraction analysis established the formation of 1. Equimolar treatment of acceptor 1 separately with three different ``clip'' type ditopic donors (L(a)-L(c)) yielded [2 + 2] self-assembled three metallamacrocycles 2a-2c, respectively. These macrocycles were characterized by various spectroscopic techniques, and their sizes/shapes were obtained through geometry optimization using molecular mechanics universal force field (MMUFF) simulations. Attachment of unsaturated ethynyl functionality to biphenyl building unit helped to make the macrocycles (2a-2c) pi-electron rich and thereby fluorescent in nature. Furthermore, 2c in solution has been examined to be suitable for sensing electron-deficient nitroaromatic like picric acid, which is often considered as a secondary chemical explosive. The fluorescence study of 2c showed a marked quenching of initial emission intensity upon titrating with picric acid (PA), and it exhibited the largest fluorescence quenching response with high selectivity among various other electron deficient aromatic compounds tested.

An eight-connected metal organic framework based on Cu(5) clusters: Synthesis, structure, magnetic and catalytic properties

A reaction of copper acetate, 5-nitroisophthalic acid in a water-methanol mixture under solvothermal condition results in a new metal-organic framework compound, [Cu(5)(mu(3)-OH)(2)(H(2)O)(6){(NO(2))-C(6)H(3)-(COO)(2)}(4)]center dot 5H(2)O, (1). The compound contains Cu5 pentameric cluster units connected by 5-nitro isophthalate (NIPA) moieties forming a CdCl(2)-like layer, which are further connected by another NIPA moiety forming the three-dimensional structure. The water molecules in (1) can be reversibly adsorbed. The removal of water accompanies a change in the colour as well as a structural re-organization. Magnetic studies suggest strong antiferromagnetie correlations between the Cu5 cluster units. The compound (1) exhibits heterogeneous Lewis acid catalysis for the cyanosilylation of imines with more than 95 % selectivity. Compound (1) has been characterized by IR, UV-vis, TGA, powder XRD studies.

Coordination-driven self-assembly of 2D-metallamacrocycles using a shape-selective Pt(2)(II)-organometallic 90 degrees acceptor: design, synthesis and sensing study

Synthesis of a series of two-dimensional metallamacrocycles via coordination-driven self-assembly of a shape-selective Pt(2)(II)-molecular building unit incorporating carbazole-ethynyl functionality is described. An equimolar (1 : 1) combination of a Pt(2)(II)-organometallic 90 degrees acceptor, 1, with rigid linear ditopic donors (L(a) and L(b)) afforded [4 + 4] self-assembled octanuclear molecular squares, 2 and 3, in quantitative yields, respectively [L(a) = 4,4'-bipyridine; L(b) = trans-1,2-bis(4-pyridyl)ethylene]. Conversely, a similar treatment of 1 with an amide-based unsymmetrical flexible ditopic donor, L(c), resulted in the formation of a [2 + 2] self-sorted molecular rhomboid (4a) as a single product [L(c) = N-(4-pyridyl)isonicotinamide]. Despite the possibility of several linkage isomeric macrocycles (rhomboid, triangle and square) due to the different connectivity of L(c), the formation of a single and symmetrical molecular rhomboid (4a) as the only product is an interesting observation. All the self-assembled macrocycles (2, 3 and 4a) were fully characterized by multinuclear NMR ((1)H and (31)P) and ESI-MS analysis. Further structural insights about the size and shape of the macrocycles were obtained through energy minimization using density functional theory (DFT) calculations. Decoration of the starting carbazole building unit with Pt-ethynyl functionality enriches the assemblies to be more p-electron rich and luminescent in nature. Macrocycles 2 and 3 could sense the presence of electron deficient nitroaromatics in solution by quenching of the initial intensity upon gradual addition of picric acid (PA). They exhibited the largest quenching response with high selectivity for nitroaromatics compared to several other electron deficient aromatics tested.

Phenylboronic acids in crystal engineering: Utility of the energetically unfavorable syn,syn-conformation in co-crystal design

Phenylboronic acids can exist, in principle, in three different conformers (syn,syn; syn,anti and anti,anti) with distinct energy profiles. In their native state, these compounds prefer the energetically favored syn, anti-conformation. In molecular complexes, however, the functionality exhibits conformational diversity. In this paper we report a series of co-crystals, with N-donor compounds, prepared by a design strategy involving the synthons based on the syn, syn-conformation of the boronic acid functionality. For this purpose, we employed compounds with the 1,2-diazo fragment (alprazolam, 1H-tetrazole, acetazolamide and benzotriazole), 1,10-phenanthroline and 2,2'-bipyridine for the co-crystallization experiments. However, our study shows that the mere presence of the 1,2-diazo fragment in the coformer does not guarantee the successful formation of co-crystals with a syn, syn-conformation of the boronic acid. [GRAPHICS] The -B(OH)(2) fragment makes unsymmetrical O-H center dot center dot center dot N heterosynthons with alprazolam (ALP) and 1,10-phenanthroline (PHEN). In the co-crystals of phenylboronic acids with 1H-tetrazole (TETR) and 2,2'-bipyridine (BPY), the symmetrical boronic acid dimer is the major synthon. In the BPY complex, boronic acid forms linear chains and the pyridine compound interacts with the lateral OH of boronic acid dimers that acts as a connector, thus forming a ladder structure. In the TETR complex, each heterocycle interacts with three boronic acids. While two boronic acids interact using the phenolic group, the third molecule generates O-H center dot center dot center dot N hydrogen bonds using the extra OH group, of -B(OH)(2) fragment, left after the dimer formation. Thus, although molecules were selected retrosynthetically with the 1,2-diazo fragment or with nearby hetero-atoms to induce co-crystal formation using the syn,syn-orientation of the -B(OH)(2) functionality, co-crystal formation is in fact selective and is probably driven by energy factors. Acetazolamide (ACET) contains self-complementary functional groups and hence creates stable homosynthons. Phenylboronic acids being weak competitors fail to perturb the homosynthons and hence the components crystallize separately. Therefore, besides the availability of possible hydrogen bond acceptors in the required position and orientation, the ability of the phenyl-boronic acid to perturb the existing interactions is also a prerequisite to form co-crystals. This is illustrated in the table below. In the case of ALP, PHEN and BPY, the native structures are stabilized by weak interactions and may be influenced by the boronic acid fragment. Thus phenylboronic acids can attain co-crystals with those compounds, wherein the cyclic O-H center dot center dot center dot N hydrogen bonds are stronger than the individual homo-interactions. This can lower the lattice energy of the molecular complex as compared with the individual crystals. [GRAPHICS] Phenylboronic acids show some selectivity in the formation of co-crystals with N-heterocycles. The differences in solubility of the components fall short to provide a possible reason for the selective formation of co-crystals only with certain compounds. These compounds, being weak acids, do not follow the Delta pK(a) analysis and hence fail to provide any conclusive observation. Theoretical results show that of the three conformers possible, the syn,anti conformer is the most stable. The relative stabilities of the three conformers syn,anti,syn,syn and anti,anti are 0.0, 2.18 and 3.14 kcal/mol, respectively. The theoretical calculations corroborate the fact that only energetically favorable synthons can induce the formation of heterosynthons, as in ALP and PHEN complexes. From a theoretical and structural analysis it is seen that phenylboronic acids will form interactions with those molecules wherein the heterocyclic and acidic fragments can interrupt the homosynthons. However, the energy profile is shallow and can be perturbed easily by the presence of competing functional groups (such as OH and COOH) in the vicinity. [GRAPHICS] .

Structure of tandem and its implication for bifunctional intercalation into dna

Quinoxaline antibiotics (Fig. 1a, b) form a useful group of compounds for the study of drug–nucleic acid interactions1,2. They consist of a cross-bridged cyclic octadepsipeptide, variously modified, bearing two quinoxaline chromophores. These antibiotics intercalate bifunctionally into DNA2,3 probably via the narrow groove, forming a complex in which, most probably, two base pairs are sandwiched between the chromophores4,5. Depending on the nature of their sulphur-containing cross-bridge and modifications to their amino acid side chains, they display characteristic patterns of nucleotide sequence selectivity when binding to DNAs of different base composition and to synthetic polydeoxynucleotides4,6,7. This specificity has been tentatively ascribed to specific hydrogen-bonding interactions between functional groups in the DNA and complementary moieties on the peptide ring2,4,5. Variations in selectivity have been attributed both to changes in the conformation of the peptide backbone6 and no modifications of the cross-bridge7. These suggestions were made, however, in the absence of firm knowledge about the three-dimensional structure and conformation of the antibiotic molecules. We now report the X-ray structure analysis of the synthetic analogue of the antibiotic triostin A, TANDEM (des-N-tetramethyl triostin A) (Fig. 1c), which binds preferentially to alternating adenine-thymine sequences7. The X-ray structure provides a starting point for exploring the origin of this specificity and suggests possible models for the binding of other members of the quinoxaline series.

Nanocatalysis and Prospects of Green Chemistry

Designing and developing ideal catalyst paves the way to green chemistry. The fields of catalysis and nanoscience have been inextricably linked to each other for a long time. Thanks to the recent advances in characterization techniques, the old technology has been revisited with a new scope. The last decade has witnessed a flood of research activity in the field of nanocatalysis, with most of the studies focusing on the effect of size on catalytic properties. This led to the development of much greener catalysts with higher activity, selectivity and greater ease of separation from the reaction medium. This Minireview describes the emerging trends in the field of nanocatalysis with implications towards green chemistry and sustainability.

Nonthermal plasma approach in direct methanol synthesis from CH4

Direct methanol synthesis from CH4 and O2 has been experimentally studied using pulsed discharge plasma in concentric-cylinder-type reactors. The methanol production becomes efficient with an increase in the average electric field strength of the reactor. A combination of the pulsed discharge and catalysts was tested and was proved to be effective in increasing both the production and selectivity of methanol. In the present stage, about 2% of CH4 can be converted into other hydrocarbons, and a methanol yield of around 0.5% and selectivity of 38% can be obtained when a catalyst of V2O5+SiO2 is combined with the pulsed discharge plasma

A non-metal catalysed oxidation of primary azides to nitriles at ambient temperature

A novel non-metal catalyzed oxidation of organic azides to nitriles under solvent-free conditions is presented employing catalytic amounts of KI, and DABCO in aq. TBHP at room temperature. This nonmetal catalyzed oxidation of azides provides good selectivity as double and triple bonds were not oxidized under the present reaction conditions.

Reactivity of Bispropargyl Sulfones under Basic Conditions: Interplay Between Garratt-Braverman and Schmittel/Myers-Saito Cyclization Pathway

The preference for GarrattBraverman (GB) over MyersSaito (MS) and Schmittel (SCM) cyclizations has recently been demonstrated in sulfones capable of undergoing all three of the processes. As the GB cyclization is a self-quenching process, there is a need to change the selectivity to the non-self-quenching MS or SCM pathway so as to enhance the DNA-cleaving efficiency that operates through the radical-mediated process. Herein we report a conformational constraint-based strategy developed by using computations (M06-2X/6-31+G*) to switch the selectivity from GB to MS/SCM pathway which also results in greater DNA-cleavage activity. The preference for GB could be brought back by easing the constraint with the help of spacers.

Serine/Threonine/Tyrosine Protein Kinase Phosphorylates Oleosin, a Regulator of Lipid Metabolic Functions

Plant oils are stored in oleosomes or oil bodies, which are surrounded by a monolayer of phospholipids embedded with oleosin proteins that stabilize the structure. Recently, a structural protein, Oleosin3 (OLE3), was shown to exhibit both monoacylglycerol acyltransferase and phospholipase A(2) activities. The regulation of these distinct dual activities in a single protein is unclear. Here, we report that a serine/threonine/tyrosine protein kinase phosphorylates oleosin. Using bimolecular fluorescence complementation analysis, we demonstrate that this kinase interacts with OLE3 and that the fluorescence was associated with chloroplasts. Oleosin-green fluorescent protein fusion protein was exclusively associated with the chloroplasts. Phosphorylated OLE3 exhibited reduced monoacylglycerol acyltransferase and increased phospholipase A(2) activities. Moreover, phosphatidylcholine and diacylglycerol activated oleosin phosphorylation, whereas lysophosphatidylcholine, oleic acid, and Ca2+ inhibited phosphorylation. In addition, recombinant peanut (Arachis hypogaea) kinase was determined to predominantly phosphorylate serine residues, specifically serine-18 in OLE3. Phosphorylation levels of OLE3 during seed germination were determined to be higher than in developing peanut seeds. These findings provide direct evidence for the in vivo substrate selectivity of the dual-specificity kinase and demonstrate that the bifunctional activities of oleosin are regulated by phosphorylation.