Oracle Essentials [Electronic resources] : Oracle Database 10g, 3rd Edition نسخه متنی

A.9 Chapter 9, Oracle and Data Warehousing

Improved optimization

Optimizer predictions for decision support operations are compared
with actual results, and there will be subsequent adjustments in
future predictions if indicated.

MODEL clause

This clause in the SELECT statement allows relational data in a query
to be treated as a multidimensional array, which can also have
formulas applied to them.

Cross-platform transportable tablespaces

Transportable tablespaces can be used to move data between different
operating system platforms.

Downstream capture of change information

Change information can be captured from log files, rather than from
the database.

Data Pump

This is a high-speed data transfer application.

Data mining enhancements

These enhancements include text mining and BLAST similarity searches.

Additional analytics and statistics

The database includes new hypothesis testing and distribution
statistics, crosstabs, and descriptive statistics. The OLAP option
adds support for custom members and measures.