| Popis: |
Horizontal fragmentation methods are widely used in databases to improve query performance. This paper aims to present a systematic literature review on horizontal fragmentation methods applied to databases. Given the importance of multimedia applications today, this review aims to determine whether the methods consider multimedia data to obtain their partitioning schemes; whether they are dynamic, i.e., can adjust their output to access patterns or workload changes; and are based on a cost model focused on reducing query execution cost. We also consider the completeness (i.e., the paper presents all the information needed to implement the method) and implementation easiness. To meet this objective, we analyzed and classified 46 documents on horizontal fragmentation techniques. Subsequently, we selected the best approach from our comparative analysis. Finally, we presented the method workflow and architecture of a web application that implements a dynamic horizontal fragmentation technique for multimedia databases to optimize its performance and information availability. |
