|
|
|
@inproceedings{DBLP:conf/vldb/KahlerR87,
author = {Bo K{\"a}hler and
Oddvar Risnes},
editor = {Peter M. Stocker and
William Kent and
Peter Hammersley},
title = {Extending Logging for Database Snapshot Refresh},
booktitle = {VLDB'87, Proceedings of 13th International Conference on Very
Large Data Bases, September 1-4, 1987, Brighton, England},
publisher = {Morgan Kaufmann},
year = {1987},
isbn = {0-934613-46-X},
pages = {389-398},
ee = {db/conf/vldb/KahlerR87.html},
crossref = {DBLP:conf/vldb/87},
bibsource = {DBLP, http://dblp.uni-trier.de}
}
A database snapshot mechanism represents a cost effective substitute for replicated data in a distributed database. The contents of a database snapshot can be periodically refreshed to reflect the current state of the database. In a distributed database system it is significant to reduce the cost of snapshot refresh. This can be obtained by a differential refresh strategy in which modifications to the base tables involved are detected.
The paper proposes two methods based on using a separate table for logging the modifications made to a base table; a sequential and a condensed logging approach. The methods have been compared for various update frequency and composition. The sequential log performs well for single snapshots if the modification set is small relative to the base table size, or if the snapshot is restrictive. In the case of large modification sets and replicated snapshots, the condensed logging method is to be preferred.
Copyright © 1987 by the VLDB Endowment. Permission to copy without fee all or part of this material is granted provided that the copies are not made or distributed for direct commercial advantage, the VLDB copyright notice and the title of the publication and its date appear, and notice is given that copying is by the permission of the Very Large Data Base Endowment. To copy otherwise, or to republish, requires a fee and/or special permission from the Endowment.
