Loading a Cache with Query Results

06.09.99


Zum Starten hier klicken


Inhaltsverzeichnis

Loading a Cache with Query Results

Background & Motivation

Background and Motivation

Traditional System

Goal & Solution

PPT-Folie

Tradeoffs

PPT-Folie

PPT-Folie

Alternative Approaches

Caching at the Top Heuristics

Cache Operator Push Down

Caching at the Bottom Heuristics

Cost-based Cache Operator Placement

Enumerating all Caching Plans

Costing of Cache Operators

Summary of Approaches

Performance Experiments

Application Run Time (secs) single-table query + accessor method

Application Run Time (secs) three-way joins + accessor method

Query Optimization Times(secs) vary number of candidate collections

Conclusions

Future Work

Autor:Professor Kemper

Homepage: http://www.db.fmi.uni-passau.de/