Sciweavers

Share
ICDIM
2008
IEEE

Dynamic detection and administration of materialized views based on the Query Graph Model

9 years 5 months ago
Dynamic detection and administration of materialized views based on the Query Graph Model
Database Management Systems (DBMS) are complex software systems which are used in an increasing number of applications. To obtain the best performance for business relevant applications, e.g., Decision Support Systems (DSS). DBMS have to be tuned and monitored. In order to reduce the costs researchers and DBMS vendors have focused on self-management techniques for recent years. In particular, materialized views were used to pre-compute results in Online Analytical Processing (OLAP) systems to improve the performance, e.g., the query processing time. In this work, we propose an automatic selection of materialized views based on statistics about a workload that is represented in the Query Graph Model (QGM). Our approach allows the mapping of workload queries into a map graph and materializes views by using access statistics and cost functions. We evaluate our approach with the TPC-H benchmark and compare it to a commercial DBMS.
Andreas Lübcke, Ingolf Geist, Ronny Bubke
Added 30 May 2010
Updated 30 May 2010
Type Conference
Year 2008
Where ICDIM
Authors Andreas Lübcke, Ingolf Geist, Ronny Bubke
Comments (0)
books