Publications :: Search

Benchmarking Databases with History Support

Show publication

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

    Publication properties
    Title: Benchmarking Databases with History Support
    Rating: (not rated yet)
    Discussion: 0 comments
    Date: 2013
    Publication type: Technical report
    No. First name Last name Show
    1. Martin Kaufmann
    2. Peter M. Fischer
    3. Norman May
    4. Donald Kossmann
    Download (from PubZone): Download
    Download (by DOI): 10.3929/ethz-a-009994978

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

    1. benchmark
    2. bitemporal
    3. evaluation
    4. performance
    5. temporal

    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.

    ETH Zurich and SAP AG


    An increasing number of applications such as risk evaluation in banking or inventory management require support for temporal data. After more than a decade of standstill, the recent adoption of some bitemporal features in SQL:2011 has reinvigorated the support among commercial database vendors, who incorporate an increasing number of relevant bitemporal features. Naturally, assessing the performance and scalability of temporal data storage and operations is of great concern for potential users. The cost of keeping and querying history with novel operations (such as time travel, temporal joins or temporal aggregations) is not adequately reflected in any existing benchmark. In this paper, we present a benchmark proposal which provides comprehensive coverage of the bitemporal data management. It builds on the solid foundations of TPC-H but extends it with a rich set of queries and update scenarios. This workload stems both from real-life temporal applications from SAP's customer base and a systematic coverage of temporal operators proposed in the academic literature. In the accompanying paper we present preliminary results of our benchmark on a number of temporal database systems, also highlighting the need for certain language extensions. In the appendix of this technical report we provide all details required to implement the benchmark.