Abstract
A data warehouse is kind of database whose architecture (and underlying supporting technology) has been optimized for highly efficient query, at the cost of sacrificing features that support robust interactive inserts, updates and delete actions. The difference between a data warehouse and a data mart (which is also optimized for the same purpose) is partly one of scope. While warehouses are supposed to encompass data across an entire organization, data marts are typically smaller scale (e.g., departmental in scope) though in an ideal situation they would receive data from a warehouse, effectively serving as front-ends to the latter.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
Kimball R, Caserta J. The Data Warehouse ETL Toolkit. New York: Wiley; 2008.
Kimball R. The Data Warehousing Toolkit. New York: Wiley; 1997.
Inmon W, Rudin K, Buss C, Sousa R. Data Warehouse Performance. New York: Wiley; 1998.
Vetterli T, Vaduva A, Staudt M. Metadata standards for data warehousing: open information model vs. common warehouse metamodel. ACM SIGMOD Rec. 2000;29(3):68-75.
Object Management Group. Common warehouse metamodel. 2010 [cited 10/3/10]; Available from: http://www.omg.org/technology/cwm.
Kimball Group. Design tips. 2010 [cited 11/2/10]; Available from: http://www.rkimball.com/html/designtips.html.
Mundy J, Thornthwaite W, Kimball R. The Microsoft ® Data Warehouse Toolkit: With SQL Server™ 2005 and the Microsoft ® Business Intelligence Toolset. New York: Wiley; 2006.
Leuf B, Cunningham W. The Wiki Way. Quick collaboration on the Web. Reading: Addison-Wesley; 2001.
English L. Improving Data Warehouse and Business Information Quality: Methods for reducing costs and increasing profits. New York: Wiley; 1999.
Murphy SN, Morgan MM, Barnett GO, Chueh HC. Optimizing healthcare research data warehouse design through past COSTAR query analysis. Proc AMIA Symp. 1999:892-896.
Murphy SN, Barnett GO, Chueh HC. Visual query tool for finding patient cohorts from a clinical data warehouse of the partners HealthCare system. Proc AMIA Symp. 2000:1174.
Murphy SN, Chueh HC. A security architecture for query tools used to access large biomedical databases. Proc AMIA Symp. 2002:552-556.
Murphy SN, Gainer V, Chueh HC. A visual interface designed for novice users to find research patient cohorts in a large biomedical database. AMIA Annu Symp Proc. 2003:489-493.
Partners Healthcare. I2B2 Data Mart Design document. 2010 [cited 10/1/10]; Available from: https://www.i2b2.org/software/projects/datarepo/CRC_Design_15.pdf.
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2011 Springer-Verlag London Limited
About this chapter
Cite this chapter
Nadkarni, P.M. (2011). Metadata for Data Warehousing. In: Metadata-driven Software Systems in Biomedicine. Health Informatics. Springer, London. https://doi.org/10.1007/978-0-85729-510-1_16
Download citation
DOI: https://doi.org/10.1007/978-0-85729-510-1_16
Published:
Publisher Name: Springer, London
Print ISBN: 978-0-85729-509-5
Online ISBN: 978-0-85729-510-1
eBook Packages: MedicineMedicine (R0)