Encyclopedia of Database Systems

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

Temporal Benchmarks

  • Jennifer DempseyEmail author
  • Richard T. Snodgrass
  • Stephen W. Thomas
  • Rui Zhang
Reference work entry
DOI: https://doi.org/10.1007/978-1-4614-8265-9_80730


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.


  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 the 20th 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 the TPC Technology Conference; 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, part of Springer Nature 2018

Authors and Affiliations

  • Jennifer Dempsey
    • 1
    • 2
    Email author
  • Richard T. Snodgrass
    • 3
    • 6
  • Stephen W. Thomas
    • 4
  • Rui Zhang
    • 5
    • 6
    • 7
  1. 1.University of ArizonaTucsonUSA
  2. 2.Raytheon Missile SystemsTucsonUSA
  3. 3.Department of Computer ScienceUniversity of ArizonaTucsonUSA
  4. 4.Dataware VenturesKingstonCanada
  5. 5.University of MelbourneMelbourneAustralia
  6. 6.Dataware VenturesTucsonUSA
  7. 7.Dataware VenturesRedondo BeachUSA