Speeding-up multiprocessors running DBMS workloads through coherence protocols. (8th August 2005)

• Record Type: Journal Article
• Authors: Foglia, Pierfrancesco; Giorgi, Roberto; Prete, Cosimo Antonio
• Is Part Of: International journal of high performance computing and networking. Volume 1:Number 1/2/3(2004)
• Page Start: 17
• Page End: 32
• Publication Date: 2005-08-08
• Subjects: 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; High performance computing -- Periodicals; Computer networks -- Periodicals; High performance computing; Periodicals; 004.05
• Languages: English
• ISSNs: 1740-0562

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.