What is SuperQuery?

 

Introduction

 

Getting Started 

Chapter 1 Getting Started in SuperQuery

Chapter2 Organizing your Data

Chapter3 Querying the Database

Chapter4 Discover Facts and Rules.

Chapter 5 Summarize your data

System Description

Tab or Folder

Table view (TV)

Pane

Virtual Columns

How to...

How to start SuperQuery?
How to open a table?
How to generate facts on a table?
How to summarize a table?
How to update a table?
How to change pane properties?
How to change pane type?
How to add a Criteria?
How to add a virtual column?

How to add a Filter column?
How to add a Range column?
How to add a Classification column?
How to add a Formula column?
How to add a Keyword column?
How to add a graph?
How to export a table?

How to move views?

How to link tables?

Commands

File menu

Table menu

Tab menu

View menu

Options menu

Window menu

Help menu

Panes properties menus

Examples

Criteria Example

Criterion Example

Classification Column Example

Filter Column Example

Formula Column Example

Keyword Column example

Range Column Example

Definitions

SuperQuery is a data analysis and mining tool that runs under the Windows. Using Rule Induction Technology, SuperQuery searches data tables and reports all interesting patterns and exceptions. The Fact Discovery Engine is easily tuned to meet various analysis needs. SuperQuery also assists in preparing data for analysis by providing a number of facilities for partitioning, classifying and processing data columns. In addition, SuperQuery help to explore and analyze data by automatically displaying graphs and calculating statistics. It contains a number of Wizards that help read, update, and analyze data effortlessly.

SuperQuery Discovery version can read Access, xBASE, Excel, Paradox and Text files directly. and can also use ODBC to open most of the popular databases that have ODBC drivers. SuperQuery Office version can only reads MS Access and Excel files.

The Open Table Wizard will help you in opening your data. After you open the data you may analyze the entire table ( see limitations in the open Wizard ), a random sample, or a sample that satisfies given criteria.

SuperQuery is a query and database analysis tool. It helps you explore and analyze your data and discover any existing patterns.

SuperQuery is composed of three integrated facilities:

·Fact Finding System.

·Query Visual Tool.

·Tab Organizer.

The fact finding system searches your table and reports all interesting facts and exceptions. The query tool allows you to visually create different views on your data. Each view may have its own criteria and columns. Each view automatically displays statistical data and graphs about the current column. The Tab Organizer allows you to store all your views into different tabs. This helps you in using and presenting your analysis.

SuperQuery requires no knowledge of database languages or SQL.

Fact Finding and Classification

SuperQuery finds all “interesting” similarities among your data. For example, it may find that all your low income customers buy product A while most of your High Income customers are interested in product B. On the other hand, SuperQuery also detects exceptions. For example, in a mutual fund data table, SuperQuery may detect the exception that only two funds have Risk = Low and income = High.

SuperQuery uses heuristic functions to evaluate the interest level of facts and exceptions so that it can control the number and quality of facts reported. The user can raise or lower the interest threshold thus decreasing or increasing the number of facts and exceptions reported. Lowering the interest threshold reduces (and eventually cancel) the effects of heuristic functions.

In order to find facts in numerical columns ( like price, volume, temperature, etc.), we need to classify those columns into categories or ranges. SuperQuery can automatically create a new “virtual” column that classifies a numeric column into three ranges; High, Medium, and Low. You can change the number of categories and specify the ranges.

Moreover, SuperQuery allows general classification on other types of columns like Date and Text. You can create a virtual column that contains criteria on one or more columns. For example, you can classify your active customers as follows:

Large Customer if shipyear = 95 and sales > 100

Medium Customerifshipyear = 95 and sales isbetween( 10, 100 )

Small Customer if shipyear = 95 and sales < 10

Once you create the “Active Customers” column, SuperQuery is able to find facts about your Large, Medium, and Small customers. The more classified your data is, the more opportunities for finding interesting facts.

Virtual columns also include a “Formula” type that allows the user to create calculated columns. For example create a “Total Cost” column multiplying Quantity by Price columns. Another type is the “Keyword” column that detects keywords from description columns.

This tutorial will show you how to analyze and mine your data using SuperQuery. In the following chapters you will learn how to:

·Access your product sales data that is stored in the Sales table.

·Browse, set filters and create visual queries.

·Discover the hidden patterns in your data that are potentially useful.

·Summarize your sales data by product.

The tutorial consists of 5 chapters, each requires about 10 minutes.

Launch SuperQuery

If you are in the "Getting Started" dialog then, go to step 2.

If you are in the SuperQuery main screen then, select the Table | Open Wizard menu item and go to "Read the Data" section.

1.Launch SuperQuery

Click the Start button, click Programs and click SuperQuery. In the list of SuperQuery items that appears, click SuperQuery.

The SuperQuery Getting Started dialog appears

2. Click on the "Use Wizard to read your data" button. Press OK.

Read the Data

To access your data, you first need to read the database. SuperQuery will start the Open Wizard to help you read your table.

1. In the Data sources list, select Excel 7.0. Press "Next" button.

2. Press "Next" button to accept reading the table.

3. Press "Browse" button to locate the "Sales.xls" file on your disk. The file was installed in the same directory as SuperQuery. Press "Next" button.

4. Select the Sales$ from the drop-down box. Press "Next" button.

5. In the "Criteria / Scope" page press "Next" button.

6. In the "SuperQuery Database - Table names" page, leave the default names and press "Next" button.

7. Press "Read" button to start reading the data into the system. After the reading is complete, SuperQuery will create a new view for the data. Press "Next" button

8. Click on the "Analysis Wizard" button. Press "Next" button.

9. Click on the drop-down box to select the "Sales$" table. Press "Next" button.

10. Click on the "Classify numerical column into ranges" button. Press "Next" button

11. SuperQuery automatically selects all numerical columns to perform the analysis on them. Hence the two columns "PROFITDLR" (profit in dollars) and "QTYSOLD" (quantity sold) are chosen. Press "Next" button.

12. Edit the two new names "rPROFITDLR" and "rQTYSOLD" to "Profit" and "Quantity" by double clicking on the names. Press "Next" button.

13. Press "Start" button. SuperQuery will create the new columns and insert them in the data view. Press "Next" button when done.

14. Press "Finish" button twice to terminate the Analysis Wizard and to return again to the Open Wizard.

Chapter 1: Getting Started in SuperQuery

Chapter 2: Organizing your Data

Chapter 3: Querying the Database

Chapter 4: Discovering Facts and Rules

Chapter 5: Summarizing your Data

Since you will create more views in the coming sections, you need to organize these views in order to easily access them.

SuperQuery main screen consists of one row of eight tabs. You can edit the tab title and change the tab color. You can explore these features from the tab property menu. To display the property menu, click the right mouse button on the tab you want to edit.

From the property menu of the first tab, select the "Title" menu item and write down " Sales Data" in the "Edit Title" edit box, then press OK. Repeat for the second tab, and write down the title "Product Summary".

Now we need to copy the main data view and put it in a separate tab before performing more analysis. Press the Duplicate button. SuperQuery creates a new copy of the same view. To move this view to the third tab, press the button. The button state will change to indicating that the view is now floating. Click on the third tab, in order to activate it. The current active tab becomes the third tab and the view still floats on this tab. Press the button again. The view is now fixed in this tab and the button state changes to . Write down the title "Raw Data" on the third tab in the same way you did for the two previous tabs.

SuperQuery's data view consists of four panes; the main pane is the Data Table that controls the scrolling of other panes. The other three panes are: Total Page, Reps Graph and the Data Page. Each pane has a re-sizable frame, to allow you to change pane size according to your preferences and the type of the analysis you are performing.

As you move the mouse on the pane frames, the cursor changes to in order to re-size vertical splitters and to re-size horizontal splitters separating the panes. As you move the cursor towards the splitter ends, the cursor changes to one of the following shapes in order to maximize or minimize the pane in the arrow's direction.

To change the pane type simply, select the "Change Type" menu item from the pane property menu. To display the property menu, click on the right mouse button when placed on the pane you want to edit. Select the new pane type from the list of the available types. Each pane has its own unique property menu that is tailored to its own functionality.

It is recommended that you spend some time to familiarize yourself with the different pane types and their properties in order to explore the strengths and capabilities of the system.

