A dynamic vertical partitioning approach for distributed database system

Abstract

Vertical and horizontal partitioning are physical database design techniques that can considerably improve query response time in distributed database system. Although most current database management systems support horizontal partitioning, they do not implement vertical partitioning bacause it is based on user queries and it is necessary to monitor queries in order to generate a good vertical partitioning solution. In this paper, we use active rules to develop an active system for dynamic vertical partitioning of distributed database. The system vertically fragment and re-fragment a database without intervention of a database administrator. Experiments on a Benchmark database TPC-H demonstrate acceptable query response time.