论文信息 - Analytical modeling of materialized view maintenance

Analytical modeling of materialized view maintenance

A matenahzed view 1s a stored copy of the result of retrlenng the view from the database We conalder here, news that can be constructed from the relational algebra operations select, project and Jorn Also aggregates such as sum or count over views are considered Conventional systems use query mo&ficatlon, where the query on a view IS modified to operate on one or more of the base relations, [STON 751 Materlahnng a view before a query IS made on It has been a recent proposal

Jaideep Srivastava | Doron Rotem

[1] Michael Stonebraker,et al. An Implementation of Hypothetical Relations , 1983, VLDB.

[2] David J. DeWitt,et al. Updating Hypothetical Data Bases , 1983, Inf. Process. Lett..

[3] S. B. Yao,et al. Approximating block accesses in database organizations , 1977, CACM.

[4] Prashant Palvia. Expressions for batched searching of sequential and hierarchical files , 1985, TODS.

[5] Frank Wm. Tompa,et al. Efficiently updating materialized views , 1986, SIGMOD '86.

[6] Michael Stonebraker,et al. Implementation of integrity constraints and views by query modification , 1975, SIGMOD '75.

[7] Nick Roussopoulos,et al. Principles and Techniques in the Design of ADMS± , 1986, Computer.

[8] Eric N. Hanson,et al. A performance analysis of view materialization strategies , 1987, SIGMOD '87.

[9] Hamid Pirahesh,et al. A snapshot differential refresh algorithm , 1986, SIGMOD '86.

[10] Bruce G. Lindsay,et al. Database Snapshots , 1980, VLDB.

[11] Alfonso F. Cardenas. Analysis and performance of inverted data base structures , 1975, CACM.

[12] Eric K. Clemons,et al. Efficiently monitoring relational databases , 1979, ACM Trans. Database Syst..