Holistic Schema Mappings for XML-on-RDBMS

When hosting XML information on relational backends, a mapping has to be established between the schemas of the information source and the target storage repositories. A rich body of recent literature exists for mapping isolated components of XML Schema to their relational counterparts, especially with regard to table configurations. In this paper, we present the Elixir system for designing industrial-strength mappings for real-world applications. Specifically, it produces an information-preserving holistic mapping that transforms the complete XML world-view (XML schema with constraints, XML documents XQuery queries including triggers and views) into a full-scale relational mapping (table definitions, integrity constraints, indices, triggers and views) that is tuned to the application workload. A key design feature of Elixir is that it performs all its mapping-related optimizations in the XML source space, rather than in the relational target space. Further, unlike the XML mapping tools of commercial database systems, which rely heavily on user inputs, Elixir takes a principled cost-based approach to automatically find an efficient relational mapping. A prototype of Elixir is operational and we quantitatively demonstrate its functionality and efficacy on a variety of real-life XML schemas.

Beta-Turn Conformations In Crystal-Structures Of Model Peptides Containing Alpha,Alpha-Di-N-Propylglycine And Alpha,Alpha-Di-N-Butylglycine

The crystal state conformations of three peptides containing the alpha, alpha-dialkylated residues, alpha,alpha-di-n-propylglycine (Dpg) and alpha,alpha-di-n-butylglycine (Dbg), have been established by x-ray diffraction. Boc-Ala-Dpg-Ala-OMe (I) and Boc-Ala-Dbg-Ala-OMe (III) adopt distorted type II beta-turn conformations with Ala (1) and Dpg/Dbg (2) as the corner residues. In both peptides the conformational angles at the Dxg residue (I: phi = 66.2 degrees, psi = 19.3 degrees; III: phi = 66.5 degrees, psi = 21.1 degrees) deviate appreciably from ideal values for the i + 2 residue in a type II beta-turn. In both peptides the observed (N...O) distances between the Boc CO and Ala(3) NH groups are far too long (I: 3.44 Angstrom; III: 3.63 Angstrom) for an intramolecular 4 --> 1 hydrogen bond. Boc-Ala-Dpg-Ala-NHMe (II) crystallizes with two independent molecules in the asymmetric unit. Both molecules IIA and IIB adopt consecutive beta-turn (type III-III in IIA and type III-I in IIB) or incipient 3(10)-helical structures, stabilized by two intramolecular 4 --> 1 hydrogen bonds. In all four molecules the bond angle N-C-alpha-C' (tau) at the Dxg residues are greater than or equal to 110 degrees. The observation of conformational angles in the helical region of phi,psi space at these residues is consistent with theoretical predictions.

targetTB: A target identification pipeline for Mycobacterium tuberculosis through an interactome, reactome and genome-scale structural analysis

Background: Tuberculosis still remains one of the largest killer infectious diseases, warranting the identification of newer targets and drugs. Identification and validation of appropriate targets for designing drugs are critical steps in drug discovery, which are at present major bottle-necks. A majority of drugs in current clinical use for many diseases have been designed without the knowledge of the targets, perhaps because standard methodologies to identify such targets in a high-throughput fashion do not really exist. With different kinds of 'omics' data that are now available, computational approaches can be powerful means of obtaining short-lists of possible targets for further experimental validation. Results: We report a comprehensive in silico target identification pipeline, targetTB, for Mycobacterium tuberculosis. The pipeline incorporates a network analysis of the protein-protein interactome, a flux balance analysis of the reactome, experimentally derived phenotype essentiality data, sequence analyses and a structural assessment of targetability, using novel algorithms recently developed by us. Using flux balance analysis and network analysis, proteins critical for survival of M. tuberculosis are first identified, followed by comparative genomics with the host, finally incorporating a novel structural analysis of the binding sites to assess the feasibility of a protein as a target. Further analyses include correlation with expression data and non-similarity to gut flora proteins as well as 'anti-targets' in the host, leading to the identification of 451 high-confidence targets. Through phylogenetic profiling against 228 pathogen genomes, shortlisted targets have been further explored to identify broad-spectrum antibiotic targets, while also identifying those specific to tuberculosis. Targets that address mycobacterial persistence and drug resistance mechanisms are also analysed. Conclusion: The pipeline developed provides rational schema for drug target identification that are likely to have high rates of success, which is expected to save enormous amounts of money, resources and time in the drug discovery process. A thorough comparison with previously suggested targets in the literature demonstrates the usefulness of the integrated approach used in our study, highlighting the importance of systems-level analyses in particular. The method has the potential to be used as a general strategy for target identification and validation and hence significantly impact most drug discovery programmes.

