Automatic NoSQL to Relational Database Transformation with Dynamic Schema Mapping
Reads0
Chats0
TLDR
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.Abstract:
Recently, the use of NoSQL databases has grown to manage unstructured data for applications to ensure performance and scalability However, many organizations prefer to transfer data from an operational NoSQL database to a SQL-based relational database for using existing tools for business intelligence, analytics, decision making, and reporting The existing methods of NoSQL to relational database transformation require manual schema mapping, which requires domain expertise and consumes noticeable time Therefore, an efficient and automatic method is needed to transform an unstructured NoSQL database into a structured database In this paper, we proposed and evaluated an efficient method to transform a NoSQL database into a relational database automatically In our experimental evaluation, we used MongoDB as a NoSQL database, and MySQL and PostgreSQL as relational databases to perform transformation tasks for different dataset sizes We observed excellent performance, compared to the existing state-of-the-art methods, in transforming data from a NoSQL database into a relational databaseread more
Citations
More filters
Journal ArticleDOI
An Innovative Model for Extracting OLAP Cubes from NOSQL Database Based on Scalable Naïve Bayes Classifier
TL;DR: This article presents a model for extracting OLAP cubes from a document-oriented NOSQL database based on the Naïve Bayes classifier (NBC) and the MapReduce (MR) programming model, which is appropriate and suitable for large-scale data sets.
Proceedings ArticleDOI
Extraction Process of the Logical Schema of a Document-oriented NoSQL Database
TL;DR: In this paper , the authors propose an automatic process to extract the logical schema of document-oriented NoSQL DBs based on the MDA architecture, which allows to express rich data structures and a diversity of links between data: association, composition and inheritance links.
Proceedings ArticleDOI
Transforming NoSQL Database to Relational Database: An Algorithmic Approach
TL;DR: In this article , the authors proposed an algorithm to convert NoSQL databases to relational databases, i.e., conversion of MongoDB databases to MySQL databases, and they used five datasets taken from GitHub, namely mobile accessories, bookstore, university database, restaurants and ecommerce store.
Proceedings ArticleDOI
Enola: Jogo sério para ensino de SQL
TL;DR: In this article , an artefato of a jogo sério that constrói narrativas randômicas a serem investigated in a Banco de Dados utilizing consultas SQL is presented.
Journal ArticleDOI
Extraction of Semantic Links from a Document-Oriented NoSQL Database
TL;DR: Abdelhedi et al. as mentioned in this paper proposed a logical schema extraction process for a document-oriented NoSQL DB to address the needs of a medical application, and they extended this process to additional relationship types.
References
More filters
Proceedings ArticleDOI
Survey on NoSQL database
TL;DR: The background, basic characteristics, data model of NoSQL, and the mainstream NoSQL databases are separately described in detail, and some properties are extracted to help enterprises to choose NoSQL.
Journal ArticleDOI
CAP twelve years later: How the "rules" have changed
TL;DR: The featured Web extra is a podcast from Software Engineering Radio, in which the host interviews Dwight Merriman about the emerging NoSQL movement, the three types of nonrelational data stores, Brewer's CAP theorem, and much more.
Journal ArticleDOI
Will NoSQL Databases Live Up to Their Promise
TL;DR: Issues such as limitations, advantages, concerns and doubts regarding NoSQL databases are discussed.
Journal ArticleDOI
SQL databases v. NoSQL databases
TL;DR: Michael Stonebraker considers several performance arguments in favor of NoSQL databases---and finds them insufficient.
Proceedings ArticleDOI
Conceptual modeling for ETL processes
TL;DR: The proposed conceptual model is customized for the tracing of inter-attribute relationships and the respective ETL activities in the early stages of a data warehouse project and constructed in a customizable and extensible manner, so that the designer can enrich it with his own re-occurring patterns forETL activities.