research-article

Socrates: The New SQL Server in the Cloud

Authors:

Panagiotis Antonopoulos,

Cristian Diaconu,

Alejandro Hernandez Saenz,

Hanuma Kodavalla,

Donald Kossmann,

Sandeep Lingam,

Umar Farooq Minhas,

Naveen Prakash,

Vijendra Purohit,

Chaitanya Sreenivas Ravella,

Krystyna Reisteter,

Sheetal Shrotri,

Dixin Tang, and

Vikram WakadeAuthors Info & Claims

SIGMOD '19: Proceedings of the 2019 International Conference on Management of Data

June 2019

Pages 1743 - 1756

https://doi.org/10.1145/3299869.3314047

Published: 25 June 2019 Publication History

Abstract

The database-as-a-service paradigm in the cloud (DBaaS) is becoming increasingly popular. Organizations adopt this paradigm because they expect higher security, higher availability, and lower and more flexible cost with high performance. It has become clear, however, that these expectations cannot be met in the cloud with the traditional, monolithic database architecture. This paper presents a novel DBaaS architecture, called Socrates. Socrates has been implemented in Microsoft SQL Server and is available in Azure as SQL DB Hyperscale. This paper describes the key ideas and features of Socrates, and it compares the performance of Socrates with the previous SQL DB offering in Azure.

References

[1]

