Tutorial Home > Storage and Networking > Storage and Drives > Data Warehousing

Data Warehousing
"Data Warehousing" is a process of creating a corporate information repository or a "Business Intelligence" environment. Data is "extracted, transformed and loaded (ETL)" (includes checks for data quality issues) from OLTP or external systems into data warehouse(s) or data mart(s), using an Operational Data Store (ODS) as a staging area. The data warehouse(s) or data mart(s) maintain historical data. A metadata repository maintains information about the data. This topic describes data warehousing in detail.

  Topics
  Systems Management
  End-user Reporting
  Roadmap to a Data Warehouse
  Understanding Metadata
  The Snowflake Schema
  Build a Data Warehouse
  What is an ODS?
  Data Warehouse vs. Data Marts
  What is a Data Warehouse?
  What is a Data Mart?
  Roles in a Data Warehouse Team
  Decide to Normalize Or Denormalize
  Learn about Star Schema
 

  FAQs
  How do I access OLTP data residing in relational databases?
  How do I analyze data in a relational database?
  How do I analyze data in a multi-dimensional model?
  How do I analyze data for a specific duration of time?
  How do I analyze data in a multi-dimensional or relational model?