US 6,266,669 B1Granted

Partially replicated distributed database with multiple levels of remote clients

AssigneeSiebel Systems, Inc.

InventorsRobert A. Brodersen, Prashant Chatterjee, Peter S. Lim

Life of this patent

Estimating the term…

Loading patent…

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.

Claims20

Dependent claims

A method of collecting, storing, and retrieving data in a multi-tier database management system having a master database server (4), an application server (303), at least one workgroup server (315), and a plurality of workgroup user clients (310), said application server (303) and said workgroup server (315) interposed between said master database server (4) and said workgroup user clients (310), said method comprising:

(a) creating a transaction in a local database resident on one of said workgroup user clients (310),
(b) entering the transaction into a transaction log resident on said workgroup user client (310),
(c) creating a transaction file corresponding thereto in an outbox of said workgroup user client (310);
(d) copying said transaction file to an inbox on said workgroup server (315) identified to the workgroup user client (310),
(e) updating said transaction file into a workgroup database (305) resident on said workgroup server (315), said workgroup database (305) including a transaction log;
(f) reading said workgroup database (305) transaction log while skipping those transactions which originate at the master database server (4),
(g) creating data files corresponding to the entries therein,
(h) copying data files corresponding to transactions originating at the workgroup user client (310) to an inbox on the master database server (4) corresponding to the workgroup server (315), and
(i) updating the transactions into a master database (3) on the master database server (4).

6 more elements

An article of manufacture comprising a computer usable medium having computer readable program code means embodied therein for collecting, storing, and retrieving data in a multi-tier data base management system having a master database server (4), an application server (303), at least one workgroup server (315), and a plurality of workgroup user clients (310), said application server (303) and said workgroup server (315) interposed between said master database server (4) and said workgroup user clients (310), the computer readable program in said article of manufacture comprising computer readable program code for causing a computer to effect:

(a) creating a transaction in a local database resident on one of said workgroup user clients (310),
(b) entering the transaction into a transaction log resident on said workgroup user client (310),
(c) creating a transaction file corresponding thereto in an outbox of said workgroup user client (310);
(d) copying said transaction file to an inbox resident on said workgroup server (315) and identified to the workgroup user client (310),
(e) updating said transaction file into a workgroup database (305) resident on said workgroup server (315), said workgroup database (305) including a transaction log;
(f) reading said workgroup database (305) transaction log while skipping those transactions which originate at the master database server (4),
(g) creating data files corresponding to the entries therein,
(h) copying data files corresponding to an transactions originating at the workgroup user client (310) to an inbox on the master database server (4) corresponding to the workgroup server (315), and
(i) updating the transactions into a master database (3) on the master database server (4).

6 more elements

A program storage device readable by a machine, tangibly embodying a program of instructions executable by a machine to perform method steps for collecting, storing, and retrieving data in a multi-tier data base management system having a master database server (4), an application server (303), at least one workgroup server (315), and a plurality of workgroup user clients (310), said application server (303) and said workgroup server (315) interposed between said master database server (4) and said workgroup user clients (310), said method steps comprising:

(i) creating a transaction in a local database resident on the one of said workgroup user clients (310),
(ii) entering the transaction into a transaction log resident on the workgroup user client (310), and creating a transaction file corresponding thereto in an outbox of the workgroup user client (310);
(iii) copying said transaction file to an inbox resident on the workgroup server (315) and identified to the workgroup user client (310),
(iv) updating said transaction file into a workgroup database (305) resident on said workgroup server (315), said workgroup database (305) including a transaction log;
(v) reading said workgroup database (305) transaction log while skipping those transactions which originate at the master database server (4),
(vi) creating data files corresponding to the entries therein,
(vii) copying data files corresponding to transactions originating at the workgroup user client (310) to an inbox on the master database server (4) corresponding to the workgroup server (315), and
(viii) updating the transactions into a master database (3) on the master database server (4).

5 more elements

A system for managing a database residing in a multitier data base management system having a master database server (4), an application server (303), at least one workgroup server (315), and a plurality of workgroup user clients (310), said application server (303) and said workgroup server (315) interposed between said master database server (4) and said workgroup user clients (310), the system being configured to effect:

(a) creating a transaction in a local database resident on one of said workgroup user clients (310),
(b) entering the transaction into a transaction log resident on said workgroup user client (310),
(c) creating a transaction file corresponding thereto in an outbox of said workgroup user client (310);
(d) copying said transaction file to an inbox resident on said workgroup server (315) and identified to the workgroup user client (310),
(e) updating said transaction file into a workgroup database (305) resident on said workgroup server (315), said workgroup database (305) including a transaction log;
(f) reading said workgroup database (305) transaction log while skipping those transactions which originate at the master database server (4),
(g) creating data files corresponding to the entries therein,
(h) copying data files corresponding to transactions originating at the workgroup user client (310) to an inbox on the master database server (4) corresponding to the workgroup server (315), and
(i) updating the transactions into a master database (3) on the master database server (4).

6 more elements

Dependencies are inferred from the claim text.

Facts

Application: 09/373,128Filed 12 Aug 1999 · continuation
Priority: 27 Feb 1997
Granted: 24 Jul 2001
Term ends: Not estimatedThe source records don’t support an estimate.

Classification7 codes

G06F 16/278
Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system…: data…
Y10S 707/99931
Data processing: database and file management or data structures: database or file accessing
Y10S 707/99934
Query processing, i.e. searching: query formulation, input preparation, or translation
Y10S 707/99952
File or database maintenance: coherency, e.g. same view to multiple users