Aggregate Cache

  • Hasso Plattner
Chapter

Abstract

OLTP and OLAP systems (cf. Sect.3.2) employ different approaches to deal with aggregate queries. While OLAP systems make extensive use of materialized views [SDJL96, ZGMH+95], we see that the handling of aggregates in OLTP systems is often done within the application by maintaining predefined summary tables. This leads to an increased application complexity with risks for violating data consistency and to a limited throughput of insert and update queries as the related summary tables must be updated in the same transaction [JMS95, Pla09].

References

  1. [GM95]
    A. Gupta, I.S. Mumick, Maintenance of materialized views: problems, techniques, and applications. IEEE Data Eng. Bull. 18(2), 3–18 (1995)Google Scholar
  2. [JMS95]
    H.V. Jagadish, I.S. Mumick, A. Silberschatz, View maintenance issues for the chronicle data model, PODS (ACM, New York, 1995), pp. 113–124Google Scholar
  3. [KKG+11]
    J. Krueger, C. Kim, M. Grund, N. Satish, D. Schwalb, J. Chhugani, H. Plattner, P. Dubey, A. Zeier, Fast updates on read-optimized databases using multi-core CPUs. PVLDB (2011)Google Scholar
  4. [MBH+13]
    S. Müller, L. Butzmann, K. Howelmeyer, S. Klauck, H. Plattner, Efficient view maintenance for enterprise applications in columnar in-memory databases, in 14th IEEE International Enterprise Distributed Object Computing Conference (EDOC), pp. 249–258, 2013Google Scholar
  5. [MP13]
    S. Müller, H. Plattner, Aggregates caching in columnar in-memory databases, in 1st International Workshop on In-Memory Data Management and Analytics (IMDM) at VLDB 2013, August 2013Google Scholar
  6. [Pla09]
    H. Plattner, A common database approach for OLTP and OLAP using an in-memory column database, in SIGMOD, pp. 1–2, 2009Google Scholar
  7. [SDJL96]
    D. Srivastava, S. Dar, H.V. Jagadish, A.Y. Levy, Answering queries with aggregation using views, in VLDB, pp. 318–329, 1996Google Scholar
  8. [SS77]
    J.M. Smith, D.C.P. Smith, Database abstractions: aggregation. Comm. ACM, 105–133 (1977)Google Scholar
  9. [ZGMH+95]
    Y. Zhuge, H. Garcia-Molina, J. Hammer, J. Widom, Y. Zhuge, H. Garcia-Molina, J. Hammer, J. Widom, View maintenance in a warehousing environment. ACM SIGMOD Rec. (ACM, New York, 1995), pp. 316–327Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2014

Authors and Affiliations

  • Hasso Plattner
    • 1
  1. 1.Enterprise Platform and Integration ConceptsHasso Plattner InstitutePotsdamGermany

Personalised recommendations