Oracle: SQL Best For Big Data Analysis - InformationWeek

InformationWeek is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them.Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

IoT
IoT
Comments
Oracle: SQL Best For Big Data Analysis
Newest First  |  Oldest First  |  Threaded View
Li Tan
50%
50%
Li Tan,
User Rank: Ninja
10/4/2014 | 12:14:21 AM
Re: Our view
I concur with you. It's not so meaningful to argue if NoSQL and Hadoop are much better than traditional RDBMS and SQL. They are designed in different era and for different purposes. As IT professional, you need to be able to take the best weapon depending on your battle.
D. Henschen
50%
50%
D. Henschen,
User Rank: Author
10/3/2014 | 5:11:42 PM
Re: Our view
That's a good point on transactional vs. analytical and a distinction that didn't come up in Mendelsohn chat -- mostly because he was also talking about Hadoop, which is a high-scale platform for analytics. SQL does play as a language for transactional work, however, and I would say that Mendelsohn is correct in observing that NoSQL vendors need to mature their languages. Many have SQL-inspired languages, including Cassandra with CQL. Scalability and cost at scale are clearly problems for Oracle and other relational databases, so unless or until they can answer that calling, the coexistence of RDBMS and NoSQL is, as you say, assured.
RSCHUMACHER400
50%
50%
RSCHUMACHER400,
User Rank: Apprentice
10/3/2014 | 2:34:37 PM
Our view
Nearly all of us here at DataStax have come out of the RDBMS world, have decades of experience with Oracle and other relational engines, and as such, we certainly respect the technology. 

But the enterprises we engage with today use a combination of RDBMS and NoSQL, with the former mostly serving system of record use cases, while the latter is optimized for system of engagement applications (although NoSQL is making strong inroads into system of record apps as well). The fact is, today's Internet Enterprise applications necessitate a new database foundation that provides a more flexible data model (which goes beyond just support for unstructured data and JSON), a simpler and more cost effective performance/scale model, and an optimized data distribution model that provides both full write/read anywhere capabilities as well as always-on availability. And these are things that a NoSQL database like Cassandra was built to provide. 

Robin Schumacher

VP of Products, DataStax
D. Henschen
50%
50%
D. Henschen,
User Rank: Author
10/2/2014 | 4:45:20 PM
The other side of analytics
Mendelsohn is not Oracle's analytics guru. That's a seperate unit that's working on R-based algos and other advanced analytics working on Exadata. Another tidbit of note from Mendelsohn: SAS is working on SaaS services based on the Oracle 12c multi-tenant database.


The State of Cloud Computing - Fall 2020
The State of Cloud Computing - Fall 2020
Download this report to compare how cloud usage and spending patterns have changed in 2020, and how respondents think they'll evolve over the next two years.
Commentary
2021 Outlook: Tackling Cloud Transformation Choices
Joao-Pierre S. Ruth, Senior Writer,  1/4/2021
News
Enterprise IT Leaders Face Two Paths to AI
Jessica Davis, Senior Editor, Enterprise Apps,  12/23/2020
Slideshows
10 IT Trends to Watch for in 2021
Cynthia Harvey, Freelance Journalist, InformationWeek,  12/22/2020
Register for InformationWeek Newsletters
Video
Current Issue
2021 Top Enterprise IT Trends
We've identified the key trends that are poised to impact the IT landscape in 2021. Find out why they're important and how they will affect you.
White Papers
Slideshows
Twitter Feed
Sponsored Live Streaming Video
Everything You've Been Told About Mobility Is Wrong
Attend this video symposium with Sean Wisdom, Global Director of Mobility Solutions, and learn about how you can harness powerful new products to mobilize your business potential.
Sponsored Video
Flash Poll