NMR Investigations on Di- and Tri-Azanaphthalenes Oriented in Liquid Crystals

Proton NMR spectra of 1,3-diazanaphthalene and 1,2,4-triazanaphthalene have been investigated in the nematic phase of three liquid crystals. The spectral analysis provided direct dipole-dipole couplings which have been used to derive the molecular structure. Geometry of the phenyl ring in both the molecules deviates from the regular hexagonal structure. Signs of the order parameter of the largest magnitude are opposite in liquid crystals with positive diamagetic anisotropies.

Synthesis and Reactions of Binuclear Diolefin Rhodium(I) Compounds bridged by Nitrogen Heterocycles, Crystal Structure of Dichloro-Di-1,5-Cyclooctadiene(Mu-Pyrazine)-Dirhodium(I) [[Rh(1,5-C8h12)Cl]2(Mu-C4h4n2)]

Binuclear complexes of rhodium(I) of the type [(dien)(X)Rh(μ-N-N)Rh(X)(dien)] (dien = 1,5-cyclooctadiene or norbornadiene; N-N = pyrazine, 4,4′-bipyridine or Phenazine and X = Cl or Br) with bridging heterocycles have been isolated and their reactions with carbon monoxide, 2,2′-bipyridine and 1,10-phenanthroline investigated. The crystal structure of [(COD)(Cl)Rh(μ-pyrazine)Rh(Cl)(COD)] has been determined.

Structure-reactivity correlation in inclusion complexes: deoxycholic acid di-tert-butyl thioketone

Ultraviolet irradiation of crystalline molecular inclusion complexes of deoxycholic acid with di-tert-butyl thioketone results in no reaction. The structure of the above complex has been determined via X-ray diffraction. The absence of expected photoreactions. namely, photoreduction and photooxidation, is rationalized on the basis of the X-ray structure analysis of the complex.

Binary decompositions and acyclic schemes

It is well known that the notions of normal forms and acyclicity capture many practical desirable properties for database schemes. The basic schema design problem is to develop design methodologies that strive toward these ideals. The usual approach is to first normalize the database scheme as far as possible. If the resulting scheme is cyclic, then one tries to transform it into an acyclic scheme. In this paper, we argue in favor of carrying out these two phases of design concurrently. In order to do this efficiently, we need to be able to incrementally analyze the acyclicity status of a database scheme as it is being designed. To this end, we propose the formalism of "binary decompositions". Using this, we characterize design sequences that exactly generate theta-acyclic schemes, for theta = agr,beta. We then show how our results can be put to use in database design. Finally, we also show that our formalism above can be effectively used as a proof tool in dependency theory. We demonstrate its power by showing that it leads to a significant simplification of the proofs of some previous results connecting sets of multivalued dependencies and acyclic join dependencies.

GEODERM: geometric shape design system using an entity-relationship model

GEODERM, a microcomputer-based solid modeller, which incorporates the parametric object model, is discussed. The entity-relationship model, which is used to describe the conceptual schema of the geometric database, is also presented. Three of the four modules of GEODERM, which have been implemented are described in some detail. They are the Solid Definition Language (SDL), the Solid Manipulation Language (SML) and the User-System Interface.

Hydrogen bonding with mono- and di-carbonyls

The electronic absorption and i.r. spectroscopic studies are reported for the hydrogen bonding systems involving alcohol and various ketones. It is shown that the hydrogen bonding abilities of ketones are determined by the extent of delocalization of the lone pair electrons in their non-bonding molecular orbitals. Evidence for the formation of very weak intermolecular hydrogen bonds between alcohol and the π-electron part of the dicarbonyls has also been presented from the i.r. studies in the 3400–3700 cm−1 region.

