Partially replicated distributed database with multiple levels of remote clients

• US 7,231,407 B2
• Filed: 04/02/2004
• Issued: 06/12/2007
• Est. Priority Date: 02/28/1997
• Status: Expired due to Term

• Current Assignee: Siebel Systems Inc. (Oracle Corporation)
• Original Assignee: Siebel Systems Inc. (Oracle Corporation)
• Inventors: Lim, Peter S., Chatterjee, Prashant, Brodersen, Robert S.
• Primary Examiner(s): LEWIS, CHERYL RENEA
• Application Number:
  US10/817,658
• Publication Number:
  US 20040199509A1
• Time in Patent Office: 1,166 Days
• Field of Search: 707/10, 707/100, 707/8, 707/202, 707/200, 707/1, 707/201, 707/203, 709/203, 709/207
• US Class Current: 1/1
• CPC Class Codes: G06F 16/278 Data partitioning, e.g. horizontal or vertical partitioning
• CPC Class Codes: Y10S 707/99931 Database or file accessing
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation
• CPC Class Codes: Y10S 707/99952 Coherency, e.g. same view to multiple users
• CPC Class Codes: Y10S 707/99953 Recoverability

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.

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.

2. The method of claim 1 wherein the local database resident on the workgroup user client is a partially replicated version of the enterprise database on the enterprise server.

3. The method of claim 1 wherein the workgroup user client is a mobile client.

4. The method of claim 1, further comprising synchronizing the work group user database and the enterprise database.

5. The method of claim 1 comprising synchronizing the work group user database and the enterprise database.

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.

7. The computer-readable medium of claim 6 wherein the local database resident on the workgroup user client is a partially replicated version of an enterprise database on the enterprise server.

8. The computer-readable medium of claim 6 wherein the workgroup user client is a mobile client.

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.

10. The database system of claim 9 wherein the local database resident on the workgroup user client is a partially replicated version of the enterprise database resident on the enterprise server.

11. The database system of claim 9 wherein the workgroup user client is a mobile client.