论文信息 - Research and Application of Query Rewriting Based on Materialized Views

Research and Application of Query Rewriting Based on Materialized Views

It is very important to answer queries quickly in database environment. Queries are transparently rewritten using materialized views and the time consumed by queries is reduced by avoiding accessing huge raw records and performing time-consuming operations in order to improve query speed. This paper discussed the extended query rewriting algorithm based on join relation with foreign key, studied Query System Based on Materialized Views for small databases, and proved its validity.

Weifang Zhai | Tao Gao | Yulong Tian | Yaying Hu

[1] Maurizio Rafanelli,et al. Querying aggregate data , 1999, PODS '99.

[2] Rajeev Rastogi,et al. Processing complex aggregate queries over data streams , 2002, SIGMOD '02.

[3] Jonathan Goldstein,et al. Optimizing queries using materialized views: a practical, scalable solution , 2001, SIGMOD '01.

[4] Werner Nutt,et al. Algorithms for Rewriting Aggregate Queries Using Views , 2000, DMDW.

[5] Divesh Srivastava,et al. Answering Queries with Aggregation Using Views , 1996, VLDB.

[6] Werner Nutt,et al. Algorithms for Rewriting Aggregate Queries Using Views, Proc. Of East-European Conference on Advances in Databases and Information Systems , 2000 .

[7] Stéphane Grumbach,et al. On the content of materialized aggregate views , 2000, PODS '00.