Paul Krill
Editor at Large

Oracle works both sides of the SQL/NoSQL street

analysis
Aug 21, 20143 mins

While continuing to push SQL, Oracle makes accommodations for newer technologies, including NoSQL and JSON

It’s no secret that Oracle became very successful by selling relational database technology anchored by the venerable SQL standard. These days, SQL is being pushed out of the limelight by concepts like NoSQL, which is not confined by the rows and tables paradigm of the RDBMS. Oracle, however, is stepping up its strategy of staying current by accommodating new data management concepts like JSON while continuing to push its legacy SQL technology.

Speaking at the NoSQL Now conference in San Jose, Calif., on Wednesday, Oracle’s Andrew Mendelsohn, executive vice president for database server technologies, started out by emphasizing that relational database technology is still strong after 40 years. SQL and relational databases built a huge ecosystem by providing a standard language that is pretty much the same between providers and works for software vendors and developers, Mendelsohn explained. “If you wrote a SQL application back in the ’80s or the ’90s, that SQL application continues to work as we move through all these different computing generations.”

Then Mendelsohn outlined Oracle’s list of accommodations for multiple types of unstructured data beyond the relational realm. With Oracle Database 12c, Oracle is handling JSON, text, XML, spatial, graph, and multimedia data. JSON capabilities were featured in the 12.0.1.2 release of the database, which arrived last month. “You can store JSON documents in columns of an Oracle database,” with the columns schema-less, Mendelsohn said. JSON is considered a lightweight alternative to XML and the data structure of the Web.

Additionally, Oracle has made accommodations for both Hadoop and NoSQL. Oracle announced its Oracle NoSQL database a year ago and is pledging innovations across NoSQL, Hadoop, and relational technologies. The company also is playing in the big data hardware space, with its Oracle Big Data Appliance, engineered for NoSQL and Hadoop.

Later this year, Oracle will release a driver for Node.js, for server-side JavaScript, Mendelsohn said. Last month, Oracle unveiled Big Data SQL, a tool that can run a SQL query against Oracle’s data store, as well as Hadoop and NoSQL stores. The software is an option for the Big Data Appliance.

Oracle’s don’t-sweat-it-we’ll-be-there-too attitude about new technologies that encroach on Oracle’s venerable SQL database has been in force for years now. Several years ago, the open source MySQL database was considered a formidable threat to Oracle’s commercial RDBMS, but it worked out for Oracle after Sun Microsystems acquired MySQL in 2008 and Oracle, in turn, acquired Sun two years later.

This story, “Oracle works both sides of the SQL/NoSQL street,” was originally published at InfoWorld.com. Get the first word on what the important tech news really means with the InfoWorld Tech Watch blog. For the latest developments in business technology news, follow InfoWorld.com on Twitter.

Paul Krill

Paul Krill is editor at large at InfoWorld. Paul has been covering computer technology as a news and feature reporter for more than 35 years, including 30 years at InfoWorld. He has specialized in coverage of software development tools and technologies since the 1990s, and he continues to lead InfoWorld’s news coverage of software development platforms including Java and .NET and programming languages including JavaScript, TypeScript, PHP, Python, Ruby, Rust, and Go. Long trusted as a reporter who prioritizes accuracy, integrity, and the best interests of readers, Paul is sought out by technology companies and industry organizations who want to reach InfoWorld’s audience of software developers and other information technology professionals. Paul has won a “Best Technology News Coverage” award from IDG.

More from this author