A Middleware-Based Approach to Database Caching

  • Andreas Bühmann
  • Theo Härder
  • Christian Merker
Part of the Lecture Notes in Computer Science book series (LNCS, volume 4152)


Database caching supports declarative query processing close to the application. Using a full-fledged DBMS as cache manager, it enables the evaluation of specific project-select-join queries in the cache. In this paper, we propose significant improvements and optimizations – as compared to the well-known DBCache approach – that make our caching concept truly adaptive. Furthermore, we describe an adaptive constraint-based cache system (ACCache) relying on middleware components as a DBMS-independent realization of this approach.


Control Column Garbage Collector Control Table Cache Manager Probe Query 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Altinel, M., Bornhövd, C., Krishnamurthy, S., Mohan, C., Pirahesh, H., Reinwald, B.: Cache tables: Paving the way for an adaptive database cache. In: VLDB Conference, pp. 718–729 (2003)Google Scholar
  2. 2.
    Amiri, K., Park, S., Tewari, R., Padmanabhan, S.: DBProxy: A dynamic data cache for web applications. In: ICDE Conference, pp. 821–831 (2003)Google Scholar
  3. 3.
    Bühmann, A.: Einen Schritt zurück zum negativen Datenbank=Caching (A step back towards negative database caching). In: BTW Conference, Karlsruhe, pp. 107–124 (2005)Google Scholar
  4. 4.
    Bornhövd, C., Altinel, M., Mohan, C., Pirahesh, H., Reinwald, B.: Adaptive database caching with DBCache. Data Engineering Bulletin 27(2), 11–18 (2004)Google Scholar
  5. 5.
    Larson, P., Goldstein, J., Zhou, J.: MTCache: Transparent mid-tier database caching in SQL server. In: ICDE Conference, pp. 177–189. IEEE Computer Society, Los Alamitos (2004)CrossRefGoogle Scholar
  6. 6.
    Zhou, J., Larson, P., Goldstein, J.: Partially materialized views. Technical Report MSR-TR-2005-77, Microsoft Research (2005)Google Scholar
  7. 7.
    IBM: DB2 Universal Database (V 8.2) (2005)Google Scholar
  8. 8.
    Merker, C.: Konzeption und Realisierung eines Constraint-basierten Datenbank-Cache. Master’s thesis, TU Kaiserslautern (2005)Google Scholar
  9. 9.
    Härder, T., Bühmann, A.: Database Caching – Towards a Cost Model for Populating Cache Groups. In: Benczúr, A.A., Demetrovics, J., Gottlob, G. (eds.) ADBIS 2004. LNCS, vol. 3255, pp. 215–229. Springer, Heidelberg (2004)CrossRefGoogle Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2006

Authors and Affiliations

  • Andreas Bühmann
    • 1
  • Theo Härder
    • 1
  • Christian Merker
    • 1
  1. 1.Department of Computer ScienceUniversity of KaiserslauternKaiserslauternGermany

Personalised recommendations