In a keynote address at Oracle OpenWorld, Thomas Kurian, executive vice president, Product Development, Oracle, showcased Oracle Big Data SQL. “It allows you to keep data in Hadoop, in a NoSQL store, and in an Oracle Database, and be able to query across all of that data using standard SQL. It opens all the data you have in Hadoop to your users who know how to run SQL and it also lets you join data in Hadoop with your relational data from a relational system.”
Introduced earlier this year, Oracle Big Data SQL is SQL-based software that integrates data across Hadoop, NoSQL, and Oracle Database. Besides running on the Oracle Big Data Appliance, it can work in conjunction with Oracle Exadata Database Machine. By simplifying information access through industry-standard SQL, Oracle Big Data SQL enables organizations to look across all enterprise data.
In addition, he said, while today organizations must have someone write MapReduce to be able to process Hadoop data - which business users are not able to do - Oracle is "introducing a brand-new product, Oracle Big Data Discovery. It’s a visual face to Hadoop. It allows you to go to a browser, profile the data, explore the data, analyze the data, and do prediction and correlation,” he said.
Oracle, Kurian said, has taken both of these capabilities, the Big Data SQL and the optimizations for performance with query offloading and made it available on the Oracle Big Data Appliance.
Oracle has also made the In-Memory Database, and the Oracle Business Intelligence Suite which offers newly announced capabilities - such as a new interface that enables users to mashup personal data and business data and analyze it visually for patterns to enhance for sales and marketing efforts - available on Oracle Exalytics.
For customers that have departmental users, Kurian said, Oracle is also offering both of these in the Oracle Cloud as an analytics cloud offering. “So if you are a departmental user and you want to build a data mart and do some data analysis, you can simply go to cloud.oracle.com, access Oracle Database, either 11 or 12, and access Oracle BI and you can do the same with our Hadoop and Big Data Discovery tools,” he said.
Oracle has used the same technology to offer prepackaged analytics from all of its SaaS applications and today 2 million users use Oracle’s Analytics Cloud to do analytics from Oracle’s Service offering, Sales, Marketing, HR, and ERP offerings, Kurian noted.
Kurian also showcased advancements for mobility such as a Mobile Application Framework that enables developers to use one codebase optimized for both Android and iOS, a Mobile Cloud Service, single sign-on for users across web apps and mobile apps, and security containers to ensure that corporate data cannot be lost on mobile devices. "We have used these extensions to build mobile application extensions for PeopleSoft, E-Business Suite, Hyperion, and for all of our new applications - JD Edwards, etc.," said Kurian. "The value that we offer customers is an end to end mobile development platform and it is the same technology used by our own packaged apps."