Encyclopedia of Database Systems

Living Edition
| Editors: Ling Liu, M. Tamer Özsu

Temporal Benchmarks

  • Jennifer Dempsey
  • Richard T. Snodgrass
  • Stephen W. Thomas
  • Rui Zhang
Living reference work entry
DOI: https://doi.org/10.1007/978-1-4899-7993-3_80730-1


Temporal benchmarks are used to compare temporal support for various databases. Benchmarks consist of data, a schema for that data, and workloads that perform computations on that data.

Historical Background


Benchmarks consist of three parts, data, a schema for that data, and workloads that perform computations on that data. They have been used in order to provide of means of comparing the performance of various software systems, including databases. Among the most widely used benchmarks are those published by the Transaction Processing Performance Council including TPC-C and TPC-H [1, 2].

TPC-C provides an environment that simulates several uses interacting with a single database at one time. TPC-C models the data, schema, and workloads after those of a wholesale supplier. To replicate this process, TPC-C simulates users that enter new orders, record payments, check the status of an order, deliver an order, and view the available products in the warehouse.


This is a preview of subscription content, log in to check access.

Recommended Reading

  1. 1.
    Transaction Processing Performance Council. TPC benchmarks. http://www.tpc.org/information/benchmarks.asp. Accessed 26 Sept 2014.
  2. 2.
    Gray J. Benchmark handbook: for database and transaction processing systems. San Francisco: Morgan Kaufmann Publishers Inc.; 1992.zbMATHGoogle Scholar
  3. 3.
    Yao BB, Özsu MT, Khandelwal N. XBench benchmark and performance testing of XML DBMSs. In: Proceedings of International Conference on Data Engineering; 2004. p. 621–33.Google Scholar
  4. 4.
    Jensen CS. A consensus test suite of temporal database queries. Department of Mathematics and Computer Science, Institute for Electronic Systems, University of Aalborg, 1993.Google Scholar
  5. 5.
    Kaufmann M, Fischer PM, May N, Tonder A, Kossmann D. TPC-BiH: a Benchmark for bitemporal databases. In: Proceedings of TPC Technology Conference. Berlin/New York: Springer; 2014. p. 16–31.Google Scholar
  6. 6.
    Thomas SW, Snodgrass RT, Zhang R. τBench: extending XBench with time. Time Center technical report, University of Arizona, TR-92, 2010.Google Scholar
  7. 7.
    Currim F, Currim S, Dyreson C, Joshi S, Snodgrass RT, Thomas SW, Roeder E. τXSchema: support for data- and schema-versioned XML documents. TimeCenter technical report, University of Arizona, TR-91, 2009.Google Scholar

Copyright information

© Springer Science+Business Media LLC 2017

Authors and Affiliations

  • Jennifer Dempsey
    • 1
  • Richard T. Snodgrass
    • 1
  • Stephen W. Thomas
    • 2
  • Rui Zhang
    • 2
  1. 1.University of ArizonaTucsonUSA
  2. 2.Dataware VenturesTusconUSA

Section editors and affiliations

  • Richard T. Snodgrass
    • 1
  • Christian S. Jensen
    • 2
  1. 1.Department of Computer ScienceUniversity of ArizonaTucsonUSA
  2. 2.Aalborg UniversityAalborg ØstDenmark