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". Microsoft. http://blogs.technet.com/b/dataplatforminsider/archive/2012/11/08/breakthrough-performance-with-in-memory-technologies.aspx.
2. ↑ Chang, Janie (20 December 2012). "Hekaton Breaks Through - Microsoft Research". http://research.microsoft.com/en-us/news/features/hekaton-122012.aspx.
3. ↑ Foley, Mary Jo (11 June 2013). "Microsoft's SQL Server 2014: More than just in-memory OLTP - ZDNet". CBS Interactive which owns ZDNet.com. http://www.zdnet.com/microsofts-sql-server-2014-more-than-just-in-memory-oltp-7000016672/.
4. ↑ Foley, Mary Jo (18 March 2014). "Microsoft SQL Server 2014 released to manufacturing | ZDNet". CBS Interactive. http://www.zdnet.com/article/microsoft-sql-server-2014-released-to-manufacturing/.
5. ↑ Foley, Mary Jo (7 November 2012). "Microsoft to fold in-memory database technology into SQL Server Next | ZDNet". CBS Interactive. http://www.zdnet.com/microsoft-to-fold-in-memory-database-technology-into-sql-server-next-7000007047/.
6. ↑ Jackson, Joab (7 November 2012). "Microsoft adding in-memory technology to SQL Server". IDG. http://www.computerworld.com/s/article/9233352/Microsoft_adding_in_memory_technology_to_SQL_Server?taxonomyId=221.
7. ↑ Henschen, Doug (7 November 2012). "Microsoft In-Memory Move Challenges SAP, Oracle - Software -". UBM. http://www.informationweek.com/software/information-management/microsoft-in-memory-move-challenges-sap/240062566.
8. ↑ Hernandez, Pedro (9 November 2012). "Project Hekaton: Microsoft Bakes In-Memory Tech into SQL Server — DatabaseJournal.com". http://www.databasejournal.com/news/project-hekaton-microsoft-in-memory-sql-server.html.

0.00

(0 votes)

Original source: https://en.wikipedia.org/wiki/Hekaton (database). Read more

|

Retrieved from "https://handwiki.org/wiki/index.php?title=Software:Hekaton_(database)&oldid=722384"