Yesquel: Scalable SQL storage for Web applications

Marcos K. Aguilera; Joshua B. Leners; Michael Walfish

doi:10.1145/2815400.2815413

Yesquel: Scalable SQL storage for Web applications

Marcos K. Aguilera, Joshua B. Leners, Michael Walfish

Computer Science

Research output: Chapter in Book/Report/Conference proceeding › Conference contribution

Abstract

Web applications have been shifting their storage systems from SQL to NOSQL systems. NOSQL systems scale well but drop many convenient SQL features, such as joins, secondary indexes, and/or transactions. We design, develop, and evaluate Yesquel, a system that provides performance and scalability comparable to NOSQL with all the features of a SQL relational system. Yesquel has a new architecture and a new distributed data structure, called YDBT, which Yesquel uses for storage, and which performs well under contention by many concurrent clients. We evaluate Yesquel and find that Yesquel performs almost as well as Redis - a popular NOSQL system-and much better than MYSQL Cluster, while handling SQL queries at scale.

Original language	English (US)
Title of host publication	SOSP 2015 - Proceedings of the 25th ACM Symposium on Operating Systems Principles
Publisher	Association for Computing Machinery, Inc
Pages	245-262
Number of pages	18
ISBN (Electronic)	9781450338349
DOIs	https://doi.org/10.1145/2815400.2815413
State	Published - Oct 4 2015
Event	25th ACM Symposium on Operating Systems Principles, SOSP 2015 - Monterey, United States Duration: Oct 5 2015 → Oct 7 2015

Publication series

Name	SOSP 2015 - Proceedings of the 25th ACM Symposium on Operating Systems Principles

Other

Other	25th ACM Symposium on Operating Systems Principles, SOSP 2015
Country/Territory	United States
City	Monterey
Period	10/5/15 → 10/7/15

ASJC Scopus subject areas

Hardware and Architecture
Software
Electrical and Electronic Engineering
Computer Science Applications

Access to Document

10.1145/2815400.2815413

Cite this

Aguilera, M. K., Leners, J. B., & Walfish, M. (2015). Yesquel: Scalable SQL storage for Web applications. In SOSP 2015 - Proceedings of the 25th ACM Symposium on Operating Systems Principles (pp. 245-262). (SOSP 2015 - Proceedings of the 25th ACM Symposium on Operating Systems Principles). Association for Computing Machinery, Inc. https://doi.org/10.1145/2815400.2815413

Yesquel: Scalable SQL storage for Web applications. / Aguilera, Marcos K.; Leners, Joshua B.; Walfish, Michael.
SOSP 2015 - Proceedings of the 25th ACM Symposium on Operating Systems Principles. Association for Computing Machinery, Inc, 2015. p. 245-262 (SOSP 2015 - Proceedings of the 25th ACM Symposium on Operating Systems Principles).

Research output: Chapter in Book/Report/Conference proceeding › Conference contribution

Aguilera, MK, Leners, JB & Walfish, M 2015, Yesquel: Scalable SQL storage for Web applications. in SOSP 2015 - Proceedings of the 25th ACM Symposium on Operating Systems Principles. SOSP 2015 - Proceedings of the 25th ACM Symposium on Operating Systems Principles, Association for Computing Machinery, Inc, pp. 245-262, 25th ACM Symposium on Operating Systems Principles, SOSP 2015, Monterey, United States, 10/5/15. https://doi.org/10.1145/2815400.2815413

@inproceedings{876e2d2a8ce34d5b8e706072b5bcf478,

title = "Yesquel: Scalable SQL storage for Web applications",

abstract = "Web applications have been shifting their storage systems from SQL to NOSQL systems. NOSQL systems scale well but drop many convenient SQL features, such as joins, secondary indexes, and/or transactions. We design, develop, and evaluate Yesquel, a system that provides performance and scalability comparable to NOSQL with all the features of a SQL relational system. Yesquel has a new architecture and a new distributed data structure, called YDBT, which Yesquel uses for storage, and which performs well under contention by many concurrent clients. We evaluate Yesquel and find that Yesquel performs almost as well as Redis - a popular NOSQL system-and much better than MYSQL Cluster, while handling SQL queries at scale.",

author = "Aguilera, {Marcos K.} and Leners, {Joshua B.} and Michael Walfish",

year = "2015",

month = oct,

day = "4",

doi = "10.1145/2815400.2815413",

language = "English (US)",

series = "SOSP 2015 - Proceedings of the 25th ACM Symposium on Operating Systems Principles",

publisher = "Association for Computing Machinery, Inc",

pages = "245--262",

booktitle = "SOSP 2015 - Proceedings of the 25th ACM Symposium on Operating Systems Principles",

}

TY - GEN

T1 - Yesquel

T2 - 25th ACM Symposium on Operating Systems Principles, SOSP 2015

AU - Aguilera, Marcos K.

AU - Leners, Joshua B.

AU - Walfish, Michael

PY - 2015/10/4

Y1 - 2015/10/4

N2 - Web applications have been shifting their storage systems from SQL to NOSQL systems. NOSQL systems scale well but drop many convenient SQL features, such as joins, secondary indexes, and/or transactions. We design, develop, and evaluate Yesquel, a system that provides performance and scalability comparable to NOSQL with all the features of a SQL relational system. Yesquel has a new architecture and a new distributed data structure, called YDBT, which Yesquel uses for storage, and which performs well under contention by many concurrent clients. We evaluate Yesquel and find that Yesquel performs almost as well as Redis - a popular NOSQL system-and much better than MYSQL Cluster, while handling SQL queries at scale.

AB - Web applications have been shifting their storage systems from SQL to NOSQL systems. NOSQL systems scale well but drop many convenient SQL features, such as joins, secondary indexes, and/or transactions. We design, develop, and evaluate Yesquel, a system that provides performance and scalability comparable to NOSQL with all the features of a SQL relational system. Yesquel has a new architecture and a new distributed data structure, called YDBT, which Yesquel uses for storage, and which performs well under contention by many concurrent clients. We evaluate Yesquel and find that Yesquel performs almost as well as Redis - a popular NOSQL system-and much better than MYSQL Cluster, while handling SQL queries at scale.

UR - http://www.scopus.com/inward/record.url?scp=84957959060&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=84957959060&partnerID=8YFLogxK

U2 - 10.1145/2815400.2815413

DO - 10.1145/2815400.2815413

M3 - Conference contribution

AN - SCOPUS:84957959060

T3 - SOSP 2015 - Proceedings of the 25th ACM Symposium on Operating Systems Principles

SP - 245

EP - 262

BT - SOSP 2015 - Proceedings of the 25th ACM Symposium on Operating Systems Principles

PB - Association for Computing Machinery, Inc

Y2 - 5 October 2015 through 7 October 2015

ER -

Yesquel: Scalable SQL storage for Web applications

Abstract

Publication series

Other

ASJC Scopus subject areas

Access to Document

Other files and links

Fingerprint

Cite this