- The API of the Easy Mining procedures is task oriented. You can
use it to perform common mining tasks.
For more information, see DB2 Warehouse: Data Mining with Easy Mining procedures.
- The SQL/MM API conforms to the standard. It provides an API that enables you to 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.
In DB2, professionals can interactively issue SQL statements from the command center or from the command line processor. They can also start mining functions from one of these interfaces.
To assist application developers, the DB2 Warehouse Design Studio provides data mining plug-ins. These plug-ins contain graphical wizards and editors that are integrated in the Eclipse environment. With these plug-ins, you can graphically model mining tasks and generate the SQL to embed Intelligent Miner SQL functionality into your business applications.
To assist database administrators, Intelligent Miner provides administrative functions in the DB2 Warehouse Administration Console Web interface. You can enable a database for mining, administer data mining models, or manage the Intelligent Miner model cache.
Developing mining solutions
Depending on the experience, the personal preferences, the mining skills, and the complexity of the problem to solve, you can choose between the following approaches to develop a mining solution:
- Use the samples and tutorials to get started and adapt them to your own business problem.
- Use the graphical interface that is provided by the DB2 Warehouse Design Studio to define the mining process. Generate the code and integrate it into your own business application. Deploy mining steps as part of an automated data transformation step.
- Use the Easy Mining procedures for common mining tasks to perform typical mining tasks.
- Use the command line script generator idmmkSQL as a starting point to compose Scoring statements.
- Use the powerful lower-level SQL/MM API in SQL scripts or from any JDBC, CLI, ODBC, or SQLJ application.
- An application developer of a business application integrates the Intelligent Miner SQL functionality into the application by using the developer tooling.
- A professional uses this mining functionality from the business application.
- The DB2 Warehouse tutorial that is included in the product package
- The data mining tutorials that are included in the online-help of the DB2 Warehouse Design Studio
- The Intelligent Miner tutorials at
http://www.ibm.com/developerworks/db2/library/tutorials/iminer/iminer.html