Loading a Cache with Query Results
Background & Motivation
Background and Motivation
Traditional System
Goal & Solution
PPT-Folie
Tradeoffs
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
Homepage: http://www.db.fmi.uni-passau.de/