What's New in Oracle Data Mining Administration

This section summarizes the new features of Oracle Data Mining that pertain to installation, administration, and upgrade.

See Also:

  • "What's New" in Oracle Data Mining Concepts for a complete list of new and deprecated features in Oracle Data Mining 11g Release 1 (11.1).

  • Chapter 3 for information on upgrading and downgrading a database

This section contains the following topics:

No DMSYS Schema

Oracle Data Mining 11g Release 1 (11.1) has a tight integration with Oracle Database. Data Mining metadata and PL/SQL packages have been migrated from DMSYS to SYS. The DMSYS schema no longer exists in Oracle Database 11g Release 1 (11.1) fresh installations.

Mining Models in the Oracle Data Dictionary

New catalog views for Data Mining are introduced in 11g Release 1 (11.1):

The ALL/DBA/USER_OBJECTS catalog view now identifies mining models.

Enhanced Security

Security features of Oracle Data Mining are significantly enhanced in 11g Release 1 (11.1). Improved security for data mining has several aspects:


The privilege CREATE MINING MODEL is required for creating models in 11g. This privilege should be added to any accounts being upgraded to 11g.

Scoping of Nested Data

Oracle Data Mining supports nested data types for both categorical and numerical data. Multi-record case data must be transformed to nested columns for mining.

In Oracle Data Mining 10gR2, nested columns were processed as top-level attributes; the user had to ensure that two nested columns did not contain an attribute with the same name. In Oracle Data Mining 11g, nested attributes are scoped with the column name, which relieves the user of this burden.

Enhanced Handling of Sparse Data

Handling of sparse data and missing values has been standardized across algorithms in Oracle Data Mining 11g. Data is sparse when a high percentage of the cells are empty, but all the values are assumed to be known. Only nested data can be considered sparse. Missing values in simple numeric or character columns are considered missing at random.

Features Not Available in This Release

The following features are not supported in 11g Release 1 (11.1):

Deprecated Features

The following features are deprecated in 11g Release 1 (11.1):


Oracle recommends that you do not use deprecated features in new applications. Support for deprecated features is for backward compatibility only.