DYVEP: An active database system with vertical partitioning functionality

Vertical partitioning has been widely employed in relational databases to improve query response time. Nevertheless, most of the vertical partitioning approaches are static, based on the way applications access the database attributes. A vertical fragmentation scheme (VPS) is created according to a previously known set of queries. If this set undergoes changes, then the VPS can be degraded. As a result, query response time may increase. In this paper, we present the improvement on DYVEP which was developed as an active system with dynamic partitioning capability. The system vertically fragment and re-fragment a database without intervention of a database administrator (DBA) and maintain an acceptable query response time. The efficiency of our approach is illustrated by an application on TPC-H benchmark.