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: Advances in Database Technology, EDBT'09
Pages791-802
Number of pages12
DOIs
Publication statusPublished - 25 Sep 2009
Externally publishedYes
Event12th International Conference on Extending Database Technology: Advances in Database Technology, EDBT'09 - Saint Petersburg, Russian Federation
Duration: 24 Mar 200926 Mar 2009

Other

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

Fingerprint

XML
Servers
Information systems
Middleware
Mobile devices
Energy utilization

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) https://doi.org/10.1145/1516360.1516451

An approach to detecting relevant updates to cached data using XML and active databases. / Mansour, Essam; Höpfner, Hagen.

Proceedings of the 12th International Conference on Extending Database Technology: Advances in Database Technology, EDBT'09. 2009. p. 791-802.

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

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, 12th International Conference on Extending Database Technology: Advances in Database Technology, EDBT'09, Saint Petersburg, Russian Federation, 24/3/09. https://doi.org/10.1145/1516360.1516451
Mansour E, Höpfner H. 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. 2009. p. 791-802 https://doi.org/10.1145/1516360.1516451
Mansour, Essam ; Höpfner, Hagen. / An approach to detecting relevant updates to cached data using XML and active databases. Proceedings of the 12th International Conference on Extending Database Technology: Advances in Database Technology, EDBT'09. 2009. pp. 791-802
@inproceedings{90b13396a2374b97b75c286e8caf6250,
title = "An approach to detecting relevant updates to cached data using XML and active databases",
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.",
author = "Essam Mansour and Hagen H{\"o}pfner",
year = "2009",
month = "9",
day = "25",
doi = "10.1145/1516360.1516451",
language = "English",
isbn = "9781605584225",
pages = "791--802",
booktitle = "Proceedings of the 12th International Conference on Extending Database Technology: Advances in Database Technology, EDBT'09",

}

TY - GEN

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

AU - Mansour, Essam

AU - Höpfner, Hagen

PY - 2009/9/25

Y1 - 2009/9/25

N2 - 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.

AB - 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.

UR - http://www.scopus.com/inward/record.url?scp=70349277579&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=70349277579&partnerID=8YFLogxK

U2 - 10.1145/1516360.1516451

DO - 10.1145/1516360.1516451

M3 - Conference contribution

AN - SCOPUS:70349277579

SN - 9781605584225

SP - 791

EP - 802

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

ER -