History[04][08]

VoltDB originated from H-Store, a research project from Brown U and MIT under Michael Stonebraker, Samuel Madden, Andy Pavlo, etc. In 2009, it started as a spinoff in Boston, MA.

The original source code was removed from GitHub is no longer available. The project is no longer considered open-source.

Checkpoints[09]

The snapshot creation could either block all the other transactions or be done in a non-blocking way (e.g. Copy-On-Write).

Concurrency Control[06][07][10]

VoltDB schedules transactions deterministically on each partition of the data in the cluster. For transactions that span across partitions, a global serial order controller is responsible for determining the execution order. MVCC mode is only used when taking snapshots.

Data Model[11]

VoltDB is based on the standard relational model.

Foreign Keys[12][13]

FOREIGN KEY and CHECK are not currently supported.

Indexes[14]

Apart from the default tree index, VoltDB also supports hash index.

Isolation Levels[06][07][10]

VoltDB supports serializable isolation level with ACID guarantee. The deterministic ordering of transactions is achieved by controllers at each data partition.

Joins[15][16]

Table joins are only supported if the result is smaller than 50MB. The join ordering must be specified if the query joins more than 6 tables.

Logging[17]

VoltDB supports transaction-level logging for all the stored procedures that are invoked. By command logging, the amount of memory overhead is minimized since a single stored procedure invocation could contain arbitrary number of SQL statements. Only logs after the latest snapshot are kept, and the logs are flushed to the disk at a regular interval. This feature is only available in the enterprise edition.

Query Compilation[18][06]

Query Execution

Query Interface[18][11][19]

Apart from supporting most of the standard SQL statements, VoltDB also allows the user to define pre-compiled stored procedures.

Storage Architecture[09]

VoltDB is designed to be an in-memory relational DBMS. Its data persistence is achieved by snapshots stored on disk.

Storage Model[20]

VoltDB is only designed for fast OLTP queries.

Stored Procedures[18][06]

The stored procedure in VoltDB allows the user to define a transaction once and to be invoked later with given parameters. Stored procedures are pre-compiled to reduce execution time. Temporary queries are automatically comipled and executed as a stored procedure. VoltDB supports stored procedures written in SQL or Java.

System Architecture[21][22]

VoltDB runs on a sharded DBMS cluster. Data partitioning and replication is done automatically across the cluster

Views[23]

Views in VoltDB are materialized to improve read speed, and all updates to the original table will have a performance impact.