Examining the Performance of a Constraint-Based Database Cache

Constraint-based database caching aims at correctly answering SQL query predicates from a local cache database by exploiting constraints that have previously been used in selecting sets of records to be cached from a remote database. In this paper, we take our first steps in looking at performance aspects of our prototype Adaptive Constraint-based Cache (ACCache), which is realized in a middleware manner on top of regular databases. Within our measurement setup, the initial focus is on two central ACCache functions: query processing and cache loading. To demonstrate their time behavior and interaction, we have chosen a scenario based on the TPC-W specification. We conclude with a discussion of our first measurement results.

• Type: Conference
• Year: 2007
• Where: IDEAS
• Authors: Andreas Bühmann, Joachim Klein 0002
• Keywords: Adaptive Constraint-based Cache, Database, Database Caching Aims, IDEAS 2007, Local Cache Database