Management of updates in the enhanced client-server DBMS

The client-server DBMS model has emerged as the main paradigm in database computing. The enhanced client-server architecture takes advantage of all the available client resources including their disk managers. Clients can cache server data into their own disk units if data are part of their operational space. However, when updates occur at the server, some of the client data managers may need to not only be notified about them but also obtain portions of the updates as well. In this paper, we examine the problem of managing server-imposed updates that affect client cached data. We propose a number of server update propagation techniques in the context of the enhanced client-server DBMS architecture and examine the performance of these strategies through detailed simulation experiments.<<ETX>>

[1]  Akihito Nakamura,et al.  Reliable broadcast protocol for selectively partially ordering PDUs (SPO protocol) , 1991, [1991] Proceedings. 11th International Conference on Distributed Computing Systems.

[2]  Lawrence A. Rowe,et al.  Cache consistency and concurrency control in a client/server DBMS architecture , 1991, SIGMOD '91.

[3]  Liba Svobodova.  File servers for network-based distributed systems , 1984, CSUR.

[4]  Miron Livny,et al.  Data caching tradeoffs in client-server DBMS architectures , 1991, SIGMOD '91.

[5]  Nick Roussopoulos,et al.  An incremental access method for ViewCache: concept, algorithms, and cost analysis , 1991, TODS.

[6]  Miron Livny,et al.  Local Disk Caching for Client-Server Database Systems , 1993, VLDB.

[7]  Derek L. Eager,et al.  Disk cache performance for distributed systems , 1990, Proceedings.,10th International Conference on Distributed Computing Systems.

[8]  W. Richard Stevens,et al.  Unix network programming , 1990, CCRV.

[9]  James K. Archibald,et al.  Cache coherence protocols: evaluation using a multiprocessor simulation model , 1986, TOCS.

[10]  Meichun Hsu,et al.  Update propagation in distributed memory hierarchy , 1990, [1990] Proceedings. Sixth International Conference on Data Engineering.

[11]  Michael Burrows,et al.  Performance of Firefly RPC , 1989, SOSP '89.

[12]  Arie Segev,et al.  Maintaining materialized views in distributed databases , 1989, [1989] Proceedings. Fifth International Conference on Data Engineering.

[13]  C. J. Date,et al.  A guide to Sybase and the SQL server , 1992 .

[14]  A RoweLawrence,et al.  Cache consistency and concurrency control in a client/server DBMS architecture , 1991 .

[15]  BaerJean-Loup,et al.  Cache coherence protocols: evaluation using a multiprocessor simulation model , 1986 .

[16]  Michael Burrows,et al.  Performance of Firefly RPC , 1990, ACM Trans. Comput. Syst..

[17]  Nick Roussopoulos,et al.  Performance and Scalability of Client-Server Database Architectures , 1992, VLDB.

[18]  Peter Dadam,et al.  Cooperative Object Buffer Management in the Advanced Information Management Prototype , 1987, VLDB.

[19]  John Bloomer,et al.  Power Programming with RPC , 1992 .

[20]  Won Kim,et al.  Architecture of the ORION Next-Generation Database System , 1990, IEEE Trans. Knowl. Data Eng..

[21]  Bill Nitzberg,et al.  Distributed shared memory: a survey of issues and algorithms , 1991, Computer.

[22]  Rafael Alonso,et al.  Data caching issues in an information retrieval system , 1990, TODS.

[23]  Tony P. Ng.  Propagating updates in a highly replicated database , 1990, [1990] Proceedings. Sixth International Conference on Data Engineering.

[24]  Uwe Deppisch,et al.  Tight Database Cooperation in a Server-Workstation Environment , 1987, ICDCS.

[25]  François Bancilhon,et al.  Building an Object-Oriented Database System, The Story of O2 , 1992 .

[26]  Nick Roussopoulos,et al.  Performance Comparison of Three Modern DBMS Architectures , 1993, IEEE Trans. Software Eng..