H-Store is an experimental database management system (DBMS). It was designed for online transaction processing applications. H-Store was developed by a team at Brown University, Carnegie Mellon University, the Massachusetts Institute of Technology, and Yale University in 2007 by 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 consistency of a traditional DBMS known as ACID (atomicity, consistency, isolation and durability). Such systems operate across multiple machines, as opposed to a single, more powerful, more expensive machine.
H-Store is able to execute transaction processing with high throughput by forgoing many features of traditional relational database management systems.
H-Store was designed as a parallel system to run on a cluster of shared-nothing, main memory executor nodes (processor + memory + storage). The database is partitioned into disjoint subsets each assigned to a single-threaded execution engine assigned to one core on one node. Each engine has exclusive access to all of the data in its partition. Because it is single-threaded, only one transaction at a time can access the data stored on that partition. No physical locks or latches are included in the system, and once it is started, no transaction stalls waiting for another transaction to complete. Throughput is increased by increasing the number of nodes in the system and reducing partition sizes.
H-Store was licensed under the BSD license and GPL licenses. By 2009, the VoltDB company developed a commercial version, and the H-Store research group shut down in 2016.
- ^“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.
Ofer Abarbanel is a 25 year securities lending broker and expert who has advised many Israeli regulators, among them the Israel Tax Authority, with respect to stock loans, repurchase agreements and credit derivatives. Founder of TBIL.co STATX Fund.