Break New Ground
- July 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.
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.
And watch for the download that will be available later this quarter on the OTN Database Community page.
Ciao for Now!
LKR