Oracle Upgrades Recently Acquired TimesTen In-Memory Database - InformationWeek

InformationWeek is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them.Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

Software // Information Management
09:32 PM
Connect Directly

Oracle Upgrades Recently Acquired TimesTen In-Memory Database

But TimesTen support for Oracle's PL/SQL language is still missing.

Oracle has integrated the TimesTen in-memory, real-time database more tightly with its own relational database and is offering a new release of the TimesTen database system. Oracle acquired TimesTen in June.

TimesTen Release 6.0, which was under development prior to the acquisition, is available immediately at a price of $12,000 to $24,000 per CPU, depending on the size of the in-memory data store.

Oracle has broken out two pieces of the original product and now offers them as add-on options: a replication service called Replication " TimesTen to TimesTen, for hot backup in case of server or network failure; and Cache Connect to Oracle, a service that uploads a subset of Oracle data into TimesTen, then updates both the cache and the parent database on an ongoing basis.

The two add-ons are each priced at $6,000-$12,000, depending on the size of the data store in memory. Both are available immediately.

"By pulling forward data into an in-memory database, you get great performance," says Jim Groff, formerly CEO of TimesTen and now senior VP of Oracle's TimesTen product line. A data retrieval or record update that might take a few tenths of a second in a typical relational system will take nine millionths of a second with TimesTen, he says.

One improvement still to be made is getting TimesTen to recognize and use Oracle's modified SQL query development language, called PL/SQL, Groff says. Many applications written for Oracle's database use PL/SQL.

In-memory database systems are a special type of database where both the database software and the data it's managing reside in a server's memory rather than on a disk. That allows the system to act on calls for data much more quickly than traditional databases. TimesTen is often used to host stock price information for equities trading at financial services companies. It's also used in telecommunications and network services for high-speed tasks.

Other changes in Release 6.0 include expanded support for SQL constructs and Java Database Connectivity (JDBC) interfaces. Throughput for updates to in-memory data caches has been increased by 500%, Groff says. With larger addressable memories made possible by 64-bit operating systems, TimesTen sometimes work with caches that contain 20-to-30 gigabytes of data, compared to the two-to-five gigabytes that were typical one or two years ago.

We welcome your comments on this topic on our social media channels, or [contact us directly] with questions about the site.
Comment  | 
Print  | 
More Insights
Get Your Enterprise Ready for 5G
Mary E. Shacklett, Mary E. Shacklett,  1/14/2020
Modern App Dev: An Enterprise Guide
Cathleen Gagne, Managing Editor, InformationWeek,  1/5/2020
9 Ways to Improve IT and Operational Efficiencies in 2020
Cynthia Harvey, Freelance Journalist, InformationWeek,  1/2/2020
White Papers
Register for InformationWeek Newsletters
Current Issue
The Cloud Gets Ready for the 20's
This IT Trend Report explores how cloud computing is being shaped for the next phase in its maturation. It will help enterprise IT decision makers and business leaders understand some of the key trends reflected emerging cloud concepts and technologies, and in enterprise cloud usage patterns. Get it today!
Flash Poll