Abstract
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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Memcached, http://www.danga.com/memcached/
BitTorrent, http://www.bittorrent.com/index.html
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)
Colquhoun, J.: A BitTorrent-Based Peer-to-Peer Database Server Newcastle University (2009), CS-TR No1135
Colquhoun, J., Watson, P.: A Peer-to-Peer Database Server based on BitTorrent. Newcastle University (2008), CS-TR No1089
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)
OGSA-DAI, http://www.ogsadai.org.uk/
MySQL, http://www.mysql.com
SQL Server, http://www.microsoft.com/sql/default.mspx
Transaction Processing Council TPC-H Benchmark, http://www.tpc.org/tpch/
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)
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-002
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)
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)
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)
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)
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)
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)
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)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2009 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Colquhoun, J., Watson, P. (2009). Evaluating a Peer-to-Peer Database Server Based on BitTorrent. In: Sexton, A.P. (eds) Dataspace: The Final Frontier. BNCOD 2009. Lecture Notes in Computer Science, vol 5588. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-02843-4_17
Download citation
DOI: https://doi.org/10.1007/978-3-642-02843-4_17
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-02842-7
Online ISBN: 978-3-642-02843-4
eBook Packages: Computer ScienceComputer Science (R0)