skip to main content
10.1145/1698790.1698800acmotherconferencesArticle/Chapter ViewAbstractPublication PagesedbtConference Proceedingsconference-collections
research-article

P2P based hosting system for scalable replicated databases

Published: 22 March 2009 Publication History

Abstract

We propose a large-scale peer-to-peer database hosting system capable to efficiently replicate and manage databases accessed worldwide. This proposal is twofold: the transparent replication and management of database replicas over a peer-to-peer network, and the provision of a replica control middleware that guarantees the 1-copy snapshot isolation correctness criterion, thanks to a scheduler-based certification protocol. This paper focuses on the system architecture and how this architecture is deployed over a P2P network. Though the evaluation of our prototype is still under way, we argue that this database replica hosting system will boost the performance of database-intensive applications accessed by clients distributed world-wide.

References

[1]
J. E. Armendariz-Inigo, A. Mauch-Goya, J. R. Gonzalez de Mendivil, and F. D. Munoz-Escoi. Sipre: A partial database replication protocol with si replicas. In Annual ACM Symposium on Applied Computing, Fortaleza, Ceara, Brazil, March 2008.
[2]
Hal Berenson, Phil Bernstein, Jim Gray, Jim Melton, Elizabeth O'Neil, and Patrick O'Neil. A critique of ansi sql isolation levels. In SIGMOD '95: Proceedings of the 1995 ACM SIGMOD international conference on Management of data, pages 1--10, New York, NY, USA, 1995. ACM.
[3]
Miguel Castro, Peter Druschel, Anne marie Kermarrec, and Antony Rowstron. Scribe: A large-scale and decentralized application-level multicast infrastructure. IEEE Journal on Selected Areas in Communications (JSAC, 20:2002, 2002.
[4]
Frank Dabek, Frans M. Kaashoek, David Karger, Robert Morris, and Ion Stoica. Wide-area cooperative storage with cfs. In SOSP '01: Proceedings of the eighteenth ACM symposium on Operating systems principles, volume 35, pages 202--215, New York, NY, USA, December 2001. ACM Press.
[5]
Khuzaima Daudjee and Kenneth Salem. Lazy database replication with snapshot isolation. In Proceedings of the 32nd International Conference on Very Large Data Bases., pages 715--726, Seoul, Korea, September 2006. VLDB.
[6]
Sameh Elnikety, Fernando Pedone, and Willy Zwaenepoel. Database replication using generalized snapshot isolation. In Proceedings of the 2005 24th IEEE Symposium on Reliable Distributed Systems (SRDS'05)., Orlando, Florida (USA), October 2005. IEEE.
[7]
Jim Gray, Pat Helland, Patrick O'Neil, and Dennis Shasha. The dangers of replication and a solution. In In Proceedings of the 1996 ACM SIGMOD International Conference on Management of Data, pages 173--182, Montreal, Quebec, Canada, june 1996. ACM SIGMOD.
[8]
Tobias Groothuyse, Swaminathan Sivasubramanian, and Guillaume Pierre. GlobeTP: Template-based database replication for scalable web applications. In Proceedings of the 16th International World Wide Web Conference, Banff, Canada, May 2007.
[9]
John Kubiatowicz, David Bindel, Yan Chen, Steven Czerwinski, Patrick Eaton, Dennis Geels, Ramakrishna Gummadi, Sean Rhea, Hakim Weatherspoon, Westley Weimer, Chris Wells, and Ben Zhao. Oceanstore: An architecture for global-scale persistent storage. In In Proceedings of the Ninth International Conference on Architectural Support for Programming Languages and Operating Systems, pages 190--201, 2000.
[10]
Yi Lin, Bettina Kemme, Marta Patino-Martinez, and Ricardo Jimenez-Peris. Middleware based data replication providing snapshot isolation. In Proceedings of the 24th ACM SIGMOD International Conference on Management of Data., Baltimore, Maryland (USA), june 2005. ACM SIGMOD.
[11]
Yi Lin, Bettina Kemme, Marta Patino-Martinez, and Ricardo Jimenez-Peris. Enhancing edge computing with database replication. volume 0, pages 45--54, Los Alamitos, CA, USA, 2007. IEEE Computer Society.
[12]
Christion Plattner and Gustavo Alonso. Ganymed: Scalable replication for transactional web applications. In Proceedings of 5th International Middleware Conference, pages 155--174, Toronto, Ontario, Canada, October 2004. ACM/IFIP/USENIX.
[13]
D. Serrano, M. Patino-Martinez, R. Jimenez-Peris, and B. Kemme. Boosting database replication scalability through partial replication and 1-copy-snapshot-isolation. In PRDC '07: Proceedings of the 13th Pacific Rim International Symposium on Dependable Computing, pages 290--297, Washington, DC, USA, 2007. IEEE Computer Society.

Cited By

View all
  • (2019)RepliSmartProceedings of the ACM India Joint International Conference on Data Science and Management of Data10.1145/3297001.3297022(164-170)Online publication date: 3-Jan-2019
  • (2012)Dynamic adaptive model of the multi-tenant data replication based on queuing theoryProceedings of 2012 2nd International Conference on Computer Science and Network Technology10.1109/ICCSNT.2012.6526260(1755-1759)Online publication date: Dec-2012

Recommendations

Comments

Information & Contributors

Information

Published In

cover image ACM Other conferences
EDBT/ICDT '09: Proceedings of the 2009 EDBT/ICDT Workshops
March 2009
218 pages
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]

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 22 March 2009

Permissions

Request permissions for this article.

Check for updates

Qualifiers

  • Research-article

Conference

EDBT/ICDT '09
EDBT/ICDT '09: EDBT/ICDT '09 joint conference
March 22, 2009
Saint-Petersburg, Russia

Acceptance Rates

Overall Acceptance Rate 7 of 10 submissions, 70%

Contributors

Other Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

  • Downloads (Last 12 months)0
  • Downloads (Last 6 weeks)0
Reflects downloads up to 15 Feb 2025

Other Metrics

Citations

Cited By

View all
  • (2019)RepliSmartProceedings of the ACM India Joint International Conference on Data Science and Management of Data10.1145/3297001.3297022(164-170)Online publication date: 3-Jan-2019
  • (2012)Dynamic adaptive model of the multi-tenant data replication based on queuing theoryProceedings of 2012 2nd International Conference on Computer Science and Network Technology10.1109/ICCSNT.2012.6526260(1755-1759)Online publication date: Dec-2012

View Options

Login options

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Figures

Tables

Media

Share

Share

Share this Publication link

Share on social media