What's New in Oracle Database?

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.

The following section describse new features in Oracle Database:

• Oracle Database 10g Release 1 (10.1) 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"

  
  

• SQLAccess Advisor

  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"

  
  

• Materialized Views

  The 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.

  
  

  See Also: Chapter 15, " Maintaining the Data Warehouse"

  
  

• Query Rewrite Enhancements

  Query rewrite performance and capabilities have been improved.

  
  

  See Also: Chapter 18, " 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.

  
  

  See Also: Chapter 5, " Parallelism and Partitioning in Data Warehouses"

  
  

• 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.

  
  

  See Also: Chapter 11, " Overview of Extraction, Transformation, and Loading"

  
  

• Storage Management

  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.

  
  

  See Also: Chapter 4, " Hardware and I/O Considerations in Data Warehouses"