Partially replicated distributed database with multiple levels of remote clients
First Claim
1. A method of managing data in a database system having an enterprise server, at least one docking client, and at least one workgroup user client, comprising:
- creating a distinguished transaction against a local database resident on the workgroup user client;
copying the distinguished transaction from the workgroup user client to the docking client in a manner that indicates that the distinguished transaction did not originate at the enterprise server;
applying the distinguished transaction against an agency database resident on the docking client;
copying from the docking client to the enterprise server one or more transactions, the transactions copied from the docking client to the enterprise server excluding transactions indicated to originate at the enterprise server and including the distinguished transaction; and
applying against an enterprise database on the enterprise server the transactions copied from the docking client to the enterprise server.
0 Assignments
0 Petitions
Accused Products
Abstract
A method of and system for collecting, storing, and retrieving data in a data base management system. The database management system includes a master database server (4), at least one workgroup server (315), and a plurality of workgroup user clients (310). The workgroup server (315) is interposed between the master database server (4) and said workgroup user clients (310). The method creating a transaction in a local database resident on one of the workgroup user clients (310), entering the transaction into a transaction log resident on the workgroup user client (310), and creating a transaction file corresponding to the transaction in an outbox of said workgroup user client (310). Next, the transaction file is copied to an inbox identified to the workgroup user client (310) and updating the transaction file into a workgroup database (305) resident on the workgroup server (315). The workgroup database (305) includes a transaction log.
-
Citations
11 Claims
-
1. A method of managing data in a database system having an enterprise server, at least one docking client, and at least one workgroup user client, comprising:
-
creating a distinguished transaction against a local database resident on the workgroup user client; copying the distinguished transaction from the workgroup user client to the docking client in a manner that indicates that the distinguished transaction did not originate at the enterprise server; applying the distinguished transaction against an agency database resident on the docking client; copying from the docking client to the enterprise server one or more transactions, the transactions copied from the docking client to the enterprise server excluding transactions indicated to originate at the enterprise server and including the distinguished transaction; and applying against an enterprise database on the enterprise server the transactions copied from the docking client to the enterprise server. - View Dependent Claims (2, 3, 4, 5)
-
-
6. A computer-readable medium whose contents cause a computing system to perform a method of imaging data in a database system having an enterprise server, at least one docking client, and at least one workgroup user client, comprising:
-
creating a distinguished transaction against a local database resident on the workgroup user client; copying the distinguished transaction from the workgroup user client to the docking client in a manner that indicates that the distinguished transaction did not originate at the enterprise server; applying the distinguished transaction against an agency database resident on the docking client; copying from the docking client to the enterprise server one or more transactions, the transactions copied from the docking client to the enterprise server excluding transactions indicated to originate at the enterprise server and including the distinguished transaction; and applying against an enterprise database on the enterprise server the transactions copied from the docking client to the enterprise server. - View Dependent Claims (7, 8)
-
-
9. A database system, comprising:
-
a workgroup user client, in which a distinguished transaction is created against a local database resident on the work group user client; a docking client, to which the distinguished transaction is copied from the workgroup user client in a manner that indicates that the distinguished transaction did not originate at the enterprise server, an agency database being resident on the docking client against which the distinguished transaction is applied; and an enterprise server, to which one or more transactions are copied from the docking client, the transactions copied from the docking client to the enterprise server excluding transactions indicated to originate at the enterprise server and including the distinguished transaction, an enterprise database being resident on the enterprise server against which the transaction is copied from the docking client to the enterprise server are applied. - View Dependent Claims (10, 11)
-
Specification