BT

Hekaton: In-Memory Transaction Processing Integrated with SQL Server

by Abel Avram on Nov 09, 2012 |

During the Professional Association of SQL Server (PASS) Summit 2012, a technical conference for SQL Server professionals, Microsoft announced Hekaton, an in-memory row-based data management system targeted at transaction processing (TP) workloads. Besides the advertised increase in TP speeds of up to 10x for old applications and up to 50x for new optimized ones, Microsoft touts Hekaton as being fully integrated into SQL Server.

Existing applications may benefit from the new database technology by determining the most used tables with the help of a tool, then setting the server to store those tables in a system’s main memory in memory-optimized data structures for faster access time, while the rest of data will reside in traditional storage-optimized structures that can be paged in or out to disk when necessary.

Until now, SQL Server has compiled queries and stored procedures into data structures that are interpreted by the query processor, but Hekaton compiles T-SQL stored procedures directly into native code for faster execution.

Hekaton uses a new concurrency control mechanism (PDF) developed by Microsoft and researchers from the University of Wisconsin using lock-free data structures for better scalability across multiple cores, avoiding locks while preserving ACID transaction integrity.

Hekaton is currently in tests by selected partners of Microsoft, and will be included in the next major version of SQL Server. When it is released, Hekaton will compete with SAP Hana, a stand alone appliance and database for real-time analytics released in 2010, and Oracle Exadata X3, also an appliance running Oracle Database 11g, which keeps hot data in solid-state storage.

Microsoft has announced a new version of SQL Server 2012 Parallel Data Warehouse (PDW), an SQL Server appliance, to be made available during first half of 2013.

Hello stranger!

You need to Register an InfoQ account or to post comments. But there's so much more behind being registered.

Get the most out of the InfoQ experience.

Tell us what you think

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

Finally? by Mark N

I saw this posted on Computerworld. One commenter said that Oracle has had this for 2 versions.

Anyway, just remember that this is just another tool in the tool chest. It will work for certain classes of issues, but it is purely a performance enhancement and limited to the (and to a) database server.

howtojboss.com/2012/11/07/data-grid-why/

Re: Finally? by Roopesh Shenoy

Just confirming - is the Oracle in-memory offering integrated into their main database product itself or it is a separate add-on?

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

2 Discuss

Educational Content

General Feedback
Bugs
Advertising
Editorial
InfoQ.com and all content copyright © 2006-2013 C4Media Inc. InfoQ.com hosted at Contegix, the best ISP we've ever worked with.
Privacy policy
BT