DBDB.io The Encyclopedia of Database Systems · Est. 2017
Database of Databases

Database Entry

H-Store


H-Store was an experimental database management system designed for on-line transaction processing applications.

Source Code
https://github.com/apavlo/h-store[02]
Country of Origin
US
Start Year
2006
End Year
2016 [05]
Former Name
Horizontica
Project Types
Academic, Open Source
Written in
C++, Java
Derived From
HyperSQL
Operating System
Linux
Licenses
BSD License, GPL v3

Database Entry

H-Store


H-Store was an experimental database management system designed for on-line transaction processing applications.

History[05]


H-Store was originally conceived as the academic prototype. The original version of H-Store was a single-node proof-of-concept used in the 2007 VLDB paper. In the beginning of 2008, researchers at Brown, MIT, and Yale started working on a full-fledged, general purpose H-Store system. At the same time, Horizontica was launched as an secret internal project at Vertica. Once again, these were separate code bases that were to serve separate purposes.

In the spring of 2008, it was decided to merge together the backend execution engine of H-Store and the front-end transaction coordinator and query planner of Horizontica. After the VLDB demo in the fall of 2008, the H-Store codebase was forked off and became VoltDB.

The final version was announced in 2016. There have been no new developments since then.

Checkpoints


Concurrency Control


Data Model


Indexes


Isolation Levels


All transactions execute with SERIALIZABLE isolation. It is not possible to execute transactions at a lower isolation level.

Joins


Logging


Query Compilation


Query Execution


Query Interface


The primary query interface for H-Store was through stored procedures written in Java.

Storage Architecture


Storage Format


Storage Model


Storage Organization


Stored Procedures


All transactions are executed as Java-based stored procedures.

System Architecture


Views


H-Store only supports simplistic views based on aggregations (e.g., COUNT, SUM).

Derivative Systems
VoltDB VoltDB

Citations

5 sources
  1. H-Store: Next Generation OLTP Database Research brown.edu
  2. GitHub - apavlo/h-store: H-Store Distributed Main Memory OLTP Database System · GitHub github.com
  3. Documentation « H-Store brown.edu
  4. VoltDB - Wikipedia wikipedia.org
  5. Final Release (June 2016) « H-Store brown.edu Dead — Check Archive
Revision #9 Last Updated: