An Automated Data Warehouse

An increasing number of organizations are implementing data warehouses to strengthen their decision support systems. This comes with the challenges of the population and the periodic update of data warehouses. In this thesis, we present a tool that provides users with features to create a warehouse database and transform structures of the source database into structures for the warehouse database. It is highly interactive, easy to use, and hides the underlying complexity of manual SQL code generation from its users. Attributes from source tables can be mapped into new attributes in the warehouse database tables using aggregate functions. Then, relevant data is automatically transported from the source database to the newly created warehouse. The tool thus integrates warehouse creation, schema mapping and data population into a single generalpurpose tool. This tool has been designed as a component of the framework for an automated data warehouse being developed at theComputer Science Department, University of New Orleans. Users of this framework are the database administrators, who will also be able to synchronize updates of multiple copies of the data warehouse. Warehouse images that need to be updated are taken offline and applications that need to access the data warehouse can now access any of the other image warehouses. The Switching Application built into this framework switches between databases in a way that is totally transparent to applications so that they do not realize existence of multiple copies of the data warehouse. In effect, even non-technical users can create, populate and update data warehouses with minimal time and effort

Mineralogical Transformation and Electrochemical Nature of Magnesium-Rich Primers During Natural Weathering

Magnesium-rich primers (MgRP) have generated great interest as a promising alternative to chromium-based primers for the protection of aluminum substrates but their performance during exterior exposure has not been well documented. This paper focuses on the evaluation of MgRP during natural weathering to gain insight into its mineralogical phase transformation and electrochemical nature. Control studies were conducted on Mg and AA2024-T3 coupons. The results indicate that Mg particles in MgRP transform into a variety of hydroxide, carbonate, and hydroxy carbonates. During natural weathering, CO2 inhibited the dissolution of both Mg and AA2024-T3 as a result of protective carbonate layer formation in the coating

Diagnostic accuracy of an integrated approach using conventional ultrasonography, and Doppler and strain elastography in the evaluation of superficial soft tissue lesions

Introduction: To assess the diagnostic accuracy of an integrated approach using conventional ultrasonography, colour Doppler ultrasonography, and elastography strain ratios in tandem in the evaluation of superficial soft tissue lesions. Material and methods: Sixty-five subjects were included in this prospective cross-sectional study. Greyscale features and Doppler parameters were recorded. Strain elastography of the non-vascular and non-cystic lesions was performed and strain ratios were calculated. Fine-needle aspiration or biopsy of all the lesions was performed depending on their site and condition. Inter-rater k agreement was used to determine the strength of agreement between imaging-based diagnosis and histopathological diagnosis. A diagnostic test was used to calculate the sensitivity, specificity, positive predictive value, and negative predictive value. A p value of < 0.05 was considered statistically significant. Results: Multiple superficial soft tissue lesions were studied, the majority of which were lipomas, vascular anomalies, and epidermoid cysts. The diagnostic accuracy was very high and varied from 92.31% to 100% for various masses. The imaging-based diagnosis was in agreement with the histopathological diagnosis in 86.15% (n = 56) and disagreement in 13.85% (n = 9) of the cases (p < 0.007). There was very good inter-rater agreement between the imaging-based diagnosis and histopathological diagnosis (κ = 0.818). Conclusions: The combined use of conventional ultrasonography, colour Doppler, and elastography strain ratios provides a very effective non-invasive tool for the diagnosis of superficial soft tissue lesions and may negate the need for unnecessary biopsies. The advantage of this integrated approach using various ultrasound techniques needs no further emphasis

Recommendations for the assessment of non‐extremity venous thromboembolism outcomes: communication from the SSC of the ISTH

Peer Reviewedhttp://deepblue.lib.umich.edu/bitstream/2027.42/110812/1/jth12809.pd

Experience with a third generation recombinant factor VIII concentrate (Advate ® ) for immune tolerance induction in patients with haemophilia A

Peer Reviewedhttp://deepblue.lib.umich.edu/bitstream/2027.42/73338/1/j.1365-2516.2008.01960.x.pd

Genome-wide MicroRNA profiling of mantle cell lymphoma reveal a distinct subgroup with poor prognosis

MicroRNA (miRNA) deregulation has been implicated in the pathogenesis of mantle cell lymphoma (MCL). Using a high-throughput quantitative real-time PCR platform, we performed miRNA profiling on cyclin D1- positive MCL (n=30) and cyclin D1-negative MCL (n=7) and compared them with small lymphocytic leukemia/lymphoma (SLL, n=12), aggressive B-cell lymphomas (n=138), normal B-cell subsets and stromal cells. We identified a 19-miRNA classifier which included six upregulated miRNAs (miR-135a, miR-708, miR-150, miR-363, miR-184, miR-342-5p) and 13 downregulated miRNAs, that was able to distinguish MCL from other aggressive lymphomas with \u3e90% probability. Some of these upregulated miRNAs are highly expressed in naïve B-cells. MicroRNA classifier showed consistent results in FFPE tissues and was able to distinguish cyclin D1-negative MCL from other lymphomas. A 26-miRNA classifier could distinguish MCL from SLL, dominated by 23 upregulated miRNAs in MCL. Unsupervised hierarchical clustering of MCL cases demonstrated a cluster characterized by high expression of miRNAs from polycistronic miR17~92 cluster and its paralogs miR-106a-363 and miR-106b-25, which was distinct from the other clusters showing enrichment of stroma associated miRNAs. The corresponding gene-expressionprofiling (GEP) data showed that the former cluster of MCL had significantly higher proliferation genesignature (PS), while the other subsets had higher expression of stroma associated genes. Clinical outcome analysis suggests that miRNAs can serve as prognosticators

Genome-wide miRNAprofiling of mantle cell lymphoma reveals a distinct subgroup with poor prognosis

miRNA deregulation has been implicated in the pathogenesis of mantle cell lymphoma (MCL). Using a high-throughput quantitative real-time PCR platform, we performed miRNA profiling on cyclin D1–positive MCL (n = 30) and cyclin D1–negative MCL (n =7) and compared them with small lymphocytic leukemia/ lymphoma (n =12), aggressive B-cell lymphomas (n =138), normal B-cell subsets, and stromal cells.We identified a 19-miRNA classifier that included 6 up-regulated miRNAs and 13 down regulated miRNA that was able to distinguish MCL from other aggressive lymphomas. Some of the up-regulated miRNAs are highly expressed in naive B cells. This miRNAclassifier showed consistent results in formalinfixed paraffin-embedded tissues and was able to distinguish cyclin D1–negative MCL from other lymphomas. A 26-miRNA classifier could distinguish MCL from small lymphocytic leukemia/lymphoma, dominated by 23 up-regulated miRNAs in MCL. Unsupervised hierarchical clustering of MCL patients demonstrated a cluster characterized by high expression of miRNAs from the polycistronic miR17-92 cluster and its paralogs, miR-106a-363 and miR-106b-25, and associated with high proliferation gene signature. The other clusters showed enrichment of stroma-associated miRNAs, and also had higher expression of stroma-associated genes. Our clinical outcome analysis in the present study suggested that miRNAs can serve as prognosticators