Month: April 2018

Using Materialized Views with Big Data SQL to Accelerate Performance

One of Big Data SQL’s key benefits is that it leverages the great performance capabilities of Oracle Database 12c. I thought it would be interesting to illustrate an example – and in this case we’ll review a performance optimization that has been around for quite a while and is used at thousands of customers: Materialized … Continue reading Using Materialized Views with Big Data SQL to Accelerate Performance

Export from Hadoop File System to a SQL Server Database Table

Problem I need to export data from the Hadoop Distributed File System (HDFS) to a SQL Server database table. How can I do this? Solution Apache's Sqoop allows for importing data from a database such as SQL Server to the HDFS, and for exporting data from the HDFS to a database table. In this tip … Continue reading Export from Hadoop File System to a SQL Server Database Table

What are the advantages of Big Data Analytics?

There are many advantages of processing Big Data Analytics in real-time. Knowing errors instantly within the organisation. Implementing new strategies To improve service dramatically Fraud can be detected the moment it happens Cost savings Better sales insights Keep up the customer trends The advantages of processing Big Data in real-time are many: Errors within the … Continue reading What are the advantages of Big Data Analytics?

What is the advantages of Hadoop and Big data?

Big data means the huge amount of data which is beyond the processing capability of traditional data management system to manage and analyse the data in a specified time span.Big Data comes from many sources, some of them are digital media,online transaction records, cellphone signals etc. Hadoop has its own advantage,and In order to overcome … Continue reading What is the advantages of Hadoop and Big data?