Iron(II, III) complexes with N, N'-DI(2-)Pyridyl Thiourea. Moumlssbauer and other spectroscopic studies

Several iron(II, III) complexes of N, N'-di(2-)pyridyl thiourea have been synthesized. The preparation of the complexes from iron(III) salts proceeds through a reduction of iron(III) to iron(II) followed by a subsequent reoxidation. The Moumlssbauer, electronic and infrared spectra of these complexes have been measured. The results are concordant with the coordination of pyridine nitrogens and thiocarbonyl sulfur yielding polymeric complexes. A variable temperature NMR study of the free ligand shows that two conformation are accessible for it in solution at subambient temperatures.

Complexes of rare earth perchlorates with di-2-pyridyl ketone

Abstract is not availabe.

Complexes of lanthanide perchlorates with N,N,N′,N′-tetramethyl-α-carboxamido-O-anisamide and N,N′-di-t-butyl-α-carboxamido-O-anisamide

A survey of the literature on lanthanide coordination compounds reveals that ligands involving ether oxygens as donor atoms have received very little attention [ 11. Only recently have the complexes of lanthanides with cyclic polyethers been characterized [l-3]. We report in this communication that interaction of rareearth perchlorates with two new ligands namely N,N,N’,N’-tetramethyl-u-carboxamido-Oanisamide (TMCA) and N,N’-di-t-butyl-crcarboxamido- 0-anisamide (DTBCA). The two ligands are potentially tridentate possessing two amide moieties and an ether linkage in between. The isolated complexes have been characterized by analysis, electrolytic conductance, infrared and electronic spectra. The ‘H and “C NMR spectra for the diamagnetic La3+ and Y3+ complexes are also discussed.

A self-adaptive migration model genetic algorithm for data mining applications

Data mining involves nontrivial process of extracting knowledge or patterns from large databases. Genetic Algorithms are efficient and robust searching and optimization methods that are used in data mining. In this paper we propose a Self-Adaptive Migration Model GA (SAMGA), where parameters of population size, the number of points of crossover and mutation rate for each population are adaptively fixed. Further, the migration of individuals between populations is decided dynamically. This paper gives a mathematical schema analysis of the method stating and showing that the algorithm exploits previously discovered knowledge for a more focused and concentrated search of heuristically high yielding regions while simultaneously performing a highly explorative search on the other regions of the search space. The effective performance of the algorithm is then shown using standard testbed functions and a set of actual classification datamining problems. Michigan style of classifier was used to build the classifier and the system was tested with machine learning databases of Pima Indian Diabetes database, Wisconsin Breast Cancer database and few others. The performance of our algorithm is better than others.

Conformation of di-n-propylglycine residues (Dpg) in peptides: crystal structures of a type I-turn forming tetrapeptide and an -helical tetradecapeptide

The crystal structures of two oligopeptides containing di-n-propylglycine (Dpg) residues, Boc-Gly-Dpg-Gly-Leu-OMe (1) and Boc-Val-Ala-Leu-Dpg-Val-Ala-Leu-Val-Ala-Leu-Dpg-Val-Ala-Leu-OMe (2) are presented. Peptide 1 adopts a type I-turn conformation with Dpg(2)-Gly(3) at the corner positions. The 14-residue peptide 2 crystallizes with two molecules in the asymmetric unit, both of which adopt -helical conformations stabilized by 11 successive 5 1 hydrogen bonds. In addition, a single 4 1 hydrogen bond is also observed at the N-terminus. All five Dpg residues adopt backbone torsion angles (, ) in the helical region of conformational space. Evaluation of the available structural data on Dpg peptides confirm the correlation between backbone bond angle NCC() and the observed backbone , values. For > 106° , helices are observed, while fully extended structures are characterized by < 106° . The mean values for extended and folded conformations for the Dpg residue are 103.6° ± 1.7° and 109.9° ± 2.6° , respectively.