scispace - formally typeset
Proceedings ArticleDOI

A Framework to Convert NoSQL to Relational Model

Reads0
Chats0
TLDR
A generic framework is proposed in this paper so that different NoSQL databases could be converted to RDBMS, and a case study on MongoDB and Neo4j proves robustness of the proposed mechanism.
Abstract
Due to the exponential growth of NoSQL databases and in addition the circumstance of perusing humongous volumes of information, maximum applications switch RDBMS to NoSQL and pick it as information stockpiling framework. But we all know that RDBMS have several advantages which make it a popular platform across several applications over the decades. Therefore we view the standard problem of converting the RDBMS to NoSQL in reverse approach and we conceptualize a problem where NoSQL is converted back to a RDBMS based system. A generic framework is proposed in this paper so that different NoSQL databases could be converted to RDBMS. This approach is illustrated here using a case study on MongoDB and Neo4j. MongoDB is a document oriented database, fully unstructured and schemaless whereas Neo4j is a graph oriented database, fully unstructured and schemaless. This proves robustness of our proposed mechanism.

read more

Citations
More filters
Proceedings ArticleDOI

Model Driven Extraction of NoSQL Databases Schema: Case of MongoDB

TL;DR: This paper proposes an automatic approach for extracting a physical model starting from a document-oriented NoSQL database, including links between different collections, using the Eclipse Modeling Framework environment.
Journal ArticleDOI

Automatic NoSQL to Relational Database Transformation with Dynamic Schema Mapping

TL;DR: This paper proposed and evaluated an efficient method to transform a NoSQL database into a relational database automatically and observed excellent performance, compared to the existing state-of-the-art methods.
Posted Content

Storage Solutions for Big Data Systems: A Qualitative Study and Comparison

TL;DR: In this article, a feature analysis of 80 NoSQL solutions has been provided, elaborating on the criteria and points that a developer must consider while making a possible choice, and comparing the advantages, shortcomings and possible use cases of available big data file formats for Hadoop.
Posted Content

Bivariate, Cluster and Suitability Analysis of NoSQL Solutions for Different Application Areas.

TL;DR: A feature analysis of 80 NoSQL solutions is presented, elaborating on the criteria and points that a developer must consider while making a possible choice, to determine the suitability of a NoSQL solution for an application area.
Book ChapterDOI

Reverse Engineering Approach for NoSQL Databases

TL;DR: This paper aims to achieve a reverse engineering of NoSQL databases in order to provide an element of semantic knowledge close to human understanding and provides experiments of this approach using a case study taken from the medical field.
References
More filters
Proceedings ArticleDOI

Comparison of SQL, NoSQL and NewSQL databases for internet of things

TL;DR: This paper compares the performance of three databases each from the said technologies; SQL (MySQL), NoSQL (MongoDB) and NewSQL (VoltDB) respectively for sensor readings and tested against single write, single read, single delete and multi write operations.
Proceedings ArticleDOI

Big-data NoSQL databases: A comparison and analysis of “Big-Table”, “DynamoDB”, and “Cassandra”

TL;DR: The study concluded that Google's BigTable and Amazon's DynamoDB are also critical and efficient on their own, and found that the combination of both systems had caused the development of Cassandra, which is the basis of various modern applications available both open source and socially.
Proceedings ArticleDOI

Model driven reverse engineering of NoSQL property graph databases: The case of Neo4j

TL;DR: This paper seeks to present and illustrate an MDA-based approach, allowing to achieve a reverse engineering of NoSQL property graph databases into an Extended Entity-Relationship schema and presents an illustrative scenario and evaluates the reverse engineering approach.
Proceedings ArticleDOI

Security analysis of unstructured data in NOSQL MongoDB database

TL;DR: This paper uses symmetric cryptographic techniques for providing the security (confidentiality) of unstructured data in NoSQL document stored MongoDB and uses a zlib compression technique to reduce the storage size taken by the encrypted data and provides comparative results.
Proceedings ArticleDOI

Transformation of SQL system to NoSQL system and performing data analytics using SVM

TL;DR: To promote Hybrid Database architecture including a Relational Database and NoSQL Database, a Data Adapter system is proposed that can deal with database transformations using a data synchronization mechanism and deliver strict consistency without affecting scalability and availability of NoSQL Databases.