Data Warehouse

Concept Briefing:

Data warehouse is record of an enterprise's past transactional and operational information, stored in a database designed to favour efficient data analysis and reporting (especially OLAP).

Data warehousing is not meant for current "live" data. Data warehouses often hold large amounts of information which are sometimes subdivided into smaller logical units called dependent data marts. Usually, two basic ideas guide the creation of a data warehouse:

Integration of data from distributed and differently structured databases, which facilitates a global overview and comprehensive analysis in the data warehouse.

Separation of data used in daily operations from data used in the data warehouse for purposes of reporting, decision support, analysis and controlling.

Periodically, one imports data from enterprise resource planning (ERP ) systems and other related business software systems into the data warehouse for further processing. It is common practice to "stage" data prior to merging it into a data warehouse. In this sense, to "stage data" means to queue it for preprocessing, usually with an ETL tool. The preprocessing program reads the staged data (often a business's primary OLTP databases), performs qualitative preprocessing or filtering (including denormalization, if deemed necessary), and writes it into the warehouse.

Need more information on Data Warehouse?

Enter your search terms

Submit search form

25.01.2007. 07:23