Simple Select Query

The Simple Select Query is an easy and a fast way to use the Analytical Data 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.

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 fields.

The set of controls for the Query is placed on the "Analysed Data Set" page.

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

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.

Note: page "Analysed Data Set", "Show All Records" button - after processing the Simple Select Query the "Analysed Table" control will display only corresponding records. If you want to see all the records just press "Show All Records" button.

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.