Oracle finally unveiled its Oracle Database In Memory Option to the public Tuesday morning during an Oracle press event at the company’s campus, with CEO Larry Ellison announcing that the product will be available in July. Working as an add-on to the Oracle 12c database, the new option will supposedly boost performance of real-time analytics and transactional workloads.
In today’s world of connected devices and artificial intelligence, it’s more important for organizations to process all their accumulated data in real time as fast as possible.
That’s where Oracle’s In Memory Option software comes into play. Ellison said users can expect real-time analytics queries 100 times faster and online transaction processing that is two times faster as long as they are using hardware that supports the Oracle 12c database.
Ellison stressed how easy it is to use the In Memory Option: “Install the new software, throw a switch, and everything runs faster.”
The In Memory Option allows users to mix and manage their data across dynamic random-access memory (DRAM), PCI Flash and disk storage, with the most important information hosted in DRAM for instant access.
“Tell us specifically what tables or portions you want cached in memory,” Ellison said. “You’re done. That’s it. Nothing else. I really mean minutes.”
Additionally, the software will allow people to store data in both columns (used for analytics) and rows (used for transactions) as opposed to only one method; Ellison described this function as being “the magic of Oracle.”
Of course, Oracle is not alone in real-time analytics. SAP’s HANA offers a similar function, as does database startup MemSQL, which launched a columnar store that operates on flash storage in February.