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

Simple Select Query

The Simple Select Query is an easy and a fast way to use rules and decision trees obtained as a result of data mining. The query allows to search for records in a database, correlating to the Decision Rules or Decision Trees. With the help of this Query you can detect Classes in a database, without performing additional analysis or using it as Learning Databse. 

For example: after creating Decision Rules, describing loyal clients in the customers database, Rules can be used for detecting loyal clients in other databases. Even if there is a difference in databases structures, Decision Rules and Decision Trees can be applyed after setting an Analogy between databases tables fields.

The set of controls for the Query is placed on the "Search a Database" page.

Simple Select Query uses the source of Analytical Data (Decision Rules or Decision Trees), determined in the "Analytical Data" settings dialog.

Using The Simple Select Query
  • The "Rules List" control in "Simple Select Query" dialog  contains all Classes and Rules (depending on Analytical Data), unearthed by ESTARD Data Miner.
  • "Find Undetermined Records" - some of records may remain undetermined by the Rules. Mark the control in case if you need to select these records.
  • "Process Simple Query" button - starts the Query.
  • "Cancel" button - closes the "Simple Select Query" dialog.

You can create combined Queries, turning on "Find Undetermined Records" feature and  selecting any classes. In this case you will be given a mixed list of records, corresponding to the marked rules and classes.

So, to process a Simple Select Query you should:

  • Mark the Classes or Rules you are interested in
  • Press the "Process Simple Query" button

The Data is transformed into SQL Query. The length of the SQL Query is limited to 7000 symbols. In case if the Query length is over 7000 symbols, you will be informed by a notification. In the appeared notification dialog you can choose:
  • "Yes" - to Edit the SQL Query, manually reducing it's length. The "Edit the SQL Query"  dialog will be displayed.
  • "No" - to ignore the notification and process the Query (not recommended)
  • "Abort" - to abort the Simple Query processing. After aborting the Query you can reduce the overall number of selected Rules or Classes, by deselecting them in the "Simple Select Query" dialog.

"Edit the SQL Query" Window

The text of SQL Query is displayed in the dialog. Query length can be viewed in the bottom left corner. Edit the Query by deleting it's patterns, following the word "WHERE".

For example:

SELECT * FROM `DemoTable` WHERE ((`Industry`="Iron & Steel")) OR ((`Industry`="Metal Mining")) OR ((`Industry`="Misc. Fabricated Products")) OR ((`Industry`="Paper & Paper Products")) OR ((`Industry`="Paper & Paper Products") AND ((`Current liabilities`>=4180.0001) AND (`Current liabilities`<=4382)) AND ((`Sales`>=21245.5001) AND (`Sales`<=24573))) OR ((`Industry`="Apparel/Accessories"))

To edit the SQL Query we will select it's first pattern: ((`Industry`="Iron & Steel")) OR

and delete it. It is important to remove the word "OR" following the Rule pattern. Removing Rules from the Query will reduce it's length. When the length of the Query is less than 7000 symbols, the text in the bottom left corner (displaying the Query length) will become green.

Buttons

  • Press "OK" button if the length of the SQL Query is less than 7000.
  • Press "Abort" button to quit the Simple Select Query and reduce it's length by deselecting Rules in the "Simple Select Query" dialog.