The Community for Technology Leaders
RSS Icon
Subscribe
Issue No.02 - June (1989 vol.1)
pp: 173-184
ABSTRACT
<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>
INDEX TERMS
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
CITATION
A. Segev, J. Park, "Updating Distributed Materialized Views", IEEE Transactions on Knowledge & Data Engineering, vol.1, no. 2, pp. 173-184, June 1989, doi:10.1109/69.87958
18 ms
(Ver 2.0)

Marketing Automation Platform Marketing Automation Tool