Encyclopedia of Database Systems

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

Data Warehouse

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

Synonyms

Information repository

Definition

A data warehouse (DW) is an integrated repository of data put into a form that can be easily understood, interpreted, and analyzed by the people who need to use it to make decisions. The most widely cited definition of a DW is from Inmon [1] who states that “a data warehouse is a subject-oriented, integrated, time-variant, and nonvolatile collection of data in support of management’s decisions.”

The subject-oriented property means that the data in a DW are organized around major entities of interests of an organization. Examples of subjects are customers, products, sales, and vendors. This property allows users of a DW to analyze each subject in depth for tactical and strategic decision-making.

The integratedproperty means that the data in a DW are integrated not only from all operational database systems but also some meta-data and other related external data. When data are moved from operational databases to a DW, they are extracted,...

This is a preview of subscription content, log in to check access.

Recommended Reading

  1. 1.
    Chaudhuri S, Dayal U. An overview of data warehousing and OLAP technology. SIGMOD Rec. 1997;26(1):65–74.CrossRefGoogle Scholar
  2. 2.
    Inmon WH. Building the data warehouse. 3rd ed. New York: Wiley; 2002.Google Scholar
  3. 3.
    Kimball R, Ross M. The data warehouse toolkit: The definitive guide to dimensional modeling, 3rd ed. New York: Wiley; 2013.Google Scholar

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