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. Finally, it is shown how results can be extended to other DBMS workloads.
Speeding-up multiprocessors running DBMS workloads through coherence protocol / Foglia, Pierfrancesco; R., Giorgi; Prete, COSIMO ANTONIO. - In: INTERNATIONAL JOURNAL OF HIGH PERFORMANCE COMPUTING AND NETWORKING. - ISSN 1740-0562. - STAMPA. - 1(2004), pp. 17-32.
|Autori:||Foglia, Pierfrancesco; R., Giorgi; Prete, COSIMO ANTONIO|
|Titolo:||Speeding-up multiprocessors running DBMS workloads through coherence protocol|
|Anno del prodotto:||2004|
|Digital Object Identifier (DOI):||10.1504/IJHPCN.2004.007562|
|Appare nelle tipologie:||1.1 Articolo in rivista|