Chapter 1: Getting Started in SuperQuery

Chapter 2: Organizing your Data

Chapter 3: Querying the Database

Chapter 4: Discovering Facts and Rules

Chapter 5: Summarizing your Data

Chapter3 Querying the Database

Now that you have the view of the table "Sales", you can start browsing, exploring and learning more about your data.

SuperQuery Table View contains several panes separated by Splitters. As you are scrolling in the Data Table pane, all other panes in the same view are updated at all times. You can completely reconfigure any view by including some or all pane types.

Simple Queries:

In the Sales view:

Click on the "Sales Data" tab. Move the cursor through the columns, and look at the Reps Graph to see the most common values in each column.

Go to a numerical column "PROFITDLR" or "QTYSOLD" and look at the Total Page pane to see the total, average, minimum and maximum values.

Click on any cell in the "CITY" column. The Reps Graph pane will show the most common values in this column. Double click on the "New York" bar in the graph. SuperQuery will immediately position the cursor in the Data Table at the first row that has the value "CITY = New York". Now push the filter button, and you will see only those rows satisfying that value "CITY = New York". Scroll through the other columns and watch all graphs and statistics calculated for New York. Furthermore, move to the "Profit" column and place the cursor on any cell having the value "High" then press the button again. This will simply perform the Query "City = New York AND Profit = High". This means that you are only viewing sales in New York City, which has high profits.

As you may have noticed, both "Profit" and "Quantity" columns have the cyan color, to reflect that they are calculated by the system. The Analysis Wizard created these two columns when you were reading the data table.

In order to edit the "Profit" column; first make sure that no filters are set on the view. To release all filters, press on the button, so that the green light is turned off. Double click on the column "Profit", the "Enter Ranges" dialog is displayed. Click on "5 Range" button and press OK. The column will be recalculated to map the original numerical values into five ranges (Very High, High, Medium, Low and Very Low) instead of three ranges (High, Medium, and Low).

More Comprehensive Queries:

In the "Sales" table, suppose that you want to study the New York City sales only during the winter. To do this, you need to create a new column of type "Filter" to perform the criterion: CITY = New York and MONTH is one of (December, January and February).

Click on the first tab "Sales Data" in order to work with the Sales data view. Make sure that no filters are set on the view. To release all filters press on the button, so that the green light is turned off.

1. Place the cursor on the column " CITY" and press the button. The Add / Edit Virtual Columns dialog is displayed. Type the new column name "NY Winter Sales" in the "Select / Add column" edit box. Press on the "Filter" button. The "Enter Criteria" dialog is displayed.

2. To create the first part of the criteria "CITY = New York" double click on the cyan cell next to "CITY", the Enter Criterion dialog is displayed.

3. Click on the drop-down box to select the operator "=". Select the value "New York. Press OK to return back to the "Enter Criteria" dialog.

4. In order to AND another criterion, simply double click on any other cyan cell in the same column that has the previous criterion you created. On the other hand, if you want to OR ANOTHER criterion, double click on any other cyan cell in the same ROW. Now to AND the second part of the criteria "MONTH is one of (December, January and February)", double click on the cell next to the "MONTH", again the "Enter Criterion" dialog is displayed.

5. Click on the drop-down box to select the operator " is one of". Select the values "December, January and February" from the list and press OK. The Enter Criteria dialog will show the criterion " is one of (December, January and February)" in the cell next to the "MONTH". Press OK to return back to the Enter Criteria dialog. Press OK.

6. SuperQuery will create the new column "NY Winter Sales" and add it to the view before the "CITY" column. The new column will be given a cyan color indicating that the column is a calculated column (Virtual Column).

7. On the graph double click on the "True", the cursor will be placed on the first value equal to "True" in the "NY Winter Sales" column. Press the filter button to show only the values satisfying the criteria. Now move the cursor on the column "QTYSOLD" and "PROFITDLR" and study the statistics of each column from the "Total page" pane.

Chapter 1: Getting Started in SuperQuery

Chapter 2: Organizing your Data

Chapter 3: Querying the Database

Chapter 4: Discovering Facts and Rules

Chapter 5: Summarizing your Data

Now you are ready to run the most powerful feature in SuperQuery and discover the patterns hidden in the data.

Click on the first tab "Sales Data" in order to work again with the Sales data view. Make sure that no filters are set on the view. To release all filters, press on the filter button, so that the green light is turned off.

1. Press the Facts button to display the "Fact Discovery Engine" dialog.

2. In the "Select / Add Fact Table" edit box, write down "Profit Facts" to name the new Facts table. SuperQuery will store all the discovered facts and exceptions in this table.

3. From the "Then conclusion" drop-down list, select the Profit column.

4. Because the example data table is a small table, we need to change the settings of the Fact Discovery Engine to increase the number of facts discovered. Press the "Settings…" button.

5. The Fact Settings will display. Move the first blue slider to the right so that it shows 90% at the right side. Move all other blue sliders to 80%. This means that you are tuning the engine to discover more facts.

6. From the "Maximum Fact Level" drop-down box, select 2.

7. Press OK to exit this dialog.

8. In the "Fact Discovery Engine" dialog, press Run.

9. Once the "Run" button is pressed, SuperQuery starts the Fact Discovery Engine and displays the "Facts Progress" dialog showing facts as the engine discovers them. The dialog gives some useful information about the engine performance as it discovers the facts.

When the engine finishes scanning the data , it asks you if you want to view the discovered facts in a table view. Press "Yes" to view the facts in the SuperQuery Facts View.

The new view will be floating on top of the data view. You can move this view to one of the empty tabs and edit its title to read "Profit Facts" (as explained in Chapter 2).

Now you can scroll through the "Fact Table View" rows and read the facts. Notice that as you are scrolling in the rows, the Facts pane (the pane below the Data Table pane) shows the description of the current fact in natural language. For example, in the first row, you should have a fact similar to following:

This Fact means that "Most Hat Sales have Medium Profits." The fact has a certainty factor of 80% and there are 25 rows supporting this fact.

You can also look at the Facts pane and read the same fact in a more natural language "Most Sales where PRODUCT = Hat --> have Profit = Medium. Percentage 80% Supported by 25 rows." You can also read the fact in the Rules format. To do this, click on the Right mouse button when placed on the Facts pane and check the Rules Format. The text will be changed to "If PRODUCT = Hat --> then Profit = Medium. Confidence 80% Supported by 25 rows."

Press the Drill-Down button to view those data rows supporting this fact. SuperQuery will create a new data view and set filter on those data rows. You can close the view or move it to another tab.

It is sometimes easier to read the discovered facts in a report form. SuperQuery allows you to export the discovered facts into text files in both Facts and Rules format. From the Table menu, select the Export | Facts menu items. When the "Select Table" dialog is displayed, select the "Profit Facts" table. Press OK, the Save As dialog is displayed. Write down "ProfFact" in the "File name" edit box and press OK. SuperQuery saves the new file as a text file "ProfFact.txt". Open this file using any text editors and view the text. Try to do the same steps to export the Facts Tables in the Rules format and compare the two.

In situations where you have a lot of facts, it is useful to be able to set filters on specific types of facts and also see a graph of the distribution of facts among columns and values. To do this, you need the "Reps Graph Pane" which is already in the view but minimized. Use the splitter bar at the right side to resize it, then scroll through the view columns to see the different distributions.

Chapter 1: Getting Started in SuperQuery

Chapter 2: Organizing your Data

Chapter 3: Querying the Database

Chapter 4: Discovering Facts and Rules

Chapter 5: Summarizing your Data

Suppose that you want to analyze your sales by product. For example, for each product, you want to know:

The most common city and month in sales,

The total quantity sold, and

The total profit.

Now click on the first tab "Sales Data" in order to work again with the Sales data view. Make sure that no filters are set on the view. To release all filters, press on the filter button so that the green light is turned off.

On the sales view, press the Summary button; the Add / Edit Summary table dialog is displayed.

In the Select / Add Summary Table edit box, write down "Product Summary" to name the new Summary table. Click on the "Group By" drop-down box to select the PRODUCT column. Press the "Select Cols" button in order to select the columns City, Month, QTYSOLD and PROFITDLR and their associated summary operators. The "Select columns and their summary calculations" dialog is displayed.

