Optimizing queries with materialized views
Surajit Chaudhuri, R. Krishnamurthy, Spyros Potamianos, Kyuseok Shim
Abstract
Surajit Chaudhuri, R. Krishnamurthy, Spyros Potamianos, Kyuseok Shim
Abstract
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.>
OpenAlex reports 376 citations for this work. Citation counts describe recorded attention and do not establish research quality.
A contribution statement is not available in the OpenAlex record.
Method details are not available in the OpenAlex metadata.
Findings are not separately available in the OpenAlex metadata.
Limitations are not available in the OpenAlex metadata.
Application details are not available in the OpenAlex metadata.
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.>
Key concepts: Materialized view, Computer science, Generalization, Simple (philosophy), Property (philosophy), Information retrieval, Theoretical computer science, Mathematics