Mining with an SQL interface

Mining is integrated in Db2®. It consists of Db2 extensions that include an SQL application program interface (API). You can embed the SQL API in business applications to exploit the data mining functions from this business application.

The SQL API consists of the following layers that provide different granularity and a different degree of abstraction:
  • The API of the Easy Mining procedures is task oriented.

    With this API, you can perform common mining tasks. The interfaces are easy to use and should be the first choice when you start working with the mining interfaces.

  • The SQL/MM API conforms to the standard.

    With this API, mining experts can compose mining tasks that are hand-tailored for your individual requirements. You can use it in SQL scripts or from any JDBC, CLI, ODBC, or SQLJ application. You can create new mining models (Modeling) or apply existing mining models (Scoring).

    The SQL/MM API consists of many different interfaces that provide a lot of options. By using these options, you have a fine-grained control of the mining process.