Tuesday, 12 December 2017

Session 13: Industry Track Best Paper Candidates

Further Implementation Aspects of the Server Efficiency Rating Tool (SERT)

Authors:

Klaus-Dieter Lange (Hewlett-Packard Company)
Jeremy A. Arnold (IBM Corporation)
Hansfried Block (Fujitsu Technology Solutions GmbH)
Nathan Totura (Intel Corporation)
John Beckett (Dell Inc.)
Mike G. Tricker (Microsoft Corporation)

Abstract:

The Server Efficiency Rating Tool (SERT) has been developed by the Standard Performance Evaluation Corporation (SPEC) at the request of the US Environmental Protection Agency (EPA). Almost 3% of all electricity consumed within the US in 2010 went to running datacenters. With this in mind, the EPA released Version 2.0 of the ENERGY STAR for Computer Servers program in early 2013 to include the mandatory use of the SERT. Other governments world-wide that are also concerned with growing power consumption of servers and datacenters are considering the adoption of the SERT.

DOI: 10.1145/2479871.2479926

Full text: PDF

[#][]

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

Authors:

Tilmann Rabl (University of Toronto)
Meikel Poess (Oracle Corporation)
Hans-Arno Jacobsen (University of Toronto)
Patrick O'Neil (University of Massachusetts, Boston)
Elizabeth O'Neil (University of Massachusetts, Boston)

Abstract:

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.). This is also true for other database system parts, such as indices and operators, and ultimately holds for an end-to-end benchmark as well. SSB’s data generator, based on TPC-H’s dbgen, is not easy to adapt to different data distributions as its meta data and actual data generation implementations are not separated. In this paper, we motivate the need for a new revision of SSB that includes non-uniform data distributions. We list what specific modifications are required to SSB to implement non-uniform data sets and we demonstrate how to implement these modifications in the Parallel Data Generator Framework to generate both the data and query sets.

DOI: 10.1145/2479871.2479927

Full text: PDF

[#][]