Query optimization using restructured views: Theory and experiments

We study optimization of relational queries using materialized views, where views may be regular or restructured. In a restructured view, some data from the base table(s) are represented as metadata—that is, schema information, such as table and attribute names—or vice versa.     

Changes in tissue abundance and activity of enzymes related to branched-chain amino acid catabolism in dairy cows during early lactation

Branched-chain α-keto acid dehydrogenase (BCKDH) complex catalyzes the irreversible oxidative decarboxylation of branched-chain α-keto acids. This reaction is considered as the rate-limiting step in the overall branched-chain amino acid (BCAA) catabolic pathway in mammals. For characterizing the potential enzymatic involvement of liver, skeletal muscle, adipose tissue (AT), and mammary gland (MG) in BCAA metabolism during early lactation, tissue and blood samples were examined on d 1, 42, and 105 after parturition from 25 primiparous Holstein cows. Serum BCAA profiles were analyzed and the mRNA and protein abundance as well as the activity in the different tissues were assessed for the BCAA catabolic enzymes, partly for the branched-chain aminotransferase and completely for BCKDH. Total BCAA concentration in serum was lowest on d 1 after parturition and increased thereafter to a steady level for the duration of the experiment. Pronounced differences between the tissues were observed at all molecular levels. The mRNA abundance of the mitochondrial isoform of branched-chain aminotransferase (BCATm) was greatest in AT as compared with the other tissues studied, indicating that AT might be an important contributor in the initiation of BCAA catabolism in dairy cows. From the different subunits of the BCKDH E1 component, only the mRNA for the β polypeptide (BCKDHB), not for the α polypeptide (BCKDHA), was elevated in liver. The BCKDHA mRNA abundance was similar across all tissues except muscle, which tended to lower values. Highest BCKDHA protein abundance was observed in both liver and MG, whereas BCKDHB protein was detectable in these tissues but could not be quantified. Adipose tissue and muscle only displayed abundance of the α subunit, with muscle having the lowest BCKDHA protein of all tissues. We found similarities in protein abundance for both BCKDH E1 subunits in liver and MG; however, the corresponding overall BCKDH enzyme activity was 7-fold greater in liver compared with MG, allowing for hepatic oxidation of BCAA transamination products. Reduced BCKDH activity in MG associated with no measurable activity in AT and muscle may favor sparing of BCAA for the synthesis of the different milk components, including nonessential AA. Deviating from previously published data on BCAA net fluxes and isotopic tracer studies in ruminants, our observed results might in part be due to complex counter-regulatory mechanisms during early lactation.     

Mammalian target of rapamycin signaling and ubiquitin-proteasome–related gene expression in skeletal muscle of dairy cows with high or normal body condition score around calving

The objective of the current study was to investigate the effects of overconditioning around calving on gene expression of key components of the mammalian target of rapamycin (mTOR) pathway and ubiquitin-proteasome system (UPS) in skeletal muscle as well as the AA profiles in both serum and muscle of periparturient cows. Fifteen weeks antepartum, 38 multiparous Holstein cows were allocated to either a high body condition group (HBCS; n = 19) or a normal body condition group (NBCS; n = 19) and were fed different diets until dry-off (d ?49 relative to calving) to amplify the difference. The groups were also stratified for comparable milk yields (NBCS: 10,361 ± 302 kg; HBCS: 10,315 ± 437 kg). At dry-off, the NBCS cows (parity: 2.42 ± 1.84; body weight: 665 ± 64 kg) had a body condition score (BCS) <3.5 and backfat thickness (BFT) <1.2 cm, whereas the HBCS cows (parity: 3.37 ± 1.67; body weight: 720 ± 57 kg) had a BCS >3.75 and BFT >1.4 cm. During the dry period and the subsequent lactation, both groups were fed identical diets but maintained the BCS and BFT differences. Blood samples and skeletal muscle biopsies (semitendinosus) were repeatedly (d ?49, +3, +21, and +84 relative to calving) collected for assessing the concentrations of free AA and the mRNA abundance of various components of mTOR and UPS. The differences in BCS and BFT were maintained throughout the study. The circulating concentrations of most AA with the exception of Gly, Gln, Met, and Phe increased in early lactation in both groups. The serum concentrations of Ala (d +21 and +84) and Orn (d +84) were lower in HBCS cows than in NBCS cows, but those of Gly, His, Leu, Val, Lys, Met, and Orn on d ?49 and Ile on d +21 were greater in HBCS cows than in NBCS cows. The serum concentrations of 3-methylhistidine, creatinine, and 3-methylhistidine:creatinine ratio increased after calving (d +3) but did not differ between the groups. The muscle concentrations of all AA (except for Cys) remained unchanged over time and did not differ between groups. The muscle concentrations of Cys were greater on d ?49 but tended to be lower on d +21 in HBCS cows than in NBCS cows. On d +21, mTOR and eukaryotic translation initiation factor 4E binding protein 1 mRNA abundance was greater in HBCS cows than in NBCS cows, whereas ribosomal protein S6 kinase 1 was not different between the groups. The mRNA abundance of ubiquitin-activating enzyme 1 (d +21), ubiquitin-conjugating enzyme 1 (d +21), atrogin-1 (d +21), and ring finger protein-1 (d +3) enzymes was greater in HBCS cows than in NBCS cows, whereas ubiquitin-conjugating enzyme 2 was not different between the groups. The increased mRNA abundance of key components of mTOR signaling and of muscle-specific ligases of HBCS cows may indicate a simultaneous activation of anabolic and catabolic processes and thus increased muscle protein turnover, likely as a part of the adaptive response to prevent excessive loss of skeletal muscle mass during early lactation.     

Uncertain deductive databases: A hybrid approach

Uncertainty in deductive databases and logic programming has been modeled using a variety of (numeric and non-numeric) formalisms in the past, including probabilistic, possibilistic, and fuzzy set-theoretic approaches, and many valued logic programming. In this paper, we consider a hybrid approach to the modeling of uncertainty in deductive databases. Our model, called deductive IST (DIST) is based on an extension of the Information Source Tracking (IST) model, recently proposed for relational databases. The DIST model permits uncertainty to be modeled and manipulated in essentially qualitative terms with an option to convert qualitative expressions of uncertainty into numeric form (e.g., probabilities). An uncertain deductive database is modeled as a Horn clause program in the DIST framework, where each fact and rule is annotated with an expression indicating the “sources” contributing to this information and their nature of contribution. (1) We show that positive DIST programs enjoy the least model/least fixpoint semantics analogous to classical logic programs. (2) We show that top-down (e.g., SLD-resolution) and bottom-up (e.g., magic sets rewriting followed by semi-naive evaluation) query processing strategies developed for datalog can be easily extended to DIST programs. (3) Results and techniques for handling negation as failure in classical logic programming can be easily extended to DIST. As an illustration of this, we show how stratified negation can be so extended. We next study the problem of query optimization in such databases and establish the following results. (4) We formulate query containment in qualitative as well as quantitative terms. Intuitively, our qualitative sense of containment would say a query Q₁ is contained in a query Q₂ provided for every input database D, for every tuple t, t ε Q₂(D) holds in every “situation” in which t ε Q₁(D) is true. The quantitative notion of containment would say Q₁ is contained in Q₂ provided on every input, the certainty associated with any tuple computed by Q₁ is no more than the certainty associated with the same tuple by Q₂ on the given input. We also prove that qualitative and quantitative notions of containment (both absolute and uniform versions) coincide. (5) We establish necessary and sufficient conditions for the qualitative containment of conjunctive queries. (6) We extend the well-known chase technique to develop a test for uniform containment and equivalence of positive DIST programs. (7) Finally, we prove that the complexity of testing containment of conjunctive DIST queries remains the same as in the classical case when number of information sources is regarded as a constant (so, it's NP-complete in the size of the queries). We also show that testing containment of conjunctive queries is co-NP-complete in the number of information sources.     

The effect of PVD coatings on the corrosion behaviour of AZ91 magnesium alloy

In this study, multilayered AlN (AlN + AlN + AlN) and AlN + TiN were coated on AZ91 magnesium alloy using physical vapour deposition (PVD) technique of DC magnetron sputtering, and the influence of the coatings on the corrosion behaviour of the AZ91 alloy was examined. A PVD system for coating processes, a potentiostat for electrochemical corrosion tests, X-ray difractometer for compositional analysis of the coatings, and scanning electron microscopy for surface examinations were used. It was determined that PVD coatings deposited on AZ91 magnesium alloy increased the corrosion resistance of the alloy, and AlN + AlN + AlN coating increased the corrosion resistance much more than AlN + TiN coating. However, it was observed that, in the coating layers, small structural defects e.g., pores, pinholes, cracks that could arise from the coating process or substrate and get the ability of protection from corrosion worsened were present.