Hekaton (database)
Hekaton (also known as SQL Server In-Memory OLTP) is an in-memory database for OLTP workloads built into Microsoft SQL Server.{{cite web|url=http://blogs.technet.com/b/dataplatforminsider/archive/2012/11/08/breakthrough-performance-with-in-memory-technologies.aspx|title=Breakthrough performance with in-memory technologies - SQL Server Team Blog - Site Home - TechNet Blogs|last=Campbell|first=Dave|date=8 November 2012|website=TechNet Blogs|publisher=Microsoft|archive-url=https://web.archive.org/web/20121112012908/http://blogs.technet.com/b/dataplatforminsider/archive/2012/11/08/breakthrough-performance-with-in-memory-technologies.aspx|archive-date=12 November 2012|url-status=live}} Hekaton was designed in collaboration with Microsoft Research{{cite web|url=http://research.microsoft.com/en-us/news/features/hekaton-122012.aspx|title=Hekaton Breaks Through - Microsoft Research|last=Chang|first=Janie|date=20 December 2012|website=Microsoft Research|archive-url=https://web.archive.org/web/20121230184119/http://research.microsoft.com/en-us/news/features/hekaton-122012.aspx|archive-date=30 December 2012|url-status=dead}} and was released in SQL Server 2014.{{cite web|url=https://www.zdnet.com/article/microsofts-sql-server-2014-more-than-just-in-memory-oltp/|title=Microsoft's SQL Server 2014: More than just in-memory OLTP - ZDNet|last=Foley|first=Mary Jo|date=11 June 2013|website=ZDNet|publisher=CBS Interactive which owns ZDNet.com|archive-url=https://web.archive.org/web/20141222201041/https://www.zdnet.com/article/microsofts-sql-server-2014-more-than-just-in-memory-oltp/|archive-date=22 December 2014|url-status=live}}{{cite web|url=https://www.zdnet.com/article/microsoft-sql-server-2014-released-to-manufacturing/|title=Microsoft SQL Server 2014 released to manufacturing|last=Foley|first=Mary Jo|date=18 March 2014|website=ZDNet|publisher=CBS Interactive|archive-url=https://web.archive.org/web/20141223015235/http://www.zdnet.com/article/microsoft-sql-server-2014-released-to-manufacturing/|archive-date=23 December 2014|url-status=live|access-date=31 August 2018}}
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.{{cite web|url=https://www.zdnet.com/article/microsoft-to-fold-in-memory-database-technology-into-sql-server-next/|title=Microsoft to fold in-memory database technology into SQL Server Next|last=Foley|first=Mary Jo|date=7 November 2012|website=ZDNet|publisher=CBS Interactive|archive-url=https://web.archive.org/web/20150109055853/http://www.zdnet.com/article/microsoft-to-fold-in-memory-database-technology-into-sql-server-next/|archive-date=9 January 2015|url-status=live|access-date=17 April 2013}}{{cite web|url=http://www.computerworld.com/s/article/9233352/Microsoft_adding_in_memory_technology_to_SQL_Server?taxonomyId=221|title=Microsoft adding in-memory technology to SQL Server|last=Jackson|first=Joab|date=7 November 2012|website=Computerworld|publisher=IDG|archive-url=https://web.archive.org/web/20130312193622/http://www.computerworld.com/s/article/9233352/Microsoft_adding_in_memory_technology_to_SQL_Server?taxonomyId=221|archive-date=12 March 2013|url-status=live}}{{Cite web|url=http://www.informationweek.com/software/information-management/microsoft-in-memory-move-challenges-sap/240062566|title=Microsoft In-Memory Move Challenges SAP, Oracle - Software -|last=Henschen|first=Doug|date=7 November 2012|website=InformationWeek|publisher=UBM|archive-url=https://web.archive.org/web/20121110132410/http://www.informationweek.com/software/information-management/microsoft-in-memory-move-challenges-sap/240062566|archive-date=10 November 2012|url-status=dead|access-date=17 April 2013}}{{cite web|url=http://www.databasejournal.com/news/project-hekaton-microsoft-in-memory-sql-server.html|title=Project Hekaton: Microsoft Bakes In-Memory Tech into SQL Server — DatabaseJournal.com|last=Hernandez|first=Pedro|date=9 November 2012|website=Database Journal|archive-url=https://web.archive.org/web/20121112033627/http://www.databasejournal.com/news/project-hekaton-microsoft-in-memory-sql-server.html|archive-date=12 November 2012|url-status=live|access-date=17 April 2013}}