IMPLEMENTATION OF UNIFIED QUERY FOR BIG DATABASE USING SQL ON ORACLE PLATFORM

Author: 
Rashmi Shrivastava ., Gaurav Kumar Saxena and Kailash Patidar
Country: 
India
Abstract: 

Today data have sprout from petabytes(10 15 bytes) to zettabytes ( 10 21 bytes ) Day-by-day the increment in technologies all over the world is leading to an increase in information exchange and the challenges of data processing. The information, ofte n called as “data”, is integrated with the help of different tools and softwa re. Data integrating is the process of transferring the data from one format (also referred as “source format”) to another format(also referred as “destination format”) A very large amount of data, also referred as “big data”, is always followed by the p roblem of transferring the data. ETL  (Extract, Transform and load) Tools are the best options to manage the data transfer. In ETL three database functions are combined in a single tool using the process called “data warehousing”. Data warehouse transforms all data formats into a single format for the purpose of data transfer. Sometimes, date warehouse is achieved by manually coded integration programs using java, map reduce, SQL, Hadoop, or any other software language. Since the data is generally generated from different sources like social networking sites, web servers, e-mails, web browsers etc. so they are in comparatively unstructured form. To solve the problem of unstructured data transfer using single software tool the market organizations are always i n need of an efficient solution using the various technologies to handle the big data.

KeyWords: 

Big Data, Data integration, Data warehouse, ETL Tool, SQL.

Volume & Issue: 
Vol. 3, Issue 03
Pages: 
616-621
Download PDF: