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 enterprisewide 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. 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.


Related Research

2019 Planning Guide Overview: Architecting Your Digital Ecosystem

Technical professionals are confronting increasingly complex technology ecosystems. They must overcome this complexity to create solutions...

Read Free Research
Related Webinar

Beyond the Data Warehouse: New Data Management for Analytics

The traditional data warehouse still forms the foundation of analytics programs. However, as demand for new data types and use cases...

Start Watching

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