private void testPaper()
{
Performance p = new Performance();
p.GenerateScript = false;
p.UseNormalizedValues = false;
p.WindowSort = SQLCommon.Ordering.EntropyFunction;
p.WindowHandling = 2; //Move To End start with last tuple in window.
p.UseCLR = false;
p.Trials = 1; //Amount of trials for each single sql preference statement
p.MinDimensions = 3; //Up from x dimensions
p.MaxDimensions = 7; //Up to x dimensions
p.RandomDraws = 100; //Amount of draws (x times randomly choose a some preferences)
p.TableSize = Performance.Size.Superlarge;
p.Set = Performance.PreferenceSet.All;
p.Mode = Performance.PreferenceChooseMode.Shuffle;
p.SkylineUpToLevel = 1;
p.Strategy = null; // new SkylineBNLSort(); // null; //all algorithms should be tested
p.WriteRCommand = true;
p.GeneratePerformanceQueries();
}
private void MeasurePerformance()
{
Performance p = new Performance();
p.GenerateScript = false;
p.UseNormalizedValues = false;
//p.UseNormalizedValues = true;
p.WindowSort = SQLCommon.Ordering.AttributePosition;
//p.WindowSort = SQLCommon.Ordering.EntropyFunction;
//p.WindowHandling = 0; //Do not move start with last tuple in window.
//p.WindowHandling = 1; //Do not move start with first tuple in window.
p.WindowHandling = 2; //Move To End start with last tuple in window.
//p.WindowHandling = 3; //Move To Beginning start with first tuple in window.
//p.UseCLR = true;
p.UseCLR = false;
p.Trials = 1; //Amount of trials for each single sql preference statement
p.MinDimensions = 7; //Up from x dimensions
p.MaxDimensions = 7; //Up to x dimensions
p.RandomDraws = 10; //Amount of draws (x times randomly choose a some preferences)
//p.TableSize = Performance.Size.Small;
//p.TableSize = Performance.Size.Medium;
//p.TableSize = Performance.Size.Large;
p.TableSize = Performance.Size.Superlarge;
//p.Set = Performance.PreferenceSet.ArchiveComparable;
//p.Set = Performance.PreferenceSet.ArchiveIncomparable;
//p.Set = Performance.PreferenceSet.Jon;
//p.Set = Performance.PreferenceSet.Mya;
//p.Set = Performance.PreferenceSet.Barra;
//p.Set = Performance.PreferenceSet.All;
p.Set = Performance.PreferenceSet.Numeric;
//p.Set = Performance.PreferenceSet.Categoric;
//p.Set = Performance.PreferenceSet.MinCardinality;
//p.Set = Performance.PreferenceSet.CategoricIncomparable;
//p.Set = Performance.PreferenceSet.NumericIncomparable;
p.Mode = Performance.PreferenceChooseMode.Combination;
//p.Mode = Performance.PreferenceChooseMode.SameOrder;
//p.Mode = Performance.PreferenceChooseMode.Shuffle;
//p.Mode = Performance.PreferenceChooseMode.Correlation;
//p.Mode = Performance.PreferenceChooseMode.AntiCorrelation;
//p.Mode = Performance.PreferenceChooseMode.Independent;
p.SkylineUpToLevel = 1;
//p.Strategy = null; //all algorithms should be tested
//p.Strategy = new SkylineSQL();
//p.Strategy = new SkylineBNL();
p.Strategy = new SkylineBNLSort();
//p.Strategy = new SkylineDQ();
//p.Strategy = new SkylineHexagon();
//p.Strategy = new SkylineDecisionTree();
//p.Sampling = true;
//p.SamplingSubspacesCount = 10;
//p.SamplingSubspaceDimension = 3;
//p.SamplingSamplesCount = 10;
p.GeneratePerformanceQueries();
}