This section describes the new features of Oracle Database 10g Release 2 (10.2) and provides pointers to additional information. New features information from previous releases is also retained to help those users migrating to the current release.
The following section describes new features in Oracle Database:
Oracle Database 10g Release 2 (10.2) New Features in Data Warehousing
Oracle Database 10g Release 1 (10.1) New Features in Data Warehousing
SQL Model Calculations
The MODEL clause enables you to specify complex formulas while avoiding multiple joins and UNION clauses. This clause supports OLAP queries such as share of ancestor and prior period comparisons, as well as calculations typically done in large spreadsheets. The MODEL clause provides building blocks for budgeting, forecasting, and statistical applications.
See Also:
Chapter 22, "SQL for Modeling"Materialized View Refresh Enhancements
Materialized view fast refresh involving multiple tables, whether partitioned or non-partitioned, no longer requires that a materialized view log be present.
Query Rewrite Enhancements
Query rewrite performance has been improved because query rewrite is now able to use multiple materialized views to rewrite a query.
See Also:
Chapter 17, "Basic Query Rewrite"Partitioning Enhancements
You can now use partitioning with index-organized tables. Also, materialized views in OLAP are able to use partitioning. You can now use hash-partitioned global indexes.
Change Data Capture
Oracle now supports asynchronous change data capture as well as synchronous change data capture.
See Also:
Chapter 16, "Change Data Capture"ETL Enhancements
Oracle's extraction, transformation, and loading capabilities have been improved with several MERGE improvements and better external table capabilities.
SQL Model Calculations
The MODEL clause enables you to specify complex formulas while avoiding multiple joins and UNION clauses. This clause supports OLAP queries such as share of ancestor and prior period comparisons, as well as calculations typically done in large spreadsheets. The MODEL clause provides building blocks for budgeting, forecasting, and statistical applications.
See Also:
Chapter 22, "SQL for Modeling"Materialized View Refresh Enhancements
Materialized view refresh has new optimizations for data warehousing and OLAP environments. The enhancements include more efficient calculation and update techniques, support for nested refresh, along with improved cost analysis.
Query Rewrite Enhancements
Query rewrite performance and capabilities have been improved.
See Also:
Chapter 17, "Basic Query Rewrite"Partitioning Enhancements
You can now use partitioning with index-organized tables. Also, materialized views in OLAP are able to use partitioning. You can now use hash-partitioned global indexes.
Change Data Capture
Oracle now supports asynchronous change data capture as well as synchronous change data capture.
See Also:
Chapter 16, "Change Data Capture"ETL Enhancements
Oracle's extraction, transformation, and loading capabilities have been improved with several MERGE improvements and better external table capabilities.
Storage Management
Oracle's Managed Files has simplified the administration of a database by providing functionality to automatically create and manage files, so the database administrator no longer needs to manage each database file.
Automatic Storage Management provides additional functionality for managing not only files, but also the disks. In addition, you can now use ultralarge data files.