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); }