public override DataTable GetSkylineTable(String querySQL, String preferenceOperators)
{
//Calculate cardinality
long thresholdCardinality = 300;
TemplateStrategy strategy;
if (Cardinality <= thresholdCardinality)
{
strategy = new SPSkylineDQ();
}
else
{
if (HasIncomparablePreferences)
{
strategy = new SPSkylineBNLSort();
}
else
{
strategy = new SPSkylineBNLSortLevel();
}
}
strategy.WindowHandling = WindowHandling;
DataTable dt = strategy.GetSkylineTable(querySQL, preferenceOperators, RecordAmountLimit, true, ConnectionString, Provider, AdditionParameters, SortType);
TimeMilliseconds = strategy.TimeInMs;
NumberOfComparisons = strategy.NumberOfOperations;
NumberOfMoves = strategy.NumberOfMoves;
return dt;
}
public override DataTable GetSkylineTable(String querySQL, String preferenceOperators)
{
//Calculate cardinality
long thresholdCardinality = 300;
TemplateStrategy strategy;
if (Cardinality <= thresholdCardinality)
{
strategy = new SPSkylineDQ();
}
else
{
if (HasIncomparablePreferences)
{
strategy = new SPSkylineBNLSort();
}
else
{
strategy = new SPSkylineBNLSortLevel();
}
}
strategy.WindowHandling = WindowHandling;
DataTable dt = strategy.GetSkylineTable(querySQL, preferenceOperators, RecordAmountLimit, true, ConnectionString, Provider, AdditionParameters, SortType);
TimeMilliseconds = strategy.TimeInMs;
NumberOfComparisons = strategy.NumberOfOperations;
NumberOfMoves = strategy.NumberOfMoves;
return(dt);
}
public override DataTable GetSkylineTable(String querySQL, String preferenceOperators)
{
SPSkylineDQ skyline = new SPSkylineDQ();
DataTable dt = skyline.GetSkylineTable(querySQL, preferenceOperators, RecordAmountLimit, true, ConnectionString, Provider, AdditionParameters, SortType);
TimeMilliseconds = skyline.TimeInMs;
NumberOfComparisons = skyline.NumberOfOperations;
NumberOfMoves = skyline.NumberOfMoves;
return dt;
}
public override DataTable GetSkylineTable(String querySQL, String preferenceOperators)
{
SPSkylineDQ skyline = new SPSkylineDQ();
DataTable dt = skyline.GetSkylineTable(querySQL, preferenceOperators, RecordAmountLimit, true, ConnectionString, Provider, AdditionParameters, SortType);
TimeMilliseconds = skyline.TimeInMs;
NumberOfComparisons = skyline.NumberOfOperations;
NumberOfMoves = skyline.NumberOfMoves;
return(dt);
}
public static void GetSkyline(SqlString strQuery, SqlString strOperators, SqlInt32 numberOfRecords, SqlInt32 sortType)
{
SPSkylineDQ skyline = new SPSkylineDQ();
skyline.GetSkylineTable(strQuery.ToString(), strOperators.ToString(), numberOfRecords.Value, false, Helper.CnnStringSqlclr, Helper.ProviderClr, null, sortType.Value);
}
public static void GetSkyline(SqlString strQuery, SqlString strOperators, SqlInt32 numberOfRecords, SqlInt32 sortType)
{
SPSkylineDQ skyline = new SPSkylineDQ();
skyline.GetSkylineTable(strQuery.ToString(), strOperators.ToString(), numberOfRecords.Value, false, Helper.CnnStringSqlclr, Helper.ProviderClr, null, sortType.Value);
}