Programming Tutorials Browser Tutorials Articles Struts Tutorials Hibernate Tutorials

  Tutorial: DB2 Data Mining Through Excel

A tool that allows DB2 data mining through a spreadsheet.

Tutorial Details:

This tool makes DB2's Data Mining available for Microsoft® Excel™ users via an Excel add-in. It serves as a spreadsheet client for DB2's Data Mining; that is, for the following DB2 extenders: IBM DB2 Intelligent Miner™ Modeling, Scoring, and Visualization (all part of DB2 Data Warehouse Edition 9.1). These components provide data mining within DB2 with a SQL API. Users can integrate these products in SQL and Java applications or simply run data mining from withing DB2. Developing such applications or SQL calls respectively is now made easier though this Excel add-in. Users can work with the add-in in a "play around" mode and, whenever the result is satisfactory, they can grab the SQL "source code," which is displayed in the tool for re-use in their applicatons.

The current version of this tool supports the following:

* Prediction of a column (classification and regression), such as predicting customer behavior (buy vs. not buy), quality (item defective vs. item OK)
* Finding of groups (clustering), such as customer groups
* Finding of rules (associations), such as finding relationships between the different columns in a table
* Finding of column explanations (classification). Finds logical conditions for each value in the target column
* Explaining a column value (associations and classification). Finds rules that explain a selected value in the target column
* Finding deviations. Uses clustering to find atypical records in a table
* Finding important fields (classification and regression). Determines which columns are most important to explain the target column
* Enabling the Intelligent Miner functions in a DB2 database.


 

Read Tutorial at: Click here to view the tutorial

Rate Tutorial:
DB2 Data Mining Through Excel

View Tutorial:
DB2 Data Mining Through Excel

Related Tutorials:

Accelerate your Java apps! - JavaWorld - September 1998
Accelerate your Java apps! - JavaWorld - September 1998
 
Java Tip 77: Enable copy and paste functionality between Swing's JTables and Excel - JavaWorld
Java Tip 77: Enable copy and paste functionality between Swing's JTables and Excel - JavaWorld
 
Use JDBC for industrial-strength performance, Part 1 - JavaWorld January 2000
Use JDBC for industrial-strength performance, Part 1 - JavaWorld January 2000
 
Pattern your way to automated regression testing
Pattern your way to automated regression testing
 
Unleash mobile agents using Jini
Unleash mobile agents using Jini
 
Java is here to stay (JavaWorld / January 2000 / by John Rommel)
Java is here to stay (JavaWorld / January 2000 / by John Rommel)
 
High-availability mobile applications
High-availability mobile applications
 
Interesting concept ...
Interesting concept ...
 
Excelling in Excel with Java
Excelling in Excel with Java
 
The HTML Renderer Shootout, Part 1
The HTML Renderer Shootout, Part 1 In this article, we will review 11 different HTML renderers, comparing their features, compliance, and speed; searching for the best one for any project.
 
JForumFusion
About jForumFusion JForumFusion is a platform independent discussion board program.
 
They just work
Writing CSV files: CSVPrinter This class makes it easy to output CSV. Given values, it will automatically determine if they need to be quoted and escape special characters. Comments can easily be written and correct line beginnings will be added.
 
Accessing Databases Using Java and JDBC
This article will show how a Java Application, Applet or Servlet can access data stored in relational databases using the JDBC API.
 
Hibernate simplifies inheritance mapping.
Learn three easy-to-implement strategies to map class hierarchies. Hibernate is an object-relational mapping and persistence framework that provides a lot of advanced features, ranging from introspection to polymorphism and inheritance mapping.
 
Manage Database Metadata with POI and Excel
Set up quick and easy database metadata housekeeping with the Java Apache POI libraries and Microsoft Excel.
 
Bioinformatics
Bioinformatics Bioinformatics Introduction Bioinformatics is new hot topic after the Software. In the coming days there will be huge demand of Bioinformatics professionals in all sectors of biotechnology, pharmaceutical, and biomedical sciences.
 
Using Beans in JSP. A brief introduction to JSP and Java Beans.
Using Beans in JSP. A brief introduction to JSP and Java Beans. USING BEANS IN JSP Java Beans Java Beans are reusable components. They are used to separate Business logic from the Presentation logic. Internally, a bean is just an instance of a
 
Buy SuSe 9.1 Personal CDs in India from us. Suse 9.1 Personal is available with us.
Buy SuSe 9.1 Personal CDs in India from us. Suse 9.1 Personal is available with us. SuSe 9.1 Personal Linux Now Available SuSe 9.1 Personal CD's SuSE 9.1 Personal Edition was based on the x86 port of the Personal Edition, and it includes all of
 
VolatileBufferedToolkitImage Strategies
Ever wondered what kind of image to use in your application? Or what method to use in creating it? This article attempts to address this challenging topic.
 
DB Visual Architect for Eclipse
DB Visual Architect for Eclipse (DBVA-EC) is a full featured Object Relational Mapping (ORM) plugin for Eclipse that provides the industry\'s best round-trip code engineering support with Java.
 
Site navigation
 

 

Send your comments, Suggestions or Queries regarding this site at roseindia_net@yahoo.com.

Copyright © 2006. All rights reserved.