Application of Dynamic Fragmentation Methods in Multimedia Databases: A Review
View/ Open
Date
2020-11-30Author
Castro-Medina, Felipe
Rodríguez-Mazahua, Lisbeth
López-Chau, Asdrúbal
Cervantes, Jair
Alor-Hernández, Giner
Machorro-Cano, Isaac
Metadata
Show full item recordAbstract
Fragmentation is a design technique widely used in multimedia databases, because it produces substantial benefits in reducing response times, causing lower execution costs in each operation performed. Multimedia databases include data whose main characteristic is their large size, therefore, database administrators face a challenge of great importance, since they must contemplate the different qualities of non-trivial data. These databases over time undergo changes in their access patterns. Different fragmentation techniques presented in related studies show adequate workflows, however, some do not contemplate changes in access patterns. This paper aims to provide an in-depth review of the literature related to dynamic fragmentation of multimedia databases, to identify the main challenges, technologies employed, types of fragmentation used, and characteristics of the cost model. This review provides valuable information for database administrators by showing essential characteristics to perform proper fragmentation and to improve the performance of fragmentation schemes. The reduction of costs in fragmentation methods is one of the most desired main properties. To fulfill this objective, the works include cost models, covering different qualities. In this analysis, a set of characteristics used in the cost models of each work is presented to facilitate the creation of a new cost model including the most used qualities. In addition, different data sets or reference points used in the testing stage of each work analyzed are presented.
Temas
Cost modelDynamic fragmentation
Multimedia fragmentation
Literature review
Horizontal fragmentation
Vertical fragmentation
Hybrid fragmentation
Tipo
ArticleCollections
- Artículos (DCI) [72]
Related items
Showing items related by title, author, creator and subject.
-
FRAGMENT: A Web Application for Database Fragmentation, Allocation and Replication Over a Cloud Environment
Castro-Medina, Felipe; Rodríguez-Mazahua, Lisbeth; López-Chau, Asdrúbal; Abud-Figueroa, María Antonieta; Alor-Hernández, Giner (IEEE, 2020-05-25)Fragmentation, allocation and replication are techniques widely used in relational databases to improve the performance of operations and reduce their cost in distributed environments. This article shows an analysis of ... -
Application of Dynamic Fragmentation Methods in Multimedia Databases: A Review
Castro-Medina, Felipe; Rodríguez Mazahua, Lisbeth; López-Chau, Asdrúbal; Cervantes, Jair; Alor-Hernández, Giner; Machorro-Cano, Isaac (MDPI Publishing, 2020-11-30)Fragmentation is a design technique widely used in multimedia databases, because it produces substantial benefits in reducing response times, causing lower execution costs in each operation performed. Multimedia databases ... -
Horizontal Fragmentation of Data Warehouses Using Decision Trees
Rodríguez-Mazahua, Nidia; Rodríguez-Mazahua, Lisbeth; López-Chau, Asdrúbal; Alor-Hernández, Giner (Universidad Autónoma de Coahuila, Centro de Investigación en Matemáticas Aplicadas, 2020-08-01)One of the main problems faced by Data Warehouse (DW) designers is fragmentation. Several studies have proposed data mining-based horizontal fragmentation methods, which focus on optimizing the query response time and ...