Hekaton (database)

Last updated

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]

Related Research Articles

ZDNet Business technology news website owned by CBS Interactive

ZDNet is a business technology news website published by CBS Interactive, along with TechRepublic. The brand was founded on April 1, 1991, as a general interest technology portal from Ziff Davis and evolved into an enterprise IT-focused online publication owned by CNET Networks.

Microsoft BizTalk Server is an Inter-Organizational Middleware System (IOMS) that enables companies to automate business processes, through the use of adapters which are tailored to communicate with different software systems used in an enterprise. Created by Microsoft, it provides enterprise application integration, business process automation, business-to-business communication, message broker and business activity monitoring.

Microsoft Office 2010 version of the Microsoft Office suite

Microsoft Office 2010 is a version of the Microsoft Office productivity suite for Microsoft Windows. Office 2010 was released to manufacturing on April 15, 2010, and was later made available for retail and online purchase on June 15, 2010. It is the successor to Office 2007 and the predecessor to Office 2013. Research and development of Office 2010 began in 2006, before the release of its predecessor.

Office Online an online office suite offered by Microsoft

Office Online is an online office suite offered by Microsoft, which allows users to create and edit files using lightweight Microsoft Office web apps: Word, Excel, PowerPoint and OneNote. The offering also includes Outlook.com, People, Calendar and OneDrive, all of which are accessible from a unified app switcher. Users can install the on-premises version of this service, called Office Online Server, in private clouds in conjunction with SharePoint, Microsoft Exchange Server and Microsoft Lync Server.

Microsoft Desktop Optimization Pack (MDOP) is a suite of utilities for Microsoft Windows customers who have subscribed to Microsoft Software Assurance program. It aims at bringing easier manageability and monitoring of enterprise desktops, emergency recovery, desktop virtualization and application virtualization.

This is a history of Microsoft Office and its versions. This table only includes final releases and not pre-release or beta software.

Midori was the code name for a managed code operating system being developed by Microsoft with joint effort of Microsoft Research. It had been reported to be a possible commercial implementation of the Singularity operating system, a research project started in 2003 to build a highly dependable operating system in which the kernel, device drivers, and applications are all written in managed code. It was designed for concurrency, and could run a program spread across multiple nodes at once. It also featured a security model that sandboxes applications for increased security. Microsoft had mapped out several possible migration paths from Windows to Midori. The operating system was discontinued some time in 2015, though many of its concepts were rolled into other Microsoft projects.

Microsoft Azure is a cloud computing service created by Microsoft for building, testing, deploying, and managing applications and services through Microsoft-managed data centers. It provides software as a service (SaaS), platform as a service (PaaS) and infrastructure as a service (IaaS) and supports many different programming languages, tools and frameworks, including both Microsoft-specific and third-party software and systems.

Windows Home Server 2011 home server operating system by Microsoft released in 2011

Windows Home Server 2011, code named Vail, is a home server operating system by Microsoft designed for small office/home offices and homes with multiple connected PCs to offer protected file storage, file sharing, automated PC backup, remote access, and remote control of PC desktops. It was released on 6 April 2011 following the release of Power Pack 3 for its aging predecessor, Windows Home Server. Windows Home Server 2011 is the last Windows Home Server release and was succeeded by Windows Server 2012 Essentials.

Resilient File System (ReFS), codenamed "Protogon", is a Microsoft proprietary file system introduced with Windows Server 2012 with the intent of becoming the "next generation" file system after NTFS.

Windows Server 2012 server operating system by Microsoft released in 2012

Windows Server 2012, codenamed "Windows Server 8", is the fifth release of Windows Server. It is the server version of Windows 8 and succeeds Windows Server 2008 R2. Two pre-release versions, a developer preview and a beta version, were released during development. The software was generally available to customers starting on September 4, 2012.

HomeOS is the working title of a home automation operating system that was being developed at Microsoft Research in the early 2010s. Microsoft Research announced the project in 2010.

Server Core Windows Server installation option

Server Core is a minimalistic Microsoft Windows Server installation option, debuted in Windows Server 2008. Server Core provides a server environment with functionality scaled back to core server features, and because of limited features, it has reduced servicing and management requirements, attack surface, disk and memory usage. Andrew Mason, a program manager on the Windows Server team, noted that a primary motivation for producing a Server Core variant of Windows Server 2008 was to reduce the attack surface of the operating system, and that about 70% of the security vulnerabilities in Microsoft Windows from the prior five years would not have affected Server Core. Most notably, no Windows Explorer shell is installed. All configuration and maintenance is done entirely through command-line interface windows, or by connecting to the machine remotely using Microsoft Management Console (MMC), remote server administration tools, and PowerShell.

Docker is a set of platform as a service (PaaS) products that use OS-level virtualization to deliver software in packages called containers. Containers are isolated from one another and bundle their own software, libraries and configuration files; they can communicate with each other through well-defined channels. All containers are run by a single operating-system kernel and are thus more lightweight than virtual machines.

Mary Jo Foley American podcaster, author, and blogger

Mary Jo Foley is an American freelance technology writer, author, podcaster and news editor. She regularly writes news, previews, and reviews for Microsoft's strategy, products and technology. Foley has been covering news on Microsoft Windows, and previously on Unix-related technology, since 1983, for publications including ZDNet, eWeek, Baseline, Redmond magazine and PC Magazine.

Hybrid transaction/analytical processing (HTAP), a term created by Gartner Inc. – an information technology research and advisory company. As defined by Gartner:

Hybrid transaction/analytical processing (HTAP) is an emerging application architecture that "breaks the wall" between transaction processing and analytics. It enables more informed and "in business real time" decision making.

Microsoft Edge Web browser developed by Microsoft

Microsoft Edge is a web browser developed by Microsoft. It was first released for Windows 10 and Xbox One in 2015, then for Android and iOS in 2017, and for macOS in 2019.

Windows Server 2016 Microsoft Windows Server operating system released in 2016

Windows Server 2016 is a server operating system developed by Microsoft as part of the Windows NT family of operating systems, developed concurrently with Windows 10. The first early preview version became available on October 1, 2014 together with the first technical preview of System Center. Windows Server 2016 was released on September 26, 2016 at Microsoft's Ignite conference and became generally available on October 12, 2016. It has two successors: Windows Server 2019, and the Windows Server Semi-Annual Channel, which excludes the graphical user interface and many older components.

Windows 10 has twelve editions, all with varying feature sets, use cases, or intended devices. Certain editions are distributed only on devices directly from an original equipment manufacturer (OEM), while editions such as Enterprise and Education are only available through volume licensing channels. Microsoft also makes editions of Windows 10 available to device manufacturers for use on specific classes of devices, including smartphones and IoT devices.

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". 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". 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.