{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,5,19]],"date-time":"2026-05-19T07:14:14Z","timestamp":1779174854531,"version":"3.51.4"},"reference-count":18,"publisher":"Association for Computing Machinery (ACM)","issue":"12","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2015,8]]},"abstract":"<jats:p>Over the last two releases SQL Server has integrated two specialized engines into the core system: the Apollo column store engine for analytical workloads and the Hekaton in-memory engine for high-performance OLTP workloads. There is an increasing demand for real-time analytics, that is, for running analytical queries and reporting on the same system as transaction processing so as to have access to the freshest data. SQL Server 2016 will include enhancements to column store indexes and in-memory tables that significantly improve performance on such hybrid workloads. This paper describes four such enhancements: column store indexes on in-memory tables, making secondary column store indexes on disk-based tables updatable, allowing B-tree indexes on primary column store indexes, and further speeding up the column store scan oper ator.<\/jats:p>","DOI":"10.14778\/2824032.2824071","type":"journal-article","created":{"date-parts":[[2015,9,16]],"date-time":"2015-09-16T12:18:17Z","timestamp":1442405897000},"page":"1740-1751","source":"Crossref","is-referenced-by-count":67,"title":["Real-time analytical processing with SQL server"],"prefix":"10.14778","volume":"8","author":[{"given":"Per-\u00c5ke","family":"Larson","sequence":"first","affiliation":[{"name":"Microsoft"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Adrian","family":"Birka","sequence":"additional","affiliation":[{"name":"Microsoft"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Eric N.","family":"Hanson","sequence":"additional","affiliation":[{"name":"Microsoft"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Weiyun","family":"Huang","sequence":"additional","affiliation":[{"name":"Microsoft"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Michal","family":"Nowakiewicz","sequence":"additional","affiliation":[{"name":"Microsoft"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Vassilis","family":"Papadimos","sequence":"additional","affiliation":[{"name":"Microsoft"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"320","published-online":{"date-parts":[[2015,8]]},"reference":[{"key":"e_1_2_1_1_1","unstructured":"Kalen Delaney SQL Server In-Memory OLTP Internals Overview Red gate books 2014.  Kalen Delaney SQL Server In-Memory OLTP Internals Overview Red gate books 2014."},{"key":"e_1_2_1_2_1","volume-title":"SIGMOD 2013:  1243--1254 10","author":"Diaconu Cristian"},{"issue":"1","key":"e_1_2_1_3_1","first-page":"22","article-title":"Compilation in the Microsoft SQL Server Hekaton Engine","volume":"37","author":"Freedman Craig","year":"2014","journal-title":"IEEE Data Engeenering. Bulletin"},{"key":"e_1_2_1_4_1","unstructured":"IBM IBM DB2 Analytics Accelerator for z\/OS http:\/\/www03.ibm.com\/software\/products\/en\/db2analacceforzos  IBM IBM DB2 Analytics Accelerator for z\/OS http:\/\/www03.ibm.com\/software\/products\/en\/db2analacceforzos"},{"key":"e_1_2_1_5_1","unstructured":"IBM Informix Warehouse http:\/\/www-01.ibm.com\/software\/data\/informix\/warehouse\/  IBM Informix Warehouse http:\/\/www-01.ibm.com\/software\/data\/informix\/warehouse\/"},{"issue":"2","key":"e_1_2_1_6_1","first-page":"41","volume":"36","author":"Alfons Kemper","year":"2013","journal-title":"IEEE Data Engineering Bulletin"},{"key":"e_1_2_1_7_1","volume-title":"SIGMOD 2011:  1177--1184 10","author":"Larson Per-\u00c5ke","year":"1989"},{"key":"e_1_2_1_8_1","doi-asserted-by":"publisher","DOI":"10.14778\/2095686.2095689"},{"key":"e_1_2_1_9_1","volume-title":"SIGMOD 2013:  1159--1168 10","author":"Larson Per-\u00c5ke"},{"key":"e_1_2_1_10_1","volume-title":"ICDE 2013:  302--313 10","author":"Levandoski Justin J.","year":"2013"},{"key":"e_1_2_1_11_1","unstructured":"Memsql database http:\/\/www.memsql.com\/product\/  Memsql database http:\/\/www.memsql.com\/product\/"},{"key":"e_1_2_1_12_1","unstructured":"Microsoft In-Memory OLTP (In-Memory Optimization) http:\/\/msdn.microsoft.com\/en-us\/library\/dn133186.aspx  Microsoft In-Memory OLTP (In-Memory Optimization) http:\/\/msdn.microsoft.com\/en-us\/library\/dn133186.aspx"},{"key":"e_1_2_1_13_1","unstructured":"Microsoft Columnstore Indexes Described http:\/\/msdn.microsoft.com\/en-us\/library\/gg492088.aspx  Microsoft Columnstore Indexes Described http:\/\/msdn.microsoft.com\/en-us\/library\/gg492088.aspx"},{"key":"e_1_2_1_14_1","unstructured":"Oracle Oracle Database In-Memory http:\/\/www.oracle.com\/technetwork\/database\/in-memory\/overview\/twp-oracle-database-in-memory-2245633.html  Oracle Oracle Database In-Memory http:\/\/www.oracle.com\/technetwork\/database\/in-memory\/overview\/twp-oracle-database-in-memory-2245633.html"},{"key":"e_1_2_1_15_1","unstructured":"Pivotal Greenplum Database http:\/\/pivotal.io\/big-data\/pivotal-greenplum-database  Pivotal Greenplum Database http:\/\/pivotal.io\/big-data\/pivotal-greenplum-database"},{"key":"e_1_2_1_16_1","doi-asserted-by":"publisher","DOI":"10.14778\/2536222.2536233"},{"key":"e_1_2_1_17_1","unstructured":"SAP HANA http:\/\/hana.sap.com\/abouthana.html  SAP HANA http:\/\/hana.sap.com\/abouthana.html"},{"key":"e_1_2_1_18_1","unstructured":"Teradata 14 Hybrid Columnar http:\/\/www.teradata.com\/Resources\/White-Papers\/Teradata-14-Hybrid-Columnar  Teradata 14 Hybrid Columnar http:\/\/www.teradata.com\/Resources\/White-Papers\/Teradata-14-Hybrid-Columnar"}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/2824032.2824071","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,12,28]],"date-time":"2022-12-28T10:10:46Z","timestamp":1672222246000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/2824032.2824071"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2015,8]]},"references-count":18,"journal-issue":{"issue":"12","published-print":{"date-parts":[[2015,8]]}},"alternative-id":["10.14778\/2824032.2824071"],"URL":"https:\/\/doi.org\/10.14778\/2824032.2824071","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2015,8]]}}}