SQRun Function

The SQRun function runs the Fact Engine on the API data set.

Syntax

int SQRun(      



  int iIfCol = -1, 

  int iThenCol = -1, 

  const char* szSetupFile = NULL

);

Parameters

iIfCol

[in] Index of If Column in the data set. Default -1 to consider all column.

iThenCol

[in] Index of the Then Column in the data set. Default -1 to consider all columns.

szSetupFile

[in] Name of the file containing setup information for the Fact Engine. Default NULL to use default settings.

Return Value

Number of facts found in the data set.

Remarks

SQRun: Use this function to run the Fact Engine on the data set. You can specify the If Column and the Then Column which tells the engine that you are only interested in facts that relates this If Column with the Then Column; you can also specify -1 for any of them to tell the system to consider all columns.  A fact example: If City = New York then Sales = High. In this example the If Column is the City column and the Then Column is the Sales Column.  You can also specify a Setup File to fine tune the Fact Engine, for more information on how the Fact Engine works, please refer to the while paper in our web site. Following is an example of the setup file:

[Settings]

Generate Facts = 1

Generate Exceptions = 1

Facts = "95, 95, 80, 80, 50, 50"

Exceptions = "50, 40, 40, 30, 30, 20"

Max Level = 1

Most =  40

[Filters]

IgnoreBlank = 1

IgnoreALLMCV = 1

IgnoreMostMCV = 1

IgnoreSrcCols = 1

AllMCVPercent = 50

MostMCVPercent = 50

[Fact Engine]

iSupportResolution = 200

Example

See example 2, example 3, and example 4