Oracle Announces Database Option for Online Transaction Processing

Discovering meaningful insight from a mountain of information is the core Big Data challenge, says Oracle Corporation. In provision of solution to the challenge, Oracle said that its new Database In-Memory Option to Oracle Database 12c dramatically accelerates database performance enabling new business insights, real-time decision making, and much faster online transaction processing response times without changes to existing applications.

Using the Oracle Database In-Memory Option, decades of IT investments become immediately more valuable.

Oracle on Thursday announced the Oracle Database In-Memory option to help customers accelerate database performance for analytics, data warehousing, reporting and online transaction processing (OLTP). Oracle’s unique in-memory optimizations enable real-time ad-hoc analytics on live transactional data while also accelerating OLTP.

Every application that runs on Oracle Database 12c can automatically and transparently take advantage of Oracle Database In-Memory Option. Existing applications will retain full functionality while experiencing effortless speedups. New applications can be developed that were previously impractical due to performance limitations.

According to Andrew Mendelsohn, senior vice president, Oracle Database Development, “All of Oracle Database’s leading reliability, scalability, availability and security technologies work transparently with Oracle Database In-Memory Option, bringing Oracle’s mature technologies developed over decades of joint work with thousands of leading banks, telecoms and e-commerce sites to in-memory computing.

“Oracle’s unique “dual-format” approach enables real-time ad-hoc analytics on live transactional data while also accelerating OLTP. Data is maintained in both the existing Oracle row format, and a new purely in-memory column format optimized for analytical processing. Both formats are simultaneously active and transactionally consistent. The Oracle database automatically uses the new in-memory column format for analytic queries and the existing row format for OLTP operations.

The new in-memory columnar format eliminates the need for expensive to maintain analytic indexes and therefore greatly accelerates OLTP operations.

Oracle Database In-Memory Option simplifies development and management and lowers costs by eliminating the need for separate databases and data structures that have traditionally been required to achieve good analytic performance.

“Organizations that make data-driven decisions have a distinct competitive advantage,” Mendelsohn, continued, “The Oracle Database In-Memory Option will enable near instant analysis of data in existing applications allowing users to make better decisions faster and with complete confidence.”