|Developer(s)||Brown, CMU, MIT, Yale|
June 2016 / June 3, 2016
|Written in||C++, Java|
|Operating system||Linux, Mac OS X|
|Type||Database Management System|
|License||BSD License, GPL|
H-Store is an experimental database management system (DBMS) designed for online transaction processing applications developed by a team at Brown University, Carnegie Mellon University, the Massachusetts Institute of Technology, and Yale University. The system's design was developed in 2007 by database researchers Michael Stonebraker, Sam Madden, Andy Pavlo and Daniel Abadi.
H-Store was promoted as a new class of parallel database management systems, called NewSQL,that provide the high-throughput and high-availability of NoSQL systems, but without giving up the transactional guarantees of a traditional DBMS known as the ACID properties. Such systems use a computer cluster on multiple machines, as opposed to moving to a more powerful, more expensive machine for a single-node system for more performance.
H-Store is able to execute transaction processing with high throughput by forgoing much of legacy architecture of System R-like systems. For example, H-Store was designed as a parallel, row-storage relational DBMS that runs on a cluster of shared-nothing, main memory executor nodes. The database is partitioned into disjoint subsets that are assigned to a single-threaded execution engine assigned to one and only one core on a node. Each engine has exclusive access to all of the data at its partition. Because it is single-threaded, only one transaction at a time is able to access the data stored at its partition. Thus, there are no physical locks or latches in the system, and no transaction will stall waiting for another transaction once it is started.
- "H-Store - Next Generation OLTP DBMS Research". Retrieved 2011-08-07.
- Van Couvering, David (2008-02-18). "Stonebraker's H-Store: There's something happenin' here" (published 2011-03-11). Retrieved 2012-07-18.
- Stonebraker, Mike; et al. (2007). "The end of an architectural era: (it's time for a complete rewrite)" (PDF). VLDB '07: Proceedings of the 33rd international conference on Very large data bases. Vienna, Austria.
- Kallman, Robert; Kimura, Hideaki; Natkins, Jonathan; Pavlo, Andrew; Rasin, Alexander; Zdonik, Stanley; Jones, Evan P. C.; Madden, Samuel; Stonebraker, Michael; Zhang, Yang; Hugg, John; Abadi, Daniel J. (2008). "H-Store: a high-performance, distributed main memory transaction processing system" (PDF). Proc. VLDB Endowment. 2. 1: 1496–1499. ISSN 2150-8097.
- Monash, Curt (2008). "Mike Stonebraker calls for the complete destruction of the old DBMS order" (published 2008-02-18). Retrieved 2012-07-18.
- Aslett, Matthew (2010). "How Will The Database Incumbents Respond To NoSQL And NewSQL?" (PDF). 451 Group (published 2011-04-04). Archived from the original (PDF) on January 27, 2012. Retrieved 2012-07-06.
- Thomas, Nigel (2008-03-01). "H-Store - a new architectural era, or just a toy?". Retrieved 2012-07-05.
- Aslett, Matthew (2008-03-04). "Is H-Store the future of database management systems?". Retrieved 2012-07-05.
- "H-Store - Architecture Overview". Retrieved 2011-08-07.
- Dignan, Larry (2008). "H-Store: Complete destruction of the old DBMS order?". Retrieved 2012-07-05.
- Monash, Curt (2009). "H-Store is now VoltDB". Retrieved 2011-07-14.