Abstract
Fragmentation plays a very important role in databases since this achieves an adequate design in distributed environments such as the cloud, which in terms of execution cost of the read and write operations, benefits are obtained. This work presents an improvement to the design of the overlapping fragmentation algorithm shown in previous works, which is part of a method to also carry out allocation and replication. The improvement consists of ordering the predicates by cost and in this way obtaining each predicate contemplating that the fragment overlap will occur, however, the fragments with a higher cost will be kept more intact than those with a lower cost. Experiments with the TPC-E benchmark adapted to a distributed environment demonstrate that our enhanced approach achieves a significant reduction of query response time.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
Abdel AE, Badr NL, Tolba MF (2016) Distributed database system (DSS) design over a cloud environment. Multimed Forensics Secur 115:97–116
Castro-Medina F, Rodriguez-Mazahua L, Lopez-Chau A, Abud-Figueroa M, Alor-Hernandez G (2020) FRAGMENT: a web application for database fragmentation, allocation and replication over a cloud environment. IEEE Latin Am Trans 18(6):1126–1134
Silberschatz A, Korth HF, Sudarshan S (2011) Database systems concepts, 6th edn. Yale University, McGraw-Hill, New Haven, CT
Özsu M, Valduriez P (2020) Principles of distributed database systems, 4th edn. Springer International Publishing, Ontario, CA
López C, Heinsen R, Huh E (2017) Improving availability applying intelligent replication in federated cloud storage based on log analysis. In: Proceedings of the 2017 international conference on machine learning and soft computing—ICMLSC ’17. Association for Computing Machinery, Ho Chi Minh City, Vietnam, pp 148–153
Stiemer A, Fetai I, Schuldt H (2016) Analyzing the performance of data replication and data partitioning in the cloud: the BEOWULF approach. In: IEEE international conference on big data (big data). IEEE, Washington, DC, pp 2837–2846
Rodríguez-Mazahua L, Alor-Hernández G, Li X, Cervantes J, López-Chau A (2017) Active rule base development for dynamic vertical partitioning of multimedia databases. J Intell Inf Syst 48(2):421–451
Abdel AE, Badr NL, Tolba MF (2014) Dynamic distributed database over cloud environment. In: International conference on advanced machine learning technologies and applications. Springer, Cairo, Egypt, pp 67–76
Drissi A, Nait-Bahloul S, Benouaret K, Benslimane D (2018) Horizontal fragmentation for fuzzy querying databases. Distrib Parallel Databases 37(3):441–468
Wiese L, Waage T, Bollwein F (2016) A replication scheme for multiple fragmentations with overlapping fragments. Comput J 60(3):308–328
Ali A, Adel A, Tacha MA (2017) An optimized approach for simultaneous horizontal data fragmentation and allocation in distributed database systems (DDBSs). Heliyon 3(12):1–42
Kumar R, Gupta N (2014) An extended approach to non-replicated dynamic fragment allocation in distributed database systems. In: 2014 international conference on issues and challenges in intelligent computing techniques. IEEE, Ghaziabad, India, pp 861–865
TPC Homepage, www.tpc.org, last accessed: 2020/08/30
Acknowledgements
The authors thank The National Technological of Mexico (TecNM) for its support for this work. Also, the National Council of Science and Technology (CONACYT) has sponsored this research paper.
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2022 The Author(s), under exclusive license to Springer Nature Singapore Pte Ltd.
About this paper
Cite this paper
Castro-Medina, F., Rodríguez-Mazahua, L., López-Chau, A., Alor-Hernández, G., Juárez-Martínez, U., Sánchez-Ramírez, C. (2022). An Improvement to FRAGMENT: A Web Application for Database Fragmentation, Allocation, and Replication Over a Cloud Environment. In: Yang, XS., Sherratt, S., Dey, N., Joshi, A. (eds) Proceedings of Sixth International Congress on Information and Communication Technology. Lecture Notes in Networks and Systems, vol 216. Springer, Singapore. https://doi.org/10.1007/978-981-16-1781-2_60
Download citation
DOI: https://doi.org/10.1007/978-981-16-1781-2_60
Published:
Publisher Name: Springer, Singapore
Print ISBN: 978-981-16-1780-5
Online ISBN: 978-981-16-1781-2
eBook Packages: Intelligent Technologies and RoboticsIntelligent Technologies and Robotics (R0)