Examining the Performance of a Constraint-Based Database Cache, Submitted to: ADBIS, September 29 - October 03

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 look-ing 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. 1