H-Store

H-Store
Developer(s)	Brown, CMU, MIT, Yale
Stable release	June 2016 / June 3, 2016;9 years ago (2016-06-03)
Repository	github.com/apavlo/h-store
Written in	C++, Java
Operating system	Linux, Mac OS X
Type	Database Management System
License	BSD License, GPL
Website	hstore.cs.brown.edu

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 ^{[1] [2]} in 2007 by researchers Michael Stonebraker, Sam Madden, Andy Pavlo and Daniel Abadi. ^{[3] [4] [5]}

Architecture

H-Store was promoted as a new class of parallel database management systems, called NewSQL, ^[6] 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). ^[7] Such systems operate across multiple machines, as opposed to a single, more powerful, more expensive machine. ^[8]

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). ^[9] 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 a transaction is started, it cannot stall waiting for another transaction to complete. Throughput is increased by increasing the number of nodes in the system and reducing partition sizes. ^[10]

Licensing

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. ^[11]

See also

• Free and open-source software portal

• C-Store

References

1. "H-Store - Next Generation OLTP DBMS Research" . Retrieved 2011-08-07.
2. Van Couvering, David (2008-02-18). "Stonebraker's H-Store: There's something happenin' here" (published 2011-03-11). Retrieved 2012-07-18.
3. 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.
4. 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 Endow. 2. 1: 1496–1499. doi:10.14778/1454159.1454211. ISSN   2150-8097.
5. Monash, Curt (2008). "Mike Stonebraker calls for the complete destruction of the old DBMS order" (published 2008-02-18). Retrieved 2012-07-18.
6. 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.
7. Thomas, Nigel (2008-03-01). "H-Store - a new architectural era, or just a toy?" . Retrieved 2012-07-05.
8. Aslett, Matthew (2008-03-04). "Is H-Store the future of database management systems?". Archived from the original on 2012-05-06. Retrieved 2012-07-05.
9. "H-Store - Architecture Overview" . Retrieved 2011-08-07.
10. Dignan, Larry (2008). "H-Store: Complete destruction of the old DBMS order?". ZDNet . Retrieved 2012-07-05.
11. Monash, Curt (2009). "H-Store is now VoltDB" . Retrieved 2011-07-14.