Data Warehousing Using Oracle 9i

Back TO Home

Index

1. Introduction

• What is Data warehousing?
• Data warehouse Architectures

• Basic
• With Staging Area
• Staging Area and Data mart

2. Objective and Problem Definition

• Why Oracle?

3. Solution

• List of Available Database Tools
• Comparison Among Tools
• Database Benchmark by eWEEK and PC Magazine.
• Technical Comparison (Issues and Results)

4. Design Methodology

• Logical Design

• ER Diagram
• C Graph
• DW schemas. Star
• DW Objects
• Facts and Dimension Tables
• Hierarchies
• Level
• Level Relationships

• Physical Design
  

• Table Space
• Tables and Partition Tables
• Views
• Integrity Constraints

• Not Null
• Unique Constraints
• Foreign Key

• Indexes and Partition Indexes

• Local Indexes and Global Indexes
• Bitmap Indexes

• Materialized View

• Materialize Views in Data Warehouse
• Need for Materialize Views
• Transparent Query Rewrite
• Overview of Summary Management in Oracle 9i

• Dimensions

• What is Dimensions?
• Creating Dimension

5. Managing ETL in Oracle 9i

• Extraction Process

• Extraction Methods in Oracle 9i
• Extraction Using Oracle 9i

• Transportation Process

• Transportation Mechanisms in Data Warehouse

• Loading and Transformation Process

• Transformation Flow

• Multistage Data Transformation
• Pipelined Data Transformation

• Loading Mechanism

• SQL Loader
• Direct path SQL Loader
• Conventional SQL Loader

6. Lesson Learned
7. Summary
8. References

Keywords: Table space, SQL Loader, Bitmap Index, B-tree index, Flat files

// Under Construction