ACM SIGMOD Anthology VLDB dblp.uni-trier.de

Performance and Scalability of Client-Server Database Architectures.

Alex Delis, Nick Roussopoulos: Performance and Scalability of Client-Server Database Architectures. VLDB 1992: 610-623
@inproceedings{DBLP:conf/vldb/DelisR92,
  author    = {Alex Delis and
               Nick Roussopoulos},
  editor    = {Li-Yan Yuan},
  title     = {Performance and Scalability of Client-Server Database Architectures},
  booktitle = {18th International Conference on Very Large Data Bases, August
               23-27, 1992, Vancouver, Canada, Proceedings},
  publisher = {Morgan Kaufmann},
  year      = {1992},
  isbn      = {1-55860-151-1},
  pages     = {610-623},
  ee        = {db/conf/vldb/DelisR92.html},
  crossref  = {DBLP:conf/vldb/92},
  bibsource = {DBLP, http://dblp.uni-trier.de}
}

Abstract

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 different 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 con-sistency 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 byone or more orders of magnitude. The Client-Server with Multiple Disks architecture offers performance comparable to that achieved by the Enhanced Client- Server for up to 100 clients, but the latter scales up a lot better for higher number of clients.

Copyright © 1992 by the VLDB Endowment. Permission to copy without fee all or part of this material is granted provided that the copies are not made or distributed for direct commercial advantage, the VLDB copyright notice and the title of the publication and its date appear, and notice is given that copying is by the permission of the Very Large Data Base Endowment. To copy otherwise, or to republish, requires a fee and/or special permission from the Endowment.


Online Paper

ACM SIGMOD Anthology

CDROM Version: Load the CDROM "Volume 1 Issue 5, VLDB '89-'97" and ... DVD Version: Load ACM SIGMOD Anthology DVD 1" and ...

Printed Edition

Li-Yan Yuan (Ed.): 18th International Conference on Very Large Data Bases, August 23-27, 1992, Vancouver, Canada, Proceedings. Morgan Kaufmann 1992, ISBN 1-55860-151-1
Contents CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML

References

[AB86]
James K. Archibald, Jean-Loup Baer: Cache Coherence Protocols: Evaluation Using a Multiprocessor Simulation Model. ACM Trans. Comput. Syst. 4(4): 273-298(1986) CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[ABGM90]
Rafael Alonso, Daniel Barbará, Hector Garcia-Molina: Data Caching Issues in an Information Retrieval System. ACM Trans. Database Syst. 15(3): 359-384(1990) CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[ACL87]
Rakesh Agrawal, Michael J. Carey, Miron Livny: Concurrency Control Performance Modeling: Alternatives and Implications. ACM Trans. Database Syst. 12(4): 609-654(1987) CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[BE89]
...
[BS88]
Anupam Bhide: An Analysis of Three Transaction Processing Architectures. VLDB 1988: 339-350 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[CD85]
Hong-Tai Chou, David J. DeWitt: An Evaluation of Buffer Management Strategies for Relational Database Systems. VLDB 1985: 127-141 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[CFLS91]
Michael J. Carey, Michael J. Franklin, Miron Livny, Eugene J. Shekita: Data Caching Tradeoffs in Client-Server DBMS Architectures. SIGMOD Conference 1991: 357-366 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[DBP88]
...
[DGK+86]
David J. DeWitt, Robert H. Gerber, Goetz Graefe, Michael L. Heytens, Krishna B. Kumar, M. Muralikrishna: GAMMA - A High Performance Dataflow Database Machine. VLDB 1986: 228-237 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[DMFV90]
David J. DeWitt, Philippe Futtersack, David Maier, Fernando Vélez: A Study of Three Alternative Workstation-Server Architectures for Object Oriented Database Systems. VLDB 1990: 107-121 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[DR91a]
Alex Delis, Nick Roussopoulos: Performance Comparison of Three Modern DBMS Architectures. IEEE Trans. Software Eng. 19(2): 120-138(1993) CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[DR91b]
...
[FD90]
...
[Fer84]
Domenico Ferrari: On the Foundations of Artificial Workload Design. SIGMETRICS 1984: 8-14 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[GLPT76]
...
[Hal89]
Gary Hallmark: Function Request Shipping in a Database Machine Environment. IWDM 1989: 171-186 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[HF86]
Robert B. Hagmann, Domenico Ferrari: Performance Analysis of Several Back-End Database Architectures. ACM Trans. Database Syst. 11(1): 1-26(1986) CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[KDG87]
Klaus Küspert, Peter Dadam, Jürgen Günauer: Cooperative Object Buffer Management in the Advanced Information Management Prototype. VLDB 1987: 483-492 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[KGBW90]
Won Kim, Jorge F. Garza, Nat Ballou, Darrell Woelk: Architecture of the ORION Next-Generation Database System. IEEE Trans. Knowl. Data Eng. 2(1): 109-124(1990) CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[PGK88]
David A. Patterson, Garth A. Gibson, Randy H. Katz: A Case for Redundant Arrays of Inexpensive Disks (RAID). SIGMOD Conference 1988: 109-116 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[PJ91]
James M. Purtilo, Pankaj Jalote: An Environment for Developing Fault-Tolerant Software. IEEE Trans. Software Eng. 17(2): 153-159(1991) CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[RD91]
Nick Roussopoulos, Alex Delis: Modern Client-Server DBMS Architectures. SIGMOD Record 20(3): 52-61(1991) CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[RK86]
Nick Roussopoulos, Hyunchul Kang: Principles and Techniques in the Design of ADMS±. IEEE Computer 19(12): 19-25(1986) CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[RKC87]
W. Bradley Rubenstein, M. S. Kubicar, R. G. G. Cattell: Benchmarking Simple Database Operations. SIGMOD Conference 1987: 387-394 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[Rou91]
Nick Roussopoulos: An Incremental Access Method for ViewCache: Concept, Algorithms, and Cost Analysis. ACM Trans. Database Syst. 16(3): 535-563(1991) CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[SKK+90]
Mahadev Satyanarayanan, James J. Kistler, Puneet Kumar, Maria E. Okasaki, Ellen H. Siegel, David C. Steere: Coda: A Highly Available File System for a Distributed Workstation Environment. IEEE Trans. Computers 39(4): 447-459(1990) CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[SM86]
Kenneth Salem, Hector Garcia-Molina: Disk Striping. ICDE 1986: 336-342 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[Ste90]
...
[TR91]
Alexander Thomasian, In Kyung Ryu: Performance Analysis of Two-Phase Locking. IEEE Trans. Software Eng. 17(5): 386-402(1991) CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[WN90]
W. Kevin Wilkinson, Marie-Anne Neimat: Maintaining Consistency of Client-Cached Data. VLDB 1990: 122-133 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[Wol89]
Joel L. Wolf: The Placement Optimization Program: A Practical Solution to the Disk File Assignment Problem. SIGMETRICS 1989: 1-10 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[WR91]
Yongdong Wang, Lawrence A. Rowe: Cache Consistency and Concurrency Control in a Client/Server DBMS Architecture. SIGMOD Conference 1991: 367-376 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML

Copyright © Fri Mar 12 17:22:52 2010 by Michael Ley (ley@uni-trier.de)