Data Warehousing: Data Warehouse, Teradata, Extract, Transform, Load, Slowly Changing Dimension, Data Warehouse Appliance, OLAP Cube

Please note that the content of this book primarily consists of articles available from Wikipedia or other free sources online. Pages: 37. Chapters: Data warehouse, Extract, transform, load, Slowly changing dimension, Data warehouse appliance, Master data management, OLAP cube, Anchor Modeling, Dimensional modeling, Data Vault Modeling, Business analytics, Dimensional Fact Model, Snowflake schema, Fact table, Enterprise bus matrix, Data mart, Bill Inmon, Aggregate, Star schema, Ralph Kimball, Spreadmart, Dashboard, The Kimball Lifecycle, Dimension table, Data warehouse architectures, Degenerate dimension, Operational database, Data extraction, SAS Rapid Data Warehouse Methodology, Operational data store, Document warehouse, Time variance, Operational system, Early-arriving fact, Staging, Integration warehouse, Measure, DIRKS. Excerpt: In computing, a data warehouse (DW) is a database used for reporting and analysis. The data stored in the warehouse is uploaded from the operational systems. The data may pass through an operational data store for additional operations before it is used in the DW for reporting. A data warehouse maintains its functions in three layers: staging, integration, and access. Staging is used to store raw data for use by developers. The integration layer is used to integrate data and to have a level of abstraction from users. The access layer is for getting data out for users. This definition of the data warehouse focuses on data storage. The main source of the data is cleaned, transformed, catalogued and made available for use by managers and other business professionals for data mining, online analytical processing, market research and decision support (Marakas & O'Brien 2009). However, the means to retrieve and analyze data, to extract, transform and load data, and to manage the data dictionary are also considered essential components of a data warehousing system. Many references to data warehousing use this broader context. Thus, an exp...