Migration Toolkit for DB2 Intelligent Miner

Overview

Requirements

Download

FAQs

Forum

Reviews

What is Migration Toolkit for DB2 Intelligent Miner?

This toolkit allows migration of DB2® Intelligent Miner™ for Data mining bases to DB2 Data Warehouse Edition Design Studio projects in a controlled, step-by-step manner. The toolkit enables one to work with a graphical user interface (Design Studio) for ad hoc mining and for integrating data mining into Information Management applications. The migration from DB2 Intelligent Miner for Data to DB2 Data Warehouse Edition 9.1 and its data mining component, Intelligent Miner, is greatly improved.

The toolkit consists of two chief components:

• the mining base normalization
• the mining base transformation.

Mining base normalization: An Intelligent Miner for Data mining base may contain objects that refer to tables not yet stored in DB2 (such as flat file tables). DB2 Data Warehouse Edition's data mining builds specifically on DB2 tables and views. Therefore, such tables are transformed into DB2 tables. The result of this step is an improved, but fully compatible, mining base whose objects refer to DB2 tables only. When executing a mining setting in this new mining base, the result is identical to the corresponding run in the original mining base; therefore, customers can re-use all of their existing mining investments.

Mining base transformation: The objects and sequences of the settings in a normalized mining base are transformed to Data Warehouse Edition Design Studio's mining and control flows. Because the functionality of the Design Studio operators does not cover all aspects of the objects of Intelligent Miner settings, the mapping is not complete. There are settings for mining and statistics (such as similar time sequences) that have no counterpart in the Design Studio. For other mining and statistics settings, the underlying algorithm may have changed or certain parameters may no longer be available.

After the completion of this step, the user can execute the mining and control flows in the Design Studio and see how the results differ from those of Intelligent Miner for Data.

How does it work?

The mining base migration is realized as a plug-in of the Data Warehouse Edition Design Studio.

Both are implemented in Java and use the DB2 Intelligent Miner for Data API for accessing the metadata of Intelligent Miner mining bases.