Comprehensive and interactive temporal query processing with SAP HANA

  • Authors:
  • Martin Kaufmann;Panagiotis Vagenas;Peter M. Fischer;Donald Kossmann;Franz Färber

  • Affiliations:
  • Systems Group, ETH Zürich, Switzerland and SAP AG, Walldorf, Germany;Systems Group, ETH Zürich, Switzerland and SAP AG, Walldorf, Germany;Albert-Ludwigs-Universität, Freiburg, Germany;Systems Group, ETH Zürich, Switzerland;SAP AG, Walldorf, Germany

  • Venue:
  • Proceedings of the VLDB Endowment
  • Year:
  • 2013

Quantified Score

Hi-index 0.00

Visualization

Abstract

In this demo, we present a prototype of a main memory database system which provides a wide range of temporal operators featuring predictable and interactive response times. Much of real-life data is temporal in nature, and there is an increasing application demand for temporal models and operations in databases. Nevertheless, SQL:2011 has only recently overcome a decade-long standstill on standardizing temporal features. As a result, few database systems provide any temporal support, and even those only have limited expressiveness and poor performance. Our prototype combines an in-memory column store and a novel, generic temporal index structure named Timeline Index. As we will show on a workload based on real customer use cases, it achieves predictable and interactive query performance for a wide range of temporal query types and data sizes.