In this work, it is shown how a DBMS workload, running on a shared-bus shared-memory multiprocessor, can be accelerated by adding simple support to the MESI coherence protocol. As a DBMS workload, we choose the TPC-D benchmark running on the PostgreSQL DBMS. Results show that, for a DSS workload, the use of a WU protocol with a selective invalidation strategy for private data improves performance because of the access pattern to shared data and the lower bus utilisation due to the absence of invalidation miss, when the contribution of passive sharing is eliminated. In the 16 processor case, the advantage can be quantified in a 20% of increased performance.

P., F., Giorgi, R., C. A., P. (2004). Speeding-up multiprocessors running DBMS workloads through coherence protocol. INTERNATIONAL JOURNAL OF HIGH PERFORMANCE COMPUTING AND NETWORKING, 1(1/2), 17-32 [10.1504/IJHPCN.2004.007562].

Speeding-up multiprocessors running DBMS workloads through coherence protocol

GIORGI, ROBERTO;
2004-01-01

Abstract

In this work, it is shown how a DBMS workload, running on a shared-bus shared-memory multiprocessor, can be accelerated by adding simple support to the MESI coherence protocol. As a DBMS workload, we choose the TPC-D benchmark running on the PostgreSQL DBMS. Results show that, for a DSS workload, the use of a WU protocol with a selective invalidation strategy for private data improves performance because of the access pattern to shared data and the lower bus utilisation due to the absence of invalidation miss, when the contribution of passive sharing is eliminated. In the 16 processor case, the advantage can be quantified in a 20% of increased performance.
2004
P., F., Giorgi, R., C. A., P. (2004). Speeding-up multiprocessors running DBMS workloads through coherence protocol. INTERNATIONAL JOURNAL OF HIGH PERFORMANCE COMPUTING AND NETWORKING, 1(1/2), 17-32 [10.1504/IJHPCN.2004.007562].
File in questo prodotto:
File Dimensione Formato  
Foglia04b.pdf

non disponibili

Tipologia: Post-print
Licenza: NON PUBBLICO - Accesso privato/ristretto
Dimensione 396.08 kB
Formato Adobe PDF
396.08 kB Adobe PDF   Visualizza/Apri   Richiedi una copia

I documenti in IRIS sono protetti da copyright e tutti i diritti sono riservati, salvo diversa indicazione.

Utilizza questo identificativo per citare o creare un link a questo documento: https://hdl.handle.net/11365/7770
 Attenzione

Attenzione! I dati visualizzati non sono stati sottoposti a validazione da parte dell'ateneo