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.