VTU Slides :: Introduction to Data Warehousing

The Topics covered in this slide are as follows:

• A Brief History of Information Technology
• Databases for Decision Support
• OLTP vs. OLAP
• Why OLAP & OLTP don’t mix (1)
• Organizational Data Flow and Data Storage Components
• Loading the Data Warehouse
• Characteristics of a Data Warehouse
• A Data Warehouse is Subject Oriented
• Data in a Data Warehouse are Integrated
• The Data Warehouse Architecture
• Components of the Data Warehouse Architecture
• Data Warehousing Typology
• Data Have Data -- The Metadata
• The Metadata in Action
• Implementing the Data Warehouse
• “Seven Deadly Sins"
• The Future of Data Warehousing
• Data Integration is Hard
• Federated Databases
• Warehouses vs. Federation