Lecture Notes in Computer Science, 2005, Volume 3453/2005, 989, DOI: 10.1007/11408079_48

Designing and Using Views to Improve Performance of Aggregate Queries (Extended Abstract)

Foto Afrati, Rada Chirkova, Shalu Gupta and Charles Loftis

View Related Documents

Abstract

Data-intensive systems routinely use derived data (e.g., indexes or materialized views) to improve query-evaluation performance. We present a system architecture for Query-Performance Enhancement by Tuning (QPET), which combines design and use of derived data in an end-to-end approach to automated query-performance tuning. Our focus is on a tradeo. between (1) the amount of system resources spent on designing derived data and on keeping the data up to date, and (2) the degree of the resulting improvement in query performance. From the technical point of view, the novelty that we introduce is that we combine aggregate query rewriting techniques [1, 2] and view selection techniques [3] to achieve our goal.

Fulltext Preview

Image of the first page of the fulltext document