A generalized method for maintaining views

Authors:
Kathryn C. Kinsley;James R. Driscoll
Affiliations:
Datawise, Inc., Orlando, Florida;University of Central Florida, Orlando, Florida
Venue:
AFIPS '84 Proceedings of the July 9-12, 1984, national computer conference and exposition
Year:
1984

Citing 8
Cited 0

Differential files: their application to the maintenance of large databases

ACM Transactions on Database Systems (TODS)
Relational Database Systemsr

ACM Computing Surveys (CSUR)
A relational model of data for large shared data banks

Communications of the ACM
Implementation of integrity constraints and views by query modification

SIGMOD '75 Proceedings of the 1975 ACM SIGMOD international conference on Management of data
An Introduction to Database Systems

An Introduction to Database Systems
Fast methods for testing quantified relational calculus assertions

SIGMOD '82 Proceedings of the 1982 ACM SIGMOD international conference on Management of data
Dynamic derived relations within the RAQUEL II DBMS

ACM '79 Proceedings of the 1979 annual conference
Functional specifications of a subsystem for data base integrity

VLDB '75 Proceedings of the 1st International Conference on Very Large Data Bases

Quantified Score

Hi-index	0.00

Visualization

Abstract

A generalized method for maintaining views, which takes into account each view's pattern of usage, is described. This method involves storing views in both actual and potential forms. When views exist in actual form (concrete views), updates are deferred until the view is queried. Differential files are formed from tuples inserted and deleted from the defining relations. These differential files are then used in conjunction with specified update schemes to update the view. Views alternate between actual and potential form based on their usage and the storage replacement algorithm.