Paper Info
Title
Evolving the architecture of SQL Server for modern hardware trends
Abstract
The basic architecture of SQL Server, as well as other major database systems, goes back to a time when main memories were (very) small, data lived on disk, machines had a single (slow) processor, and OLTP was the only workload that mattered. This is not an optimal design for today's environment with large main memories, plenty of cores, and where transactional and analytical processing are equally important. To adapt to these trends and take advantage of the opportunities they offer SQL Server has added support for column store indexes and in-memory tables over the last two releases. The two features are aimed at dramatically improving performance on analytical and transactional workloads, respectively. This paper gives an overview of the design of the two features and the performance improvements they provide.
Year
DOI
Venue
2015
10.1109/ICDE.2015.7113371
Data Engineering
Keywords
Field
DocType
sql,data mining,transaction processing,oltp,sql server architecture,analytical processing,database systems,inmemory tables,modern hardware trends,optimal design,transactional processing,engines,indexes,dictionaries,concurrency control,market research,servers
Data mining,Business Intelligence Markup Language,Concurrency control,Computer science,In-Memory Processing,Online transaction processing,Server,Data Transformation Services,Data definition language,User-defined function,Database
Conference
ISSN
Citations 
PageRank 
1084-4627
3
0.39
References 
Authors
6
3
Name
Order
Citations
PageRank
Per-åke Larson13262973.94
Eric N. Hanson2917376.11
Mike Zwilling327711.98