Title
Network latency optimizations in distributed database systems
Abstract
The advent of high-speed networks will enable the de- ployment of data-server systems currently used in local- area networks, over wide-area networks. The users of these systems will have the same high expectations with respect to performance parameters such as the transaction through- put, response time and system reliability as in the case of local-area networks. Thus, it is important to study the performance of existing distributed database protocols in the new networking environment, identify the performance bottlenecks and develop protocols that are capable of tak- ing advantage of the high speed networking technology. As a first step, in this paper we examine the scalability of the server-based two-phase locking (s-2PL) protocol, and discuss three optimizations which allow the s-2PL protocol to be tailored for high-speed wide-area network environ- ments where the size of the message is less of a concern than the number of rounds of message passing. These opti- mizations, collectively called the group two-phase lockin g (g-2PL) protocol, reduce the number of rounds of message passing by grouping lock grants, client-end caching and data migration. In a simulation study, 20-25% improve- ment in the response time of the g-2PL protocol over that of the s-2PL protocol was observed.
Year
DOI
Venue
1998
10.1109/ICDE.1998.655816
Orlando, FL
Keywords
Field
DocType
access protocols,cache storage,concurrency control,distributed databases,memory protocols,message passing,optimisation,software performance evaluation,software reliability,transaction processing,wide area networks,client-end caching,data migration,data-server systems,distributed database systems,g-2PL protocol,group two-phase locking protocol,high-speed WAN environments,high-speed networks,lock grants,message size,message-passing rounds,network latency optimization,performance bottlenecks,performance parameters,response time,s-2PL protocol,scalability,server-based two-phase locking protocol,simulation,system reliability,transaction throughput,wide-area networks
Two-phase commit protocol,Latency (engineering),Computer science,Computer network,Distributed database,Throughput,Database transaction,Message passing,Database,Distributed computing,Data migration,Scalability
Conference
ISSN
ISBN
Citations 
1063-6382
0-8186-8289-2
19
PageRank 
References 
Authors
11.79
20
2
Name
Order
Citations
PageRank
Sujata Banerjee12327165.38
Chrysanthis, P.K.213822.73