Check the boxes next to the columns: City, Month, QTYSOLD and PROFITDLR. Click on the drop-down box next to the "CITY", and select the operator "Most common". Also for the "MONTH", select the operator "Most common". For both "QTYSOLD" and "PROFITDLR", select the operator "Total". Press OK to return back to the Add / Edit Summary Table dialog and press OK.

SuperQuery will summarize the data on each of the products: Coat, Glove, Hat, Jacket and Shirt and will show them in a new Summary view.

The new view will be floating on the top of the data view. Move this view to third tab "Product Summary". To do this, click on the "Product Summary" tab. The view will move to this tab. Press on the button to fix the view in this tab.

The first row in the summary view reveals the following :

1. Boston is the most common city in coat sales.

2. December is the most common month in coats sales.

3. The total quantity sold for coats are 7260.

4. The total profit for selling coats are $13150.

In order to view those rows that have "PRODUCT = Coat", place the cursor on the first row and click on the Drill-Down button. SuperQuery will create a new data view and set a filter on those data rows. You can close the view or move it to another tab.

The Data Graph is showing the values of the column you have the cursor on. In this case, the graph is showing the values of the column "Total QTYSOLD". It is clear that Shirts are the highest quantity sold since they have the longest bar in the graph. You can set the Graph Pane to show the highest or lowest values using its property menu.

Browse through the summary view rows and columns and look at the Data Graph and experiment with changing the property of each pane.

Chapter 1: Getting Started in SuperQuery

Chapter 2: Organizing your Data

Chapter 3: Querying the Database

Chapter 4: Discovering Facts and Rules

Chapter 5: Summarizing your Data

System Description

SuperQuery defines three major concepts are for data visualization and organization:

Tab or Folder

Table view (TV)

Pane

Virtual Columns

Query and Statistical Analysis

Tab Organization

Criteria

Calculation statement

Statistical calculations

Operators:

Text Operators

Date Operators

Logical Operators

Mathematical Operators

Numerical Operators

Summary operator

Criteria Operators

Calculation Statement Operators

Value (s).

Column identifier

Primary key

Foreign Key

SQL Types

SuperQuery allows you to create queries visually in a “Query-By-Example” style. Furthermore, there are a number of short cuts that let you interact faster with your data. For example:

• When you click the filter button, a filter is set on the current cell value. You can restrict the filter more by selecting another cell and pressing the filter button again.

• As you move between columns, the statistical information of the current column is displayed along with a chart representing the distribution of its values and any relevant facts.

• Any table view can contain several panes separated by Splitters. All panes are kept in sync at all times.

Examples of SuperQuery Panes are:

• Total Panes -- Shows total, average, ... for current numeric column

• Graph Panes -- Shows a graph indicating the most common values or the highest values , etc.

• Fact Pane -- For the current fact row, shows a textual representation of the fact.

• Notes -- Allows the user to write notes about the view

The user can completely configure any view by including some or all pane types. Panes process rows selected in the filter, for example, if you need to find total sales from NY then:

• Set a filter on NY (move to any cell that have NY and press the filter button)

• move to the sales column

• “Total” pane now displays total NY sales (as well as average, max, etc.).

Similarly, if you need to find how you shipped to NY, move to the shipment column and look at the Reps Graph. The Graph will show the percentage of your different shipment methods to NY.

In order to create a comprehensive analysis on your data, you need to create several views. Some views showing rows sharing common criteria or compose a specific fact. In order to be able to organize these views, SuperQuery provides a Hierarchical Tab Organizer. Initially, you have eight empty Tabs.

You can start organizing your data views in these tabs. Each view has a “pin” button. You simply click the button to “fix” the view in the current tab. Similarly you click the pin again to make the view “floating”, then change to another tab and “fix” it there. If you need more tabs, you can add a new group of tabs inside any of the exiting ones. This allows you to create as many tabs as you want .

SuperQuery allows you to build criteria in a very easy manner ; SQ criterion consists of any number of Expressions ANDed or ORed together.

Each expression consists of : Column identifier Operator Value (s)

See the criterion example

See the criteria example

The Calculation statement consists of one or more Operands and one Operator.

The Operand types are:

• Numerical data

• Text data

• Date data

• Logical data

• Another Calculation statement

• a mix of any of the above operands

The Operator types are:

Numerical Operators

Text Operators

Date Operators

Logical Operators

Mathematical Operators

You may choose among these operator types depending on the operand's type.

SuperQuery supports a wide selection of comparison operators, following is a list of these operators:

Logical Operators

Summary operator

SuperQuery supports the five following Calculation Statement operator's types:

Numerical Operators

Text Operators

Date Operators

Logical Operators

Mathematical Operators

The column identifier is any valid column name that exists in the data table.

A primary key is the table key. It is a data column with unique values. An example of the primary key is Employer Name column in the Employee table.

The foreign  key in a table is a column that represents the primary key of another table . Each table may contain non-or many foreign keys.

SuperQuery Supports the following SQL types list which contains the major ODBC SQL types:

1. BigInt

2. Binary

3. Bit

4. Char

5. Date

6. Decimal

7. Double

8. Float

9. Integer

10. LongVarBinary

11. LongVarChar

12. Numeric

13. Real

14. SmallInt

15. Time

16. TimeStamp

17. TinyInt

18. VarBinary

19. VarChar

1. TOTAL calculates the sum of the data points. The equation for total is : sum( x )

2. AVERAGE calculates the average of data points. The equation for average is: 1/n( sum( x ) )

3. MAXIMUM calculates the maximum data point among the data points.

4. MINIMUM calculates the minimum data point among the data points.

5. AVEDEV calculates the average of the absolute deviations of data points from their mean. AVEDEV is a measure of the variability in a data set. The equation for average deviation is: 1/n( sum( x - Ave ( x ) ) )

6. HARMEAN calculates the harmonic mean of a data set. The harmonic mean is the reciprocal of the arithmetic mean of reciprocals. The equation for the harmonic mean is: 1/n sum ( 1/xi )

7. KURT calculates the kurtosis of a data set. Kurtosis characterizes the relative peakness or flatness of a distribution compared to the normal distribution. Positive kurtosis indicates a relatively peaked distribution. Negative kurtosis indicates a relatively flat distribution. Kurtosis is defined as (n(n+1)/(n-1)(n-2)(n-3) sum( (xi-ave(xi)) / std(x) )^4)) - (3((n-1)^2) / (n-2)(n-3))

8. SKEW calculates the skewness of a distribution. Skewness characterizes the degree of asymmetry of a distribution around its mean. Positive skewness indicates a distribution with an asymmetric tail extending towards more positive values. Negative skewness indicates a distribution with an asymmetric tail extending towards more negative values. The equation for skewness is defined as: n/(n-1)(n-2) sum( (xi-ave(xi)) / std(x) )^3)

9. STDEV calculates standard deviation based on a sample. The standard deviation is a measure of how widely values are dispersed from the average value (the mean). STDEV uses the following formula: sqrt( (n sum(x^2) - (sum(x))^2) / n(n-1) )

10. STDEVP calculates standard deviation based on the entire population given as arguments. The standard deviation is a measure of how widely values are dispersed from the average value (the mean). STDEVP uses the following formula: sqrt( (n sum(x^2) - (sum(x))^2) / n^2 )

11. VAR calculates variance based on a sample. VAR uses the following formula: (n sum(x^2) - (sum(x))^2) / n(n-1)

12. VARP calculates variance based on the entire population. The equation for VARP is : (n sum(x^2) - (sum(x))^2) / n^2

13. Count counts the number of total number of rows.

14. Distinct Count the number of the distinct values.

15. Median calculates the median of the column values.

16. Most Common finds the most common value.

17. MC % calculates the percentage of the most common value to the total number of the rows.

18. MC # counts of the occurrence of the most common value.

19. Least Common finds the least common value.

20. LC % calculates the percentage of the least common value to the total number of the rows.

21. LC # counts of the occurrence of the most common value.

Values may be literal for example, 100 and “New Jersey” and may not be in the table, or may selected from the existing values.

The main window in SuperQuery contains a set of tabs or folders. Each tab may have data Table Views or other tabs (but not both). This means you can have a hierarchy of tabs. A new SuperQuery document contains one tab-level that has eight tabs. You may add any number of tabs at this level or create more levels of tabs within any tab. Tab customization includes:

