10 In-Memory Database Options Power Speedy Performance - 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.

IoT
IoT
Data Management // Software Platforms
News
2/9/2015
11:48 AM
Doug Henschen
Doug Henschen
Slideshows
Connect Directly
Google+
LinkedIn
Twitter
RSS
E-Mail
100%
0%

10 In-Memory Database Options Power Speedy Performance

From Altibase to VoltDB, and covering options from IBM, Microsoft, Oracle, and SAP, we wrap up leading in-memory databases and add-on options. When you need speed, here are 10 tools to choose.
Previous
1 of 12
Next

Yes, the death of the conventional disk drive has been greatly exaggerated, but Moore's Law has brought down the cost of RAM so dramatically that in-memory technology is getting to be downright pervasive.

With its Hana platform, SAP has been the biggest champion of in-memory technology over the last five years. The latest chapter from SAP is S/4Hana, a rewrite of the company ERP suite launched in early February and designed to take full advantage of Hana's in-memory power. The platform eliminates aggregates, indexes, and even the need for a separate data warehouse, replacing all of that with virtual views of live, transactional data held in memory. The approach shrinks the data footprint by a factor of 10 while speeding both analytical and transactional performance, according to SAP.

[ Want more on this topic? Read In-Memory Databases: Do You Need The Speed? ]

SAP didn't invent in-memory technology and it certainly doesn't have a monopoly on using RAM for processing transactions or analyzing data. Database incumbents IBM, Microsoft, and Oracle have each introduced in-memory options of their own. These are add-on options to conventional databases, not in-memory databases. But IBM, Microsoft, and Oracle tout the fact that applications designed to run on their flagship databases can now take advantage of in-memory performance without changes to those apps. You simply run key tables in memory to enhance transactional or analytical performance.

Big data practitioners are also falling in love with in-memory technology. The hot, open-source Spark and Storm projects run in-memory, but these are purpose-built analytical and streaming platforms, respectively. This collection focuses on databases, so we look at NoSQL and NewSQL options including Aerospike, a DataStax add-on for Cassandra, MemSQL, and VoltDB.

The earliest purveyors of in-memory databases included Altibase, solidDB (recently divested by IBM), and TimesTen (acquired in 2005 and still owned by Oracle). These products emerged for niche applications such as telecom, financial trading, and high-speed e-commerce. Today these products are seeing broader use, branching into analytics, big data, gaming, and Internet-of-Things-style applications.

Read on to get a better sense of the breadth of in-memory databases and add-on features now available. Offering many times faster transactional or analytical performance (and, in many cases, both), these products are changing people's minds about the practicality and affordability of in-memory computing.

Doug Henschen is Executive Editor of InformationWeek, where he covers the intersection of enterprise applications with information management, business intelligence, big data and analytics. He previously served as editor in chief of Intelligent Enterprise, editor in chief of ... View Full Bio

We welcome your comments on this topic on our social media channels, or [contact us directly] with questions about the site.
Previous
1 of 12
Next
Comment  | 
Print  | 
More Insights
Comments
Newest First  |  Oldest First  |  Threaded View
sgraves980
50%
50%
sgraves980,
User Rank: Apprentice
2/13/2015 | 12:37:37 PM
eXtremeDB
eXtremeDB was first released in 2001.  It was the first in-memory embedded database system written explicitly for embedded systems.  TimesTen, Altibase and Polyhedra were on the market, but none of them could be used in embedded systems.  Today, we have more than 20 million run-time copies of eXtremeDB embedded in devices ranging from networking equipment to consumer electronics to industrial control to aerospace/defense.  eXtremeDB is also gaining in popularity with the financial markets with applications in high frequency trading, algorithmic trading, matching engines, and risk management.
D. Henschen
50%
50%
D. Henschen,
User Rank: Author
2/12/2015 | 2:57:37 PM
Why weren't we included?
After this was posted, I heard from Exasol and Starcounter, both of which asked why they were not included. Both are smallish, European-headquartered companies that don't have big customer counts. Exasol is the larger of the two. I've talked to customers and I think of Exasol as a database that can make use of lots of RAM, but not really as an in-memory database. (To be fair, Oracle, Microsoft, and Teradata aren't "in-memory" either, but they offer in-memory add-on features.) Starcounter pitches itself as an in-memory database engine and application server, which is a slightly different proposition than the other products mentioned here.

I did not hear from Pivotal, which offers the SQLFire in-memory database. Pivotal is a more prominent vendor with more customers than either of the two companies above. If I were to list 11 options, that's the one I would add. I guess Pivotal has bigger concerns (like its larger cloud and big data strategies) than worrying about the visibility of just one of its many products.

 
Li Tan
50%
50%
Li Tan,
User Rank: Ninja
2/10/2015 | 12:33:38 AM
Re: MongoDB will be the next to join this set
Currently my company used MongoDB quite a lot and I am willing to listen to further updates on the in-memory version. How is the experiment going? How long it will take to get a trial version in production?
D. Henschen
50%
50%
D. Henschen,
User Rank: Author
2/9/2015 | 2:52:12 PM
MongoDB will be the next to join this set
I contemplated adding MongoDB to this list, but the "In-Memory Experimental" storage engine included with just-released MongoDB 3.0 is, as the name suggests, only experimental at this point. It may be generally available for production use within just a few months, but I didn't feel it was ready to highlight as an in-memory product offering just yet. Stay tuned.
Slideshows
Reflections on Tech in 2019
James M. Connolly, Editorial Director, InformationWeek and Network Computing,  12/9/2019
Slideshows
What Digital Transformation Is (And Isn't)
Cynthia Harvey, Freelance Journalist, InformationWeek,  12/4/2019
Commentary
Watch Out for New Barriers to Faster Software Development
Lisa Morgan, Freelance Writer,  12/3/2019
White Papers
Register for InformationWeek Newsletters
Video
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!
Slideshows
Flash Poll