Paper Info
Title
DYVEP: An active database system with vertical partitioning functionality
Abstract
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.
Year
DOI
Venue
2013
10.1109/ICNSC.2013.6548782
Networking, Sensing and Control
Keywords
Field
DocType
query processing,relational databases,DBA,DYVEP,TPC-H benchmark,VPS,active database system,database administrator,database attributes,dynamic partitioning capability,query response time,relational databases,vertical fragmentation scheme,vertical partitioning functionality
Query optimization,Data mining,Alias,Computer science,Sargable,View,Database design,Query by Example,Database theory,Active database
Conference
ISSN
ISBN
Citations 
1810-7869
978-1-4673-5199-7
0
PageRank 
References 
Authors
0.34
0
6
Name
Order
Citations
PageRank
Lisbeth Rodriguez1242.75
Xiaoou Li255061.95
Alma-Delia Cuevas3212.08
Farid GarcíA Lamont4699.58
Cuevas-Rasgado, A.D.500.34
Garcia-Lamont, F.600.34