An Empirical Hybrid Strategy for NoSQL Database Distribution

被引:0
|
作者
Mendoza-Labastida, Jose Abiel [1 ]
Clavel-Maqueda, Mireya [1 ]
Garcia-Perez, Orlando [1 ]
Cornejo-Velazquez, Eduardo [1 ]
机构
[1] Univ Autonoma Estado Hidalgo, Area Acad Comp & Elect, Pachuca 42184, Hidalgo, Mexico
关键词
NoSQL; MongoDB; Replication; Sharding; Migration; ALGORITHM;
D O I
10.61467/2007.1558.2024.v15i1.435
中图分类号
O29 [应用数学];
学科分类号
070104 ;
摘要
A case study of a pharmaceutical distribution company with a relational database that is migrated to a document-oriented NoSQL database for which a hybrid distribution strategy based on fragmentation and replication is implemented. The legacy relational database schema was thoroughly analyzed and evaluated to determine the collections and documents needed to move all the data and leverage the capabilities of the document-based database. In addition, a hybrid data distribution strategy was designed to effectively balance the performance, scalability, and fault tolerance of the system. Finally, integrated operational tests were performed on the distributed system nodes to verify that they function properly and ensure their availability for the company's operations.
引用
收藏
页码:51 / 61
页数:11
相关论文
共 50 条
  • [41] NoSQL Database Record Versions Processing Model
    Burdakov, Aleksey
    Grigorev, Uriy
    Ttsviashchenko, Eugene
    Ploutenko, Andrey
    2017 25TH EUROMICRO INTERNATIONAL CONFERENCE ON PARALLEL, DISTRIBUTED AND NETWORK-BASED PROCESSING (PDP 2017), 2017, : 149 - 156
  • [42] Evaluation of NoSQL Prototypes for the CMS Conditions Database
    Sipos, R.
    2015 IEEE NUCLEAR SCIENCE SYMPOSIUM AND MEDICAL IMAGING CONFERENCE (NSS/MIC), 2015,
  • [43] Schema Conversion Model of SQL Database to NoSQL
    Zhao, Gansen
    Lin, Qiaoying
    Li, Libo
    Li, Zijing
    2014 NINTH INTERNATIONAL CONFERENCE ON P2P, PARALLEL, GRID, CLOUD AND INTERNET COMPUTING (3PGCIC), 2014, : 355 - 362
  • [44] The application of NoSQL database in Air Quality Monitoring
    Han, Mei
    PROCEEDINGS OF THE 2015 INTERNATIONAL CONFERENCE ON INTELLIGENT SYSTEMS RESEARCH AND MECHATRONICS ENGINEERING, 2015, 121 : 101 - 104
  • [45] MySQL and NoSQL database comparison for IoT application
    Rautmare, Sharvari
    Bhalerao, D. M.
    2016 IEEE INTERNATIONAL CONFERENCE ON ADVANCES IN COMPUTER APPLICATIONS (ICACA), 2016, : 235 - 238
  • [46] Association Analysis of Firmware Based on NoSQL Database
    Wang, Gongbo
    Dong, Weiyu
    Chang, Rui
    CLOUD COMPUTING AND SECURITY, PT V, 2018, 11067 : 94 - 105
  • [47] Estimation Models for NoSQL Database Consistency Characteristics
    Burdakov, Aleksey
    Grigorev, Uriy
    Ploutenko, Andrey
    Ttsviashchenko, Eugene
    2016 24TH EUROMICRO INTERNATIONAL CONFERENCE ON PARALLEL, DISTRIBUTED, AND NETWORK-BASED PROCESSING (PDP), 2016, : 35 - 42
  • [48] Hints from the Crowd: A Novel NoSQL Database
    Fosci, Paolo
    Psaila, Giuseppe
    Di Stefano, Marcello
    MODEL AND DATA ENGINEERING, MEDI 2013, 2013, 8216 : 118 - 131
  • [49] NoSQL Database Generation Using SAT Solver
    Ibrahim, Muhammad
    Sarwar, Nadeem
    2016 SIXTH INTERNATIONAL CONFERENCE ON INNOVATIVE COMPUTING TECHNOLOGY (INTECH), 2016, : 627 - 631
  • [50] Discovering of a Conceptual Model from a NoSQL Database
    Abdelhedi, Fatma
    Brahim, Amal Ait
    Ferhat, Rabah Tighilt
    Zurfluh, Gilles
    PROCEEDINGS OF THE 22ND INTERNATIONAL CONFERENCE ON ENTERPRISE INFORMATION SYSTEMS (ICEIS), VOL 1, 2020, : 61 - 72