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
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
Oldest First  |  Newest First  |  Threaded View
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.
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.

 
InformationWeek Is Getting an Upgrade!

Find out more about our plans to improve the look, functionality, and performance of the InformationWeek site in the coming months.

News
Remote Work Tops SF, NYC for Most High-Paying Job Openings
Jessica Davis, Senior Editor, Enterprise Apps,  7/20/2021
Slideshows
Blockchain Gets Real Across Industries
Lisa Morgan, Freelance Writer,  7/22/2021
Commentary
Seeking a Competitive Edge vs. Chasing Savings in the Cloud
Joao-Pierre S. Ruth, Senior Writer,  7/19/2021
White Papers
Register for InformationWeek Newsletters
Video
Current Issue
Monitoring Critical Cloud Workloads Report
In this report, our experts will discuss how to advance your ability to monitor critical workloads as they move about the various cloud platforms in your company.
Slideshows
Flash Poll