"Benchmarking Bitemporal Database Systems: Ready for the Future or Stuck in the Past?" accepted at EDBT 2014

One more paper has been accepted at EDBT 2014, which will be held in Athens, Greece, March 24-28, 2014.

Title: Benchmarking Bitemporal Database Systems: Ready for the Future or Stuck in the Past

Authors: Martin Kaufmann (ETH), Peter M. Fischer (University of Freiburg), Norman May (SAP), Donald Kossmann (ETH)


After more than a decade of a virtual standstill, the adoption of temporal data management features has recently picked up speed, driven by customer demand and the inclusion of temporal expressions into SQL:2011. Most of the big commercial DBMS now include support for bitemporal data and operators. In this paper, we perform a thorough analysis of these commercial temporal DBMS: We investigate their architecture, determine their performance and study the impact of performance tuning. This analysis utilizes our recent (TPCTC 2013) benchmark proposal, which includes a comprehensive temporal workload definition. The results of our analysis show that the support for temporal data is still in its infancy: All systems store their data in regular, statically partitioned tables and rely on standard indexes as well as query rewrites for their operations. As shown by our measurements, this causes considerable performance variations on slight workload variations and a significant effort for performance tuning. In some cases, there is considerable overhead for temporal operations even after extensive tuning.