TPC-BiH: A Benchmark for Bitemporal Databases

  • Martin Kaufmann
  • Peter M. Fischer
  • Norman May
  • Andreas Tonder
  • Donald Kossmann
Conference paper

DOI: 10.1007/978-3-319-04936-6_2

Part of the Lecture Notes in Computer Science book series (LNCS, volume 8391)
Cite this paper as:
Kaufmann M., Fischer P.M., May N., Tonder A., Kossmann D. (2014) TPC-BiH: A Benchmark for Bitemporal Databases. In: Nambiar R., Poess M. (eds) Performance Characterization and Benchmarking. TPCTC 2013. Lecture Notes in Computer Science, vol 8391. Springer, Cham

Abstract

An increasing number of applications such as risk evaluation in banking or inventory management require support for temporal data. After more than a decade of standstill, the recent adoption of some bitemporal features in SQL:2011 has reinvigorated the support among commercial database vendors, who incorporate an increasing number of relevant bitemporal features. Naturally, assessing the performance and scalability of temporal data storage and operations is of great concern for potential users. The cost of keeping and querying history with novel operations (such as time travel, temporal joins or temporal aggregations) is not adequately reflected in any existing benchmark. In this paper, we present a benchmark proposal which provides comprehensive coverage of the bitemporal data management. It builds on the solid foundations of TPC-H but extends it with a rich set of queries and update scenarios. This workload stems both from real-life temporal applications from SAP’s customer base and a systematic coverage of temporal operators proposed in the academic literature. We present preliminary results of our benchmark on a number of temporal database systems, also highlighting the need for certain language extensions.

Keywords

Bitemporal Databases Benchmark Data Generator 

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Springer International Publishing Switzerland 2014

Authors and Affiliations

  • Martin Kaufmann
    • 1
    • 2
  • Peter M. Fischer
    • 3
  • Norman May
    • 1
  • Andreas Tonder
    • 1
  • Donald Kossmann
    • 2
  1. 1.SAP AGWalldorfGermany
  2. 2.ETH ZurichZurichSwitzerland
  3. 3.Albert-Ludwigs-UniversitätFreiburgGermany

Personalised recommendations