Scheduled System Maintenance:
On May 6th, single article purchases and IEEE account management will be unavailable from 8:00 AM - 12:00 PM ET (12:00 - 16:00 UTC). We apologize for the inconvenience.
By Topic

Deferred maintenance of replicated objects in single-site databases

Sign In

Cookies must be enabled to login.After enabling cookies , please use refresh or reload or ctrl+f5 on the browser for the login options.

Formats Non-Member Member
$31 $13
Learn how you can qualify for the best price for this item!
Become an IEEE Member or Subscribe to
IEEE Xplore for exclusive pricing!
close button

puzzle piece

IEEE membership options for an individual and IEEE Xplore subscriptions for an organization offer the most affordable access to essential journal articles, conference papers, standards, eBooks, and eLearning courses.

Learn more about:

IEEE membership

IEEE Xplore subscriptions

1 Author(s)
Teuhola, J. ; Dept. of Comput. Sci., Turku Univ., Finland

Replication of database objects is suggested as a means of enhancing performance in cases where conflicting preferences for clustering occur, such as in the storage of many-to-many relationships. A novel feature is lazy propagation of updates: the primary objects are kept up-to-date, but an obsolete replica is not updated until it is next retrieved. The core of the method is a main-memory hash table, containing timestamps of primary objects. Replication causes almost no overhead in regard to updates, concurrency or recovery. Yet, the retrieval speed can be increased considerably. Replication should be applied only for critical, read-intensive object types, to gain actual advantage from redundancy, compensating the storage penalty. The author's scheme could be used for implementing materialized views in relational databases. However, the method is described in terms of pointer-based architectures

Published in:

Database and Expert Systems Applications, 1996. Proceedings., Seventh International Workshop on

Date of Conference:

9-10 Sep 1996