The APIs for data mining

The PL/SQL interface to Oracle Data Mining is implemented mainly using the following three packages:

  • DBMS_DATA_MINING: This is the primary interface to Oracle Data Mining
  • DBMS_DATA_MINING_TRANSFORM: This enables us to make use of convenient routines for data transformation
  • DBMS_PREDICTIVE_ANALYTICS: This is a predictive analytics package

Using the available SQL and PL/SQL APIs, we can perform all following actions in the data miner:

  • Run a workflow
  • Cancel a running workflow
  • Rename a workflow
  • Delete a workflow
  • Import a workflow
  • Export a workflow
  • Create a project
  • Delete one or more projects
  • Rename a project

Get Oracle SQL Developer now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial