Data Warehousing

Data Warehousing

1. DW

   • pool of data produced to support decision making

2. Fundamental

   • Subject oriented
   • Integrated
   • Time variant
   • Novolatile

3. Characteristics

   • Enable data warehouse
     • web based
     • relational/multidimensional
     • client/server
     • real time
     • include metadata

4. Data Marts

   • subset of a data warehouse, typically consisting of a single subject area
     • Dependent data mart
       • subset that is created directly from the data warehouse
     • Independent data mart
       • small warehouse designed for a strategic business unit

5. operational data store (ODS)​

   • provides a fairly recent form of customer information file (CIF)

6. enterprise data warehouse (EDW)​

   • large-scale data warehouse that is used across the enterprise for decision support

7. Metadata

   • are data about data

8. Data integration

   • Data access
     • access and extract data from any data source
   • Data federation
     • integration of business views across multiple data stores
   • Change capture

9. integration technologies

   • Enterprise application integration (EAI)
     • vehicle for pushing data from source systems into the data warehouse
   • Service-oriented architecture (SOA)
   • Enterprise information integration (EII)
     • evolving tool space that promises real-time data integration from a variety of sources
   • Extraction, transformation, and load (ETL)
     • Extraction
     • transforamtion
     • load

10. ​snowflake schema

    • logical arrangement of tables in a multidimensional database

11. OLTP

    • capturing and storing data related to day-to-day business functions

12. OLAP

    • To support decision making and provide answers to business and management queries