User Tools

Site Tools


Data warehouse


A data warehouse is a central data storage for managing structured data.


Data Warehousing describes the operational extract, cleansing, transformation, con-trol, and load processes that maintain the data in a data warehouse so that it can be used by BI. The data warehousing process focuses on enabling an integrated and his-torical business context on operational data by enforcing business rules and maintain-ing appropriate business data relationships. Also includes processes that interact with Metadata repositories.


  • An integrated, centralized decision support database and the related soft-ware programs used to collect, cleanse, transform, and store data from a variety of operational sources to support Business Intelligence. A Data Warehouse may also include dependent data marts. (DAMA-DMBOK Guide, 1st edition, pg. 197.)
  • A subject oriented, integrated, time variant, and non-volatile collection of summary and detailed historical data used to support the strategic deci-sion-making processes for the corporation. (“What is a Data Ware-house?” W.H. Inmon, Prism, Volume 1, Number 1, 1995)
  • A copy of transaction data specifically structured for query and analysis. (Ralph Kimball, The Data Warehouse Toolkit, pg. 310.)


A data warehouse makes it easy to store and manage large amounts of data, and to run complex queries against the data.


Data warehouseis child ofdata storage
Data warehousehas subsetdata mart


  • Rani, Isha (2023). Key data terms explained. LinkedIn Post.
  • Earley, S. (2011). The DAMA Dictionary of Data Management (DDDM). Technics Publications, LLC, New Jersey.
data_management/data_warehouse.txt · Last modified: 2023/12/10 16:44 by peter