Integration of Relational and NoSQL Databases

• Main Author: Jaroslav Pokorný
• Format: Article
• Language: English
• Published: World Scientific Publishing 2019-11-01
• Series: Vietnam Journal of Computer Science
• Subjects: relational database; nosql database; big data; big analytics; database integration
• Online Access: http://www.worldscientific.com/doi/pdf/10.1142/S2196888819500210

The analysis of relational and NoSQL databases leads to the conclusion that these data processing systems are to some extent complementary. In the current Big Data applications, especially where extensive analyses (so-called Big Analytics) are needed, it turns out that it is nontrivial to design an infrastructure involving data and software of both types. Unfortunately, the complementarity negatively influences integration possibilities of these data stores both at the data model and data processing levels. In terms of performance, it may be beneficial to use a polyglot persistence, a multimodel approach or multilevel modeling, or even to transform the SQL database schema into NoSQL and to perform data migration between the relational and NoSQL databases. Another possibility is to integrate a NoSQL database and relational database with the help of a third data model. The aim of the paper is to show these possibilities and present some new methods of designing such integrated database architectures.