DB-risk: The game of global database placement

Victor Zakhary, Faisal Nawab, Divyakant Agrawal, Amr El Abbadi

Research output: Chapter in Book/Report/Conference proceedingConference contribution

4 Citations (Scopus)

Abstract

Geo-replication is the process of maintaining copies of data at geographically dispersed datacenters for better availability and fault-tolerance. The distinguishing characteristic of geo-replication is the large wide-area latency between datacenters that varies widely depending on the location of the datacenters. Thus, choosing which datacenters to deploy a cloud application has a direct impact on the observable response time. We propose an optimization framework that automatically derives a geo-replication placement plan with the objective of minimizing latency. By running the optimization framework on real placement scenarios, we learn a set of placement optimizations for geo-replication. Some of these optimizations are surprising while others are in retrospect straight-forward. In this demonstration, we highlight the geo-replication placement optimizations through the DB-Risk game. DB-Risk invites players to create different placement scenarios while experimenting with the proposed optimizations. The placements created by the players are tested on real cloud deployments.

Original languageEnglish
Title of host publicationSIGMOD 2016 - Proceedings of the 2016 International Conference on Management of Data
PublisherAssociation for Computing Machinery
Pages2185-2188
Number of pages4
Volume26-June-2016
ISBN (Electronic)9781450335317
DOIs
Publication statusPublished - 26 Jun 2016
Externally publishedYes
Event2016 ACM SIGMOD International Conference on Management of Data, SIGMOD 2016 - San Francisco, United States
Duration: 26 Jun 20161 Jul 2016

Other

Other2016 ACM SIGMOD International Conference on Management of Data, SIGMOD 2016
CountryUnited States
CitySan Francisco
Period26/6/161/7/16

Fingerprint

Fault tolerance
Demonstrations
Availability

Keywords

  • Geo-replication
  • Placement
  • Transactions

ASJC Scopus subject areas

  • Software
  • Information Systems

Cite this

Zakhary, V., Nawab, F., Agrawal, D., & El Abbadi, A. (2016). DB-risk: The game of global database placement. In SIGMOD 2016 - Proceedings of the 2016 International Conference on Management of Data (Vol. 26-June-2016, pp. 2185-2188). Association for Computing Machinery. https://doi.org/10.1145/2882903.2899405

DB-risk : The game of global database placement. / Zakhary, Victor; Nawab, Faisal; Agrawal, Divyakant; El Abbadi, Amr.

SIGMOD 2016 - Proceedings of the 2016 International Conference on Management of Data. Vol. 26-June-2016 Association for Computing Machinery, 2016. p. 2185-2188.

Research output: Chapter in Book/Report/Conference proceedingConference contribution

Zakhary, V, Nawab, F, Agrawal, D & El Abbadi, A 2016, DB-risk: The game of global database placement. in SIGMOD 2016 - Proceedings of the 2016 International Conference on Management of Data. vol. 26-June-2016, Association for Computing Machinery, pp. 2185-2188, 2016 ACM SIGMOD International Conference on Management of Data, SIGMOD 2016, San Francisco, United States, 26/6/16. https://doi.org/10.1145/2882903.2899405
Zakhary V, Nawab F, Agrawal D, El Abbadi A. DB-risk: The game of global database placement. In SIGMOD 2016 - Proceedings of the 2016 International Conference on Management of Data. Vol. 26-June-2016. Association for Computing Machinery. 2016. p. 2185-2188 https://doi.org/10.1145/2882903.2899405
Zakhary, Victor ; Nawab, Faisal ; Agrawal, Divyakant ; El Abbadi, Amr. / DB-risk : The game of global database placement. SIGMOD 2016 - Proceedings of the 2016 International Conference on Management of Data. Vol. 26-June-2016 Association for Computing Machinery, 2016. pp. 2185-2188
@inproceedings{7c22b70ed83b47a0b42da3662667c986,
title = "DB-risk: The game of global database placement",
abstract = "Geo-replication is the process of maintaining copies of data at geographically dispersed datacenters for better availability and fault-tolerance. The distinguishing characteristic of geo-replication is the large wide-area latency between datacenters that varies widely depending on the location of the datacenters. Thus, choosing which datacenters to deploy a cloud application has a direct impact on the observable response time. We propose an optimization framework that automatically derives a geo-replication placement plan with the objective of minimizing latency. By running the optimization framework on real placement scenarios, we learn a set of placement optimizations for geo-replication. Some of these optimizations are surprising while others are in retrospect straight-forward. In this demonstration, we highlight the geo-replication placement optimizations through the DB-Risk game. DB-Risk invites players to create different placement scenarios while experimenting with the proposed optimizations. The placements created by the players are tested on real cloud deployments.",
keywords = "Geo-replication, Placement, Transactions",
author = "Victor Zakhary and Faisal Nawab and Divyakant Agrawal and {El Abbadi}, Amr",
year = "2016",
month = "6",
day = "26",
doi = "10.1145/2882903.2899405",
language = "English",
volume = "26-June-2016",
pages = "2185--2188",
booktitle = "SIGMOD 2016 - Proceedings of the 2016 International Conference on Management of Data",
publisher = "Association for Computing Machinery",

}

TY - GEN

T1 - DB-risk

T2 - The game of global database placement

AU - Zakhary, Victor

AU - Nawab, Faisal

AU - Agrawal, Divyakant

AU - El Abbadi, Amr

PY - 2016/6/26

Y1 - 2016/6/26

N2 - Geo-replication is the process of maintaining copies of data at geographically dispersed datacenters for better availability and fault-tolerance. The distinguishing characteristic of geo-replication is the large wide-area latency between datacenters that varies widely depending on the location of the datacenters. Thus, choosing which datacenters to deploy a cloud application has a direct impact on the observable response time. We propose an optimization framework that automatically derives a geo-replication placement plan with the objective of minimizing latency. By running the optimization framework on real placement scenarios, we learn a set of placement optimizations for geo-replication. Some of these optimizations are surprising while others are in retrospect straight-forward. In this demonstration, we highlight the geo-replication placement optimizations through the DB-Risk game. DB-Risk invites players to create different placement scenarios while experimenting with the proposed optimizations. The placements created by the players are tested on real cloud deployments.

AB - Geo-replication is the process of maintaining copies of data at geographically dispersed datacenters for better availability and fault-tolerance. The distinguishing characteristic of geo-replication is the large wide-area latency between datacenters that varies widely depending on the location of the datacenters. Thus, choosing which datacenters to deploy a cloud application has a direct impact on the observable response time. We propose an optimization framework that automatically derives a geo-replication placement plan with the objective of minimizing latency. By running the optimization framework on real placement scenarios, we learn a set of placement optimizations for geo-replication. Some of these optimizations are surprising while others are in retrospect straight-forward. In this demonstration, we highlight the geo-replication placement optimizations through the DB-Risk game. DB-Risk invites players to create different placement scenarios while experimenting with the proposed optimizations. The placements created by the players are tested on real cloud deployments.

KW - Geo-replication

KW - Placement

KW - Transactions

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

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

U2 - 10.1145/2882903.2899405

DO - 10.1145/2882903.2899405

M3 - Conference contribution

AN - SCOPUS:84979695360

VL - 26-June-2016

SP - 2185

EP - 2188

BT - SIGMOD 2016 - Proceedings of the 2016 International Conference on Management of Data

PB - Association for Computing Machinery

ER -