About DJPS    Editorial Board    Advisory Board    Secretary of Journal    Events & News         



Diyala Journal For Pure Science

Scientific Refereed Journal Published By College of Science - University of Diyala


Admin of Website


Diyala Journal For Pure Sciences DJPS

ISRA Impact Factor:3.715

P- ISSN:2222-8373, E-ISSN:2518-9255

Volume 14, Issue 4 , October . 2018



Secured Data Conversion, Migration, Processing and Retrieval between SQL Database and NoSQL Big Data


Alaa Khalil Jumaa

Year: 2018, Volume: 14, Issue: 4


Pages:  66-87 , DOI: http://dx.doi.org/10.24237/djps.1404.449A


Language: English


Download :  




Data collection is presently managed by using classic relational database systems like SQL, MySQL and Oracle. In recent years, data collection has grown up, and it has become more complex than conventional Relational Database Management System (RDBMS); which are incompetent to deal with it. To handle this problem, organizations and large companies like Google, Facebook, Yahoo and others bring up with new data management technique called NoSQL database; which is designed for a large-scale data storage and analysis. In this paper, a new technique is presented and used to convert SQL to NoSQL database, and also it can migrate, process and retrieve data between them. Because of the NoSQL database (Big Data), it sometimes needs to store in an untrusted or semi-trusted third party, the proposed system allow users to protect their database by encrypting database sensitive attributes before performing conversion and migration processes. Furthermore, the proposed system gives users the ability for retrieving NoSQL data from Big Data storage just like retrieve SQL data; that means users can write a SQL query to retrieve NoSQL data. The proposed system used Apache HBase for NoSQL Big Data storage and Apache Sqoop and Hive for data conversion, migration, processing and retrieving processes. The implementation and results of the proposed system are showed the ability of converting, migrating, processing and retrieving data with high efficiency and good performance.


Keywords: NoSQL database, BigData, Data Migration, Sensitive Attributes.

Copyright © 2017 Diyala Journal For Pure Science (DJPS) . All rights reserved