List of in-memory databases
Appearance
This article is a list of in-memory database system software.
Name | Developer | Availability | License | Description/Notes |
---|---|---|---|---|
ActiveSpaces | TIBCO Software | Proprietary with developer download | For Java/.Net./C, distributed, hybrid, event enabled, NewSQL | |
Aerospike | Aerospike Company | 2012 | Open Source (AGPL) | Flash-optimized in-memory open source NoSQL database. |
ALTIBASE HDB | Altibase Corporation | Proprietary | "Hybrid DBMS" that combines an in-memory database with a conventional disk-resident database in a single unified engine. Supports full ACID properties, standard connectivity interfaces such as JDBC and ODBC [fully supported] as well as interoperability. | |
ALTIBASE XDB | Altibase Corporation | Proprietary | General purpose database that has high data processing speeds in main-memory alone. It comes with high-availability, replication and scalability features; three interfaces (including Direct Access Mode and Direct Access API Mode) as well as conventional client/server protocols such as TCP/IP and IPC for more complex database operations. Supports full ACID properties, standard connectivity interfaces such as JDBC and ODBC [fully supported] as well as interoperability. | |
Apache Geode | Apache Software Foundation, Pivotal Software | 2015 | Open source (Apache License) | Open source backend to Pivotal Software's Gemfire database, currently incubating to be part of the Apache Software Foundation. Described as an "open source distributed, in-memory database for scale-out applications". |
Apache Ignite | Apache Software Foundation, GridGain Systems | 2014 | Open Source (Apache License
Version 2.0) |
Apache Ignite In-Memory Data Fabric is a high-performance, integrated and distributed in-memory platform for computing and transacting on large-scale data sets in real-time, orders of magnitude faster than possible with traditional disk-based or flash technologies. Java, .NET, C++. |
BigMemory | Terracotta, Inc. (Software AG) | Proprietary (free editions) | ||
dashDB | IBM | 2014 | Proprietary | IBM dashDB is an in-memory data warehouse in the cloud on IBM Bluemix as a managed service. It includes parallel vector processing, actionable compression, and data-skipping technologies, collectively called IBM BLU Acceleration by IBM. It also includes in-databases analytics originally from the Netezza analytics appliance (Pure Data for Analytics) for R, spatial analytics etc. Released in June 2014. |
Datablitz (formerly Dali) | Bell Labs (Alcatel-Lucent) | Proprietary | Dali prototype was developed for in-house Bell Labs needs | |
DB2 BLU | IBM | 2013 | 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. |
DB2 for i | IBM | 1992 | Proprietary | IBM DB2 for i (DB2/400) in conjunction with the IBM i operating system supports simultaneous in-memory and on-disk tables and indexes. |
Ehcache | Terracotta, Inc. (Software AG) | Open source (Apache License) | For Java, distributed | |
EXASolution | EXASOL | 2008 | 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 | 2001 | 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 (for example) clustering, high availability, 64-bit support, and hybrid (in-memory and persistent) storage. eXtremeDB Financial Edition implements columnar data handling, vector-based statistical function library, integrated performance monitoring. |
FuelDB | Wonderfuel Inc. | 2014 | Open Source (MIT License) | Realtime database based on NodeJS |
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 | |
GPUdb | GIS Federal | 2014 | Proprietary | GPUdb is a Graphical Processing Unit (GPU) accelerated distributed in-memory database with native geospatial objects and rendering support that handles streaming Big Data. |
H2 (DBMS) | H2 | Open Source (Mozilla Public License or Eclipse Public License) | For Java | |
HSQLDB | HSQL Development Group | Open Source (BSD License) | Relational, for Java[2] | |
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). The Informix Advanced Enterprise and Advanced Workgroup Editions include IWA. Released: March 2011. | |
InMemory.Net | InMemory.Net | 2014 | Proprietary | Dot Net Native in-memory database with import scripting language, that can query large amounts of data via Dot Net, ODBC or COM. |
Kinetica | Kinetica | 2014 | Proprietary | |
Kognitio Analytical Platform | Kognitio, Limited | 1989 (beta) | Proprietary | Development of an in-memory database, specialized for analytical workloads started at White Cross Systems, Limited in 1988, 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 as of 2014[update] markets version 8 of the same code-base as the "Kognitio Analytical Platform". |
LokiJS | TechFort | 2013 | Open Source (MIT) | In-memory database written in JavaScript, compatible with node.js and browser environments. |
MemSQL | MemSQL, Inc. | Proprietary | SQL relational | |
SQLite | SQLite | Open Source (Public domain) | SQL database that supports in-memory storage with the :memory: connection string.[3] | |
Microsoft COM+ IMDB | Microsoft Corporation | Proprietary | Defunct | |
Microsoft SQL Server | Microsoft | 2012 | Proprietary | Hekaton, a new in-memory technology in SQL Server 2014 for OLTP databases, requires native compiled procedures using C language. Rows in tables are versioned by a hash key. Supports only hash indexes. Columnstore indexes had been extended to support OLTP workloads.
SQL Server 2012 also included an in-memory technology called xVelocity column-store indexes targeted for data-warehouse workloads. |
MonetDB | CWI | 2004 | Open Source (MonetDB License, based on the MPL 1.1) | Column-store RDBMS with an SQL top-level interface and ODBC, JDBC drivers |
Oracle RDBMS | Oracle Corporation | 2014 | Proprietary | RDBMS Oracle 12c contains an option for in-memory technology (additional licenses required). |
Oracle Coherence | Oracle Corporation | Proprietary with developer download | For Java, relational, distributed | |
Oracle Exalytics | Oracle Corporation | Proprietary | Appliance | |
OrigoDB | Devrex Labs | 2008 | Open Source (embedded engine, commercially licensed enterprise features) | 100% ACID transactional engine written in C# for Microsoft NET and Mono. Entities, datastructures and transactions (commands and queries) are written using C# and LINQ. OrigoDB uses Write-ahead logging with optional snapshots for persistence. Enterprise features include master/slave replication. |
Polyhedra | ENEA AB (previously Perihelion Software) | 1993 | 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 released in 1993; version 8.7 released in March 2013.[4] Polyhedra Lite appeared with a free-to-use license in 2012.[5] |
P*time | Seoul National University, Big Data Institute, Korea and Transact In Memory, Inc. (TIM) | 1997 | Commercial | Initial focus on the telecommunication industry.[6] General availability 2001. The successor product was acquired and integrated by SAP. |
Raima | Raima Database Manager (RDM) | 1982 | Proprietary | Raima Database Manager (RDM) is an In-memory database management system used by application developers. It is a linkable library of functions that becomes a part of the application program. It has multiple interfaces available to C, C++, C#, or Java programmers. RDM supports ODBC, JDBC, SQL and SQL PL in RDM 14.0. RDM 14.0 was released in 2016. |
Redis | VMware / Pivotal Software | 2009 | Open Source (BSD) | |
rqlite | rqlite | 2014 | Open Source (MIT) | Lightweight, distributed relational database, with SQLite-based storage engine. rqlite runs the SQLite in-memory engine by default. |
SafePeak | SafePeak Technologies | Proprietary | Automated In-Memory Dynamic Caching for SQL Server OLTP applications and databases. Code-free, Dynamic Caching, Relational | |
SAP HANA | SAP SE | 2012 | Proprietary | SAP HANA, short for 'High Performance Analytic Appliance' is an in-memory, column-oriented, relational database management system written in C, C++ |
Scuba | Proprietary | |||
SharedHashFile | Hardy-Francis Enterprises Inc. | 2014 | Open Source (AGPL) | 10+M TPS per server in-memory open source NoSQL database. |
solidDB | Unicom Global | 1992 | Proprietary | Relational with standard SQL support. ODBC and JDBC interfaces. Includes in-memory and on-disk tables in the same engine. Supports high availability. |
SQL CE | Microsoft Corporation | Free | Compact relational embedded database produced by Microsoft for applications that run on mobile devices and desktops. ADO.NET, OLE DB. No ODBC driver. | |
SQLFire | Pivotal Software Inc. | Proprietary | Relational, distributed, NewSQL | |
Tarantool | Community | 2010 | Open Source (BSD) | In-memory database and application server (data grid) |
TimesTen | now Oracle Corporation | 1997 | Proprietary | Standalone database or in-memory cache for Oracle Database |
TPF (Transaction Processing Facility) | IBM | 1979 | Marketed | Generalized extension of IBM Airlines reservation system. IBM's DB/DC system backed up the in-memory transaction processing computer.[7] |
UnQLite Embedded Database | Symisc Systems | Open Source (BSD, SPL) | UnQLite supports for in-memory databases as well on-disk databases using the same API with pluggable run-time interchangeable storage engines (B+tree, Hash, etc.) | |
Starcounter | Starcounter AB | 2014 | Proprietary | In-memory database engine combined with an application server that melds the Virtual Machine and the Database Management System. |
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. Both in-memory and on-disk tables in a single database provide resilience. | |
Xeround | Xeround Inc. | Proprietary / Not for sale, service only | Cloud database, defunct as of 2014 |
Forrester Research created the first in-memory database platform wave in 2015.[8]
Many DBMS support in-memory-only storage engines,[9] including:
References
- ^ TPC-H - Homepage. Tpc.org (2010-04-21). Retrieved on 2013-09-18.
- ^ http://hsqldb.org/doc/2.0/guide/running-chapt.html#rgc_hsqldb_db
- ^ http://www.sqlite.org/inmemorydb.html
- ^ 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
- ^ Sang Kyun Cha, Ki Hong Kim, Juchang Lee: Database Architecture for Location and Trajectory Management in Telecommunications; Databases in Telecommunications, International Workshop Co-located with VLDB-99, Edinburgh, Scotland, UK, September 6, 1999
- ^ Siwiec,J.E.: A High-Performance DB/DC System;IBM, G321-5051, 1978
- ^ "The Forrester Wave™: In-Memory Database Platforms, Q3 2015".
- ^ "DB-Engines, list of databases with their properties".