Compression Aware Physical Database Design

Details Compression Aware Physical Database Design Compression Aware Physical Database Design

2011-09-04

arxiv.org/abs/1109.0736v1

Computer Science

Databases

VLDB2011

Scientific paper

Modern RDBMSs support the ability to compress data using methods such as null suppression and dictionary encoding. Data compression offers the promise of significantly reducing storage requirements and improving I/O performance for decision support queries. However, compression can also slow down update and query performance due to the CPU costs of compression and decompression. In this paper, we study how data compression affects choice of appropriate physical database design, such as indexes, for a given workload. We observe that approaches that decouple the decision of whether or not to choose an index from whether or not to compress the index can result in poor solutions. Thus, we focus on the novel problem of integrating compression into physical database design in a scalable manner. We have implemented our techniques by modifying Microsoft SQL Server and the Database Engine Tuning Advisor (DTA) physical design tool. Our techniques are general and are potentially applicable to DBMSs that support other compression methods. Our experimental results on real world as well as TPC-H benchmark workloads demonstrate the effectiveness of our techniques.

Affiliated with

Also associated with

No associations

Rating

Compression Aware Physical Database Design does not yet have a rating. At this time, there are no reviews or comments for this scientific paper.

If you have personal experience with Compression Aware Physical Database Design, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Compression Aware Physical Database Design will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFWR-SCP-O-109329