BT

New Early adopter or innovator? InfoQ has been working on some new features for you. Learn more

Hekaton: In-Memory Transaction Processing Integrated with SQL Server

| by Abel Avram on Nov 09, 2012. Estimated reading time: 1 minute |

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.

Rate this Article

Adoption Stage
Style

Hello stranger!

You need to Register an InfoQ account or or login 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

Login to InfoQ to interact with what matters most to you.


Recover your password...

Follow

Follow your favorite topics and editors

Quick overview of most important highlights in the industry and on the site.

Like

More signal, less noise

Build your own feed by choosing topics you want to read about and editors you want to hear from.

Notifications

Stay up-to-date

Set up your notifications and don't miss out on content that matters to you

BT