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.

A unified approach to the gauging of space-time and internal symmetries

The properties of the manifold of a Lie groupG, fibered by the cosets of a sub-groupH, are exploited to obtain a geometrical description of gauge theories in space-timeG/H. Gauge potentials and matter fields are pullbacks of equivariant fields onG. Our concept of a connection is more restricted than that in the similar scheme of Ne'eman and Regge, so that its degrees of freedom are just those of a set of gauge potentials forG, onG/H, with no redundant components. The ldquotranslationalrdquo gauge potentials give rise in a natural way to a nonsingular tetrad onG/H. The underlying groupG to be gauged is the groupG of left translations on the manifoldG and is associated with a ldquotrivialrdquo connection, namely the Maurer-Cartan form. Gauge transformations are all those diffeomorphisms onG that preserve the fiber-bundle structure.

An NAD(P)(+)-dependent secondary-alcohol dehydrogenase of Alcaligenes eutrophus: Purification, characterization and its application for the production of chiral alcohols

A soil micro-organism identified as Alcaligenes eutrophus capable of utilizing nerolidol, a sesquiterpene alcohol as the sole source of carbon, contains an inducible NAD(P)(+)-linked secondary-alcohol dehydrogenase (SADH), The enzyme was purified 252-fold from crude cell-free extract by a combination of salt precipitation, ion-exchange and affinity-matrix chromatography, Native and SDS/PAGE PAGE of the purified enzyme showed a single protein band and the enzyme appears to be a homotetramer having an apparent molecular mass of 139 kDa comprising four identical subunits of 38.5 kDa, The isoelectric point (pi) of SADH was determined to be 6.2, Depending on pH of the reaction media, the enzyme carried out both oxidation and reductions of various terpenoids and steroids, At pH 5.5, the enzyme catalysed the stereospecific reduction of prochiral ketones to optically active (S)-alcohols and the oxidation reaction was predominated over the former at pH 9.5, NADP(+) and NADPH were respectively preferred over NAD(+) and NADH for oxidation and reduction reactions, The K-m values for testosterone, NADP(+) and NAD(+) were 11.8, 55.6, and 122 mu M respectively, Neither enzyme was significantly inhibited by metal-binding agents, but some thiol-blocking compounds inhibited it, SADH tolerates moderate concentrations of water-miscible organic solvents such as ethanol, methanol, acetone and dioxan, Some of the properties of this enzyme were found to be significantly different from those thus far described.

High-level expression of biologically active glycoprotein hormones in Pichia pastoris strains—selection of strain GS115, and not X-33, for the production of biologically active N-glycosylated 15N-labeled phCG

The methylotrophic yeast Pichia pastoris is widely used for the production of recombinant glycoproteins. With the aim to generate biologically active 15N-labeled glycohormones for conformational studies focused on the unravelling of the NMR structures in solution, the P. pastoris strains GS115 and X-33 were explored for the expression of human chorionic gonadotropin (phCG) and human follicle-stimulating hormone (phFSH). In agreement with recent investigations on the N-glycosylation of phCG, produced in P. pastoris GS115, using ammonia/glycerol-methanol as nitrogen/carbon sources, the N-glycosylation pattern of phCG, synthesized using NH4Cl/glucose–glycerol–methanol, comprised neutral and charged, phosphorylated high-mannose-type N-glycans (Man8–15GlcNAc2). However, the changed culturing protocol led to much higher amounts of glycoprotein material, which is of importance for an economical realistic approach of the aimed NMR research. In the context of these studies, attention was also paid to the site specific N-glycosylation in phCG produced in P. pastoris GS115. In contrast to the rather simple N-glycosylation pattern of phCG expressed in the GS115 strain, phCG and phFSH expressed in the X-33 strain revealed, besides neutral high-mannose-type N-glycans, also high concentrations of neutral hypermannose-type N-glycans (Manup-to-30GlcNAc2). The latter finding made the X-33 strain not very suitable for generating 15N-labeled material. Therefore, 15N-phCG was expressed in the GS115 strain using the new optimized protocol. The 15N-enrichment was evaluated by 15N-HSQC NMR spectroscopy and GLC-EI/MS. Circular dichroism studies indicated that 15N-phCG/GS115 had the same folding as urinary hCG. Furthermore, 15N-phCG/GS115 was found to be similar to the unlabeled protein in every respect as judged by radioimmunoassay, radioreceptor assays, and in vitro bioassays.

