A system and method are described for implementing a distributed database
caching system with the capability to support and accelerate read and
update transactions to and from one or more central Database Management
System (DBMS) servers for multiple concurrent users. The system and
method include a resource abstraction layer in a database client driver
in communication with remote server units (RSUs) having a cache database.
RSUs respond to user requests using the cache database if possible. If
the cache database does not have the needed data, the RSU sends the
request to a database subscription manager (DSM) in communication with
the DBMS server. The DSM responds to the request and sends predicate data
based on queries processed by the DBMS server for use in updating the
cache databases.