2002Unpublished venueRequires access

Optimizing queries with materialized views

Surajit Chaudhuri, R. Krishnamurthy, Spyros Potamianos, Kyuseok Shim

Open publisher page 376 citations

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.>

About this research paper

What this paper is about

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.>

Why it matters

OpenAlex reports 376 citations for this work. Citation counts describe recorded attention and do not establish research quality.

Key contribution

A contribution statement is not available in the OpenAlex record.

Method / approach

Method details are not available in the OpenAlex metadata.

Main findings

Findings are not separately available in the OpenAlex metadata.

Limitations

Limitations are not available in the OpenAlex metadata.

Applications

Application details are not available in the OpenAlex metadata.

Available 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.>

Key concepts: Materialized view, Computer science, Generalization, Simple (philosophy), Property (philosophy), Information retrieval, Theoretical computer science, Mathematics

Related papers

Back to paper searchBrowse research topicsOriginal source
Optimizing queries with materialized views — Research Paper | ScholarLens