List of in-memory databases

From Wikipedia, the free encyclopedia
Jump to: navigation, search

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
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.
Ants Data Server Ants Software Corporation 2000 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 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.
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 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.
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). The Informix Advanced Enterprise and Advanced Workgroup Editions include IWA. Released: March 2011.
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 markets 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 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
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.[2] Polyhedra Lite appeared with a free-to-use license in 2012.[3]
P*time Seoul National University, Big Data Institute, Korea and Transact In Memory, Inc. (TIM) 1997 Commercial Initial focus on the telecommunication industry.[4] General availability 2001. The successor product was acquired and integrated by SAP.
Redis VMware / Pivotal Software 2009 BSD
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 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 Facebook Proprietary
solidDB Unicom Global 1992 Proprietary Relational with standard SQL support. ODBC and JDBC interfaces. Supports also on-disk tables in the same engine.
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
SUNDB SUNJESOFT Corporation 2010 Proprietary Pure in-memory DBMS for high performance
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.[5]
UnQLite Embedded Database Symisc Systems 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.)
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

Many DBMS support in-memory-only storage engines, including:

References[edit]

  1. ^ TPC-H - Homepage. Tpc.org (2010-04-21). Retrieved on 2013-09-18.
  2. ^ Enea Adds Fine-Grain Locking and Cascaded Deletes to the World's Best Relational In-Memory Database Server, Press Release (8.7), Enea AB 
  3. ^ Polyhedra Lite In-Memory Relational Database System Freeware Available Now from Enea, Press Release, Reuters 
  4. ^ 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
  5. ^ Siwiec,J.E.: A High-Performance DB/DC System;IBM, G321-5051, 1978