Oracle Database In-Memory

Database In-Memory is the technology increasing performance of information and analytical databases, the systems of preparation of reports on several orders, accelerating online transaction processing (OLTP).

On June 24, 2014 the Oracle corporation provided new technology - Oracle Database In-Memory.

Use of Database In-Memory technology gives the chance in any existing application working with Oracle Database, automatically and is transparent to use advantages of pokolonochny processing in RAM without additional programming or change of the application. The innovation architecture of data processing in RAM allows to use effectively lower case and pokolonochny formats for acceleration of analytical requests and transactions of OLTP processing.

Oracle Database In-Memory shows cardinal - from 100 to more than 1000 times - performance improvement of work of corporate business applications, including: Oracle E-Business Suite Oracle JD Edwards Oracle PeopleSoft Oracle Fusion Applications, , , Oracle Siebel и .

The data analysis combination in real time to transaction processing for fractions of a second, using existing applications, will help the organizations to become the "enterprises of real time" (Real-Time Enterprise) capable to fast decision making on the basis of new data, instant reaction to customer needs and continuous optimization of key processes.

Oracle Database In-Memory is transparent expands possibilities of Oracle Database 12c, helping the organizations to conform to requirements of business in real time and to increase performance of transaction transactions. Oracle Database In-Memory gives the chance to immediately receive answers to questions of business for which before it was necessary to wait for hours, to increase the speed and service quality of internal and external participants of business operations.

The release of Oracle Database In-Memory is planned for July, 2014. The product can be used together with any hardware platforms certified for Oracle Database 12c.

"In the modern dynamic, mobile and social world the companies need to obtain instantly information and quickly to react to it. And offering the exclusive performance of processing in RAM without restriction of functionality, to Oracle Database In-Memory it is capable to change rules of business in Russia where Oracle DBMS within already several decades is a market leader, - Maria Orlovskaya, the area director of Oracle in Russia noted. – The new product is completely integrated with advanced technologies of vertical and horizontal scalability, multilevel storage, ensuring high availability and security of Oracle Database and therefore is the most powerful offer in the industry".

Oracle Database In-Memory in the functionality has possibilities of Oracle Database:

• Architecture of the maximum availability to protection against data loss and idle times.
• Security technologies, best in the industry.
• Scalability for satisfaction of any requirements through vertical scaling of big SMP servers, horizontal scaling of server clusters and multilevel storage for cost-efficient functioning of databases of any size — whether it be data warehouses which capacity is measured by petabytes, processing of Big Data or cloud services of databases.
• Extensive opportunities of programming: Java, R, Big Data, PHP Python, Node, REST, Ruby, etc.
• Full support of different data types: relational, objects, XML, text, space and the new integrated JSON format.

The hardware and software systems Oracle Engineered Systems are optimized and supplement Oracle Database In-Memory:

• The Oracle Engineered Systems platforms, including Oracle Exadata Database Machine and Oracle SuperCluster, are optimized for work with Oracle Database In-Memory, offering high capacity of RAM, the highest performance and high readiness and also automatic movement of seldom used data of flash drives and disks for ensuring cost efficiency.

• Means of ensuring of fault tolerance of transactions in RAM on hardware and software systems of Oracle allow to duplicate data of RAM on cluster nodes that requests instantly switched to the copy of data of RAM in case of refusal of the server. The new Direct-to-Wire Infiniband technology accelerates horizontal scaling for processing in RAM.

• Oracle M6-32 Big Memory Machine - the scalable platform most powerful vertically for Oracle Database In-Memory - offers to the 32nd terabyte of RAM and capacity of 3 Tb / with for ensuring maximum capacity of transactions in RAM.

2015

SAP certified Oracle Database In-Memory

On July 27, 2015 the Oracle corporation announced certification of Oracle Database In-Memory technology by SAP company for use with SAP solutions on a technology platform of SAP NetWeaver 7.x.

Clients can use business applications SAP with Oracle Database In-Memory for data analysis in real time together with transaction processing in real time, adding the table SAP to storage of a columnar format in RAM. Certification - continuation of cooperation Oracle and SAP, the software of SAP directed to satisfaction of customer needs in use together with technologies Oracle. Earlier in 2015 SAP certified Oracle Database 12c, Oracle Exadata Database Machine X5-2 and Oracle Exalogic Elastic Cloud X5-2 for use with solutions SAP.

The Oracle Database In-Memory technology implements the unique "two-format" architecture providing the fast analysis and high-performance OLTP processing. This option allows to process not millions, but billions of lines per second and to make the analysis directly in the OLTP databases, reducing delays and increasing accuracy. It is easy for Oracle Database In-Memory to unroll with any existing the business application compatible to Oracle Database.

Any changes Oracle Database In-Memory is not required to be made to work of business applications. Uses the developed technologies of vertical scaling, horizontal scaling and multilevel storage for cost-efficient accomplishment of workloads of any volumes. Oracle Database In-Memory inherits all already recommended functionality of Oracle Database 12c, including the solutions of ensuring high availability implemented in popular architecture of Oracle Maximum Availability Architecture (MAA).

As it works in Oracle Database In-Memory

The sense of Oracle Database In-Memory is that near a usual buffer cache which stores lines of tables and blocks of indexes there is a new cache, more precisely the new separated area for data in RAM, in which data from tables are stored in a columnar format^[1].

Data are at the same time active and are transactionally approved. All changes, as usual, at first are made in a normal buffer cache then are reflected in columnar, or as it is called by foreign specialists, a "kolumnarny" cache.

Representation of the movement of data, 2015

Representation in a columnar format in memory is automatically used by Oracle Database 12c DBMS for accomplishment of analytical requests, accelerating their accomplishment in tens and hundreds of times.

The additional product — Oracle Database In-Memory Advisor – helps to estimate applicability of Oracle Database In-Memory technology to the specific database. He analyzes statistics of work of the database and issues recommendations about the extent of memory, the list of tables which need to be cached in In-Memory Columnar Store.

It is important to understand that Oracle Database In-Memory does not require rewriting of applications, unlike the competing solutions. There are no restrictions for SQL, data migration is not necessary, the technology is ready for a cloud.

Business applications of Oracle, including E-Business Suite, Siebel CRM, JD Edwards, completely support Database In-Memory, and for different modules acceleration unprecedented earlier from 100 to more than 1000 times is reached.

Not so long ago standard SAP BW-EML test on identical quantity of main cores on the hardware and software system Oracle Exadata with the included Oracle Database In-Memory technology and on SAP/R3 of HANA showed that it was Oracle Database twice quicker. Besides, it is possible to use functionality of in-memory in HANA only after serious modification of applications which work with it, and the database should find room completely in RAM. Now clients have facts for the reasonable choice of the best platform of the database for the SAP applications.

Result of testing of SAP BW-EML, 2015

In Russia and the CIS at a number of customers testing and approbation of Oracle Database In-Memory technology under different solutions is held. In the Russian company of freight transportation use of Oracle Database In-Memory accelerated accomplishment of some requests by 22 times. Testing was held for applications of own development of the company, and the size of the database was only several cells of gigabytes and under area of columnar storage only 30 GB of memory were selected. At the same time no changes of the application and hardware characteristics of the server were required.

The Oracle Database In-Memory technology implements the "two-format" architecture providing the fast analysis and high-performance OLTP processing. This option allows to process not millions, but billions of lines per second and to make the analysis directly in the OLTP databases, reducing delays and increasing accuracy. It is easy for Oracle Database In-Memory to unroll with any existing the business application compatible to Oracle Database 12c.

Notes