List of in-memory databases
This article is a list of in-memory database system software.
| Name | Developer | License | Description/Notes |
|---|---|---|---|
| ActiveSpaces | TIBCO Software | Proprietary with developer download | For Java/.Net./C, distributed, hybrid, event enabled, NewSQL |
| ALTIBASE HDB | Altibase Corporation | Proprietary | "Hybrid DBMS" that combines an in-memory database with a conventional disk-resident database |
| Ants Data Server | Ants Software Corporation | Proprietary | In-memory RDBMS introduced in 2000; company defunct as of 2013 |
| BigMemory | Terracotta, Inc. (Software AG) | Proprietary (free editions) | |
| Datablitz (formerly Dali) | Bell Labs (Alcatel-Lucent) | Proprietary | Dali prototype was developed for in-house Bell Labs needs |
| DB2 BLU | IBM | Proprietary | IBM DB2 for Linux, UNIX and Windows supports Dynamic In-memory (in-memory columnar processing) Parallel Vector Processing, Actionable Compression, and Data Skipping technologies, collectively called IBM BLU Acceleration by IBM. Released in June 2013. |
| Ehcache | Terracotta, Inc. (Software AG) | Open source (Apache License) | For Java, distributed |
| EXASolution | EXASOL | Proprietary | Relational (SQL over ODBC, JDBC, or ADO.NET), multi-dimensional (MDX over ODBO or XMLA); EXASOL leads the well-respected international TPC-H benchmark,[1] since 2008, in the datavolume-based categories 100GB, 300GB, 1TB, 3TB, and 10TB; EXASolution architecture: shared-nothing, column-store, in-memory database |
| eXtremeDB | McObject | Proprietary | Cross-platform, including Linux, Windows, RTOS and server platforms. Interfaces include type-safe, native C/C++; native Java & .NET; SQL/ODBC/JDBC. Specialized editions for clustering, high availability, 64-bit support, hybrid (in-memory and persistent) storage, and more. eXtremeDB Financial Edition implements columnar data handling, vector-based statistical function library, integrated performance monitoring. |
| GemFire | Pivotal Software Inc. | Proprietary | Written in Java, distributed, shared-nothing, NoSQL key-value store for OLTP |
| GemFire XD | Pivotal Software Inc. | Proprietary | Relational, distributed, NewSQL, HDFS-integration |
| H2 (DBMS) | H2 | Mozilla Public License or Eclipse Public License | For Java |
| Hazelcast | Hazelcast Team | Open source (Apache License 2.0) | For Java, NoSQL, distributed |
| Informix Warehouse Accelerator | IBM | Proprietary | IWA supports Dynamic In-memory (in-memory columnar processing) Parallel Vector Processing, Actionable Compression, and Data Skipping technologies, collectively called Blink Technology by IBM (the same technology underlying IBM BLU Acceleration). IWA is included in the Informix Advanced Enterprise and Advanced Workgroup Editions. Released March 2011. |
| Kognitio Analytical Platform | Kognitio, Limited | Proprietary | Development of an in-memory database, specialized for analytical workloads was started at White Cross Systems, Limited in 1988. The first beta release of that system was in 1989. It was based on the INMOS Transputer. The first full production release was offered in 1992. White Cross merged in 2005 with Kognitio, Limited in the United Kingdom and is currently marketing version 8 of the same code base as the "Kognitio Analytical Platform". |
| MemSQL | MemSQL, Inc. | Proprietary | SQL relational |
| Microsoft COM+ IMDB | Microsoft Corporation | Proprietary | Defunct |
| Microsoft SQL Server | Microsoft | Proprietary | SQL Server 2012 contains an in-memory technology called xVelocity column store indexes targeted for data warehouse workload. The recently announced SQL Server 2014 will contain a in-memory technology with the code name Hekaton targeted for OLTP type workloads. |
| Oracle RDBMS | Oracle Corporation | Proprietary | RDBMS Oracle 12c contains an option for in-memory technology (additional licenses are required). |
| Oracle Coherence | Oracle Corporation | Proprietary with developer download | For Java, relational, distributed |
| Oracle Exalytics | Oracle Corporation | Proprietary | Appliance |
| Polyhedra | ENEA AB (previously Perihelion Software) | Proprietary, with a free to use edition (Polyhedra Lite) | Relational (SQL, ODBC, JDBC) in-memory database system originally developed for use in SCADA and embedded systems, but used in a variety of other applications including financial systems. Supports data durability via snapshots and journal logging, and high availability via a hot-standby. First release was in 1993; 8.7 released in March 2013.[2] Polyhedra Lite was released under a free-to-use license in 2012.[3] |
| SafePeak | SafePeak Technologies | Proprietary | Automated In-Memory Dynamic Caching for SQL Server OLTP applications and databases. Code-free, Dynamic Caching, Relational |
| SAP HANA | SAP AG | Proprietary | SAP HANA, short for 'High Performance Analytic Appliance' is an in-memory, column-oriented, relational database management system written in C, C++ |
| solidDB | IBM | Proprietary | Relational |
| SQLFire | Pivotal Software Inc. | Proprietary | Relational, distributed, NewSQL |
| TimesTen | Oracle Corporation | Proprietary | Standalone database or in-memory cache for Oracle Database |
| UnQLite Embedded Database | Symisc Systems | BSD, SPL | UnQLite has support for in-memory databases as well on-disk databases using the same API with pluggable run-time interchangeable storage engines (B+tree, Hash, etc.) |
| VoltDB | VoltDB Inc. | Open source (GPL) / Proprietary | Relational; implements H-Store design |
| WebDNA | WebDNA Software Corporation | Freeware | Robust hybrid in-memory database system and scripting language designed for the World Wide Web. Resilience is provided by both in-memory and on-disk tables in a single database. |
| Xeround | Xeround Inc. | Proprietary/Not for sale, service only | Cloud database, defunct as of 2014 |
Many DBMS support in-memory-only storage engines, including:
References
- ^ TPC-H - Homepage. Tpc.org (2010-04-21). Retrieved on 2013-09-18.
- ^ Enea Adds Fine-Grain Locking and Cascaded Deletes to the World's Best Relational In-Memory Database Server, Press Release, Enea AB
- ^ Polyhedra Lite In-Memory Relational Database System Freeware Available Now from Enea, Press Release, Reuters