Performance of database workloads on shared-memory systems with out-of-order processors

Parthasarathy Ranganathan; Kourosh Gharachorloo; Sarita V. Adve; Luiz Andre Barroso

doi:10.1145/291069.291067

Performance of database workloads on shared-memory systems with out-of-order processors

Parthasarathy Ranganathan, Kourosh Gharachorloo, Sarita V. Adve, Luiz Andre Barroso

Research output: Contribution to conference › Paper › peer-review

Abstract

The behavior of database workloads on shared memory multiprocessors with aggressive out-of-order processors is analyzed, and simple optimizations to provide further performance improvements are considered. This analysis is based on detailed simulations of the Oracle commercial database engine. Results showed that combination of out-of-order execution and multiple instruction issue is effective in improving performance of database workloads, providing gains of 1.5 and 2.6 times over an in-order single-issue processor for online transaction processing and decision support systems.

Original language	English (US)
Pages	307-318
Number of pages	12
DOIs	https://doi.org/10.1145/291069.291067
State	Published - 1998
Externally published	Yes
Event	Proceedings of 1998 8th International Conference on Architectural Support for Programming Languages and Operating Systems, ASPLOS-8 - San Jose, CA, USA Duration: Oct 3 1998 → Oct 7 1998

Other

Other	Proceedings of 1998 8th International Conference on Architectural Support for Programming Languages and Operating Systems, ASPLOS-8
City	San Jose, CA, USA
Period	10/3/98 → 10/7/98

ASJC Scopus subject areas

Software
Information Systems
Hardware and Architecture

Online availability

10.1145/291069.291067

Library availability

Discover UIUC Full Text

Cite this

Ranganathan, P., Gharachorloo, K., Adve, S. V., & Barroso, L. A. (1998). Performance of database workloads on shared-memory systems with out-of-order processors. 307-318. Paper presented at Proceedings of 1998 8th International Conference on Architectural Support for Programming Languages and Operating Systems, ASPLOS-8, San Jose, CA, USA. https://doi.org/10.1145/291069.291067

Performance of database workloads on shared-memory systems with out-of-order processors. / Ranganathan, Parthasarathy; Gharachorloo, Kourosh; Adve, Sarita V. et al.
1998. 307-318 Paper presented at Proceedings of 1998 8th International Conference on Architectural Support for Programming Languages and Operating Systems, ASPLOS-8, San Jose, CA, USA.

Research output: Contribution to conference › Paper › peer-review

Ranganathan, P, Gharachorloo, K, Adve, SV & Barroso, LA 1998, 'Performance of database workloads on shared-memory systems with out-of-order processors', Paper presented at Proceedings of 1998 8th International Conference on Architectural Support for Programming Languages and Operating Systems, ASPLOS-8, San Jose, CA, USA, 10/3/98 - 10/7/98 pp. 307-318. https://doi.org/10.1145/291069.291067

@conference{3852b1b8bf2f4e23ac7d63fe459ce6ba,

title = "Performance of database workloads on shared-memory systems with out-of-order processors",

abstract = "The behavior of database workloads on shared memory multiprocessors with aggressive out-of-order processors is analyzed, and simple optimizations to provide further performance improvements are considered. This analysis is based on detailed simulations of the Oracle commercial database engine. Results showed that combination of out-of-order execution and multiple instruction issue is effective in improving performance of database workloads, providing gains of 1.5 and 2.6 times over an in-order single-issue processor for online transaction processing and decision support systems.",

author = "Parthasarathy Ranganathan and Kourosh Gharachorloo and Adve, {Sarita V.} and Barroso, {Luiz Andre}",

year = "1998",

doi = "10.1145/291069.291067",

language = "English (US)",

pages = "307--318",

note = "Proceedings of 1998 8th International Conference on Architectural Support for Programming Languages and Operating Systems, ASPLOS-8 ; Conference date: 03-10-1998 Through 07-10-1998",

}

TY - CONF

T1 - Performance of database workloads on shared-memory systems with out-of-order processors

AU - Ranganathan, Parthasarathy

AU - Gharachorloo, Kourosh

AU - Adve, Sarita V.

AU - Barroso, Luiz Andre

PY - 1998

Y1 - 1998

N2 - The behavior of database workloads on shared memory multiprocessors with aggressive out-of-order processors is analyzed, and simple optimizations to provide further performance improvements are considered. This analysis is based on detailed simulations of the Oracle commercial database engine. Results showed that combination of out-of-order execution and multiple instruction issue is effective in improving performance of database workloads, providing gains of 1.5 and 2.6 times over an in-order single-issue processor for online transaction processing and decision support systems.

AB - The behavior of database workloads on shared memory multiprocessors with aggressive out-of-order processors is analyzed, and simple optimizations to provide further performance improvements are considered. This analysis is based on detailed simulations of the Oracle commercial database engine. Results showed that combination of out-of-order execution and multiple instruction issue is effective in improving performance of database workloads, providing gains of 1.5 and 2.6 times over an in-order single-issue processor for online transaction processing and decision support systems.

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

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

U2 - 10.1145/291069.291067

DO - 10.1145/291069.291067

M3 - Paper

AN - SCOPUS:0031611717

SP - 307

EP - 318

T2 - Proceedings of 1998 8th International Conference on Architectural Support for Programming Languages and Operating Systems, ASPLOS-8

Y2 - 3 October 1998 through 7 October 1998

ER -

Performance of database workloads on shared-memory systems with out-of-order processors

Abstract

Other

ASJC Scopus subject areas

Online availability

Library availability

Related links

Fingerprint

Cite this