IT Glossary

Data Warehouse

data warehouseA data warehouse is a storage architecture designed to hold data extracted from transaction systems, operational data stores and external sources. The warehouse then combines that data in an aggregate, summary form suitable for enterprise-wide data analysis and reporting for predefined business needs.

The five components of a data warehouse are:

  1. production data sources
  2. data extraction and conversion
  3. the data warehouse database management system
  4. data warehouse administration
  5. business intelligence (BI) tools

A data warehouse contains data arranged into abstracted subject areas with time-variant versions of the same records, with an appropriate level of data grain or detail to make it useful across two or more different types of analyses most often deployed with tendencies to third normal form. A data mart contains similarly time-variant and subject-oriented data, but with relationships implying dimensional use of data wherein facts are distinctly separate from dimension data, thus making them more appropriate for single categories of analysis.

See also Master Data Management – MDM


Read reviews of Warehouse Management Systems…

Gartner Peer Insights has over 691 reviews on 28+ vendors in the Warehouse Management Systems market. Learn about these companies and these products from IT professionals who have first-hand experience with them.


Become a Client

Call us now at:

+1 800-213-4848


Contact us online 

Free Research
Discover what 12,000 CIOs and Senior IT leaders already know.
Free Access