A method of workload compression basing on characteristics for index selection

Authors:
Xin Zhang;Zhihao Zhang;Jinlong Lin
Affiliations:
Peking University, Beijing, China;Peking University, Beijing, China;Peking University , Beijing, China
Venue:
Proceedings of the ACM first international workshop on Data-intensive software management and mining
Year:
2009

Citing 3
Cited 0

Compressing SQL workloads

Proceedings of the 2002 ACM SIGMOD international conference on Management of data
Automated Selection of Materialized Views and Indexes in SQL Databases

VLDB '00 Proceedings of the 26th International Conference on Very Large Data Bases
Primitives for workload summarization and implications for SQL

VLDB '03 Proceedings of the 29th international conference on Very large data bases - Volume 29

Quantified Score

Hi-index	0.00

Visualization

Abstract

This paper presents a novel method of database workload compression basing on the queries' characteristics for purpose of solving Index Selection Problem (ISP). The algorithm applies a close analysis on the queries in workload to capture their characteristics, which are used to build the relationships between pairs of queries. Using these relationships, the original workload can be filtered out into the compressed workload, which can be used for the task without degrading the performance. This method has been implemented and the experiments on workloads illustrate that proposed solution can achieve a high performance with a little quality loss.