Abstract:Context: The efficient processing of Big Data is a challenging task for SQL and NoSQL Databases, where competent software architecture plays a vital role. The SQL Databases are designed for structuring data and supporting vertical scalability. In contrast, horizontal scalability is backed by NoSQL Databases and can process sizeable unstructured Data efficiently. One can choose the right paradigm according to the organisation's needs; however, making the correct choice can often be challenging. The SQL and NoSQL Databases follow different architectures. Also, the mixed model is followed by each category of NoSQL Databases. Hence, data movement becomes difficult for cloud consumers across multiple cloud service providers (CSPs). In addition, each cloud platform IaaS, PaaS, SaaS, and DBaaS also monitors various paradigms. Objective: This systematic literature review (SLR) aims to study the related articles associated with SQL and NoSQL Database software architectures and tackle data portability and Interoperability among various cloud platforms. State of the art presented many performance comparison studies of SQL and NoSQL Databases by observing scaling, performance, availability, consistency and sharding characteristics. According to the research studies, NoSQL Database designed structures can be the right choice for big data analytics, while SQL Databases are suitable for OLTP Databases. The researcher proposes numerous approaches associated with data movement in the cloud. Platform-based APIs are developed, which makes users' data movement difficult. Therefore, data portability and Interoperability issues are noticed during data movement across multiple CSPs. To minimize developer efforts and Interoperability, Unified APIs are demanded to make data movement relatively more accessible among various cloud platforms.

Automatic NoSQL to Relational Database Transformation with Dynamic Schema Mapping

From Relational Databases to NoSQL Databases: Performance Evaluation

Model Transformation and Data Migration from Relational Database to MongoDB.

A Survey on Mapping Semi-Structured Data and Graph Data to Relational Data

Relational Databases Ingestion into a NoSQL Data Warehouse

Schema design advisor model for RDBMS to NoSQL database migration

Comparative Study Between the MySQL Relational Database and the MongoDB NoSQL Database

An Efficient Method to Build a Standard Data Entry System by Extracting OLAP Cubes from NoSQL Data Sources

DLToDW: Transferring Relational and NoSQL Databases from a Data Lake

NoSQL Database: New Era of Databases for Big data Analytics - Classification, Characteristics and Comparison

Evaluating NoSQL Databases for OLAP Workloads: A Benchmarking Study of MongoDB, Redis, Kudu and ArangoDB

Utilizing a NoSQL Data Store for Scalable Log Analysis

A comparative study: MongoDB vs. MySQL

Incremental extraction of a NoSQL database model using an MDA-based process

SQL and NoSQL Databases Software architectures performance analysis and assessments -- A Systematic Literature review

Big Data, Big Decisions Choosing the Right Database

A Cloud-based Service for Real-Time Performance Evaluation of NoSQL Databases

Performance analysis of NoSQL and relational databases with MongoDB and MySQL

An Analysis of the Performance and Configuration Features of MySQL Document Store and Elasticsearch as an Alternative Backend in a Data Replication Solution

Can the Elephants Handle the NoSQL Onslaught?

The Data Allocation Strategy Based on Load in NoSQL Database