Editing the tab title

Changing the tab background color

Moving views from one tab to the other

Adding tabs to a specific tab level or even Adding tab level to within another tab

Select the tab, then, choose the Tab | Title from the main menu, or click on the right mouse button on the tab and choose the title menu item. The Edit Title dialog will be displayed to allow you to enter or edit the tab name.

Select the tab, then choose the Tab | Color from the main menu or, click the right mouse button on the tab and choose the Color menu item. The Color dialog will be displayed to allow you to change the tab background color.

Select the tab level that you want to add a tab to, by clicking on any of its tabs. Choose the Tab | New | Tab from the main menu or, click the right mouse button on the tab and choose the New | Tab menu item.

Select an empty tab that you want to insert a tab level in. Choose the Tab | New | Tab Level from the main menu or, click the right mouse button on the tab and choose the New | Tab Level menu item. The Insert Tab(s) dialog will be displayed.

SuperQuery Table View is a new innovative way of viewing the data. Each Table View consists of a set of Panes. Each pane displays data from its own point of view.

The SuperQuery standard Table View consists of four panes; the main pane is the

Data Table Pane that controls the scrolling of the other three panes; Total Page Pane,

Reps Graph Pane and the Data Page Pane.

Each pane has a re-sizable frame, to allow you to change pane size according to your preferences and type of analysis. As you move the mouse on the pane frame, the cursor shape changes to show the re-sizing cursor and to show which frame to re-size. To maximize or minimize a pane, use the small button located at both ends of each frame.

Table view contains a row of 12 sets of buttons:

A pane is a re-sizable window that displays data in a certain way. SuperQuery provides 10 types of panes:

• Data Table Pane

• Data Page Pane

• Reps Table Pane

• Reps Graph Pane

• Data Graph Pane

• Total Page Pane

• Total Table Pane

• Notes Pane

• Data Cell Pane

• Facts Pane

The standard Table View panes are the Data Table Pane, Data Page Pane, Reps Graph Pane and the Data Page Pane. You can change the type of any pane but you must have one Data Table Pane. You can't have more than one pane of each type.

To change the pane type:

1. Place the mouse on the pane you want to change.
2. Click on the right mouse button to get the property menu.
3. Select the “Change Type” menu item to view all the available pane types, and select the new pane type.

Data Cell Pane is a view of the current cell. It is useful for displaying memo fields or long text lines.

To change the properties of the Data Cell Pane, click on the right mouse button (when placed on the Data Cell Pane) the Data cell pane menu will pop up. Select the property you want change.

 The graph consists of horizontal bars representing the numerical values of the data fields in the current column. The left side of the graph shows the row number and the content of the first column. The right side of the bar shows the numerical value. You can set the graph to show the highest or lowest number of values.

If you double click on any bar, SuperQuery will go to that row number. You can then set a filter to study all rows that have this value.

To change the properties of the Data Graph Pane, click on the right mouse button (when placed on the Data Graph Pane) the Data graph pane menu will pop up. Select the property you want change.

Data Page Pane is a page view of the current row. The pane’s first column contains names of the view columns. The second column ( in the pane ) contains the current row data.

When you scroll in the Data Page Pane, SuperQuery will update all other panes in the Table View.

To change the properties of the Data Page Pane, click on the right mouse button (when placed on the Data Page Pane) the Data page pane menu will pop up. Select the property you want change.

The Data Table Pane is the main pane in SuperQuery.

The first row shows column headers, and the first column shows the row numbers (initially hidden). You can keep the first column or hide it, using the property menu item -- Display row headers. The status bar shows the total number of rows and the current row number.

As you scroll across columns and the rows of the Data Table Pane, all other panes in the view will consequently update their content.

When you double click on any virtual column in the Data Table Pane, SuperQuery will bring up the corresponding edit dialog for that virtual column type.

To change the properties of the Data Table Pane, click on the right mouse button ( when placed on the Data Table pane) the Data table pane menu will pop up. Select the property you want change.

Facts pane rewrites the current row in the facts table in a more natural language form. You have the option to select the formatting in either a "Facts - Exception" or "if ... then" form.

To change the properties of the Facts Pane, click on the right mouse button (when placed on the Facts Pane) the Facts pane menu will pop up. Select the property you want change.

Notes Pane is a window that you can use to write any comments about the view.

To change the properties of the Notes Pane, click on the right mouse button (when placed on the Notes Pane) the Notes pane menu will pop up. Select the property you want change.

This pane displays the repetition of values in the current column. It shows the number of occurrences (or frequency) of each individual value in a graphical representation.

The graph consists of horizontal bars representing the unique values in the current column. On the right side of the bars are the corresponding number of rows and their percentage to the total number of rows.

If you double click on any bar, SuperQuery will search for the first row that has that value. You can then set a filter to study all rows that have this value.

To change the properties of the Reps Graph Pane, click on the right mouse button (when placed on the Reps Graph Pane) the Reps graph pane menu will pop up. Select the property you want change.

Reps Table Pane

Reps Table Pane displays the repetition of values in the current column. It shows the number of occurrences (or frequency) of each individual value.

If you double click in any of the value cells, SuperQuery will search for the first row that has that value. You can then set a filter to study all rows that have this value.

To change the properties of the Reps table Pane, click on the right mouse button (when placed on the Reps Table Pane) the Reps table pane menu will pop up. Select the property you want change.

Total Page Pane displays statistics about the current numerical column. You can add or remove from the set of default statistical calculations that were selected.

When you double click on a value in the pane, SuperQuery will search for the first row that has that value. This makes it easy to locate rows that have the maximum or minimum values for example.

To change the properties of the Total Page Pane click, on the right mouse button (when placed on the Total Page Pane) the Total page pane menu will pop up. Select the property you want change.

Total Table Pane works exactly the same as the Total Page Pane but with extended view to show the result of the selected statistical calculations when applied to all the numerical columns in the view.

When you double click on a value in the pane, SuperQuery will search for the first row that has that value. This makes it easy to locate rows that have the maximum or minimum values for example.

To change the properties of the Total Table Pane, click on the right mouse button (when placed on the Total Table Pane) the Total table pane menu will pop up. Select the property you want change.

Panes properties menus

Data table pane menu

Data page pane menu

Reps table pane menu

Reps graph pane menu

Data graph pane menu

Total page pane menu

Total table pane menu

Notes pane menu

Data cell pane menu

Facts pane menu

Data table pane menu commands

Facts pane menu commands

From the Getting Started dialog you can either select any SuperQuery document from the drop down list, or the Use Wizard to read your data button to run the Open Wizard to help you to open your data.

or

From the File menu select any of the three menu items:

From the Table menu select the Open Wizard menu item. The Open Wizard will run and will assist you to open your data. 

From the View menu select the Facts menu item or press the Facts button to display the Add / Edit Table Facts dialog or the Facts Engine dialog to create a new fact table. When you press the Run button, the fact engine starts and the system automatically generates a new table view on the new created Facts Table.

 From the View menu select the Summary menu item or press the Summary button to display the Add / Edit Summary Table Dialog in order to create a new Summary Table. Press the Select Cols button to select the columns you want to include in the summary table. When you finish with the dialog press OK, the system automatically generates a new table view on the new created Summary Table. 

From the Table menu select the Update Wizard menu item. The Update Wizard will run and will assist you to update your data. 

1. Place the mouse on the pane you want to change.

2. Click on the right mouse button to display the property menu.

3. Select the property you want to change.

1. Place the mouse on the pane you want to change.

2. Click on the right mouse button to display the property menu.

3. Select the “Change Type” menu item to view all the available pane types, and select the new pane type.  

1. Select a table to open using the Table | Open Wizard menu

2. The wizard allows you to specify criteria, when you press the criteria button the Enter criteria dialog will be displayed.

3. Double click on any of the cyan cells next to the selected criterion column, the

4. Edit Criterion dialog will be displayed to select the criterion operator and value(s). 

5. To AND another criterion to the one previously entered, simply double click on any other cell in the same column containing the previous criterion. On the other hand, to OR another criterion, double click on any cell within the nine criterion's columns.  

From the Table menu select The Analysis Wizard menu item to run the Analysis Wizard that will assist you to create the virtual column, or:

