PERFORMANCE COMPARISON OF 3 MODERN DBMS ARCHITECTURES

The introduction of powerful workstations connected through local area networks (LAN's) inspired new DBMS architectures that offer high perf ormance characteristics. In this paper, we examine three such software architecture configurations: Client-Server (CS), RAD-UNIFY(R) type of DBMS (RU), and Enhanced Client-Server (ECS). Their specific functiona l components and design rationales are discussed. We use three simulat ion models to provide a performance comparison under different job wor kloads. Our simulation results show that the RU almost always performs slightly better than the CS, especially under light workloads, and th at ECS offers significant performance improvement over both CS and RU. Under reasonable update rates, the ECS over CS (or RU) performance ra tio is almost proportional to the number of participating clients (for less than 32 clients). We also examine the impact of certain key para meters on the performance of the three architectures and finally show that ECS is more scalable that the other two.