Introduction to ESTARD Data Miner
Introduction to Data Mining
Step By Step Guide
Using Rules & Decision Trees
Reporting & Saving
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
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
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"
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
- "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
the bottom left corner. Edit the Query by deleting it's patterns, following
the word "WHERE".
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
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.
- Press "OK" button if the length of the SQL Query is less
- Press "Abort" button to quit the Simple Select Query
and reduce it's length by deselecting Rules in the "Simple Select Query"