An approach to detecting relevant updates to cached data using XML and active databases

Essam Mansour, Hagen Höpfner

Research output: Chapter in Book/Report/Conference proceedingConference contribution

3 Citations (Scopus)

Abstract

Client/server information systems use caching techniques to reduce the volume of transmitted data as well as response time and, especially in the case of systems with mobile clients, to reduce energy consumptions. Updating the server database might cause inconsistencies between server data and cached data. Guaranteeing consistency at least demands to invalidate outdated caches. To avoid invalidation of caches that are not affected by a particular update one must check the relevancy of each update for each cache. It has been proven, that this can only be done on a stateful server. This paper presents the purely database system (DBS) based DRUPE method for checking the relevance of server side updates to cached data by analyzing the intersection between modified data and cached data. A non-empty intersection means that the update operations are relevant to the cached data. The necessary cache descriptions are stored in form of XML-documents inside the DBS. The paper introduces the used XML-model XREAL as well as the relevancy proof-of-concept system UPTIME. The main contribution of our work is that the system utilizes the DBS utilities to detect update relevance, notify clients and manage the required repository of the queries issued by the clients. Hence, no additional middleware is required in order to realize consistency aware client/server information systems, even if clients are small footprinted mobile devices.

Original languageEnglish
Title of host publicationProceedings of the 12th International Conference on Extending Database Technology
Subtitle of host publicationAdvances in Database Technology, EDBT'09
Pages791-802
Number of pages12
DOIs
Publication statusPublished - 25 Sep 2009
Event12th International Conference on Extending Database Technology: Advances in Database Technology, EDBT'09 - Saint Petersburg, Russian Federation
Duration: 24 Mar 200926 Mar 2009

Publication series

NameProceedings of the 12th International Conference on Extending Database Technology: Advances in Database Technology, EDBT'09

Other

Other12th International Conference on Extending Database Technology: Advances in Database Technology, EDBT'09
CountryRussian Federation
CitySaint Petersburg
Period24/3/0926/3/09

    Fingerprint

ASJC Scopus subject areas

  • Computer Science Applications
  • Software

Cite this

Mansour, E., & Höpfner, H. (2009). An approach to detecting relevant updates to cached data using XML and active databases. In Proceedings of the 12th International Conference on Extending Database Technology: Advances in Database Technology, EDBT'09 (pp. 791-802). (Proceedings of the 12th International Conference on Extending Database Technology: Advances in Database Technology, EDBT'09). https://doi.org/10.1145/1516360.1516451