About cookies on this site Our websites require some cookies to function properly (required). In addition, other cookies may be used with your consent to analyze site usage, improve the user experience and for advertising. For more information, please review your options. By visiting our website, you agree to our processing of information as described in IBM’sprivacy statement. To provide a smooth navigation, your cookie preferences will be shared across the IBM web domains listed here.
Paper
Determining the Number of Remote Sites Accessed in Distributed Transaction Processing
Abstract
We characterize the number of remote accesses and the number of distinct remote sites accessed by global transactions in a distributed database environment. Both measures are important in determining the overhead of distributed transaction processing and are affected by the distribution of transaction size (number of distinct objects accessed by a transaction) and the distribution of remote accesses made by a transaction. Keeping the mean transaction size fixed, we show that in the case of some commonly used distributions for the number of remote accesses (e.g., the binomial and uniform distribution) variable size transactions access a fewer number of distinct remote sites on the average than fixed size transactions. Also for these and some other distributions (for the number of remote accesses) the mean number of remote accesses is independent of the distribution of transaction size, but this is not generally true. In cases when variable size transactions have a higher mean number of remote accesses than fixed size transactions, fixed size transactions still tend to access a larger number of remote sites than variable size transactions, but this is not always true when variable size transactions have a higher mean for the number of remote accesses than fixed size transactions. © 1993 IEEE