Consistent caching of data objects in database driven websites

  • Authors:
  • Paweł Leszczynski;Krzysztof Stencel

  • Affiliations:
  • Faculty of Mathematics and Computer Science, Nicolaus Copernicus University, Torun;Faculty of Mathematics and Computer Science, Nicolaus Copernicus University, Torun

  • Venue:
  • ADBIS'10 Proceedings of the 14th east European conference on Advances in databases and information systems
  • Year:
  • 2010

Quantified Score

Hi-index 0.00

Visualization

Abstract

Since databases became bottlenecks of modern web applications, everal techniques of caching data have been proposed. This paper expands the existing caching model for automatic consistency maintenance of the cached data and data stored in a database. We propose a dependency graph which provides a mapper between update statements in a relational database and cached objects. When update on a database is performed the graph allows detecting cached objects which have to be invalidated in order to preserve the consistency of the cache and the data source. We describe a novel method of caching data and keeping it in a consistent state. We believe that this model allows keeping the number of invalidations as low as possible. We illustrate the method using a simple web community forum application and provide some benchmarks which prove that our method is efficient when compared with other approaches.