SQL to NoSQL transformation system using data adapter and analytics

Popularity of bigdata in cloud computing is growing tremendously nowadays. Data production rate has become explosive. Many existing systems need to enlarge their service to sustenance explosive data generation rate. NoSQL database are suitable to handle large volume of data. This paper focuses on a...

Full description

Saved in:
Bibliographic Details
Published in:2017 IEEE International Conference on Technological Innovations in Communication, Control and Automation (TICCA) pp. 59 - 63
Main Authors: Solanke, Ganesh B., Rajeswari, K.
Format: Conference Proceeding
Language:English
Published: IEEE 01.04.2017
Subjects:
Big Data
Bigdata
Data adapter
Data analytics
Hybrid database
NoSQL
NoSQL databases
Relational databases
Structured Query Language
Synchronization
Online Access:Get full text
Tags: Add Tag
No Tags, Be the first to tag this record!
Description
Summary:Popularity of bigdata in cloud computing is growing tremendously nowadays. Data production rate has become explosive. Many existing systems need to enlarge their service to sustenance explosive data generation rate. NoSQL database are suitable to handle large volume of data. This paper focuses on a data adapter which provides support for hybrid database systems, NoSQL as well as relational databases. Also, a seamless mechanism is provided for hybrid database system construction, which enables access to both databases at same time. This paper focuses on the automatic transformation of hybrid systems with multiple structured data. Hybrid database systems provide access to either relational or NoSQL database, per data size. The proposed data adapter supports application queries and database transformation at same time, which in turn speed up the process. Three different approaches are proposed for queries on database. Blocking transformation mode, blocking truncation mode, direct access mode. This paper also discusses the integration of Pentaho business analytics tool with proposed data adapter for big data predictive analytics. This integration focuses on empowering users to prepare, model and visualize and explore data sets stored in NoSQL databases. This paper describes the design of data adapter in detail.
DOI:10.1109/TICCA.2017.8344580