All the latest UK technology news, reviews and analysis


Oracle aims at SAP HANA with in-memory support for Oracle Database 12c

10 Jun 2014
Oracle OpenWorld 2012

Oracle has officially launched its promised in-memory option for the firm's Oracle Database 12c software, a capability that promises to dramatically speed up the processing of specific workloads.

Key for customers is that this has been integrated transparently, enabling existing workloads and applications that use Oracle Database 12c to take advantage of it, Oracle claims.

The in-memory option for Oracle's flagship Database 12c platform was first disclosed at the Oracle OpenWorld show in San Francisco last year. However, while the firm is officially announcing the technology today, the feature will actually be available as part of release 12.1.0.2 of Oracle Database 12c, due to ship within 60 days.

Oracle is pitching the fact that having in-memory capability integrated with its existing database is a key differentiator, especially against SAP's rival HANA platform, because it offers compatibility with current applications along with existing features for robustness and to guarantee transactional integrity.

"It is completely transparent to implement for existing applications that work with the Oracle database. This is different from all the other [in-memory] offerings in the market today that either require changes to applications or limit functionality to a subset of full database functionality," said Tim Shetler, vice president of product management at Oracle.

Singling out SAP HANA, Shetler said that it is effectively an in-memory data store that is very fast, "but they are still trying to complete the rest of the database functionality around it," he claimed.

"With Oracle, all of the features of the database are available, all of the applications that exist today, including third-party applications, custom-written applications, they will all work out of the box with the Oracle Database In-Memory option, so we think that's really huge benefit to enabling companies to become real-time enterprises," he added.

Another area where Oracle claims an advantage is in the size of the database that can be used with its in-memory technology. Users can allocate a region of memory to hold the database and specify which data they want to go into that region, whether this is an entire table, a portion of a table, or a subset of the columns in a table.

"It's very typical for an analytics application to only look at a small number of columns. A report might have only 10 data items out of a table that might have 500 columns, so it's important to conserve space to be able to identify precisely just the data that needs to be in memory, and we give you the ability to do that," Shetler said.

The in-memory option also works with Oracle's Real Application Clusters (RAC) feature, which allows a single database to be spread across multiple servers, enabling a much larger data set to be accommodated.

On Oracle's Exadata systems, the in-memory option allows the data to be spread across memory, flash and disk and transparently accessed, according to Oracle, so once more the entire data set does not have to be present in memory at the same time.

Oracle said many of its application teams have been working to incorporate the in-memory option into their software, and from its experience, it believes developers will see a performance boost without changing their applications, but an even greater boost if they update their code to take best advantage of in-memory processing.

"Some applications such as Oracle PeopleSoft, financial applications or the E-Business Suite have seen several hundred and up to a thousand times speed-up through a combination of adding the in-memory option and doing some restructuring of their internal algorithms," Shetler claimed.

Oracle is also extending its partner programme to certify applications on Oracle Database 12c with the in-memory option.

The Oracle in-memory option will be available on all platforms where Oracle Database 12c is currently supported, Shetler said. Pricing for the option will not be disclosed until it is available.

  • Comment  
  • Tweet  
  • Google plus  
  • Facebook  
  • LinkedIn  
  • Stumble Upon  
Daniel Robinson
About

Daniel Robinson is technology editor at V3, and has been working as a technology journalist for over two decades. Dan has served on a number of publications including PC Direct and enterprise news publication IT Week. Areas of coverage include desktops, laptops, smartphones, enterprise mobility, storage, networks, servers, microprocessors, virtualisation and cloud computing.

More on Databases
What do you think?
blog comments powered by Disqus
Poll

Windows 7 end of mainstream support

What are your plans for when Microsoft ends mainstream support for Windows 7 in January 2015?
10%
9%
3%
64%
14%

Popular Threads

Powered by Disqus
LG G3 in gold black and white

LG G3 vs Galaxy S5 video

We pit the two Korean firms' flagship smartphones against each other

Updating your subscription status Loading
Newsletters

Get the latest news (daily or weekly) direct to your inbox with V3 newsletters.

newsletter sign-up button
hpv3may

Getting started with virtualisation

Virtualisation can help you reduce costs, improve application availability, and simplify IT
management. However, getting started can be challenging

ibmv3may

Converting big data and analytics insights into results

Successful leaders are infusing analytics throughout their organisations to drive smarter decisions, enable faster actions and optimise outcomes

JavaScript Developer - Data Visualisation

JavaScript Developer / Front End Software Engineer (Real...

SQL DBA - SQL Database Administrator - Chippenham - £45K

SQL DBA - SQL Database Administrator - Chippenham - £45K...

Marketing Executive

Marketing Executive A fantastic opportunity has arisen...

ASP.NET MVC, C# Developer - World Class Entertainment Company

ASP.NET MVC, C# Developer (.NET, C#.NET, dot NET, Web...
To send to more than one email address, simply separate each address with a comma.