Oscar Crescencio-Rico, Lisbeth Rodríguez-Mazahua, Felipe Castro-Medina, Giner Alor-Hernández, José Luis Sánchez-Cervantes
{"title":"Dynamic Hybrid Fragmentation Method for Multimedia Databases","authors":"Oscar Crescencio-Rico, Lisbeth Rodríguez-Mazahua, Felipe Castro-Medina, Giner Alor-Hernández, José Luis Sánchez-Cervantes","doi":"10.29057/icbi.v11iespecial2.10716","DOIUrl":null,"url":null,"abstract":"Multimedia databases store high-volume data, which causes problems in efficient information retrieval, and increases execution costs and response times of the queries. To solve this problem, data fragmentation techniques exist to improve query performance, increase information availability, and efficiently execute more operations accessing less irrelevant data. This article presents a comprehensive review of 34 methods related to hybrid fragmentation and subsequently proposes the design of a hybrid fragmentation method that adapts the scheme according to workload changes to maintain efficient retrieval of multimedia data. The proposed technologies are Java as a programming language, Java Server Faces (JSF) as a framework, MySQL and MongoDB database management systems, and NetBeans as an Integrated Development Environment (IDE), following the UWE methodology (Unified Modeling Language-based Web Engineering).","PeriodicalId":476815,"journal":{"name":"PÄDI boletín científico de ciencias básicas e ingenierías del ICBI","volume":"17 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2023-09-11","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":null,"platform":"Semanticscholar","paperid":null,"PeriodicalName":"PÄDI boletín científico de ciencias básicas e ingenierías del ICBI","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.29057/icbi.v11iespecial2.10716","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
引用次数: 0
Abstract
Multimedia databases store high-volume data, which causes problems in efficient information retrieval, and increases execution costs and response times of the queries. To solve this problem, data fragmentation techniques exist to improve query performance, increase information availability, and efficiently execute more operations accessing less irrelevant data. This article presents a comprehensive review of 34 methods related to hybrid fragmentation and subsequently proposes the design of a hybrid fragmentation method that adapts the scheme according to workload changes to maintain efficient retrieval of multimedia data. The proposed technologies are Java as a programming language, Java Server Faces (JSF) as a framework, MySQL and MongoDB database management systems, and NetBeans as an Integrated Development Environment (IDE), following the UWE methodology (Unified Modeling Language-based Web Engineering).
多媒体数据库存储了大量的数据,这给信息的高效检索带来了问题,并且增加了查询的执行成本和响应时间。为了解决这个问题,存在数据碎片技术,以提高查询性能,增加信息可用性,并有效地执行更多操作,访问更少的不相关数据。本文全面回顾了34种与混合分片相关的方法,随后提出了一种混合分片方法的设计,该方法可以根据工作负载的变化调整方案,以保持多媒体数据的高效检索。建议的技术是Java作为编程语言,Java Server Faces (JSF)作为框架,MySQL和MongoDB数据库管理系统,以及NetBeans作为集成开发环境(IDE),遵循UWE方法(基于统一建模语言的Web工程)。