A Refresh Scheme for Remote Snapshots

Aditya N. Saharia and George Diehr
Additional contact information
Aditya N. Saharia: Department of Information and Decision Sciences, College of Business Administration, University of Illinois at Chicago, Chicago, Illinois 60680-4348
George Diehr: College of Business Administration, California State University, San Marcos, 820 W. Los Vallecitos Boulevard, San Marcos, California 92069-1477

Information Systems Research, 1990, vol. 1, issue 3, 277-308

Abstract: This article presents a scheme called “Difference Table” for maintaining database snapshots stored at sites remote from a central database which are refreshed only upon user request. Database snapshots are currently in widespread use where a subset of the central database is extracted and transmitted to a local workstation and utilized for decision support. The Difference Table method checks each update to a central database table against the definition of the snapshot. If the update is relevant, its effect is stored in a difference table. On receiving the refresh request, the contents of the difference table are transmitted to the remote site where they update the snapshot. The Difference Table scheme allows a selective refresh of the snapshot, in the sense that only the changes to a snapshot since the last refresh are transmitted. We discuss the additional database tables and processes required to support the Difference Table scheme. Performance measures are developed, and both quantitative and qualitative comparisons are made to alternative methods such as full regeneration and the approach used by System R * . By most criteria and in many environments, the Difference Table scheme is preferable to these alternatives. It also has several attractive side benefits which are not available in alternative methods.

Keywords: database snapshot; materialized view; snapshot management; distributed database (search for similar items in EconPapers)
Date: 1990
References: Add references at CitEc
Citations: View citations in EconPapers (1)

Downloads: (external link)
http://dx.doi.org/10.1287/isre.1.3.277 (application/pdf)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:inm:orisre:v:1:y:1990:i:3:p:277-308

Access Statistics for this article

More articles in Information Systems Research from INFORMS Contact information at EDIRC.
Bibliographic data for series maintained by Chris Asher ().