1. From the View menu select Virtual Column menu item or press on the Add Virtual Columns button on the Table View

2. The Add / Edit Virtual Columns Dialog will be displayed, you can either create a new virtual column or select one of existing columns (if any).

3. Select one of the five buttons corresponding to required virtual column type.

You can then follow the instructions in each dialog.

How to create a Filter column?
How to create a Range column?
How to create a Classification column?
How to create a Formula column?
How to create a Keyword column?

1. Select View | Add column from the main menu or press on the Add Virtual Columns button on the Table View.

2. The Add / Edit Virtual Columns Dialog will be displayed. You can either select or create a new Filter Column

3. Press the filter button to display the Enter Criteria Dialog to build the criteria.

1. Select view | Add column from the main menu or press on the Add Virtual Columns button on the Table View.

2. The Add / Edit Virtual Columns Dialog will be displayed. You can either select or create a new Formula Column.

3. The Enter Value-Formula Dialog will be displayed allowing you to enter a number of calculation statement.

SuperQuery creates a new column and places the result of the last calculation statement.

Note that the evaluation of the last calculation statement will automatically calculate all the contained statements (if any)

1. Select View | Add column from the main menu or press on the Add Virtual Columns button on the Table View.

2. The Add / Edit Virtual Columns Dialog will be displayed. You can either select or create a new Range Column.

3. The Enter Ranges Dialog will be displayed to create a number of ranges to map the selected numerical column values.

1. Select view | Add column from the main menu or press the Add Virtual Columns button on the Table View. 

2. The Add / Edit Virtual Columns Dialog will be displayed. You can either select or create a new Classification Column.

3.  

4. The Enter Value - Criteria Dialog will be displayed and allows you to enter a number of criteria - value combination.

SuperQuery scans all the data rows evaluating each criterion at each row. The category name associated with the first criterion that evaluates to TRUE, is placed in the classification column. If none of the criteria matches, SuperQuery inserts “Unclassified” in the

Note you may replace the "Unclassified" word by writing any word at the row following the last row containing a value - criteria pair.

1. Select view | Add column from the main menu or press on the Add Virtual Columns button on the Table View. 

2. The Add / Edit Virtual Columns Dialog will be displayed. You can either select or create a new Keyword Column.

3. The Edit / Add Keyword dialog will be displayed to let you enter the Keyword.

SuperQuery searches in the current column rows for the keyword. If SuperQuery finds the word among the data text, it will place the word in the new column row corresponding to that of the data table.

You can add two types of graphs to your view: Reps Graph and Data Graph. To add a graph to the view, you need to change the type of one of the existing panes to the new graph pane type. To do this:

1. Place the mouse on the pane you want to change.

2. Click on the right mouse button to get the property menu.

3. Select the “Change Type” menu item to view all the available pane types, and select the either the Reps Graph pane or Data Graph pane.  

 SuperQuery allows you to export both the data tables and the generated facts into text files.

Select Table | Export | Tab delimited to export data tables into a tab delimited file. The system will display the Select Table Dialog to select a table that you want to export, then will display the Save As dialog to save the new file.

• Select Table | Export | Facts to export the facts generated into a "Fact - Exception" format text file.

• Select Table | Export | Rules to export the facts generated into an "If ... Then" format text file.

Select the view that you want to move and make it floating by pressing the view Fix button.

Select the destination tab to make it the current tab, then click the Fix button again to fix the view there.

1. Open all tables you want to link using the Open Wizard. Make sure to select the same database name for all the tables you want to link. 

2. After you finish reading all the tables select the define links in the Open Wizard or from the application main menu select Table | Link menu   item. The Edit Table Keys dialog displays.  The dialog displays all the open tables in the current database in the “Table” column.

3. Click on the drop-down button next to the table you want to define its primary key "primary key".

4. To select the foreign key (s) double click on the cell  next to the table you want to define its foreign key (s), or place the active grid cell on the table and click on the “Edit Foreign Key” button. The Edit Foreign Keys dialog  displays

5. Define the foreign keys of the table. After you finish with the dialog the keys you defined will be displayed in the cell next to the table under the “Foreign Key” column. In order to define a foreign key (s) you will have to specify the foreign table and its primary key "primary key"  from within the same database and to associate them with one of the table (the one you are editing) columns.  The dialog displays all column names in the table you are editing to select the foreign column "foreign column" (s) from them. Click on the drop-down button next to foreign column "foreign column"  you selected under the “Foreign Table- Key” column to display all the [Primary Table - Key] combinations in the open database to associate on combination with selected foreign key.

Press the Fix button to fix or float a view in the current tab. To move a view from one tab to another, first float the view, switch to the other tab, then fix the view.

Select Columns button

Press the Select Columns button to display the Select and reorder columns dialog in order to select or deselect columns in the view.

Press the Duplicate button to duplicate the current view. You can use the Duplicate button to create a new copy of the view. You can then set a different filter, maximize a graph pane, or in general, perform further analysis on the new view.

Press the Print button, to see a print-preview the current data table view. Press the print button from the preview screen to start the printing to your printer.

Press the Find button to display the Find dialog that allows you to search for a specific word or phrase in the current column.

Filter buttons are composed of three buttons. When you press the left button, SuperQuery sets a filter on the value in the current cell in the Data Table Pane. Only rows that have the filter value are shown in the view. If you move to another cell and press the button again, the filter further restricted by the new value. Each time you press this button, you are ANDing the current cell value to the filter.

The button at the right side, is an "undo" filter operation. It will remove the last filter you set and hence expands the view.

The middle button acts mainly as an indicator to show you if there is a filter set. You can also use it as a shortcut to clear all filters.

It is important to note that all panes will change their contents according to the current filter. For example, “Total” panes will display totals for all rows in the filter.

Index buttons are composed of two buttons. The left button displays the Add / Edit Table Index dialog that allows you to create, edit, or select a Table Index. The right button acts as an indicator and a shortcut to set or set the current index.

Press the Add virtual columns button to display the Add / Edit Virtual Columns dialog, which helps you create, edit, or delete a virtual column.

SuperQuery supports five types of the virtual columns:

Filter column

Range column

Keyword column

Classification column

Formula column

This button creates a detailed view of the current row in the view. This button exists only in the Summary and Facts tables . When you press it in a Summary view, SuperQuery creates a "Drill-Down" view the original data of the current row. Similarly, in the facts table view, the Drill-Down button displays all data rows that support the current fact.

Press the Summary button to display the Add / Edit Summary Table Dialog that will help you summarize a data table.

Press the Facts button to display the Add / Edit Table Facts dialog or the Facts Engine dialog that will let you run the fact engine.

Table name : Orders

Columns: Customer, Order_Value, Order_Date

Exp1 AND Exp2

Orders.Customer_Name begins with ‘Ch’ AND Orders.Order_Value >= 1000

In this example, the criterion statement consists of two ANDed criteria. The system will only consider data rows from the table Orders that has Customer_Name column beginning with ‘Ch’ and Order_Value >= 1000.

Table name : Orders

Columns: Customer, Order_Value, Order_Date

column identifier criteria operator value Orders.Customer_Name begins with ‘Ch’

In this example, the column identifier is Orders.Customer_ Name where, Orders is the table name and Customer_ Name is the column name.

This criterion selects rows that have Customer_Name that starts with the two letters ‘Ch’, e.g., Charles, Chris, ...

Table name : Orders

Columns: Customer, Order_Value, Order_Date

1. Suppose you want to classify your orders into 4 classes Large, Medium, Small and Old. You can create a classification virtual column as follows:

2. Click the virtual column button to get the Add / Edit Virtual Column dialog.

3. Enter a new name e.g. Order_Class

4. Push the Classification button to get to the Enter Value - Criteria dialog.

5. Type each class value in the value column and double click in the criteria column to enter the corresponding criteria as follows:

Value Criteria

Table name : Orders

Columns: Customer, Order_Value, Order_Date

Suppose that you want to view only orders that are greater than $1000.

You can create a filter virtual column as follows:

1. Push the virtual column button to get the Add / Edit Virtual Column dialog.

2. Enter a new name e.g. BigOrders

3. Push the Filter button to get the Enter Criteria dialog

4. Write the criterion statement.

A new column is inserted that has the two values TRUE and FALSE depending on whether the Order_Value satisfy the criteria or not.