The production of AlN-rich matrix composites by the reactive infiltration of Al alloys in nitrogen

Aluminium nitride (AlN)-Al matrices reinforced with Al2O3 particulate have been fabricated by reactive infiltration of Al-2% Mg alloy into Al2O3 preforms in N-2 in the temperature range of 900-1075 degreesC. The growth of composites of useful thickness was facilitated by the presence of a Mg-rich external getter, in the absence of which composite growth is self-limiting and terminates prematurely. Successful growth of composites has been attributed to the reduction in residual oxygen partial pressure brought about by the reaction with oxygen of highly volatile Mg in the getter alloy. The microstructure of the matrix consists of AlN-rich regions contiguous with the particulate with metal-rich channels in-between, thereby suggesting that nitridation initiates by preferential wicking of alloy along the particle surfaces. The increase in nitride content of the matrix with temperature is consistent with hardness values that vary between similar to3 and 10 GPa. (C) 2002 Acta Materialia Inc. Published by Elsevier Science Ltd. All rights reserved.

Design of a manual press for the production of compacted stabilized soil blocks

In this paper, we discuss the design of a manually operated soil compaction machine that is being used to manufacture stabilized soil blocks (SSB). A case study of manufacturing more than three million blocks in a housing project using manually operated machines is illustrated. The paper is focussed on the design, development, and evaluation of a manually operated soil compaction machine for the production of SSB. It also details the machine design philosophy, compaction characteristics of soils, employment generation potential of small-scale stabilized soil block productions systems, and embodied energy. Static compaction of partially saturated soils was performed to generate force-displacement curves in a confined compaction process were generated. Based on the soil compaction data engineering design aspects of a toggle press are illustrated. The results of time and motion study on block production operations using manual machines are discussed. Critical path network diagrams were used for small-scale SSB production systems. Such production systems generate employment at a very low capital cost.

Beam polarization effects in the radiative production of lightest neutralinos in e(+)e(-) collisions in supersymmetric grand unified models

We study the production of the lightest neutralinos in the process e(+)e(-) -> chi(0)(1)chi(0)(1)gamma in supersymmetric grand unified models for the International Linear Collider energies with longitudinally polarized beams. We consider cases where the standard model gauge group is unified into the grand unified gauge groups SU(5), or SO(10). We have carried out a comprehensive study of this process in the SU(5) and SO(10) grand unified theories which includes the QED radiative corrections. We compare and contrast the dependence of the signal cross section on the grand unified gauge group, and on the different representations of the grand unified gauge group, when the electron and positron beams are longitudinally polarized. To assess the feasibility of experimentally observing the radiative production process, we have also considered in detail the background to this process coming from the radiative neutrino production process e(+)e(-)-> nu(nu) over bar gamma with longitudinally polarized electron and positron beams. In addition we have also considered the supersymmetric background coming from the radiative production of scalar neutrinos in the process e(+)e(-) -> (nu) over tilde(nu) over tilde*gamma with longitudinally polarized beams. The process can be a major background to the radiative production of neutralinos when the scalar neutrinos decay invisibly.

N-acetyl cysteine enhances imatinib-induced apoptosis of Bcr-Abl(+) cells by endothelial nitric oxide synthase-mediated production of nitric oxide

