Evaluating a Peer-to-Peer Database Server Based on BitTorrent

  • John Colquhoun
  • Paul Watson
Part of the Lecture Notes in Computer Science book series (LNCS, volume 5588)


Database systems have traditionally used a Client-Server architecture. As the server becomes overloaded, clients experience an increase in query response time, and in the worst case the server may be unable to provide any service at all.

In file-sharing, the problem of server overloading has been addressed by the use of Peer-to-Peer (P2P) techniques in which users (peers) supply files to each other, so sharing the load. This paper describes the Wigan P2P Database System, which was designed to investigate if P2P techniques for reducing server load, thus increasing system scalability, could be applied successfully in a database environment. It is based on the BitTorrent file-sharing approach.

This paper introduces the Wigan system architecture, explaining how the BitTorrent approach must be modified for a P2P database server. It presents and analyses experimental results, including the TPC-H benchmark, which show that the approach can succeed in delivering scalability in particular cases.


P2P Computing Database Systems 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
  2. 2.
  3. 3.
    Schollmeier, R.: A Definition of Peer-to-Peer Networking for the Classification of Peer-to-Peer Architectures and Applications. In: First International Conference on Peer-to-Peer Computing (P2P 2001). IEEE Computer Society Press, Los Alamitos (2001)Google Scholar
  4. 4.
    Colquhoun, J.: A BitTorrent-Based Peer-to-Peer Database Server Newcastle University (2009), CS-TR No1135Google Scholar
  5. 5.
    Colquhoun, J., Watson, P.: A Peer-to-Peer Database Server based on BitTorrent. Newcastle University (2008), CS-TR No1089Google Scholar
  6. 6.
    Colquhoun, J., Watson, P.: A Peer-to-Peer Database Server. In: Gray, A., Jeffery, K., Shao, J. (eds.) BNCOD 2008. LNCS, vol. 5071, pp. 181–184. Springer, Heidelberg (2008)CrossRefGoogle Scholar
  7. 7.
  8. 8.
  9. 9.
  10. 10.
    Transaction Processing Council TPC-H Benchmark, http://www.tpc.org/tpch/
  11. 11.
    Bernstein, P.A., Giunchiglia, F., Kementsietsidis, A., Mylopoulis, J., Serafini, L., Zaihrayeu, I.: Data Management for Peer-to-Peer Computing: A Vision. In: Workshop on the Web and Databases, WebDB 2002, Madison (2002)Google Scholar
  12. 12.
    Serafini, L., Giunchiglia, F., Mylopoulos, J., Bernstein, P.A.: Local Relational Model: A Logical Formalisation of Database Co-ordination. University of Trento (2003), DIT-03-002Google Scholar
  13. 13.
    Franconi, E., Kuper, G.M., Lopatenko, A., Serafini, L.: A Robust Logical and Computational Characterisation of Peer-to-Peer Database Systems. In: Aberer, K., Koubarakis, M., Kalogeraki, V. (eds.) DBISP2P 2003. LNCS, vol. 2944, pp. 64–76. Springer, Heidelberg (2004)Google Scholar
  14. 14.
    Giunchiglia, F., Zaihrayeu, I.: Making Peer Databases Interact - A Vision for an Architecture Supporting Data Coordination. In: Klusch, M., Ossowski, S., Shehory, O. (eds.) CIA 2002. LNCS, vol. 2446, pp. 18–35. Springer, Heidelberg (2002)CrossRefGoogle Scholar
  15. 15.
    Tatarinov, I., Ives, Z., Madhavan, J., Halevy, A., Suciu, D., Dalvi, N., Dong, X.L., Kadiyska, Y., Miklau, G., Mork, P.: The Piazza Peer Data Management Project. ACM Sigmod Record 32, 47–52 (2003)CrossRefGoogle Scholar
  16. 16.
    Majkic, Z.: Weakly-coupled ontology integration of P2P database systems. In: The First International Workshop on Peer-to-Peer Knowledge Management. CEUR-WS.org, Boston (2004)Google Scholar
  17. 17.
    Rouse, C., Berman, S.: A Scalable P2P Database System with Semi-Automated Schema Matching. In: 26th IEEE International Conference on Distributed Computing Systems Workshops (ICDCSW 2006). IEEE Computer Society, Lisbon (2006)Google Scholar
  18. 18.
    Laborda, C.P.d., Popfinger, C., Conrad, S.: Digame: A Vision of an Active Multidatabase with Push–based Schema and Data Propagation. In: GI-/GMDS-Workshop on Enterprise Application Integration, EAI 2004 (2004)Google Scholar
  19. 19.
    Alvarez, D., Smukler, A., Vaisman, A.A.: Peer-To-Peer Databases for e-Science: a Biodiversity Case Study. In: 20th Brazilian Symposium on Databases, UFU, Federal University of Uberlândia (2005)Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2009

Authors and Affiliations

  • John Colquhoun
    • 1
  • Paul Watson
    • 1
  1. 1.School of Computing ScienceNewcastle UniversityNewcastle-upon-TyneUnited Kingdom

Personalised recommendations