Optimizing queries with materialized views
Surajit Chaudhuri, R. Krishnamurthy, S. Potamianos et al. · Proceedings - International Conference on Data Engineering · 2002
While much work has addressed the problem of maintaining materialized views, the important question of optimizing queries in the presence of materialised views has not been resolved. In this paper, we analyze the optimization question and provide a comprehensive and efficient solution. Our solution has the desirable property that it is a simple generalization of the traditional query optimization algorithm.>
Cited by 374 works. doi:10.1109/icde.1995.380392
Authors
References
- Introduction to Algorithms
- Access path selection in a relational database management system
- Principles of database and knowledge-base systems
- Optimal implementation of conjunctive queries in relational data bases
- Maintaining views incrementally
- Efficiently updating materialized views
- Randomized algorithms for optimizing large join queries
- Query Transformation for PSJ-Queries
- Efficiently monitoring relational databases
- On rules, procedures, caching and views in database systems