Databases Reference
In-Depth Information
Figure 12.19
Zilio et al. TPC-H result.
IBM also published an experimental result on combined materialized view and
index selection [Zilio et al. 2004]. The experiments used an OLAP-type (star) schema.
The originating system was a shared-nothing database system with 10 processing parti-
tions. There were more than 15 tables in the database, comprising roughly 400 GB of
data. The workload contained 12 OLAP-like business queries to the star schema, each
of which had an equal frequency of execution. In these experiments the DB2 Design
Table 12.3
Number and Type of Attributes Recommended in Zilio et al. Experiment
Advisor was tested using both multiquery optimization alone and a combination of
multiquery optimization and whole queries as input to the candidate set of possible
materialized views.
These results include the total workload estimated times with no materialized
views, the total workload estimated times when materialized views are recommended by
