Abstract
To use benchmarks or to use real database traces (for the simulation of high performance distributed transaction processing), that is the question. Whether it is preferable to deal with special real workload, or to ignore the rich diversity observable with real measurements by restricting oneself to standardized benchmarks. We demonstrate how the evaluation and comparison of different load balancing algorithms depends on the workload considered. For that purpose we compare the TPC-B benchmark with two real workload traces: We analyze their properties with respect to workload characteristics on a theoretical level and we indicate how the differences observed influence performance evaluations in simulation experiments. The results imply that performance of different load distribution algorithms essentially depends on the workload processed.
This is a preview of subscription content, log in via an institution to check access.
Preview
Unable to display preview. Download preview PDF.
References
N. Auerbach: Lastclusterung für verteilte Hochleistungsdatenbanksysteme, Diplomarbeit, University of Zurich, 1997.
E. Born, T. Delica, W. Ehrl, L. Richter, R. Riedl: Characterization of Workloads for Distributed DB/DC-Processing, Journal on Information Science, 1997
R. Dubes, A. Jain: Algorithms for Clustering Data, Prentice-Hall, 1988
S. Haldar and D. Subrammanian: An affinity-based dynamic load balancing protocol for distributed transaction processing systems, Performance Evaluation 17, 1993
Load Balancing in High-Performance Distributed DB/DC-Systems: Modeling, Analysis and Clustering of Workload for Data-Affinity Based Load Distribution, ALV Workshop Munich, 1998
R. Riedl and R. Salomon; Proc. 2nd ICSC Symp. Fuzzy Control of Load-Balancing for Distributed DB/DC Transaction Processing, Fuzzy Logic and Applications, 1997
W. Shakespeare; The Tragedy of Hamlet, Prince of Denmark, 3.1
Yu P.S., Cornell C., Dias M., Balakrishna I.: Performance Analysis of Affinity Clustering on Transaction Processing Coupling Architectures, IEEE Trans. Knowledge and Data Engineering, Vol 6, No 5, 1994
http://www.ics.forth.gr/pleiades/projects/LYDIA/
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 1999 Springer-Verlag
About this paper
Cite this paper
Riedl, R. (1999). The impact of workload on simulation results for distributed transaction processing. In: Sloot, P., Bubak, M., Hoekstra, A., Hertzberger, B. (eds) High-Performance Computing and Networking. HPCN-Europe 1999. Lecture Notes in Computer Science, vol 1593. Springer, Berlin, Heidelberg. https://doi.org/10.1007/BFb0100563
Download citation
DOI: https://doi.org/10.1007/BFb0100563
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-65821-4
Online ISBN: 978-3-540-48933-7
eBook Packages: Springer Book Archive