Characterizing the Scalability of Decision-Support Workloads on Clusters and SMP Systems

  • Authors:
  • Yanyong Zhang;Anand Sivasubramaniam;Jianyong Zhang;Shailabh Nagar;Hubertus Franke

  • Affiliations:
  • -;-;-;-;-

  • Venue:
  • Euro-Par '02 Proceedings of the 8th International Euro-Par Conference on Parallel Processing
  • Year:
  • 2002

Quantified Score

Hi-index 0.00

Visualization

Abstract

Using a public domain version of a commercial clustered database server and TPC-H like decision support queries, this paper studies the performance and scalability issues of a Pentium/Linux cluster and an 8-way Linux SMP. The execution profile demonstrates the dominance of the I/O subsystem in the execution, and the importance of the communication subsystem for cluster scalability. In addition to quantifying their importance, this paper provides further details on how these subsystems are exercised by the database engine.