You can move to a cell that has a TRUE value and push the filter button to view only those rows having the TRUE value. Similarly, you can view only rows that have FALSE values.

Notice that the criteria may contain more than one condition. For example, Order_Value > 1000 and Order_Month = August.

Table name : Orders

Columns: Customer, Qty, Unit Price

Suppose you want to create a new column that contains the total Order_Value.

You can create a formula virtual column as follows:

1. Push the virtual column button to get the Add / Edit Virtual Column dialog.

2. Enter a new name e.g. Order_Value

3. Push the Formula button to get to the Enter Value-Formula dialog

Name Calculation statement Result

Line1Qty * Unit_Price

Using the Orders table, the user may create a VISA column to reclassify the Payment_Method column. This allows for the analysis of customers who used Visa card for payment.

Table name : Orders

Columns: Customer, Order_Value, Order_Date

Suppose you want to classify your orders into three classes Low, Medium and High orders.

You can create a range virtual column as follows:

1. Push the virtual column button to get the Add / Edit Virtual Column dialog..

2. Enter a new name e.g. Order_Class

3. Push the Range button to get to the Enter Ranges dialog

4. Press OK to create a three range virtual column.

Low from the lowest value to 1000

Medium from 1000 to 3000

High from 3000 to the highest value available

A virtual column is a user-defined column that is based on one or more data ( and / or virtual ) column. The Virtual column is dependent on its source columns and is used to produce an analytical view of the data.

SuperQuery supports five types of the virtual columns:

Filter column

Range column

Keyword column

Classification column

Formula column

Fitter Column has TRUE / FALSE values based on a specific criteria statement.

see the Filter column example

The Range column is a mapping ( or partitioning ) of a numerical column into number of ranges or levels that you specify.

See the Range column example

The Keyword column is a straight and easy way to reclassify any data text column by searching for a keyword among the contents of the column.

see the Keyword column example

The Classification column is the general form of the filter column. You can classify your data using the Enter Value - Criteria Dialog into a number of categories each has its own criterion.

SuperQuery scans all the data rows evaluating each criterion at each row. The category name associated with the first criterion that evaluates to TRUE, is placed in the classification column. If none of the criteria matches, SuperQuery inserts “Unclassified” in the Note you may replace the "Unclassified" word by writing any word at the row following the last row containing a value - criteria pair.

See the Classification column example

 The Formula column contains the result of execution of one or more calculation statement that you specify.

see the Formula column example

Enter or edit the title of the selected tab.

You can create or select a summary table from the "Select / Add Summary Table" box. Select the “Group By” column(s) that you want to summarize your table on. This column should represent groups of values. Therefore, The "Group By" box will not show key columns or columns that has no repeated values.

If you want to select more than one Group By column, press the More button that will display four more combo boxes. Check the Ascending check box if you want to summarize columns in ascending manner or uncheck it to summarize in a descending manner.

Press the ” Select Cols” button to display the Select columns and their summary calculations dialog to select the summary columns and their associated calculations.

When you finish entering all the information, press the OK button, the system will then display a progress bar indicating its progress in creating the summary table.

You can also delete an existing summary table by selecting the table from the "Select / Add Summary Table" list and press the “Delete” button. 

 This dialog allows you to edit an existing Table Index or to create a new index.

The dialog consists of:

·Select / Add Index group contains:  

1. Combo Box containing the existing indexes. You can select an existing index or create a new index. To create a new index, simply enter a new name in the Combo box.

2. Delete button to delete an existing index.

3. Select Button to set the index and exit the dialog.

4. Edit button to edit the selected index. Edit Table Index dialog.

This dialog allows you to create a new ( or edit an existing ) Virtual Column .

The dialog consists of:

1. Combo Box containing the existing virtual columns. You can either select a column from the list or create a new column by entering a new name.

2. Delete button to delete one of the existing virtual columns.

3. Virtual column buttons.

4. When you select one of the existing virtual columns, one of the buttons is enabled depending on the selected column type. On the other hand, when you enter a new column name, all virtual column buttons are enabled. This allows you to choose the new column type.

Use this dialog to select the data table of the new view. If you want to select the view layout of the new view press the “View” button, the system will display the View Layout Dialog to select the layout.

Select one of the pane types from the “Change pane type to:” Combo box that contains all the available pane types. These pane types are the ones that do not exist in the current Table View. A Table View can not contain more than one pane from the each type.

Since the Data Table Pane is the main Table View Pane, you can not change its type to any other pane type.

This dialog allows you to change the height of grid rows. The new height is applied to all grid rows. Since the individual grid row height may be changed, the dialog will always show the first row height.

 See the Keyword column example

This Dialog allows you to create calculation statements by selecting an operator and its operands.

A list of six buttons shows the five different types of operators and the sixth button selects all types together. When choosing one of these buttons, the “Select operator” list box displays a list of operators from that type.

After you choose the operator, the “Operands - Current row” group will show the required number of operands.

An operand combo box contains:

• All table columns, including virtual columns.

• All calculation statements entered before this statement.

You can also enter directly any number or text as the operand value.

As a quick test of your statement, you can press the “Calc” button to view the value of operands at the current row, as well as the result of the calculation statement. You can review the result for other rows in the table by using the right and left arrow buttons to change the current row position.

 This dialog allows you to edit a criterion by selecting the operator and the operand (s).

The Value edit box allows you to type one or more values. When entering more than one value, separate each value by a comma.

Select the criterion operator from the ‘Criterion Operator’ combo box that contains all relevant operators.

Enter the Criterion values directly into the ‘Value (s)’ edit box or, press the values button to display Select Value(s) Dialog and select from a list of data table values.

To enter more than one value type the letter comma ‘,’ to separate them. The system will do it automatically if you select the values from the Select Value (s) Dialog.

 In order to define a foreign key(s) you will have to specify the foreign table and its primary key from within the same database and to associate them with one of the table( the one you are editing) columns.

The dialog displays all the column names in the table you are editing to select the foreign column (s) from them.

Click on the drop-down button next to foreign column you selected under the “Foreign Table- Key” column to display all the [ Primary Table - Key ] combinations in the open database to associate on combination with selected foreign key.

This command changes the number of bars in the graph. The default number of bars is seven. The system will automatically update the graph with the new number of bars.

Enter or edit the title of the selected tab.

The Edit Table Index dialog allows you to edit an existing Index. It allows you to select up to five columns to index your table on. The table will be sorted on the first column then the second and so on up to the last index column.

To build a new index, you enter the name of the index in the Add / Edit Table Index dialog, then press the Edit button to display the Edit Table Index dialog.

 The dialog displays all the open tables in the current database in the “Table” column.

Click on the drop-down button next to the table you want to define its primary key

To select the foreign key (s) double click on the “Foreign key” cell next to the table you want to define its foreign key (s), or place the active grid cell on the table and click on the “Edit Foreign Key” button.

The Edit Foreign Keys Dialog will be displayed for you to define the foreign keys of the table. After you finish with the dialog the keys you defined will be displayed in the cell next to the table under the “Foreign Key” column.

This dialog allows you to specify which columns as well as which rows to read.

Select the columns you want to read from the data table by checking or un-checking the boxes in the “Select” column.

To specify criteria, follow these steps: (example: Color = Red and Shape = Box)

1. Select your column identifier (Color)

2. Double click on the adjacent criteria cells. This will display the Edit Criterion dialog to allow you to build the actual criterion. 

3. When finished specifying the criterion, you will be back in this dialog with current cell containing the text of your criterion (Color=Red).

4. To AND another criterion, simply find your second column identifier (Shape) and double click on the cell in the same vertical column containing the previous criterion. This will repeat steps 2 and 3 to form your second criterion ( Shape = Box ).

On the other hand, to OR a criterion, instead of using the same vertical column as in step 4, use another vertical column.

The rule is simple; any criteria sharing the same vertical column in this dialog are ANDed otherwise they are ORed. Read the final criteria from top to bottom.

The complete criteria are always displayed in a text box at the bottom of the dialog.

Enter Ranges dialog

 The Enter Ranges dialog consists of a grid with three columns; the Value column, the Minimum range and the Maximum range. You can classify any numeric column into a number of ranges by entering the name of each range in the Value column and the corresponding maximum value.

