Enhancing Data Warehouse Performance Through Query Caching

摘要

The main function of a data warehouse is the sep- aration of the decision layer from the operation layer so that users can invoke analysis, planning, and decision support applications without having to worry about constantly evolving operational databases. Such applications allow ad hoc queries for which no predefined reports exist. It is possible that an ad hoc query is submitted by dif- ferent users or even by the same user at different times, requiring its repeated evaluations even though the contents of the warehouse have not changed in between.