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.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Al-Kateb, M., Crolotte, A., Ghazal, A., Rose, L.: Adding a Temporal Dimension to the TPC-H Benchmark. In: Nambiar, R., Poess, M. (eds.) TPCTC 2012. LNCS, vol. 7755, pp. 51–59. Springer, Heidelberg (2013)
Cole, R., et al.: The Mixed Workload CH-benCHmark. In: DBTest, p. 8 (2011)
Gray, J.: Benchmark Handbook: For Database and Transaction Processing Systems. Morgan Kaufmann Publishers Inc., San Francisco (1992)
Jensen, C.S., et al.: A consensus test suite of temporal database queries. Tech. rep., Department of Computer Science, Aarhus University (1993)
Kalua, P.P., Robertson, E.L.: Benchmarking Temporal Databases - A Research Agenda. Tech. rep., Indiana University, Computer Science Department (1995)
Kaufmann, M., Fischer, P.M., Kossmann, D., May, N.: A Generic Database Benchmarking Service. In: ICDE (2013)
Kaufmann, M., Kossmann, D., May, N., Tonder, A.: Benchmarking Databases with History Support. Tech. report. ETH Zurich and SAP AG (2013)
Kaufmann, M., Manjili, A., Vagenas, P., Fischer, P., Kossmann, D., Faerber, F., May, N.: Timeline index: A unified data structure for processing queries on temporal data in SAP HANA. In: SIGMOD (2013)
Kulkarni, K.G., Michels, J.E.: Temporal Features in SQL: 2011. SIGMOD Record 41(3) (2012)
Salzberg, B., Tsotras, V.J.: Comparison of access methods for time-evolving data. ACM Comput. Surv. 31(2), 158–221 (1999)
Snodgrass, R.T.: Developing Time-Oriented Database Applications in SQL. Morgan Kaufmann (1999)
Snodgrass, R.T., et al.: TSQL2 language specification. SIGMOD Record 23(1) (1994)
Werstein, P.: A Performance Benchmark for Spatiotemporal Databases. In: Proc. of the 10th Annual Colloquium of the Spatial Information Research Centre, pp. 365–373 (1998)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2014 Springer International Publishing Switzerland
About this paper
Cite this paper
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. https://doi.org/10.1007/978-3-319-04936-6_2
Download citation
DOI: https://doi.org/10.1007/978-3-319-04936-6_2
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-04935-9
Online ISBN: 978-3-319-04936-6
eBook Packages: Computer ScienceComputer Science (R0)