Hekaton: SQL server's memory-optimized OLTP engine

Authors:
Cristian Diaconu;Craig Freedman;Erik Ismert;Per-Ake Larson;Pravin Mittal;Ryan Stonecipher;Nitin Verma;Mike Zwilling
Affiliations:
Microsoft, Redmond, WA, USA;Microsoft, Redmond, WA, USA;Microsoft, Redmond, WA, USA;Microsoft, Redmond, WA, USA;Microsoft, Redmond, WA, USA;Microsoft, Redmond, WA, USA;Microsoft, Redmond, WA, USA;Microsoft, Redmond, WA, USA
Venue:
Proceedings of the 2013 ACM SIGMOD International Conference on Management of Data
Year:
2013

Citing 11
Cited 8

High performance dynamic lock-free hash tables and list-based sets

Proceedings of the fourteenth annual ACM symposium on Parallel algorithms and architectures
Hazard Pointers: Safe Memory Reclamation for Lock-Free Objects

IEEE Transactions on Parallel and Distributed Systems
OLTP through the looking glass, and what we found there

Proceedings of the 2008 ACM SIGMOD international conference on Management of data
Lock-free deques and doubly linked lists

Journal of Parallel and Distributed Computing
H-store: a high-performance, distributed main memory transaction processing system

Proceedings of the VLDB Endowment
Shore-MT: a scalable storage manager for the multicore era

Proceedings of the 12th International Conference on Extending Database Technology: Advances in Database Technology
Data-oriented transaction execution

Proceedings of the VLDB Endowment
HYRISE: a main memory hybrid storage engine

Proceedings of the VLDB Endowment
Efficiently compiling efficient query plans for modern hardware

Proceedings of the VLDB Endowment
HyPer: A hybrid OLTP&OLAP main memory database system based on virtual memory snapshots

ICDE '11 Proceedings of the 2011 IEEE 27th International Conference on Data Engineering
High-performance concurrency control mechanisms for main-memory databases

Proceedings of the VLDB Endowment

Proceedings of the Twenty-Fourth ACM Symposium on Operating Systems Principles

ACM SIGOPS 24th Symposium on Operating Systems Principles
Speedy transactions in multicore in-memory databases

Proceedings of the Twenty-Fourth ACM Symposium on Operating Systems Principles
Ranking and new database architectures

Proceedings of the 7th International Workshop on Ranking in Databases
LLAMA: a cache/storage subsystem for modern hardware

Proceedings of the VLDB Endowment
Microsoft SQL server's integrated database approach for modern applications and hardware

Proceedings of the VLDB Endowment
Design and evaluation of storage organizations for read-optimized main memory databases

Proceedings of the VLDB Endowment
Adaptive range filters for cold data: avoiding trips to Siberia

Proceedings of the VLDB Endowment
Anti-caching: a new approach to database management system architecture

Proceedings of the VLDB Endowment

Quantified Score

Hi-index	0.00

Visualization

Abstract

Hekaton is a new database engine optimized for memory resident data and OLTP workloads. Hekaton is fully integrated into SQL Server; it is not a separate system. To take advantage of Hekaton, a user simply declares a table memory optimized. Hekaton tables are fully transactional and durable and accessed using T-SQL in the same way as regular SQL Server tables. A query can reference both Hekaton tables and regular tables and a transaction can update data in both types of tables. T-SQL stored procedures that reference only Hekaton tables can be compiled into machine code for further performance improvements. The engine is designed for high con-currency. To achieve this it uses only latch-free data structures and a new optimistic, multiversion concurrency control technique. This paper gives an overview of the design of the Hekaton engine and reports some experimental results.