Adapting microsoft SQL server for cloud computing

Author

Bernstein, Philip A. ; Cseri, Istvan ; Dani, Nishant ; Ellis, Nigel ; Kalhan, Ajay ; Kakivaya, Gopal ; Lomet, David B. ; Manne, Ramesh ; Novik, Lev ; Talius, Tomas

Author_Institution

Microsoft Corp., Redmond, WA, USA

fYear

2011

fDate

11-16 April 2011

Firstpage

1255

Lastpage

1263

Abstract

Cloud SQL Server is a relational database system designed to scale-out to cloud computing workloads. It uses Microsoft SQL Server as its core. To scale out, it uses a partitioned database on a shared-nothing system architecture. Transactions are constrained to execute on one partition, to avoid the need for two-phase commit. The database is replicated for high availability using a custom primary-copy replication scheme. It currently serves as the storage engine for Microsoft´s Exchange Hosted Archive and SQL Azure.

Keywords

SQL; cloud computing; relational databases; replicated databases; software architecture; Microsoft Exchange Hosted Archive; Microsoft SQL server; SQL Azure; cloud SQL server; cloud computing; custom primary-copy replication scheme; relational database system; shared-nothing system architecture; storage engine; Availability; Data models; Fabrics; Protocols; Relational databases; Servers;

fLanguage

English

Publisher

ieee

Conference_Titel

Data Engineering (ICDE), 2011 IEEE 27th International Conference on

Conference_Location

Hannover

ISSN

1063-6382

Print_ISBN

978-1-4244-8959-6

Electronic_ISBN

1063-6382

Type

conf

DOI

10.1109/ICDE.2011.5767935

Filename

5767935