The first minimum value and the last maximum value are automatically calculated by the system. As the data table is updated, the minimum and maximum are automatically recalculated.

SuperQuery copies each maximum to the minimum of the following range. This ensures the continuity of all ranges.

There are a number of pre-defined ranges that you can, these are:

1. Standard : Low, Medium and High.

2. Money : Inexpensive, Average and Expensive.

3. Length: Short, Medium and Long.

4. Weight: Light, Medium and Heavy.

5. Temperature: Cold, Moderate and Hot.

You can change the number of ranges from 3 as shown above to 5 by checking the 5 - Ranges button. The system will add two more ranges by adding the word “very” to both the first and the last ranges. You can edit these names and you can also add and delete any range values.

·Recalc. Min. & Max.

The Recalc. Min. & Max. button recalculates all the minimum and maximum ranges.

·Clear Grid

The Clear Grid button clears all ranges and entries made by you leaving the two default rows.

·Delete Range

The Delete Range button deletes the current range.

·Add Range

The Add Range button adds a blank range above the current cell.

See the Range column example

This dialog is a list of value / criteria pairs. For each row in the table, the system evaluates each of these criteria. If a criterion is satisfied, the corresponding value is placed in the classification column. If none of the criteria were satisfied, the system places “Unclassified” in the corresponding row in the classification column.

You can change the “Unclassified” word by entering any text in the value column without an associated criterion at the last entry.

This dialog consists of grid with two columns:

1. The Value column, where you enter a name for the criterion.

2. The Criteria column, where you enter the criterion. Double click on the criteria column to display the Enter Criteria dialog to edit the criteria.

The Insert row button is used for inserting a blank line above the current cell.

The Delete row button deletes the current line.

·See the Classification column example

This dialog allows you to easily create comprehensive calculations. It allows you to break down the formula into a number of calculation statements. Each calculation statement is evaluated separately on the current row of the Data Table. The result is placed in the last column in the table to allow you to test its functionality.

The “Variable” column contains the name of the Calculation Statement. You can enter any name.

Double click on the Calculation statement column to display Edit Calculation Statement dialog and edit the calculation statement.

Since calculating the last calculation statement will automatically calculate all statements involved, the system will only execute the last calculation statement.

The Insert row button is used for insetting a blank calculation statement above the current cell. The Delete row button deletes the current row with its content.

see the Formula column example 

Enter a new name in the ‘Select / Add Fact’ list box to create a new facts table or select one of the existing tables to edit.

The "If Condition" and "Then Conclusion" combo boxes allow you to instruct the engine to search using one or all columns in the condition part and in the conclusion part.

For example, in the following fact;

Most products where Product = Jacket have Profit = High. Percentage = 80%

"If Condition" column is Product and the "Then Conclusion" column is Profit.

You may be interested in facts about a specific column or about all columns.

You can store new facts in a new Table or you can use an existing Facts Table. If you use an existing facts table, then you can append or replace the new facts to the table. Check the “Append new facts” box to append any new generated facts to the selected Facts Table. If you uncheck the button the new facts will replace the existing ones.

To delete a Facts Table, select the table first then, press the delete button.

You can select whether you want Facts, Exceptions or both from the radio button group.

You can press the Filters button to remove or add certain types of facts. You can also use the Dependency button to specify interdependent groups of columns. The engine will not report any facts among these dependent columns. See hints and help within each dialog.

If you need to fine tune the performance of the Fact Engine, then press the Settings button to display the Fact Settings Dialog.

Press the Run button to start the Fact Engine. The system will then automatically generate facts, add them to the Facts Table, and arrange them in a new view. 

 Since you might be interested in facts about a specific column or about all column, the [Search for facts about:] combo box allows you to instruct the engine to search using one or all columns in the conclusion part.

For example, in the following fact;

Most products where Product = Jacket have Profit = High. Percentage = 80%.The " Conclusion" column is Profit.

You can select whether you want Facts, Exceptions or both from the radio button group.

You can use the Dependency button to specify interdependent groups of columns. The engine will not report any facts among these dependent columns. See hints and help within the Dependency dialog.

To increase or decrease the number of facts discovered , change the [Discover] slider. When you increase the slider, the engine will discover more facts by decreasing the support level requirements. This means that the engine will not require each fact to be supported by many data rows. On the other hand, when you decrease the slider, the engine will report less facts by raising the support requirements. This means that the engine will report those patterns supported by a larger number of data rows. Support level is the number of data rows that satisfies the fact or rule.

Press the Run button to start the Fact Engine. The system will display "Facts Progress Dialog" that displays the engine performance as it discovers facts.

After the system discovers all the facts, it displays the "Fact engine save results dialog" to allow you to browse through the facts and to give you the option to write facts to one of the following format: "If ... Then", "Fact - Exception..." or " Tab Delimited". 

 Ignore blank values

The Engine will ignore any value that is blank in either the condition or the conclusion side.

Ignore facts between a virtual column and its sources

The Engine will ignore any facts among a virtual column and all its source columns.

Ignore facts that conclude a most common value (MCV)

If this box is checked, the Engine will ignore all facts that have in the conclusion part a value that is already the most common value. For example, The fact that “Most Objects where Color = Red have Shape = Box” is ignored because “Box” is already the most common value in the Shape column. In other words, “Most objects have Shape = Box” is already given. In this Example Box is the MCV with 75% because we have 6 Boxes divided by 8 rows.

Example Table:

Ignore type "All"

Apply the above filter on facts of type “All”.

MCV > .. %

For the “All” filter, specify the percentage after which a value is considered a MCV.

Ignore type "Most"

Apply the above filter on facts of type “Most”

MCV > .. %

For the “Most” filter, specify the percentage after which a value is considered a MCV. 

 There are two sets of sliders used to fine tune the fact finding performance. The first set is the Facts settings sliders and the second is the Exception settings set.

In the Facts set, each slider controls the number of facts reported in a specific range. The first slider controls facts that are of type “All” and have a 100% confidence. The second slider is for facts of type “Most” and in the confidence range from 80% to 99%. The rest of the sliders cover the remaining 4 ranges. Sliders that control confidence ranges less than 50% are only useful when fact level is more than 1.

For example, if you increase the first slider, you will increase the number of facts reported that have a confidence of 100%. The fact engine will take more time and the new facts will be supported by fewer rows from the table.

In the Exception set, the first slider control exceptions that are less than 1% and the remaining sliders control the range up to 10%. When you increase a slider, you increase the number of exceptions reported in that range. On the other hand, decreasing the slider value, requires a higher clustering level. On the other hand, increasing the slider value, relaxes the clustering requirements.

Minimum Confidence Level:

This combo-box allows you to define the minimum confidence in reported facts. For example, if you select 70% then any fact of type Most must have at least 70% confidence factor. The confidence factor is the percentage of rows satisfying the fact to all rows in the filter. The default level is 60%. For example, the following table describes abstract objects that have color, shape and weight.

The following fact is generated if the “Most Level” is set at 60%.

Most(75%)objects that have Color = Red have Shape = Box (3 rows)

Consequently, if the “Most Level” is increased to 80%, then this fact is not reported.

Maximum fact level:

This combo-box allows you to define the Fact Level. The fact level is defined by the number of columns in the fact left side. For example in the following table,

The fact:

Most objects that have Color = Red have Shape = Box, is fact level 1 because it has one column at the left side (Color). On the other hand, the fact:

All objects that have Color = Red and Shape = Box have weight= 100, is fact level 2 because it has two columns at the left side( Color and Shape ).

Increasing the fact level increase the fact finding time. 

The following options allow you to specify the name and location of the file you're about to save:

File Name

Type a new filename to save a document with a different name. A filename can contain up to eight characters and an extension of up to three characters. SuperQuery uses the extension sqd to the name you specify.

Drives

Select the drive in which you want to store the document.

Directories

Select the directory in which you want to store the document.

Network...

Choose this button to connect to a network location, assigning it a new drive letter.

Use the find dialog to search for a word in the current Data Table column of the current view.

You can select the search pattern by either checking the Match whole word only or the match case.

The Match whole word only will exact compare the column fields with the word given. On the other hand the Match case will compare the fields taking into consideration the case sensitivity of the given word.

The dialog will then move the active cell of the Data Table pane to the first match found however, if the dialog fails to find a match the Data Table active cell will remain in its position and not move.

