Abstract
The importance of time in decision-support is widely recognized and has been addressed through temporal applications or through native temporal features by major DBMS vendors. In this paper we propose a framework for adding a new temporal component to the TPC-H benchmark. Our proposal includes temporal DDL, procedures to populate the temporal tables via insertselect thereby providing history, and temporal queries based on a workload that covers the temporal dimension broken down as current, history, and both. The queries we define as part of this benchmark include the typical SQL operators involved in scans, joins and aggregations. The paper concludes with experimental results. While in this paper we consider adding temporal history to a subset of the TPC-H benchmark tables namely Part/ Supplier/Partsupp, our proposed framework addresses a need and uses, as a starting point, a benchmark that is widely successful and well-understood.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
Snodgrass, R.T., Böhlen, M.H., Jensen, C.S., Steiner, A.: Adding Valid Time toSQL/Temporal. Change Proposal, ANSI X3H2-96-501r2, ISO/IECJTC1/SC21/WG3 DBL MAD-146r2 (November 1996)
Snodgrass, R.T., Böhlen, M.H., Jensen, C.S., Steiner, A.: Adding TransactionTime to SQL/Temporal. Change Proposal, ANSI X3H2- 96-502r2, ISO/IEC JTC1/SC21/WG3 DBL MAD-147r2 (November 1996)
Jensen, C.S., et al.: The TSQL benchmark. In: International Workshop on an Infrastructure for Temporal Databases, Arlington, TX, pp. QQ-1 – QQ-28 (June 1993)
Dunham, M., Elmasri, R., Nacimento, M., Sobol, M.: Benchmarking Temporal Databases A Research Agenda. Technical Report 95-CSE-20, Southern Methodist University (December 1995)
Kalua, P., Rberson, E.: Benchmark queries for temporal databases. Technical report TR-379, Computer Science Department, Indiana University (1994)
Noh, S.-Y., Gadia, S.K.: Benchmarking temporal database models with interval-based and temporal element-based timestamping. Journal of Systems and Software 81(11), 1931–1943 (2008)
TPC-H specification – Transaction Performance Council, http://www.tpc.org
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2013 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Al-Kateb, M., Crolotte, A., Ghazal, A., Rose, L. (2013). Adding a Temporal Dimension to the TPC-H Benchmark. In: Nambiar, R., Poess, M. (eds) Selected Topics in Performance Evaluation and Benchmarking. TPCTC 2012. Lecture Notes in Computer Science, vol 7755. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-36727-4_4
Download citation
DOI: https://doi.org/10.1007/978-3-642-36727-4_4
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-36726-7
Online ISBN: 978-3-642-36727-4
eBook Packages: Computer ScienceComputer Science (R0)