This paper investigates the issues involved in using multiprocessors for high performance transaction processing applications. A simulation model is used to compare the performance of three different architectures, namely, Shared Everything, Shared Nothing and Shared Disks. In Shared Everything, any processor can access any disk and all memory is shared. In Shared Nothing, neither disks nor memory is shared. In Shared Disks, any processor can access any disk, but each has its own private main memory.
The paper first studies four different variations of the Shared Disks architecture which attempt to minimize lock request messages. It then compares the best Shared Disks variation with Shared Nothing and Shared Everything. In addition, it studies how intraquery parallelism affects the performance of the architectures.
- The SD Architecture
- The Simulation Model
- Simulation Results