Updating distributed materialized views
- 1 June 1989
- journal article
- Published by Institute of Electrical and Electronics Engineers (IEEE) in IEEE Transactions on Knowledge and Data Engineering
- Vol. 1 (2) , 173-184
- https://doi.org/10.1109/69.87958
Abstract
The problem of updating materialized views in distributed database systems is discussed. An architecture and detailed procedures for updating a collection of remote views with arbitrary refresh times by using a single differential file are described. The efficiency of the update procedure is enhanced by adopting s multiquery optimization approach and by introducing a powerful prescreening procedure to eliminate differential tuples. It is shown that even for a single remote view, there are many instances where the update procedure performs better (with respect to total I/O and communication costs) than a base table approach.<>Keywords
This publication has 18 references indexed in Scilit:
- Using common subexpressions to optimize multiple queriesPublished by Institute of Electrical and Electronics Engineers (IEEE) ,2003
- A performance analysis of view materialization strategiesACM SIGMOD Record, 1987
- Principles and Techniques in the Design of ADMS±Computer, 1986
- Generating editing environments based on relations and attributesACM Transactions on Programming Languages and Systems, 1986
- Efficiently updating materialized viewsACM SIGMOD Record, 1986
- A snapshot differential refresh algorithmPublished by Association for Computing Machinery (ACM) ,1986
- Updating hypothetical data basesInformation Processing Letters, 1983
- Approximating block accesses in database organizationsCommunications of the ACM, 1977
- System RACM Transactions on Database Systems, 1976
- Space/time trade-offs in hash coding with allowable errorsCommunications of the ACM, 1970