Big Data Market Segment LS
Big Data Market Segment RS
Tuesday, 15 July 2014 22:02

Oracle adds SQL to Big Data


Oracle has announced SQL access to data stored in an Oracle Big Data Appliance, initially from Exadata systems, but over time from other models in its Engineered Systems family and then from Oracle Database generally.

Oracle vice president of product management Neil Mendelson told iTWire that the Oracle Big Data Appliance was introduced over two years ago "priced at the commodity side of the business" to give customers an alternative to building their own Hadoop clusters.

But Big Data Appliance owners have moved from experimentation to production systems, and that means they need to use the appliance within the framework of their other data management systems.

In most situations, organisations are using Hadoop alongside traditional data warehouses, explained principal product manager Dan McClary, but they want to avoid "the big data skills gap," creating another data silo, or running into security problems.

Big Data SQL helps address all three issues, he suggested.

SQL is widely known; Oracle Big Data SQL allows one SQL query to run across Hadoop, NoSQL and Oracle Database; and it also allows existing security policies and frameworks to be extended to Hadoop.

From a database administration, security management or reporting standpoint, "this all works just like Oracle Database," he said.

Furthermore, Big Data SQL means SQL-based business intelligence and other tools can easily access data from Hadoop and NoSQL sources.

"It's really about what you don't have to do," said Mr Mendelson. "The best solution is the simplest solution."

Page 2: "all the magic happens in the background."

The broad adoption of big data has been limited by the absence of declarative access, he said, but Oracle is providing users with the power to use SQL on data wherever it lives.

"We think this is going to be appealing to the industry at large," said Mr McClary.

To maximise performance, data remains on the source system as far as possible - for example, only the result of an SELECT statement is transferred. Applying the Smart Scan concept from Exadata to Hadoop provided "a massive improvement," he said. Data from Hadoop and NoSQL is presented as external tables.

Mr McClary gave the example of Twitter data, which can be sensibly stored in Hadoop. While it can be analysed there, the question for many organisations is "how do we bring that data to the data warehouse?" - perhaps to relate Twitter sentiment and purchases.

Big Data SQL allows this sort of rich analysis to be done via SQL - "and it all happens in a matter of nanoseconds," said Mr Mendelson. The person doing the job sees it all as local data, and "all the magic happens in the background."

More generally, it provides a way of efficiently storing new types of data (eg, storing sensor logs in Hadoop) while making sure it is accessible to enterprise users alongside traditional data sets.

You no longer need to worry about "uncurated data" - it can be stored wherever seems appropriate and without cluttering up the data warehouse, yet it can be drawn upon via SQL as necessary.

Big Data SQL will be available in the current quarter, following the release of Oracle Database 12.1.02. It will initially require Oracle Database 12c on Exadata, but will spread to other Oracle Engineered Systems and then to other systems running Oracle software.

WEBINAR event: IT Alerting Best Practices 27 MAY 2PM AEST

LogicMonitor, the cloud-based IT infrastructure monitoring and intelligence platform, is hosting an online event at 2PM on May 27th aimed at educating IT administrators, managers and leaders about IT and network alerts.

This free webinar will share best practices for setting network alerts, negating alert fatigue, optimising an alerting strategy and proactive monitoring.

The event will start at 2pm AEST. Topics will include:

- Setting alert routing and thresholds

- Avoiding alert and email overload

- Learning from missed alerts

- Managing downtime effectively

The webinar will run for approximately one hour. Recordings will be made available to anyone who registers but cannot make the live event.



Security requirements such as confidentiality, integrity and authentication have become mandatory in most industries.

Data encryption methods previously used only by military and intelligence services have become common practice in all data transfer networks across all platforms, in all industries where information is sensitive and vital (financial and government institutions, critical infrastructure, data centres, and service providers).

Get the full details on Layer-1 encryption solutions straight from PacketLight’s optical networks experts.

This white paper titled, “When 1% of the Light Equals 100% of the Information” is a must read for anyone within the fiber optics, cybersecurity or related industry sectors.

To access click Download here.


Stephen Withers

joomla visitors

Stephen Withers is one of Australia¹s most experienced IT journalists, having begun his career in the days of 8-bit 'microcomputers'. He covers the gamut from gadgets to enterprise systems. In previous lives he has been an academic, a systems programmer, an IT support manager, and an online services manager. Stephen holds an honours degree in Management Sciences and a PhD in Industrial and Business Studies.



Recent Comments