Issue No. 02 - June (1989 vol. 1)
DOI Bookmark: http://doi.ieeecomputersociety.org/10.1109/69.87958
<p>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.</p>
distributed materialized views; updating; distributed database systems; architecture; remote views; arbitrary refresh times; differential file; efficiency; multiquery optimization; prescreening procedure; eliminate; differential tuples; distributed databases; relational databases
J. Park and A. Segev, "Updating Distributed Materialized Views," in IEEE Transactions on Knowledge & Data Engineering, vol. 1, no. , pp. 173-184, 1989.