An empirical hybrid strategy for NoSQL database distribution

Abstract

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.