8.Oracle Data Warehousing Overview

Oracle9i, Release 1 (9.0.1), provides many features that support the needs of data warehousing and business intelligence. These features are typically useful for other activities such as Online Transaction Processing (OLTP). Therefore, most features described in this manual are presented in general terms, rather than emphasizing their data warehousing use.

These are some of the Oracle features that are designed to support data warehousing and business intelligence:

  • Parallelism in queries, data loading, indexing, and other data manipulation
  • Cost-based query optimization for efficient data access
  • Indexing techniques specifically tailored to data warehousing needs
  • Advanced SQL join algorithms
  • Data partitioning to simplify management and enhance performance
  • Analytic functions for high performance queries and simpler programming
  • Materialized view for maximum performance