H-Store Explained

H-Store
Developer:	Brown, CMU, MIT, Yale
Latest Release Version:	June 2016
Programming Language:	C++, Java
Operating System:	Linux, Mac OS X
Genre:	Database Management System
License:	BSD License, GPL

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

• C-Store

Notes and References

1. Web site: H-Store - Next Generation OLTP DBMS Research. 2011-08-07.
2. Web site: Stonebraker's H-Store: There's something happenin' here. David. Van Couvering. 2008-02-18. 2011-03-11. 2012-07-18.
3. Michael Stonebraker. Mike . Stonebraker. The end of an architectural era: (it's time for a complete rewrite). VLDB '07: Proceedings of the 33rd international conference on Very large data bases. Vienna, Austria. 2007. etal.
4. Kallman. Robert. Kimura. Hideaki. Natkins. Jonathan. Pavlo. Andrew. Rasin. Alexander. Zdonik. Stanley. Stan Zdonik. Jones. Evan P. C.. Madden. Samuel. Samuel Madden (MIT). Stonebraker. Michael. Michael Stonebraker. Zhang. Yang. Hugg. John. Abadi. Daniel J.. H-Store: a high-performance, distributed main memory transaction processing system. Proc. VLDB Endow.. 2008. 1. 2. 1496–1499. 10.14778/1454159.1454211. 2150-8097.
5. Web site: Mike Stonebraker calls for the complete destruction of the old DBMS order. Curt. Monash. 2008. 2008-02-18. 2012-07-18.
6. Web site: How Will The Database Incumbents Respond To NoSQL And NewSQL? . Matthew . Aslett . 451 Group . 2011-04-04 . 2010 . 2012-07-06 . dead . https://web.archive.org/web/20120127202623/http://www.cs.brown.edu/courses/cs227/papers/newsql/aslett-newsql.pdf . January 27, 2012 .
7. Web site: H-Store - a new architectural era, or just a toy? . Nigel. Thomas. 2008-03-01. 2012-07-05.
8. Web site: Is H-Store the future of database management systems?. Matthew. Aslett. 2008-03-04. 2012-07-05. 2012-05-06. https://web.archive.org/web/20120506075140/http://blogs.the451group.com/information_management/2008/03/04/is-h-store-the-future-of-database-management-systems/. dead.
9. Web site: H-Store - Architecture Overview. 2011-08-07.
10. Web site: H-Store: Complete destruction of the old DBMS order?. Larry. Dignan. ZDNet. 2008. 2012-07-05.
11. Web site: H-Store is now VoltDB. Curt. Monash. 2009. 2011-07-14.