Data warehousing

Data warehousing

1. Data warehouse types

   • Data Marts
     • Dependent data mart
     • Independent data mart
   • Operational data store
   • Enterprise data warehouse

2. Metadata

3. Processes

   • Data Integration
     • Enterprise application integration
     • Enterprise information integration
   • ETL

4. Dimensional modeling

   • Star schema
   • Snowflake schema

5. Real-time data warehousing