Data warehouse process

The data warehouse process ( English data warehousing ) is the process for managing and evaluating a data warehouse , which includes the following steps:

1. Data acquisition: that means the extraction of the relevant data from the source systems, transformation and, if necessary, data cleansing in a work area as well as loading into the data warehouse. This step is also called the Extract-Transform-Load-Process (ETL-Process).
2. Data storage: that means long-term storage of the data in the data warehouse
3. Supply and data storage of the separate data stocks required for the analysis, the data marts
4. Data evaluation by analyzing the data in the respective data mart or supplying downstream application systems

The repository , which is supplied with metadata in the ETL process in particular and is used in particular for the analysis of the data, is involved in all steps .

See also

• Data warehouse system
• Business intelligence
• Data mining

literature

• A. Bauer, H. Günzel: Data warehouse systems - architecture, development, application . dpunkt, 2013, ISBN 978-3-89864-785-4 .
• W. Lehner: Database technology for data warehouse systems, concepts and methods . dpunkt, 2002, ISBN 3-89864-177-5 .

Web links

• Data warehousing as an organizational concept of data management
• Bernhard Strauch, Robert Winter: Process models for information needs analysis in data warehousing. (PDF; 231 kB)
• Data warehousing needs process thinking. ( Memento of December 17, 2015 in the Internet Archive ) (PDF; 4112 kB)