View article

Tobias Mühlbauer, Florian Funke, Viktor Leis, Henrik Mühe, Wolf Rödiger, Alfons Kemper, Thomas Neumann

Tobias Mühlbauer, Florian Funke, Viktor Leis, Henrik Mühe, Wolf Rödiger, Alfons Kemper, Thomas Neumann Technische Unive Page 1 HyPer: one DBMS for all Tobias Mühlbauer, Florian Funke, Viktor Leis, Henrik Mühe, Wolf Rödiger, Alfons Kemper, Thomas Neumann Technische Universität München New England Database Summit 2014 1 http://www.hyper-db.com/ Page 2 One DBMS for all? OLTP and OLAP Traditionally, DBMSs are either optimized for OLTP or OLAP OLTP • high rate of mostly tiny transactions • high data access locality OLAP • few, but long-running transactions • scans large parts of the database • must see a consistent database state during execution Conflict of interest: traditional solutions like 2PL would block OLTP However: Main memory DBMSs enable new options! 2 OLAP OLTP Isolation: Snapshotting Page 3 One DBMS for all? Wimpy and brawny High-performance DBMSs are optimized …