Next Article in Journal
The Eminence of Co-Expressed Ties in Schizophrenia Network Communities
Previous Article in Journal
Earth Observation Open Science: Enhancing Reproducible Science Using Data Cubes

Transformation of Schema from Relational Database (RDB) to NoSQL Databases

Department of Computer Science, College of Science and Arts, Sajir Campus, Shaqra University, Sajir City 11951, Saudi Arabia
Department of Computer Science and Information Technology, School of Engineering and Mathematical Sciences, Melbourne Campus, La Trobe University, Victoria 3086, Australia
Author to whom correspondence should be addressed.
Data 2019, 4(4), 148;
Received: 28 October 2019 / Revised: 20 November 2019 / Accepted: 25 November 2019 / Published: 27 November 2019
Relational database has been the de-facto database choice in most IT applications. In the last decade there has been increasing demand for applications that have to deal with massive and un-normalized data. To satisfy the demand, there is a big shift to use more relaxed databases in the form of NoSQL databases. Alongside with this shift, there is a need to have a structured methodology to transform existing data in relational database (RDB) to NoSQL database. The transformation from RDB to NoSQL database has become more challenging because there is no current standard on NoSQL database. The aim of this paper is to propose transformation rules of RDB Schema to various NoSQL database schema, namely document-based, column-based and graph-based databases. The rules are applied based on the type of relationships that can appear in data within a database. As a proof of concept, we apply the rules into a case study using three NoSQL databases, namely MongoDB, Cassandra, and Neo4j. A set of queries is run in these databases to demonstrate the correctness of the transformation results. In addition, the completeness of our transformation rules are compared against existing work. View Full-Text
Keywords: relational database; NoSQL databases; transformation rules relational database; NoSQL databases; transformation rules
Show Figures

Figure 1

MDPI and ACS Style

Alotaibi, O.; Pardede, E. Transformation of Schema from Relational Database (RDB) to NoSQL Databases. Data 2019, 4, 148.

AMA Style

Alotaibi O, Pardede E. Transformation of Schema from Relational Database (RDB) to NoSQL Databases. Data. 2019; 4(4):148.

Chicago/Turabian Style

Alotaibi, Obaid, and Eric Pardede. 2019. "Transformation of Schema from Relational Database (RDB) to NoSQL Databases" Data 4, no. 4: 148.

Find Other Styles
Note that from the first issue of 2016, MDPI journals use article numbers instead of page numbers. See further details here.

Article Access Map by Country/Region

Back to TopTop