You can also control the direction of the search by selecting one of the Direction group buttons Up or Down.

Find next button will try to find the next match in the column fields. 

 Enter the number of tabs in the new level. The system will insert the new tab level into the current active tab.  

 Select one of the following available pane types to replace the pane you selected:

Data table pane menu

Data page pane menu

Reps table pane menu

Reps graph pane menu

Data graph pane menu

Total page pane menu

Total table pane menu

Notes pane menu

Data cell pane menu

Facts pane menu 

Print dialog box

The following options allow you to specify how the document should be printed:

Printer

This is the active printer and printer connection. Choose the Setup option to change the printer and printer connection.

Setup

Displays a Print Setup dialog box, so you can select a printer and printer connection.

Print Range

Specify the pages you want to print:

Copies

Specify the number of copies you want to print for the above page range.

Collate Copies

Prints copies in page number order, instead of separated multiple copies of each page.

Print Quality

Select the quality of the printing. Generally, lower quality printing takes less time to produce. 

The Printing dialog box is shown during the time that SuperQuery is sending output to the printer. The page number indicates the progress of the printing.

To abort printing, choose Cancel.

The following options allow you to select the destination printer and its connection.

Printer

Select the printer you want to use. Choose the Default Printer; or choose the Specific Printer option and select one of the current installed printers shown in the box. You install printers and configure ports using the Windows Control Panel.

Orientation

Choose Portrait or Landscape.

Paper Size

Select the size of paper that the document is to be printed on.

Paper Source

Some printers offer multiple trays for different paper sources. Specify the tray here.

Options

Displays a dialog box where you can make additional choices about printing, specific to the type of printer you have selected.

Network...

Choose this button to connect to a network location, assigning it a new drive letter. 

This dialog allows you to select columns that will be displayed in the view. You can also change their order. When you run the Facts Engine on a view, only those columns selected in the view are processed. The dialog consists of the following four columns:

Select column contains check boxes to select / deselect a column.

Column Name column contains all the table column names including all virtual columns.

Sql Type column contains the Sql type of the corresponding column. The Sql type is useful in deciding whether to include or to exclude the column.

Ana Type column contains the Analysis type of the column. This is either “Normal” for data columns, or one of the Virtual column types.

You can move the position of any column by placing the cursor on that column and pushing the Up or Down arrow or use the drag and drop property.

To add a foreign column to the table, press the “Add foreign col” button. This invokes the Select Foreign Table Dialog to let you select the foreign column that you want to add.

Use this dialog to select or de-select the statistical calculations you want to apply to data columns.

You can also change the order of the appearance of the calculations by using the up and down buttons or by using drag and drop.

The dialog contains a list of all table columns with their corresponding Sql type. Select all columns that you want to include in the summary table by checking the corresponding check box.

In the “Calculation” column, click on the corresponding drop-down button to select one of the summary calculation. SuperQuery gives the new summary column a name that consists of the selected summary operator and the data column name. However, you can write a different name in the “New Column Name” next to the selected column.

Sometimes, it is useful to summarize one column with more than one operator (for example you may want to summarize Sales with the average, total and maximum operators).

You can do this by duplicating the data column (Sales) and selecting the required summary operator for each duplicate.

·Select the data column and press the “Duplicate Line” button.

·Select the new summary operator from the “Calculation” column.

Press any Group button to select the group of columns that are interdependent. This will display the Select Dependent Columns Dialog.

 Click on all columns from the Multiple Selection List that are interrelated.

The dialog lists all the columns existing in the foreign table. Select the column(s) you want to add to your table. Since the relation between this table and the foreign table is many-to-one, you will be able to select one of the summary operator.

 The dialog lists all the existing columns in the foreign table. Select the column(s) that you want to add to your table and optionally rename it.

 The Dialog displays all open tables in the current database. Select the table from which you want to bring foreign column (s). When you press the “Select Cols” button, SuperQuery displays either the Select foreign columns with many-to-one relation or Select foreign columns with one-to-many relation. This depends on the relationship between the current table and the foreign table. This will enable SuperQuery to either: show the associated value in the many-to-one case, or  summarize a number of values into one value in the one-to-many case.

Select Table Dialog

 Select Table dialog consists of two list boxes:

·Databases list which contains all open databases

·Tables list which displays all tables contained in the database currently selected in the database list.

You should select a database then select one of its tables.

This dialog consists of a list box that contains all the different values in the selected column.

Select one or more of these values depending on the Criterion Operator you chose from the Edit Criterion dialog.

Select one of the following four layouts for the new view you are creating:

The File menu offers the following commands:

Options menu commands

 The Window menu offers the following commands, which enable you to arrange multiple views of multiple documents in the application window:

 The Help menu offers the following commands, which provide you assistance with this application:

SuperQuery can open most common types of databases directly using “Data Access Objects”. Also it supports ODBC if you have both ODBC and your database drivers installed.

Select Open Wizard menu item to help you in opening your data. After opening the data table, the Wizard will give you the options to:

• Read another table,

• Define links among open tables, or

• Call the analysis Wizard to analyze your data

SuperQuery allows you to update your data tables. SuperQuery will read the new data from the original source ( you can specify another source ) and update the entire analysis.

Select Analysis Wizard menu command to run the Analysis Wizard to help to perform one of the following analysis:

1. Select Columns

2. Classify numerical columns into ranges

3. Create virtual columns

4. Create summary table

5. Discover the facts

hen you have a database open, you can link its tables. This allows you to synchronize table views and exchange foreign columns among these tables.

Linking your tables requires you to define both primary key and foreign key(s). SuperQuery provides the Edit Table Keys Dialog to help with this process.

SuperQuery allows you to export both the data tables and the generated facts into text files.

Select Export | Tab delimited to export data tables into a tab delimited file. The system will display the Select Table Dialog to select a table that you want to export, then will display the Save As dialog to save the new file.

Select Export | Facts to export the facts generated into a "Fact - Exception" format text file.

Select Export | Rules to export the facts generated into an "If ... Then" format text file.

Choose the Close command menu to remove a table from memory.

The system will display the Select Table Dialog to select a table that you want to close. The system will also close all its associated views (if any) from the document.

 When you have more than one view in the same tab you may use this command to synchronize all those views. This means that SuperQuery will try to synchronize the scrolling of all views in this tab.

For views on the same table, if you move in one view to row 100, all other views will also scroll to row 100.

All views will have row 100 as the current row.

When you have views on different but related tables, SuperQuery will synchronize them depending on their relationships.

For example, let us assume that view 'X' is a Customer view and view 'Y' is an Orders view. Each customer may have a number of orders. Therefore, there is a "one to many" relation between customer and orders ( or a "many to one" between orders and customers). Now, if you scroll in the customer view to customer 'A', SuperQuery sets a filter on all orders from customer 'A' in the Orders view. Consequently, when you scroll in Orders to order 'B', SuperQuery finds the customer associated with that order and make it the current row in the Customer view.

Choose the New command menu to create a new view on any of the open tables.

SuperQuery displays the Add New Table View Dialog to let you select the database and table that you want to view. If you want to select the view layout, press the “View” button to display the View Layout Dialog and select one of the four layouts

SuperQuery allows you to export either the data view or the facts view to text files.

Select Export | Tab delimited to export active data view into a tab delimited file.

SuperQuery displays the Save As dialog to save the new file.

Select Export | Facts to export the facts generated view into a "Fact - Exception" format text file.

Select Export | Rules to export the facts generated view into an "If ... Then" format text file.

SuperQuery allows you to export either the data view or the facts view to text files.

Select Export | Tab delimited to export active data view into a tab delimited file.

SuperQuery displays the Save As dialog to save the new file.

Select Export | Facts to export the facts generated view into a "Fact - Exception" format text file.

Select Export | Rules to export the facts generated view into an "If ... Then" format text file.

Use this menu command if you have selected the Fast Scrolling Option and you want to update all panes in the active view.

Use this command to display the Panes Management Dialog. Use this dialog to select a pane and change its properties.

Use this command to instruct SuperQuery not to update all panes in the view when scrolling in the Data Table Pane. This will allows you to scroll faster in the Data Table Pane.

Use this command to instruct SuperQuery to update all panes whenever you scroll in the Data Table Pane.