|Oracle® Database Data Warehousing Guide
10g Release 1 (10.1)
Part Number B10736-01
This section describes the new features of Oracle Database 10g Release 1 (10.1) and provides pointers to additional information. New features information from previous releases is also retained to help those users migrating to the current release.
SQL Model Calculations
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"
The SQLAccess Advisor tool and its related
DBMS_ADVISOR package offer improved capabilities for recommending indexing and materialized view strategies.
See Also:Chapter 17, " SQLAccess Advisor"
TUNE_MVIEW procedure shows how to specify a materialized view so that it is fast refreshable and can use advanced types of query rewrite.
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 18, " Query Rewrite"
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"
Oracle's extraction, transformation, and loading capabilities have been improved with several
MERGE improvements and better external table capabilities.
Oracle 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.