Variations of the Star Schema Benchmark to Test the Effects of Data Skew on Query Performance

Provided by: Association for Computing Machinery
Topic: Big Data
Format: PDF
The Star Schema Benchmark (SSB) has been widely used to evaluate the performance of database management systems when executing star schema queries. SSB, based on the well known industry standard benchmark TPC-H, shares some of its drawbacks, most notably, its uniform data distributions. Today's systems rely heavily on sophisticated cost-based query optimizers to generate the most efficient query execution plans. A benchmark that evaluates optimizer's capability to generate optimal execution plans under all circumstances must provide the rich data set details on which optimizers rely (uniform and non-uniform distributions, data sparsity, etc.).

Find By Topic