Title: Speeding-up multiprocessors running DBMS workloads through coherence protocols

Authors: Pierfrancesco Foglia, Roberto Giorgi, Cosimo Antonio Prete

Addresses: Dipartimento di Ingegneria dell'Informazione, University of Pisa, Via Diotisalvi 2, Pisa 56100, Italy. ' Dipartimento di Ingegneria dell'Informazione, University of Siena, Via Roma 56, Siena 53100, Italy. ' Dipartimento di Ingegneria dell'Informazione, University of Pisa, Via Diotisalvi 2, Pisa 56100, Italy

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.

Keywords: shared-bus multiprocessors; shared-memory multiprocessors; DBMS performance; database management systems; DSS; cache memory; coherence protocols; sharing analysis; passive sharing; high performance computing; high performance networking; shared data; invalidation strategy; private data; decision support systems.

DOI: 10.1504/IJHPCN.2004.007562

International Journal of High Performance Computing and Networking, 2004 Vol.1 No.1/2/3, pp.17 - 32

Published online: 05 Aug 2005 *

Full-text access for editors Full-text access for subscribers Purchase this article Comment on this article