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:
- 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).
- Data storage: that means long-term storage of the data in the data warehouse
- Supply and data storage of the separate data stocks required for the analysis, the data marts
- 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
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)