Hekaton (database)

Hekaton (also known as SQL Server In-Memory OLTP) is an in-memory database for OLTP workloads built into Microsoft SQL Server.^[1] Hekaton was designed in collaboration with Microsoft Research^[2] and was released in SQL Server 2014.^[3][4]

Traditional RDBMS systems were designed when memory resources were expensive, and were optimized for disk storage. Hekaton is instead optimized for a working set stored entirely in main memory, but is still accessible via T-SQL like normal tables. It is fundamentally different from the "DBCC PINTABLE" feature in earlier SQL Server versions.

Hekaton was announced at the Professional Association for SQL Server (PASS) conference 2012.^[5][6][7][8]

References

1. Campbell, Dave (8 November 2012). "Breakthrough performance with in-memory technologies - SQL Server Team Blog - Site Home - TechNet Blogs". TechNet Blogs. Microsoft. Archived from the original on 12 November 2012.
2. Chang, Janie (20 December 2012). "Hekaton Breaks Through - Microsoft Research". Microsoft Research. Archived from the original on 30 December 2012.
3. Foley, Mary Jo (11 June 2013). "Microsoft's SQL Server 2014: More than just in-memory OLTP - ZDNet". ZDNet. CBS Interactive which owns ZDNet.com. Archived from the original on 22 December 2014.
4. Foley, Mary Jo (18 March 2014). "Microsoft SQL Server 2014 released to manufacturing". ZDNet. CBS Interactive. Archived from the original on 23 December 2014. Retrieved 31 August 2018.
5. Foley, Mary Jo (7 November 2012). "Microsoft to fold in-memory database technology into SQL Server Next". ZDNet. CBS Interactive. Archived from the original on 9 January 2015. Retrieved 17 April 2013.
6. Jackson, Joab (7 November 2012). "Microsoft adding in-memory technology to SQL Server". Computerworld. IDG. Archived from the original on 12 March 2013.
7. Henschen, Doug (7 November 2012). "Microsoft In-Memory Move Challenges SAP, Oracle - Software -". InformationWeek. UBM. Archived from the original on 10 November 2012. Retrieved 17 April 2013.
8. Hernandez, Pedro (9 November 2012). "Project Hekaton: Microsoft Bakes In-Memory Tech into SQL Server — DatabaseJournal.com". Database Journal. Archived from the original on 12 November 2012. Retrieved 17 April 2013.