Imatinib, a small-molecule inhibitor of the Bcr-Abl kinase, is a successful drug for treating chronic myeloid leukemia (CML). Bcr-Abl kinase stimulates the production of H2O2, which in turn activates Abl kinase. We therefore evaluated whether N-acetyl cysteine (NAC), a ROS scavenger improves imatinib efficacy. Effects of imatinib and NAC either alone or in combination were assessed on Bcr-Abl(+) cells to measure apoptosis. Role of nitric oxide (NO) in NAC-induced enhanced cytotoxicity was assessed using pharmacological inhibitors and siRNAs of nitric oxide synthase isoforms. We report that imatinib-induced apoptosis of imatinib-resistant and imatinib-sensitive Bcr-Abl(+) CML cell lines and primary cells from CML patients is significantly enhanced by co-treatment with NAC compared to imatinib treatment alone. In contrast, another ROS scavenger glutathione reversed imatinib-mediated killing. NAC-mediated enhanced killing correlated with cleavage of caspases, PARP and up-regulation and down regulation of pro- and anti-apoptotic family of proteins, respectively. Co-treatment with NAC leads to enhanced production of nitric oxide (NO) by endothelial nitric oxide synthase (eNOS). Involvement of eNOS dependent NO in NAC-mediated enhancement of imatinib-induced cell death was confirmed by nitric oxide synthase (NOS) specific pharmacological inhibitors and siRNAs. Indeed, NO donor sodium nitroprusside (SNP) also enhanced imatinib-mediated apoptosis of Bcr-Abl(+) cells. NAC enhances imatinib-induced apoptosis of Bcr-Abl(+) cells by endothelial nitric oxide synthase-mediated production of nitric oxide.

Studies on the variants of the protein toxins ricin and abrin

his study elucidates some structural and biological features of galactose-binding variants of the cytotoxic proteins ricin and abrin. An isolation procedure is reported for ricin variants from Ricinus communis seeds by using lactamyl-Sepharose affinity matrix, similar to that reported previously for variants of abrin from Abrus precatorius seeds [Hegde, R., Maiti, T. K. & Podder, S. K. (1991) Anal. Biochem. 194, 101–109]. Ricin variants, subfractionated on carboxymethyl-Sepharose CL-6B ion-exchange chromatography, were characterized further by SDS/PAGE, IEF and a binding assay. Based on the immunological cross-reactivity of antibody raised against a single variant of each of ricin and abrin, it was established that all the variants of the corresponding type are immunologically indistinguishable. Analysis of protein titration curves on an immobilized pH gradient indicated that variants of abrin I differ from other abrin variants, mainly in their acidic groups and that variance in ricin is a cause of charge substitution. Detection of subunit variants of proteins by two-dimensional gel electrophoresis showed that there are twice as many subunit variants as there are variants of holoproteins, suggesting that each variant has a set of subunit variants, which, although homologous, are not identical to the subunits of any other variant with respect to pI. Seeds obtained from polymorphic species of R. communis showed no difference in the profile of toxin variants, as analyzed by isoelectric focussing. Toxin variants obtained from red and white varieties of A. precatorius, however, showed some difference in the number of variants as well as in their relative intensities. Furthermore, variants analyzed from several single seeds of A. precatorius red type revealed a controlled distribution of lectin variants in three specific groups, indicating an involvement of at least three genes in the production of Abrus lectins. The complete absence or presence of variants in each group suggested a post-translational differential proteolytic processing, a secondary event in the production of abrin variants.

Use of structure-directed DNA ligands to probe the binding of recA protein to narrow and wide grooves of DNA and on its ability to promote homologous pairing

We have used circular dichroism and structure-directed drugs to identify the role of structural features, wide and narrow grooves in particular, required for the cooperative polymerization, recognition of homologous sequences, and the formation of joint molecules promoted by recA protein. The path of cooperative polymerization of recA protein was deduced by its ability to cause quantitative displacement of distamycin from the narrow groove of duplex DNA. By contrast, methyl green bound to the wide groove was retained by the nucleoprotein filaments comprised of recA protein-DNA. Further, the mode of binding of these ligands and recA protein to DNA was confirmed by DNaseI digestion. More importantly, the formation of joint molecules was prevented by distamycin in the narrow groove while methyl green in the wide groove had no adverse effect. Intriguingly, distamycin interfered with the production of coaggregates between nucleoprotein filaments of recA protein-M13 ssDNA and naked linear M13 duplex DNA, but not with linear phi X174 duplex DNA. Thus, these data, in conjunction with molecular modeling, suggest that the narrow grooves of duplex DNA provide the fundamental framework required for the cooperative polymerization of recA protein and alignment of homologous sequences. These findings and their significance are discussed in relation to models of homologous pairing between two intertwined DNA molecules.