Tuesday Jul 15, 2014

Oracle Big Data SQL - Bringing Structured Queries to an Unstructured World

Oracle has just launched Oracle Big Data SQL.  Watch the replay of the web launch here.

Oracle Big Data SQL

And it's interesting.  Big Data is unstructured. It's widely varied. And it "sits" in many places. Stovepipes. Caves. Vaults. And thanks to innovations from the Exadata technologies, this unstructured data can now be successfully and efficiently queried using Structured Query Language. (SQL)  That is to say: An approach to providing unified query over data in Oracle Database, Hadoop and select NoSQL datastores.  It's a step beyond "federated" query.  It's actually much more than that. 

It's the ability to run SQL queries that work seamlessly across multiple datastores. As Dan McClary points out in his blog on today's announcement, "Ideally, in a Big Data world, SQL should "play data where it lies," using the declarative power of the language to provide answers from all data."

All data? or just the relevant data?  Oracle Big Data SQL decided to go for Relevant Data by empowering very complex SQL statements that zero in on the relevant information across all these datastores to get a more valuable set of data that clearly pinpoints trends to analyze.

How? Unifying Metadata and Optimizing Performance.  

Dan McClary's blog gives an excellent overview.

Get more information.


And watch for the download that will be available later this quarter on the OTN Database Community page.

Ciao for Now!

LKR 

About

The OTN DBA/DEV Watercooler is your official source of news covering Oracle Database technology topics and community activities from throughout the OTN Database and Developer Community. Find tips and in-depth technology information you need to master Oracle Database Administration or Application Development here. This Blog is compiled by @oracledbdev, the Oracle Database Community Manager for OTN, and features insights, tech tips and news from throughout the OTN Database Community.

Search

Archives
« April 2015
SunMonTueWedThuFriSat
   
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
  
       
Today