Integration of Relational and NoSQL Databases

Abstract

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.

Cloud computing: google firebase firestore optimization analysis

“…This finding is similar to the proposed NoSql data modeling by [28]- [30]. The finding and suggestions from [31], [32] also related to this study's finding that a specific NoSql database requires detailed analysis for the performance and consistent access operations. Calculating aggregation data on the client or cloud function before sending it to the database performs better in cost efficiency, response time, and response size.…”

Ten simple rules for managing laboratory information

“…In the age of big data applications enabled by cloud computing infrastructures, there are more ways than ever to organize data. Today, NoSQL (not only SQL) databases [43][44][45], data lakes [46][47][48], and data warehouses [49,50] provide additional avenues to manage complex sets of data that may be difficult to manage in relational databases (Table 1). All these data management frameworks make it possible to query and analyze data, depending on the size, type, and structure of your data as well as your analysis goals.…”

Database development, design and trending tools

“…It processes information available for multiple virtual servers around the globe. NoSQL databases are alternative databases for storage and processing the so-called Big Data today [26] .…”