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 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.