Communications of the ACM
The HiPAC project: combining active databases and timing constraints
ACM SIGMOD Record - Special Issue on Real-Time Database Systems
Data caching issues in an information retrieval system
ACM Transactions on Database Systems (TODS)
Maintaining consistency of client-cached data
Proceedings of the sixteenth international conference on Very large databases
Data caching tradeoffs in client-server DBMS architectures
SIGMOD '91 Proceedings of the 1991 ACM SIGMOD international conference on Management of data
Cache consistency and concurrency control in a client/server DBMS architecture
SIGMOD '91 Proceedings of the 1991 ACM SIGMOD international conference on Management of data
The POSTGRES next generation database management system
Communications of the ACM
Crash recovery in client-server EXODUS
SIGMOD '92 Proceedings of the 1992 ACM SIGMOD international conference on Management of data
Continuous queries over append-only databases
SIGMOD '92 Proceedings of the 1992 ACM SIGMOD international conference on Management of data
Scheduling real-time transactions: a performance evaluation
ACM Transactions on Database Systems (TODS)
Performance Analysis of Client-Server Storage Systems
IEEE Transactions on Computers
A simulation-based study on the concurrent execution of rules in a database environment
Journal of Parallel and Distributed Computing
ARIES/CSA: a method for database recovery in client-server architectures
SIGMOD '94 Proceedings of the 1994 ACM SIGMOD international conference on Management of data
Class Library Support for Workflow Environments and Applications
IEEE Transactions on Computers
Concurrency control: methods, performance, and analysis
ACM Computing Surveys (CSUR)
Principles of distributed database systems (2nd ed.)
Principles of distributed database systems (2nd ed.)
Comparison of access methods for time-evolving data
ACM Computing Surveys (CSUR)
Scheduling Algorithms for Multiprogramming in a Hard-Real-Time Environment
Journal of the ACM (JACM)
Divergence caching in client-server architectures
PDIS '94 Proceedings of the third international conference on on Parallel and distributed information systems
Active Database Systems: Triggers and Rules for Advanced Database Processing
Active Database Systems: Triggers and Rules for Advanced Database Processing
Techniques for Update Handling in the Enhanced Client-Server DBMS
IEEE Transactions on Knowledge and Data Engineering
Continual Queries for Internet Scale Event-Driven Information Delivery
IEEE Transactions on Knowledge and Data Engineering
Performance Comparison of Three Modern DBMS Architectures
IEEE Transactions on Software Engineering
Propagating Updates in a Highly Replicated Database
Proceedings of the Sixth International Conference on Data Engineering
Universality of Serial Histograms
VLDB '93 Proceedings of the 19th International Conference on Very Large Data Bases
Synchronization and recovery in a client-server storage system
The VLDB Journal — The International Journal on Very Large Data Bases
A predicate-based caching scheme for client-server database architectures
The VLDB Journal — The International Journal on Very Large Data Bases
Real-Time Client-Server Push Strategies: Specification and Evaluation
RTAS '98 Proceedings of the Fourth IEEE Real-Time Technology and Applications Symposium
Virtual deadline assignment in distributed real-time database systems
RTCSA '95 Proceedings of the 2nd International Workshop on Real-Time Computing Systems and Applications
Data sharing and recovery in gigabit-networked databases
ICCCN '95 Proceedings of the 4th International Conference on Computer Communications and Networks
Hi-index | 0.00 |
The widespread availability of networked environments and the arrival of high-speed networks have rekindled interest in the area of automatic data refresh/update mechanisms. In many application areas, the updated information has a limited period of usefulness. Therefore, the development of systems and protocols that can handle such update tasks within predefined deadlines is required. In this paper, we propose and evaluate two real-time update-propagation mechanisms in a client-server environment. The fundamental difference in these two time-constrained techniques, Client–Push and Server-Push, is in the location where the push-transactions are generated. In both these techniques, and in contrast to conventional methods, we propose the transport of the scripts of updating transactions in order to make client-cached data current. This avoids unnecessary shipments of data over the network. Instead, messages are used to maintain the consistency of cached data. In addition, the propagation of update transaction scripts to client sites is neither periodic nor mandatory, but is instead based on client-specific criteria. These criteria depend on the content of the database objects being updated. We carry out a comprehensive experimental evaluation of the suggested methods as we examine the following aspects: (a) time constrained push scheduling issues, (b) effects of various workloads on real-time push-transaction completion rates (efficiency), and (c) overheads imposed by push-transactions on the regular transaction processing. Our experiments show that Client–Push outperforms Server-Push only for a small number of clients. The opposite is true once the load is increased by attaching a large number of sites per server. The efficiency of the update push protocols is, as expected, dependent on the load on the system as well as the percentage of updates to the database. Surprisingly, the percentage of successfully completed real-time push-transactions is not affected very much by the strategy used to schedule them.