Hal Berenson, Phil Bernstein, Jim Gray, Jim Melton, Elizabeth O'Neil, and Patrick O'Neil. 1995. A Critique of ANSI SQL Isolation Levels. In Proceedings of the 1995 ACM SIGMOD International Conference on Management of Data (SIGMOD '95). ACM, New York, NY, USA, 1--10.

Digital Library

[2]

Philip A. Bernstein, Colin W. Reid, and Sudipto Das. 2011. Hyder - A Transactional Record Manager for Shared Flash. In CIDR 2011, Fifth Biennial Conference on Innovative Data Systems Research, Asilomar, CA, USA, January 9--12, 2011, Online Proceedings. www.cidrdb.org, 9--20. http://cidrdb.org/cidr2011/Papers/CIDR11_Paper2.pdf

[3]

Dhruba Borthakur. {n. d.}. The Birth of RocksDB-Cloud . http://rocksdb.blogspot.com/2017/05/the-birth-of-rocksdb-cloud.html .

[4]

Peter Braam, Sean Roberts, Matthew O'Keefe, and David Bonnie. {n. d.}. The Limits of Open Source in Extreme-scale Storage Systems Design. https://docplayer.net/62056362-The-limits-of-open-source-in-extreme-scale-storage-systems-design.html .

[5]

Matthias Brantner, Daniela Florescu, David Graf, Donald Kossmann, and Tim Kraska. 2008. Building a Database on S3. In Proceedings of the 2008 ACM SIGMOD International Conference on Management of Data (SIGMOD '08). ACM, New York, NY, USA, 251--264.

Digital Library

[6]

Alain Bui and Hacè ne Fouchal (Eds.). 2002. Procedings of the 6th International Conference on Principles of Distributed Systems. OPODIS 2002, Reims, France, December 11--13, 2002. Studia Informatica Universalis, Vol. 3. Suger, Saint-Denis, rue Catulienne, France.

[7]

Brad Calder, Ju Wang, Aaron Ogus, Niranjan Nilakantan, Arild Skjolsvold, Sam McKelvie, Yikang Xu, Shashwat Srivastav, Jiesheng Wu, Huseyin Simitci, Jaidev Haridas, Chakravarthy Uddaraju, Hemal Khatri, Andrew Edwards, Vaman Bedekar, Shane Mainali, Rafay Abbasi, Arpit Agarwal, Mian Fahim ul Haq, Muhammad Ikram ul Haq, Deepali Bhardwaj, Sowmya Dayanand, Anitha Adusumilli, Marvin McNett, Sriram Sankaran, Kavitha Manivannan, and Leonidas Rigas. 2011. Windows Azure Storage: a highly available cloud storage service with strong consistency. In Proceedings of the 23rd ACM Symposium on Operating Systems Principles 2011, SOSP 2011, Cascais, Portugal, October 23--26, 2011, Ted Wobber and Peter Druschel (Eds.). ACM, 143--157.

Digital Library

[8]

James C. Corbett, Jeffrey Dean, Michael Epstein, Andrew Fikes, Christopher Frost, JJ Furman, Sanjay Ghemawat, Andrey Gubarev, Christopher Heiser, Peter Hochschild, Wilson Hsieh, Sebastian Kanthak, Eugene Kogan, Hongyi Li, Alexander Lloyd, Sergey Melnik, David Mwaura, David Nagle, Sean Quinlan, Rajesh Rao, Lindsay Rolig, Dale Woodford, Yasushi Saito, Christopher Taylor, Michal Szymaniak, and Ruth Wang. 2012. Spanner: Google's Globally-Distributed Database. In OSDI .

[9]

Michael J. Franklin, Bjö rn Þó r Jó nsson, and Donald Kossmann. 1996. Performance Tradeoffs for Client-Server Query Processing. In Proceedings of the 1996 ACM SIGMOD International Conference on Management of Data, Montreal, Quebec, Canada, June 4--6, 1996., H. V. Jagadish and Inderpal Singh Mumick (Eds.). ACM Press, 149--160.

Digital Library

[10]

Jim Gray, Pat Helland, Patrick E. O'Neil, and Dennis E. Shasha. 1996. The Dangers of Replication and a Solution. In Proceedings of the 1996 ACM SIGMOD International Conference on Management of Data, Montreal, Quebec, Canada, June 4--6, 1996. 173--182.

Digital Library

[11]

Jim Gray and Andreas Reuter. 1990. Transaction Processing: Concepts and Techniques .

Digital Library

[12]

Per-Åke Larson, Spyros Blanas, Cristian Diaconu, Craig Freedman, Jignesh M. Patel, and Mike Zwilling. 2011. High-Performance Concurrency Control Mechanisms for Main-Memory Databases. PVLDB, Vol. 5, 4 (2011), 298--309.

Digital Library

[13]

Simon Loesing, Markus Pilman, Thomas Etter, and Donald Kossmann. 2015. On the Design and Scalability of Distributed Shared-Data Databases. In Proceedings of the 2015 ACM SIGMOD International Conference on Management of Data, Melbourne, Victoria, Australia, May 31 - June 4, 2015, Timos K. Sellis, Susan B. Davidson, and Zachary G. Ives (Eds.). ACM, 663--676.

Digital Library

[14]

David B. Lomet, Alan Fekete, Gerhard Weikum, and Michael J. Zwilling. 2009. Unbundling Transaction Services in the Cloud. In CIDR 2009, Fourth Biennial Conference on Innovative Data Systems Research, Asilomar, CA, USA, January 4--7, 2009, Online Proceedings . http://www-db.cs.wisc.edu/cidr/cidr2009/Paper_53.pdf

[15]

C. Mohan, Don Haderle, Bruce Lindsay, Hamid Pirahesh, and Peter Schwarz. 1992. ARIES: A Transaction Recovery Method Supporting Fine-granularity Locking and Partial Rollbacks Using Write-ahead Logging. ACM Trans. Database Syst., Vol. 17, 1 (March 1992), 94--162.

Digital Library

[16]

Mendel Rosenblum and John K. Ousterhout. 1992. The Design and Implementation of a Log-Structured File System. ACM Trans. Comput. Syst., Vol. 10, 1 (1992), 26--52.

Digital Library

[17]

Alexandre Verbitski, Anurag Gupta, Debanjan Saha, Murali Brahmadesam, Kamal Gupta, Raman Mittal, Sailesh Krishnamurthy, Sandor Maurice, Tengiz Kharatishvili, and Xiaofeng Bao. 2017. Amazon Aurora: Design Considerations for High Throughput Cloud-Native Relational Databases. In Proceedings of the 2017 ACM International Conference on Management of Data (SIGMOD '17). ACM, New York, NY, USA, 1041--1052.

Digital Library

Cited By

Yang XZhang YChen HSun CLi FZhou W(2023)PolarDB-SCC: A Cloud-Native Database Ensuring Low Latency for Strongly Consistent ReadsProceedings of the VLDB Endowment10.14778/3611540.361156216:12(3754-3767)Online publication date: 1-Aug-2023
https://dl.acm.org/doi/10.14778/3611540.3611562
Depoutovitch AChen CLarson PNg JLin SXiong GLee PBoctor ERen SWu LZhang YSun C(2023)Taurus MM: Bringing Multi-Master to the CloudProceedings of the VLDB Endowment10.14778/3611540.361154216:12(3488-3500)Online publication date: 1-Aug-2023
https://dl.acm.org/doi/10.14778/3611540.3611542
Coelho FAlonso AFerreira LPereira JOliveira R(2023)Loom: A Closed-Box Disaggregated Database SystemProceedings of the 12th Latin-American Symposium on Dependable and Secure Computing10.1145/3615366.3615424(30-39)Online publication date: 16-Oct-2023
https://dl.acm.org/doi/10.1145/3615366.3615424
Show More Cited By

Index Terms

Socrates: The New SQL Server in the Cloud
1. Information systems
  1. Data management systems
    1. Database management system engines
      1. DBMS engine architectures

Recommendations

The Snowflake Elastic Data Warehouse
SIGMOD '16: Proceedings of the 2016 International Conference on Management of Data

We live in the golden age of distributed computing. Public cloud platforms now offer virtually unlimited compute and storage resources on demand. At the same time, the Software-as-a-Service (SaaS) model brings enterprise-class systems to users who ...
Read More
soCloud: a service-oriented component-based PaaS for managing portability, provisioning, elasticity, and high availability across multiple clouds

Multi-cloud computing is a promising paradigm to support very large scale world wide distributed applications. Multi-cloud computing is the usage of multiple, independent cloud environments, which assumed no priori agreement between cloud providers or ...
Read More
MCDB: Using Multi-clouds to Ensure Security in Cloud Computing
DASC '11: Proceedings of the 2011 IEEE Ninth International Conference on Dependable, Autonomic and Secure Computing

Security is considered to be one of the most critical aspects in a cloud computing environment due to the sensitive and important information stored in the cloud for users. Users are wondering about attacks on the integrity and the availability of their ...
Read More

Comments

Information & Contributors

Information

Published In

cover image ACM Conferences

SIGMOD '19: Proceedings of the 2019 International Conference on Management of Data

June 2019

2106 pages

ISBN:9781450356435

DOI:10.1145/3299869

General Chairs:
Peter Boncz
CWI & Vrije Universiteit Amsterdam, The Netherlands
,
Stefan Manegold
CWI & Universiteit Leiden, The Netherlands
,
Program Chairs:
Anastasia Ailamaki
EPFL, Switzerland
,
Amol Deshpande
University of Maryland, USA
,
Tim Kraska
MIT, USA

Copyright © 2019 ACM.

Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Sponsors

SIGMOD: ACM Special Interest Group on Management of Data

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 25 June 2019

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Author Tags

Qualifiers

Research-article

Conference

SIGMOD/PODS '19

Sponsor:

SIGMOD

SIGMOD/PODS '19: International Conference on Management of Data

June 30 - July 5, 2019

Amsterdam, Netherlands

Acceptance Rates

SIGMOD '19 Paper Acceptance Rate 88 of 430 submissions, 20%;

Overall Acceptance Rate 785 of 4,003 submissions, 20%

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

34
Total Citations
View Citations
992
Total Downloads

Downloads (Last 12 months)119
Downloads (Last 6 weeks)9

Other Metrics

View Author Metrics

Citations

Cited By

Yang XZhang YChen HSun CLi FZhou W(2023)PolarDB-SCC: A Cloud-Native Database Ensuring Low Latency for Strongly Consistent ReadsProceedings of the VLDB Endowment10.14778/3611540.361156216:12(3754-3767)Online publication date: 1-Aug-2023
https://dl.acm.org/doi/10.14778/3611540.3611562
Depoutovitch AChen CLarson PNg JLin SXiong GLee PBoctor ERen SWu LZhang YSun C(2023)Taurus MM: Bringing Multi-Master to the CloudProceedings of the VLDB Endowment10.14778/3611540.361154216:12(3488-3500)Online publication date: 1-Aug-2023
https://dl.acm.org/doi/10.14778/3611540.3611542
Coelho FAlonso AFerreira LPereira JOliveira R(2023)Loom: A Closed-Box Disaggregated Database SystemProceedings of the 12th Latin-American Symposium on Dependable and Secure Computing10.1145/3615366.3615424(30-39)Online publication date: 16-Oct-2023
https://dl.acm.org/doi/10.1145/3615366.3615424
Margara ACugola GFelicioni NCilloni S(2023)A Model and Survey of Distributed Data-Intensive SystemsACM Computing Surveys10.1145/360480156:1(1-69)Online publication date: 26-Aug-2023
https://dl.acm.org/doi/10.1145/3604801
Ferreira Loff JPorto DGarcia JMace JRodrigues RDruschel PKaufmann AMace JFlinn JSeltzer M(2023)Antipode: Enforcing Cross-Service Causal Consistency in Distributed ApplicationsProceedings of the 29th Symposium on Operating Systems Principles10.1145/3600006.3613176(298-313)Online publication date: 23-Oct-2023
https://dl.acm.org/doi/10.1145/3600006.3613176
Ruan CZhang YBi CMa XChen HLi FYang XLi CAboulnaga AXu YAamodt TJerger NSwift M(2023)Persistent Memory Disaggregation for Cloud-Native Relational DatabasesProceedings of the 28th ACM International Conference on Architectural Support for Programming Languages and Operating Systems, Volume 310.1145/3582016.3582055(498-512)Online publication date: 25-Mar-2023
https://dl.acm.org/doi/10.1145/3582016.3582055
Wang JZhang QDas SPandis ISelçuk Candan KAmer-Yahia S(2023)Disaggregated Database SystemsCompanion of the 2023 International Conference on Management of Data10.1145/3555041.3589403(37-44)Online publication date: 4-Jun-2023
https://dl.acm.org/doi/10.1145/3555041.3589403
Sun JMa HZhang LLiu HShi HLuo SWu KBruhwiler KZhu CNie YChen JZhang LLiang Y(2023)Accelerating Cloud-Native Databases with Distributed PMem Stores2023 IEEE 39th International Conference on Data Engineering (ICDE)10.1109/ICDE55515.2023.00233(3043-3057)Online publication date: Apr-2023
https://doi.org/10.1109/ICDE55515.2023.00233
Wang RWang JKadam PTamer Özsu MAref W(2023)dLSM: An LSM-Based Index for Memory Disaggregation2023 IEEE 39th International Conference on Data Engineering (ICDE)10.1109/ICDE55515.2023.00217(2835-2849)Online publication date: Apr-2023
https://doi.org/10.1109/ICDE55515.2023.00217
Guo ZZeng XWu KHwang WRen ZYu XBalakrishnan MBernstein P(2022)CornusProceedings of the VLDB Endowment10.14778/3565816.356583716:2(379-392)Online publication date: 23-Nov-2022
https://dl.acm.org/doi/10.14778/3565816.3565837
Show More Cited By

View Options

Get Access

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Full Access

Get this Publication

View options

PDF

View or Download as a PDF file.

eReader

View online with eReader.

Media

Figures

Other

Tables

View Table of Contents