A Middleware-Based Approach to Database Caching

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. 1 Motivation While Web caching is concerned with reducing response time and bandwidth consumption for service requests in the user-to-server path, database (DB) caching focuses on request optimization in the remaining path from the Web server to the backend database, which keeps the dynamic up-to-date data used by transactional programs to derive user query results. In contrast to Web caching, which can only answer identifier-based cache requests, DB cach...

• Type: Conference
• Year: 2006
• Where: ADBIS
• Authors: Andreas Bühmann, Theo Härder, Christian Merker
• Keywords: ADBIS 2006, Application Server, Caching, Database, Declarative Query Processing