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.