Introduction to ESTARD Data Miner

Introduction to Data Mining

Step By Step Guide

Program Interface

Using Databases

Using Rules & Decision Trees

BI Functions

Reporting & Saving 
 Home page

"Initial Query" and "Query Parameters" Pages


 

"Initial Query"

The "Initial Query" is used for forming parameters that later will be used for intial statistical query. Controls for selecting examined field, adjusting values, changing fields list are placed at this page. Until you click at the button none of changes you make at this page are applyed. After clicking button, all settings from this page are exported to the "Query Parameters" page.

 

Main functions of the "Initial Query" tab are:

  • Class/Examined field selection
  • Classes information viewing
  • Manual  creation of numeric classes
  • Selection of the fields for obtaining Statistics
  • Editing Queries settings
  • Processing queries

 

 

"Query Parameters"

After performing initial query we obtain statistics and automataclly switch to "Query Parameters" page. At "Query Parameters" page we store all parameters that were used for current initial query and use them for creating rules and decision trees, and to work with statistics.

To obtain rules or decision trees you have to check class values for non-numeric examined fields and check fields in the fields list. After that start the desired query by clicking on corresponding menu button: for rules and for decision trees creation.

 

 

 

Page Controls

Main buttons:

  • "Process Query" button - Data pre processing. The button is always enabled. Pressing the button starts the initial query. The result of the query are Statistics. After the pre processing Decision Rules and Decision Trees can be created.
  • "Create Rules" button - starts the Rules Query. This button is not enabled in case if initial query ("Process Query" button) is needed.
  • "Create Decision Tree" button - starts the Decision Tree Query. Is not enabled in case if data pre processing ("Process Query" button) is needed.
  • "Query Settings" button - opens the "Query Settings" dialog.

 

General Query Settings

  • "Examined/Class Field" - Determine the examined field by selecting a field from the  list. You can select it by double clicking, drag and dropping or with the help of "Manage fields" popup menu. Note: ID fields can not be selected as Class field due to percent of unique values.
  • "Fields List" control - contains a list of fields from the Learning Database. Fields with high percent of unique values and the ID field are marked with grey color. Fields in the list are used for creating Statistics, Decision Rules and Decision Trees. 

Note: After the fields selection, selected field names are marked with navy color in the "Manage fields".

Use the "Add Recommended" button to select only fields, recommended by the program.

Use the "Select  All" button to select all fields from all tables.

After selecting the Examined/Class Field the program specifies the selected field's type. In case if the field is of text or logical type, the following controls will be displayed:

  • "Classes List" list - depending on the Class Field type it will contain a list of determined classes. Select Classes to be analysed by marking them.
  • "Number of Classes:" - displays the total number of Classes(unique values) found in the field.
If the examined filed is of rational type, the Classes list control is replaced with controls for numeric Classes creation.

With the help of dispayed controls you can create a new class manually, by puting it's minimum and maximum values into corresponding fields and pressing the "OK" button.

You can also remove the selected class from a list, by selecting it in the list and clicking corresponding button.

After forming classes list and selecting fields for data mining, you can move on to obtaining Statistics, Decision Trees and Decision (If-Then) Rules.

Note: The page and the Query Wizard contain corresponding controls sets.