Migration of Relational Database to Document-Oriented Database: Structure Denormalization and Data Transformation

Girts Karnitis, Guntis Arnicans
2015 2015 7th International Conference on Computational Intelligence, Communication Systems and Networks  
Relational databases remain the leading data storage technology. Nevertheless, many companies want to reduce operating expenses, to make scalable applications that use cloud computing technologies. Use of NoSQL database is one of the possible solutions, and it is forecasted that the NoSQL market will be growing at a CAGR of approximately 50 percent over the next five years. The paper offers a solution for quick data migration from a relational database into a document-oriented database. We have
more » ... created semiautomatically two logical levels over physical data. Users can refine generated logical data model and configure data migration template for each needed document. Data migration features are implemented into relational database browser DigiBrowser. Real patients' database was migrated to Clasterpoint database. The offered approach provides means to obtain at least proof-of-concept for new document-oriented database solution in a couple of days.
doi:10.1109/cicsyn.2015.30 dblp:conf/cicsyn/KarnitisA15 fatcat:d7coi7bfs5h6tdtbceiqdwpsta