Paper Info
Title
Active rule base development for dynamic vertical partitioning of multimedia databases.
Abstract
Currently, vertical partitioning has been used in multimedia databases in order to take advantage of its potential benefits in query optimization. Nevertheless, most vertical partitioning algorithms are static; this means that they optimize a vertical partitioning scheme (VPS) according to a workload, but if this workload suffers changes, the VPS may be degraded, which would result in long query response time. This paper presents a set of active rules to perform dynamic vertical partitioning in multimedia databases. First of all, these rules collect all the information that a vertical partitioning algorithm needs as input. Then, they evaluate this information in order to know if the database has experienced enough changes to trigger a performance evaluator. In this case, if the performance of the database falls below a threshold previously calculated by the rules, the vertical partitioning algorithm is triggered, which gets a new VPS. Finally, the rules materialize the new VPS. Our active rule base is implemented in the system DYMOND, which is an active rule-based system for dynamic vertical partitioning of multimedia databases. DYMOND's architecture and workflow are presented in this paper. Moreover, a case study is used to clarify and evaluate the functionality of our active rule base. Additionally, authors of this paper performed a qualitative evaluation with the aim of comparing and evaluating DYMOND's functionality. The results showed that DYMOND improved query performance in multimedia databases.
Year
DOI
Venue
2017
10.1007/s10844-016-0420-9
J. Intell. Inf. Syst.
Keywords
Field
DocType
Database design,Query optimization,Reactive systems,Vertical fragments
Query optimization,Data mining,Architecture,Computer science,Workload,Response time,Database design,Reactive system,Multimedia,Workflow,Database
Journal
Volume
Issue
ISSN
48
2
0925-9902
Citations 
PageRank 
References 
0
0.34
46
Authors
5
Name
Order
Citations
PageRank
Lisbeth Rodríguez-Mazahua1246.43
Giner Alor-Hernández213639.47
Xiaoou Li355061.95
Jair Cervantes417618.08
Asdrubal Lopez-Chau542.77