Performance and Scalability of Client-Server Database Architectures

Recent developments in software and hardware changed the way database systems are built and operate. In this paper we present database architectures based on the Client Server paradigm and study their performance and scalability under di erent query update workloads. The architectures are: Standard Client Server, Client Server with Multiple Disks, and Enhanced Client Server. Data replication and client query result caching are used as the main mechanisms to improve the query throughput. The role of the server is to maintain system wide data consistency and in the case of Enhanced Client Server to selectively propagate updates on demand. Our study shows that except for the case of mostly update workloads, the Standard Client Server architecture is outperformed by the other two architectures by one or more orders of magnitude. The Client Server with Multiple Disks architecture o ers performance comparable to that achieved by the Enhanced Client Server for up to 100 clients, but the latt...

• Type: Conference
• Year: 1992
• Where: VLDB
• Authors: Alex Delis, Nick Roussopoulos
• Keywords: Client Server, Database, Enhanced Client Server, Standard Client Server, VLDB 1992