Automatic NoSQL to Relational Database Transformation with Dynamic Schema Mapping
Joint Authors
Aftab, Zain
Iqbal, Waheed
Almustafa, Khaled Mohamad
Bukhari, Faisal
Abdullah, Muhammad
Source
Issue
Vol. 2020, Issue 2020 (31 Dec. 2020), pp.1-13, 13 p.
Publisher
Hindawi Publishing Corporation
Publication Date
2020-07-01
Country of Publication
Egypt
No. of Pages
13
Main Subjects
Abstract EN
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 database.
American Psychological Association (APA)
Aftab, Zain& Iqbal, Waheed& Almustafa, Khaled Mohamad& Bukhari, Faisal& Abdullah, Muhammad. 2020. Automatic NoSQL to Relational Database Transformation with Dynamic Schema Mapping. Scientific Programming،Vol. 2020, no. 2020, pp.1-13.
https://search.emarefa.net/detail/BIM-1209148
Modern Language Association (MLA)
Aftab, Zain…[et al.]. Automatic NoSQL to Relational Database Transformation with Dynamic Schema Mapping. Scientific Programming No. 2020 (2020), pp.1-13.
https://search.emarefa.net/detail/BIM-1209148
American Medical Association (AMA)
Aftab, Zain& Iqbal, Waheed& Almustafa, Khaled Mohamad& Bukhari, Faisal& Abdullah, Muhammad. Automatic NoSQL to Relational Database Transformation with Dynamic Schema Mapping. Scientific Programming. 2020. Vol. 2020, no. 2020, pp.1-13.
https://search.emarefa.net/detail/BIM-1209148
Data Type
Journal Articles
Language
English
Notes
Includes bibliographical references
Record ID
BIM-1209148