Hekaton (database) explained

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]

Notes and References

  1. Web site: Breakthrough performance with in-memory technologies - SQL Server Team Blog - Site Home - TechNet Blogs. Campbell. Dave. 8 November 2012. TechNet Blogs. Microsoft. https://web.archive.org/web/20121112012908/http://blogs.technet.com/b/dataplatforminsider/archive/2012/11/08/breakthrough-performance-with-in-memory-technologies.aspx. 12 November 2012. live.
  2. Web site: Hekaton Breaks Through - Microsoft Research. Chang. Janie. 20 December 2012. Microsoft Research. https://web.archive.org/web/20121230184119/http://research.microsoft.com/en-us/news/features/hekaton-122012.aspx. 30 December 2012. dead.
  3. Web site: Microsoft's SQL Server 2014: More than just in-memory OLTP - ZDNet. Foley. Mary Jo. 11 June 2013. ZDNet. CBS Interactive which owns ZDNet.com. https://web.archive.org/web/20141222201041/https://www.zdnet.com/article/microsofts-sql-server-2014-more-than-just-in-memory-oltp/. 22 December 2014. live.
  4. Web site: Microsoft SQL Server 2014 released to manufacturing. Foley. Mary Jo. 18 March 2014. ZDNet. CBS Interactive. https://web.archive.org/web/20141223015235/http://www.zdnet.com/article/microsoft-sql-server-2014-released-to-manufacturing/. 23 December 2014. live. 31 August 2018.
  5. Web site: Microsoft to fold in-memory database technology into SQL Server Next. Foley. Mary Jo. 7 November 2012. ZDNet. CBS Interactive. https://web.archive.org/web/20150109055853/http://www.zdnet.com/article/microsoft-to-fold-in-memory-database-technology-into-sql-server-next/. 9 January 2015. live. 17 April 2013.
  6. Web site: Microsoft adding in-memory technology to SQL Server. Jackson. Joab. 7 November 2012. Computerworld. IDG. https://web.archive.org/web/20130312193622/http://www.computerworld.com/s/article/9233352/Microsoft_adding_in_memory_technology_to_SQL_Server?taxonomyId=221. 12 March 2013. live.
  7. Web site: Microsoft In-Memory Move Challenges SAP, Oracle - Software -. Henschen. Doug. 7 November 2012. InformationWeek. UBM. https://web.archive.org/web/20121110132410/http://www.informationweek.com/software/information-management/microsoft-in-memory-move-challenges-sap/240062566. 10 November 2012. dead. 17 April 2013.
  8. Web site: Project Hekaton: Microsoft Bakes In-Memory Tech into SQL Server — DatabaseJournal.com. Hernandez. Pedro. 9 November 2012. Database Journal. https://web.archive.org/web/20121112033627/http://www.databasejournal.com/news/project-hekaton-microsoft-in-memory-sql-server.html. 12 November 2012. live. 17 April 2013.

This article is licensed under the GNU Free Documentation License. It uses material from the Wikipedia article "Hekaton (database)".

Except where otherwise indicated, Everything.Explained.Today is © Copyright 2009-2024, A B Cryer, All Rights Reserved. Cookie policy.