Oracle Database 12c uses DRAM and flash storage technology to speed up queries and reporting times
Oracle Corp. officially released its Oracle Database 12c today and with it the software giant aims to create a real-time database management system for enterprise organizations.
That was the singular message from CEO Larry Ellison during the launch event in San Francisco. Since Oracle Database 12c will take advantage of DRAM and flash storage technology, Ellison said enterprises now have to think differently and therefore need to operate their business differently.
“If you can get the answers to business questions quickly, you will ask (business-related) questions more frequently,” he said.
For example, an automaker that Ellison would not name used to run its parts of materials program to process orders in 58 hours; with 12c it took just 13 minutes. Another test showed 290 million ledger lines from 250 business units being processed in 4.3 hours. With 12c, Ellison said it took just 11 seconds.
“The numbers are stunning,” he said.
Oracle Database 12c is an in-memory database that can be optimized across applications, middleware, databases and systems. Another aspect of 12c is that it will work on Infiniband network technology, which is faster than Ethernet. Oracle Database 12c will run most data in-memory and that can be accessed instantly.
According to Ellison, the goal of in-memory databases is to increase the speed of queries and reporting by three times. But what sets 12c apart is how it processes transactions. Oracle customers provided feedback to the company that most of its transactions are made inside the database. To increase the speed of those transactions was deemed to be an impossible task without trade-offs.
“Customers do transactions on databases. Not having that ability in 12c was not an option,” Ellison added.
But what Ellison and the team at Oracle wanted to do was enable this speed by customers essentially flipping a switch. The company did not want customers re-writing applications for in-memory use.
The dilemma with this is that there are two database formats:, rows and columns and analytical. Oracle Database 12c can store data both ways.
Oracle engineered server systems such as Exadata have been optimized for the 12c in-memory database. Ellison provided a cost break down on this platform where the most recent vital data will be on DRAM, active data on flash and cold data or archival data loaded onto disk. Exadata with 12c is able to prioritize the data on these levels so that not all data is run in-memory.
Oracle’s M6 Exabyte machine can scan billions of rows per second using single instructions processing where a dozen pieces of data is viewed as one item. Ellison said that this technology either Sparc or Intel based was used mainly in scientific applications until now.
“With 32 TB processors you have 400 cores and that can process a lot of rows. I think a trillion rows, which sounds impossible,” he said.
Ellison said that for years column databases were “terrible” for transactions and could also be costly because of complex OLTP and indexes. Since 12c is a dual purpose database for analytics and queries sometimes 20 or more indexes needed to be updated.
“You are now going to have to throw all those queries and process away. We dropped the analytics indexes. That’s the magic,” he said.
12c will also have in-memory fault tolerance on Oracle Engineered Systems such as Exadata. It will duplicate in-memory data across nodes enabling queries to use a copy of in-memory data if a server fails. New Direct-to-Wire Infiniband accelerates scale-out for in-memory.
Oracle’s in-memory database will work with its E-Business Suite, JD Edwards, PeopleSoft, Siebel, and Fusion Applications.
It will be made available next month.Related Download
Sponsor: IBM Canada Ltd
Increasing Profitability with Analytics in Midsize Companies
Complete with several mini-case studies, this Nucleus Research Note dispels the misperceptions surrounding Analytics, revealing how small and midsize companies have cost-effectively implemented and deployed Analytics solutions and gained benefits.