Definition
A data warehouse (DW) is an integrated repository of data for supporting decision-making applications of an enterprise. The most widely cited definition of a DW is from Inmon [3] who states that “a data warehouse is a subject-oriented, integrated, nonvolatile, and time-variant collection of data in support of management’s decisions.”
Historical Background
DW systems have evolved from the needs of decision-making based on integrated data, rather than an individual data source. DW systems address the two primary needs of enterprises: data integration and decision support environments. During the 1980s, relational database technologies became popular. Many organizations built their mission-critical database systems using the relational database technologies. This trend proliferated many independent relational database systems in an enterprise. For example, different business lines in an enterprise built separate database systems at different geographical locations. These...
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsRecommended Reading
Adamson C, Venerable M. Data warehouse design solutions. Hoboken: Wiley; 1998.
Cunningham C, Song I-Y, Chen PP. Data warehouse design for customer relationship management. J Database Manag. 2006;17(2):62–84.
Inmon WH. Building the data warehouse. 3rd ed. Hoboken: Wiley; 2002.
Jones ME, Song I-Y. Dimensional modeling: identification, classification, and evaluation of patterns. Decis Support Syst. 2008;45(1):59–76.
Kimball R, Merz R. The data webhouse toolkit: building the web-enabled data warehouse. Hoboken: Wiley; 2000.
Kimball R, Ross M. The data warehouse toolkit: the complete guide to dimensional modeling. 2nd ed. Hoboken: Wiley; 2002.
Kimball R, Ross M, Thorntwaite W, Munday J, Becker B. The data warehouse lifecycle toolkit. 2nd ed. Hoboken: Wiley; 2008.
Malinowski E, Zimanyi E. Advanced data warehouse design: from conventional to spatial and temporal applications. Berlin: Springer; 2008.
Poole J, Chang D, Tolbert D, Mellor D. Common warehouse metamodel: an introduction to the standard for data warehouse integration. Hoboken: Wiley; 2002.
Sen A, Sinha AP. A comparison of data warehousing methodologies. Commun ACM. 2005;48(3):79–84.
Todman C. Designing a data warehouse supporting customer relationship management. Upper Saddle River: Prentice Hall; 2000.
Watson HJ, Ariyachandra T. Data warehouse architectures: factors in the selection, decision, and the success of the architectures”. 2005. From http://www.terry.uga.edu/~hwatson/DW_Architecture_Report.pdf
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Section Editor information
Rights and permissions
Copyright information
© 2018 Springer Science+Business Media, LLC, part of Springer Nature
About this entry
Cite this entry
Song, IY. (2018). Data Warehousing Systems: Foundations and Architectures. In: Liu, L., Özsu, M.T. (eds) Encyclopedia of Database Systems. Springer, New York, NY. https://doi.org/10.1007/978-1-4614-8265-9_121
Download citation
DOI: https://doi.org/10.1007/978-1-4614-8265-9_121
Published:
Publisher Name: Springer, New York, NY
Print ISBN: 978-1-4614-8266-6
Online ISBN: 978-1-4614-8265-9
eBook Packages: Computer ScienceReference Module Computer Science and Engineering