Encyclopedia of Database Systems

2018 Edition
| Editors: Ling Liu, M. Tamer Özsu

Data Warehousing Systems: Foundations and Architectures

  • Il-Yeol Song
Reference work entry
DOI: https://doi.org/10.1007/978-1-4614-8265-9_121

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 to check access.

Recommended Reading

  1. 1.
    Adamson C, Venerable M. Data warehouse design solutions. Hoboken: Wiley; 1998.Google Scholar
  2. 2.
    Cunningham C, Song I-Y, Chen PP. Data warehouse design for customer relationship management. J Database Manag. 2006;17(2):62–84.CrossRefGoogle Scholar
  3. 3.
    Inmon WH. Building the data warehouse. 3rd ed. Hoboken: Wiley; 2002.Google Scholar
  4. 4.
    Jones ME, Song I-Y. Dimensional modeling: identification, classification, and evaluation of patterns. Decis Support Syst. 2008;45(1):59–76.CrossRefGoogle Scholar
  5. 5.
    Kimball R, Merz R. The data webhouse toolkit: building the web-enabled data warehouse. Hoboken: Wiley; 2000.Google Scholar
  6. 6.
    Kimball R, Ross M. The data warehouse toolkit: the complete guide to dimensional modeling. 2nd ed. Hoboken: Wiley; 2002.Google Scholar
  7. 7.
    Kimball R, Ross M, Thorntwaite W, Munday J, Becker B. The data warehouse lifecycle toolkit. 2nd ed. Hoboken: Wiley; 2008.Google Scholar
  8. 8.
    Malinowski E, Zimanyi E. Advanced data warehouse design: from conventional to spatial and temporal applications. Berlin: Springer; 2008.zbMATHGoogle Scholar
  9. 9.
    Poole J, Chang D, Tolbert D, Mellor D. Common warehouse metamodel: an introduction to the standard for data warehouse integration. Hoboken: Wiley; 2002.Google Scholar
  10. 10.
    Sen A, Sinha AP. A comparison of data warehousing methodologies. Commun ACM. 2005;48(3):79–84.CrossRefGoogle Scholar
  11. 11.
    Todman C. Designing a data warehouse supporting customer relationship management. Upper Saddle River: Prentice Hall; 2000.zbMATHGoogle Scholar
  12. 12.
    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

Copyright information

© Springer Science+Business Media, LLC, part of Springer Nature 2018

Authors and Affiliations

  1. 1.College of Computing and InformaticsDrexel UniversityPhiladelphiaUSA

Section editors and affiliations

  • Torben Bach Pedersen
    • 1
  • Stefano Rizzi
    • 2
  1. 1.Department of Computer ScienceAalborg UniversityAalborgDenmark
  2. 2.DISIUniv. of BolognaBolognaItaly