Paper Info
Title
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.
Year
DOI
Venue
2011
10.1109/ICSMC.2011.6083941
Systems, Man, and Cybernetics
Keywords
Field
DocType
distributed databases,query processing,benchmark database TPC-H,database administrator,database management system,distributed database system,dynamic vertical partitioning approach,physical database design technique,query monitor,query response time,Vertical partitioning,active rules,active system,relational databases
Data mining,Database tuning,Computer science,View,Database schema,Database design,Database testing,Database theory,Distributed database,Database index
Conference
ISSN
ISBN
Citations 
1062-922X
978-1-4577-0652-3
11
PageRank 
References 
Authors
0.55
11
2
Name
Order
Citations
PageRank
Lisbeth Rodriguez1242.75
Xiaoou Li255061.95