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 was 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][7][8]

References

  1. ↑ http://blogs.technet.com/b/dataplatforminsider/archive/2012/11/08/breakthrough-performance-with-in-memory-technologies.aspx
  2. ↑ http://research.microsoft.com/en-us/news/features/hekaton-122012.aspx
  3. ↑ http://www.zdnet.com/microsofts-sql-server-2014-more-than-just-in-memory-oltp-7000016672/
  4. ↑ http://www.zdnet.com/microsoft-sql-server-2014-released-to-manufacturing-7000027439/
  5. ↑ http://www.zdnet.com/microsoft-to-fold-in-memory-database-technology-into-sql-server-next-7000007047/
  6. ↑ http://www.computerworld.com/s/article/9233352/Microsoft_adding_in_memory_technology_to_SQL_Server?taxonomyId=221
  7. ↑ 7.0 7.1 http://www.informationweek.com/software/information-management/microsoft-in-memory-move-challenges-sap/240062566
  8. ↑ http://www.databasejournal.com/news/project-hekaton-microsoft-in-memory-sql-server.html


This article is issued from Wikipedia - version of the 4/6/2015. The text is available under the Creative Commons Attribution/Share Alike but additional terms may apply for the media files.