Lehrgebiet Informationssysteme

FB Informatik

LG IS

AG DBIS

(C) AG DBIS

Evaluation of Closely Coupled Systems for High Performance Database Processing

Erhard Rahm

University Kaiserslautern, Department of Computer Science
P.O. Box 3049, D-6750 Kaiserslautern, Germany
E-mail: rahm@informatik.uni-kl.de

Full paper (postscript version, compressed by gzip or PDF version )

Abstract

Closely coupled systems aim at a more efficient communication and cooperation between processing nodes compared to loosely coupled systems. This can be achieved by using globally shared semiconductor memory to speed up the exchange of messages or to store global data structures. For distributed database processing, the database sharing (shared disk) architecture can benefit most from such a close coupling. We present a detailed simulation study of closely coupled database sharing systems. A shared store called Global Extended Memory (GEM) is used for system-wide concurrency and coherency control, and to improve I/O performance. The performance of such an architecture is evaluated and compared with loosely coupled database sharing systems employing the primary copy approach for concurrency and coherency control. In particular, we study the impact of different update strategies (FORCE vs. NOFORCE) and workload allocation schemes (random vs. affinity-based routing). The use of shared disk caches implementing a global database buffer is also considered. Simulation results will be presented for synthetically generated debit-credit workloads and a real-life workload represented by a database trace.

in: Proc. 13th Int. Conf. on Distributed Computing Systems, Pittsburgh, USA, May 1993