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

 


Become a Client

Call us now at:

+1 800-213-4848

or

Contact us online 

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