Oracle says its latest memory database is 100 times faster than its hands.

Larry Ellison, chief executive of Oracle, was in a good mood at the opening speech of the 2013 Oracle global conference. Part of the reason may be that the US team won the America Cup in San Francisco Bay earlier that day. Oracle is the main sponsor of the US Team.

Despite being absent from the conference call last Wednesday, Ellison seems to want to announce some of the progress implied in the first quarter earnings.

This may be Oracle's In-Memory Option for Oracle Database, intended to compete with Memory products such as those during sap hana and some other small products In the enterprise IT field.

Ellison didn't waste time cutting into details directly, as shown below:

-Real-time analysis and query of OLTP databases or data warehouse batch processing is nearly 100 times faster

-Two times faster transaction processing speed

-Promises that transactions can run faster in the row format, and better results can be analyzed in the column format.

-Supports 3-4 times faster inserted rows

-Fully compatible, meaning that SQL or existing applications do not need to be modified

-Cloud ready, no data migration required

-Cross-server horizontal scaling to increase memory and CPU

-Memory queries are performed in parallel across servers and access local column data

-Interconnectivity through direct line speed InfiniBand protocol speed

Ellison said the 100-fold increase was a "breakthrough", implementing support for Row-and column-based memory formats for the same data and tables.

Ellison continued: "This is pure memory columnar technology ." He explained that this means there is no log record and there is little overhead for data change, while the CPU core scans the local memory columns.

Ellison claims that this memory technology means that databases can process billions of rows and columns at extremely fast speeds.

Ellison demonstrated the testing results of this technology in the real environment, he said, this memory technology allows a specific footwear retailer to display the sales trend of its products in a few seconds.

"The cost of retaining these indexes is high, which slows down transaction processing. Abandon it. Let's discard all these analysis indexes and replace them with indexes sorted by memory columns ."

Not over yet, Ellison next introduced Oracle's latest M6-32 "Large Memory Machine", and said it is the world's fastest memory device.

The number of M6 cores to be listed is twice that of M5, with 32 tb dram Memory configured.

"It can quickly move data and process data in memory ." Ellison said the M6 system bandwidth is twice higher than the maximum P795 of IBM. Ellison added that the cost of M6 is less than 1/3 of that of IBM systems.

"I saw that later IBM partners did not applaud ." He joked that he pointed to the back of the theme Hall in the Moscone Center.

Oracle has also introduced M6-32 memory databases and application systems, and said it is the world's fastest database device, with 3 TB network and integrated Exadata storage.

The last product introduced that night is Oracle Database Backup Logging Recovery Appliance. Ellison joked: "Which one gave the product the name of life? The sky is approaching. That's why they paid me so much ."

He also said that the development of this device is to solve the problem that backup devices are generally not designed for databases, but for "copying more files.

Oracle sets update and transaction logs to be sent to the backup device, and the database is still running normally. Therefore, backup is performed simultaneously when a change occurs-meaning that the customer will not lose any data.

This device supports restoring to any time point with log records and backing up "thousands" of databases. Another option is to directly back up the database to the public cloud of Oracle and copy it to other devices.

Edit recommendations]

Install Database 12c on Oracle Eneterprise Linux 5.8

Oracle 12c RMAN function enhancements