Characterizing the scalability of decision-support workloads on clusters and SMP systems

Yanyong Zhang; Anand Sivasubramaniam; Jianyong Zhang; Shailabh Nagar; Hubertus Franke

doi:10.1007/3-540-45706-2_47

Characterizing the scalability of decision-support workloads on clusters and SMP systems

Yanyong Zhang, Anand Sivasubramaniam, Jianyong Zhang, Shailabh Nagar, Hubertus Franke

Research output: Chapter in Book/Report/Conference proceeding › Conference contribution

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.

Original language	English (US)
Title of host publication	Euro-Par 2002 Parallel Processing - 8th International Euro-Par Conference Paderborn, Germany, August 27-30, 2002 Proceedings
Editors	Burkhard Monien, Rainer Feldmann
Publisher	Springer Verlag
Pages	355-364
Number of pages	10
ISBN (Print)	3540440496
DOIs	https://doi.org/10.1007/3-540-45706-2_47
State	Published - 2002
Event	8th International Euro-Par Conference on Parallel Processing, Euro-Par 2002 - Paderborn, Germany Duration: Aug 27 2002 → Aug 30 2002

Publication series

Name	Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)
Volume	2400
ISSN (Print)	0302-9743
ISSN (Electronic)	1611-3349

Other

Other	8th International Euro-Par Conference on Parallel Processing, Euro-Par 2002
Country/Territory	Germany
City	Paderborn
Period	8/27/02 → 8/30/02

All Science Journal Classification (ASJC) codes

Theoretical Computer Science
General Computer Science

Access to Document

10.1007/3-540-45706-2_47

Cite this

Zhang, Y., Sivasubramaniam, A., Zhang, J., Nagar, S., & Franke, H. (2002). Characterizing the scalability of decision-support workloads on clusters and SMP systems. In B. Monien, & R. Feldmann (Eds.), Euro-Par 2002 Parallel Processing - 8th International Euro-Par Conference Paderborn, Germany, August 27-30, 2002 Proceedings (pp. 355-364). (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics); Vol. 2400). Springer Verlag. https://doi.org/10.1007/3-540-45706-2_47

Zhang, Yanyong ; Sivasubramaniam, Anand ; Zhang, Jianyong et al. / Characterizing the scalability of decision-support workloads on clusters and SMP systems. Euro-Par 2002 Parallel Processing - 8th International Euro-Par Conference Paderborn, Germany, August 27-30, 2002 Proceedings. editor / Burkhard Monien ; Rainer Feldmann. Springer Verlag, 2002. pp. 355-364 (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)).

@inproceedings{ee487330764240e88be0ceb73139c119,

title = "Characterizing the scalability of decision-support workloads on clusters and SMP systems",

abstract = "Using a public domain version of a commercial clustered database server and TPC-H like1 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.",

author = "Yanyong Zhang and Anand Sivasubramaniam and Jianyong Zhang and Shailabh Nagar and Hubertus Franke",

note = "Publisher Copyright: {\textcopyright} Springer-Verlag Berlin Heidelberg 2002.; 8th International Euro-Par Conference on Parallel Processing, Euro-Par 2002 ; Conference date: 27-08-2002 Through 30-08-2002",

year = "2002",

doi = "10.1007/3-540-45706-2_47",

language = "English (US)",

isbn = "3540440496",

series = "Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)",

publisher = "Springer Verlag",

pages = "355--364",

editor = "Burkhard Monien and Rainer Feldmann",

booktitle = "Euro-Par 2002 Parallel Processing - 8th International Euro-Par Conference Paderborn, Germany, August 27-30, 2002 Proceedings",

address = "Germany",

}

Zhang, Y, Sivasubramaniam, A, Zhang, J, Nagar, S & Franke, H 2002, Characterizing the scalability of decision-support workloads on clusters and SMP systems. in B Monien & R Feldmann (eds), Euro-Par 2002 Parallel Processing - 8th International Euro-Par Conference Paderborn, Germany, August 27-30, 2002 Proceedings. Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics), vol. 2400, Springer Verlag, pp. 355-364, 8th International Euro-Par Conference on Parallel Processing, Euro-Par 2002, Paderborn, Germany, 8/27/02. https://doi.org/10.1007/3-540-45706-2_47

Characterizing the scalability of decision-support workloads on clusters and SMP systems. / Zhang, Yanyong; Sivasubramaniam, Anand; Zhang, Jianyong et al.
Euro-Par 2002 Parallel Processing - 8th International Euro-Par Conference Paderborn, Germany, August 27-30, 2002 Proceedings. ed. / Burkhard Monien; Rainer Feldmann. Springer Verlag, 2002. p. 355-364 (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics); Vol. 2400).

Research output: Chapter in Book/Report/Conference proceeding › Conference contribution

TY - GEN

T1 - Characterizing the scalability of decision-support workloads on clusters and SMP systems

AU - Zhang, Yanyong

AU - Sivasubramaniam, Anand

AU - Zhang, Jianyong

AU - Nagar, Shailabh

AU - Franke, Hubertus

N1 - Publisher Copyright: © Springer-Verlag Berlin Heidelberg 2002.

PY - 2002

Y1 - 2002

N2 - Using a public domain version of a commercial clustered database server and TPC-H like1 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.

AB - Using a public domain version of a commercial clustered database server and TPC-H like1 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.

UR - http://www.scopus.com/inward/record.url?scp=84956852097&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=84956852097&partnerID=8YFLogxK

U2 - 10.1007/3-540-45706-2_47

DO - 10.1007/3-540-45706-2_47

M3 - Conference contribution

AN - SCOPUS:84956852097

SN - 3540440496

T3 - Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)

SP - 355

EP - 364

BT - Euro-Par 2002 Parallel Processing - 8th International Euro-Par Conference Paderborn, Germany, August 27-30, 2002 Proceedings

A2 - Monien, Burkhard

A2 - Feldmann, Rainer

PB - Springer Verlag

T2 - 8th International Euro-Par Conference on Parallel Processing, Euro-Par 2002

Y2 - 27 August 2002 through 30 August 2002

ER -

Zhang Y, Sivasubramaniam A, Zhang J, Nagar S, Franke H. Characterizing the scalability of decision-support workloads on clusters and SMP systems. In Monien B, Feldmann R, editors, Euro-Par 2002 Parallel Processing - 8th International Euro-Par Conference Paderborn, Germany, August 27-30, 2002 Proceedings. Springer Verlag. 2002. p. 355-364. (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)). doi: 10.1007/3-540-45706-2_47

Characterizing the scalability of decision-support workloads on clusters and SMP systems

Abstract

Publication series

Other

All Science Journal Classification (ASJC) codes

Access to Document

Other files and links

Fingerprint

Cite this