to homepage
 Weekly emails: how to  


> glossary > data warehouse

data warehouse

A large store of data for analysis. Organizations use data warehouses (and smaller 'data marts') to help them analyze historic transaction data to detect useful patterns and trends. First of all the data is transferred into the data warehouse using a process called extracting, transforming and loading (ETL). Then it is organized and stored in the data warehouse in ways that optimize it for high-performance analysis. The transfer to a separate data warehouse system, which is usually performed as a regular batch job every night or at some other interval, insulates the live transaction systems from any side-effects of the analysis, but at the cost of not having the very latest data included in the analysis.

highlights | A-Z index       


More about "data warehouse" ...

Loosely Coupled articles:

The death of data warehousing
The cost, complexity, and utility of the data warehouse will become marginalized ...

Don't look in the attic for fresh answers
Traditional approaches to managing customer data are much like the average householder's approach to attic storage ...


Copyright © 2002-2010, Procullux Media Ltd. All Rights Reserved.