Name
Abstract | ||
|---|---|---|
The SQL Server 11 release (code named "Denali") introduces a new data warehouse query acceleration feature based on a new index type called a column store index. The new index type combined with new query operators processing batches of rows greatly improves data warehouse query performance: in some cases by hundreds of times and routinely a tenfold speedup for a broad range of decision support queries. Column store indexes are fully integrated with the rest of the system, including query processing and optimization. This paper gives an overview of the design and implementation of column store indexes including enhancements to query processing and query optimization to take full advantage of the new indexes. The resulting performance improvements are illustrated by a number of example queries. |
Year | DOI | Venue |
|---|---|---|
2011 | 10.1145/1989323.1989448 | SIGMOD Conference |
Keywords | Field | DocType |
new index,column store index,query optimization,decision support query,new data warehouse query,sql server column store,example query,data warehouse query performance,query processing,new query operator,new index type,data warehouse,indexation,olap,decision support,data warehousing | Query optimization,Data warehouse,Data mining,Web search query,Query expansion,Computer science,Sargable,Query by Example,Spatial query,Database,Speedup | Conference |
Citations | PageRank | References |
36 | 1.37 | 9 |
Authors | ||
8 | ||
Name | Order | Citations | PageRank |
|---|---|---|---|
| Per-åke Larson | 1 | 3262 | 973.94 |
| Cipri Clinciu | 2 | 72 | 3.06 |
| Eric N. Hanson | 3 | 917 | 376.11 |
| Artem Oks | 4 | 36 | 1.37 |
| Susan L. Price | 5 | 215 | 16.84 |
| Srikumar Rangarajan | 6 | 67 | 2.58 |
| Aleksandras Surna | 7 | 64 | 3.23 |
| QingQing Zhou | 8 | 41 | 3.80 |