Lehrgebiet Informationssysteme

FB Informatik

Examining the Performance of a Constraint-Based Database Cache

Andreas Bühmann, Joachim Klein

Full paper (PDF Version)

Abstract:

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. We describe the measurement framework we have developed for analyzing distributed systems in general and our extensions for observing the ACCache system. 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.

Submitted to the East-European Symposium on Advances in Databases and Information Systems (ADBIS), September 29 - October 03, 2007, Varna, F.J. Curry House of Scientists, Bulgaria.