Publications :: Search

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

Show publication

On this page you see the details of the selected publication.

    Publication properties
    Title: Benchmarking Bitemporal Database Systems: Ready for the Future or Stuck in the Past?
    Rating: (not rated yet)
    Date: 3 / 2014
    Publication type: Conference paper
    Authors:
    No. First name Last name Show
    1. Martin Kaufmann
    2. Peter M. Fischer
    3. Norman May
    4. Donald Kossmann
    Download (from PubZone): Download
    Bookmark:

    The following keywords have been assigned to this publication so far. If you have logged in, you can tag this publication with additional keywords.

    Keywords
    No keywords have been assigned to this publication yet.

    If you log in you can tag this publication with additional keywords

    A publication can refer to another publication (outgoing references) or it can be referred to by other publications (incoming references).

    Incoming References
    No incoming references have been assigned to this publication yet.
    Outgoing References
    No outgoing references have been assigned to this publication yet.

    If you log in you can add references to other publications

    A publication can be assigned to a conference, a journal or a school.

    Venue
    EDBT: 17th International Conference on Extending Database Technology, March 24-28, 2014

    Abstract

    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.