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

Please wait, while we are loading the content...

Compiler-controlled memory

Segregating heap objects by reference behavior and lifetime

Schedule-independent storage mapping for loops

An empirical analysis of instruction repetition

Space-time scheduling of instruction-level parallelism on a raw machine

Data speculation support for a chip multiprocessor

VISA: Netstation's virtual Internet SCSI adapter

Active disks: programming model, algorithms and evaluation

A cost-effective, high-bandwidth storage architecture

Hardware-software trade-offs in a direct Rambus implementation of the RAMpage memory hierarchy

Dependence based prefetching for linked data structures

Performance counters and state sharing annotations: a unified approach to thread locality

Cache-conscious data placement

An out-of-order execution technique for runtime binary translators

Overlapping execution with transfer using non-strict execution for mobile programs

Variable length path branch prediction

Performance isolation: sharing and isolation in shared-memory multiprocessors

UTLB: a mechanism for address translation on network interfaces

Locality-aware request distribution in cluster-based network servers

Investigating optimal local memory performance

Precise miss analysis for program transformations with caches of arbitrary associativity

Capturing dynamic memory reference behavior with adaptive cache topology

Accelerating multi-media processing by implementing memoing in multiplication and division units

Value speculation scheduling for high performance processors

An empirical study of decentralized ILP execution models

Fast out-of-order processor simulation using memoization

A look at several memory management units, TLB-refill mechanisms, and page table organizations

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

Content Provider	ACM Digital Library
Author	Barroso, Luiz André Adve, Sarita V. Ranganathan, Parthasarathy Gharachorloo, Kourosh
Abstract	Database applications such as online transaction processing (OLTP) and decision support systems (DSS) constitute the largest and fastest-growing segment of the market for multiprocessor servers. However, most current system designs have been optimized to perform well on scientific and engineering workloads. Given the radically different behavior of database workloads (especially OLTP), it is important to re-evaluate key system design decisions in the context of this important class of applications.This paper examines the behavior of database workloads on shared-memory multiprocessors with aggressive out-of-order processors, and considers simple optimizations that can provide further performance improvements. Our study is based on detailed simulations of the Oracle commercial database engine. The results show that the combination of out-of-order execution and multiple instruction issue is indeed effective in improving performance of database workloads, providing gains of 1.5 and 2.6 times over an in-order single-issue processor for OLTP and DSS, respectively. In addition, speculative techniques enable optimized implementations of memory consistency models that significantly improve the performance of stricter consistency models, bringing the performance to within 10--15% of the performance of more relaxed models.The second part of our study focuses on the more challenging OLTP workload. We show that an instruction stream buffer is effective in reducing the remaining instruction stalls in OLTP, providing a 17% reduction in execution time (approaching a perfect instruction cache to within 15%). Furthermore, our characterization shows that a large fraction of the data communication misses in OLTP exhibit migratory behavior; our preliminary results show that software prefetch and writeback/flush hints can be used for this data to further reduce execution time by 12%.
Starting Page	307
Ending Page	318
Page Count	12
File Format	PDF
ISBN	1581131070
DOI	10.1145/291069.291067
Language	English
Publisher	Association for Computing Machinery (ACM)
Publisher Date	1998-10-01
Publisher Place	New York
Access Restriction	Subscribed
Content Type	Text
Resource Type	Article

Sl.	Authority	Responsibilities	Communication Details
1	Ministry of Education (GoI), Department of Higher Education	Sanctioning Authority	https://www.education.gov.in/ict-initiatives
2	Indian Institute of Technology Kharagpur	Host Institute of the Project: The host institute of the project is responsible for providing infrastructure support and hosting the project	https://www.iitkgp.ac.in
3	National Digital Library of India Office, Indian Institute of Technology Kharagpur	The administrative and infrastructural headquarters of the project	Dr. B. Sutradhar bsutra@ndl.gov.in
4	Project PI / Joint PI	Principal Investigator and Joint Principal Investigators of the project	Dr. B. Sutradhar bsutra@ndl.gov.in Prof. Saswat Chakrabarti will be added soon
5	Website/Portal (Helpdesk)	Queries regarding NDLI and its services	support@ndl.gov.in
6	Contents and Copyright Issues	Queries related to content curation and copyright issues	content@ndl.gov.in
7	National Digital Library of India Club (NDLI Club)	Queries related to NDLI Club formation, support, user awareness program, seminar/symposium, collaboration, social media, promotion, and outreach	clubsupport@ndl.gov.in
8	Digital Preservation Centre (DPC)	Assistance with digitizing and archiving copyright-free printed books	dpc@ndl.gov.in
9	IDR Setup or Support	Queries related to establishment and support of Institutional Digital Repository (IDR) and IDR workshops	idr@ndl.gov.in

Abstract performance of database workloads on shared-memory systems with out-of-order processors.

Performance of Database Workloads on Shared-Memory Systems with Out-of-Order Processors (1998)

Performance of database workloads on shared-memory systems with out-of-order processors (1998).

Performance of database workloads on shared-memory systems with out-of-order processors (SIGP, Vol. 33, Issue. 11)

Performance of database workloads on shared-memory systems with out-of-order processors (OPSR, Vol. 32, Issue. 5)

Abstract Performance of Database Workloads on Shared-Memory Systems with Out-of-Order Processors

Abstract Performance of Database Workloads on Shared-Memory Systems with Out-of-Order Processors

Performance analysis of the memory management unit under scale-out workloads

The memory performance of DSS commercial workloads in shared-memory multiprocessors

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

Similar Documents

Abstract performance of database workloads on shared-memory systems with out-of-order processors.

Performance of Database Workloads on Shared-Memory Systems with Out-of-Order Processors (1998)

Performance of database workloads on shared-memory systems with out-of-order processors (1998).

Performance of database workloads on shared-memory systems with out-of-order processors (SIGP, Vol. 33, Issue. 11)

Performance of database workloads on shared-memory systems with out-of-order processors (OPSR, Vol. 32, Issue. 5)

Abstract Performance of Database Workloads on Shared-Memory Systems with Out-of-Order Processors

Abstract Performance of Database Workloads on Shared-Memory Systems with Out-of-Order Processors

Performance analysis of the memory management unit under scale-out workloads

The memory performance of DSS commercial workloads in shared-memory multiprocessors

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