Remote database update method and apparatus

• US 6,684,224 B2
• Filed: 01/16/2001
• Issued: 01/27/2004
• Est. Priority Date: 01/16/2001
• Status: Expired due to Fees

• Current Assignee: ChipData, Inc.
• Original Assignee: ChipData, Inc.
• Inventors: Meding, Uwe, Gaitonde, Salil
• Primary Examiner(s): ALAM, SHAHID AL
• Application Number:
  US09/760,976
• Publication Number:
  US 20020095413A1
• Time in Patent Office: 1,106 Days
• Field of Search: 707/201, 707/203, 707/9, 707/10, 707/101, 707/102, 707/103.R, 707/202, 707/204, 709/217, 709/218
• US Class Current: 1/1
• CPC Class Codes: G06F 16/27 Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
• CPC Class Codes: G06F 16/275 Synchronous replication
• CPC Class Codes: Y10S 707/99939 Privileged access
• CPC Class Codes: Y10S 707/99952 Coherency, e.g. same view to multiple users

Abstract

Disclosed is an apparatus and method for selectively supplying the latest versions of portions of a source database to each of a plurality of uniquely identifiable target entities where some target entities may have access to portions completely different from those portions to which other target entities are entitled to receive. The data receiving target entity provides an indication of the time stamp and revision indications of all material presently available to the receiving entity along with the unique identifier of the receiving entity. The source returns a table of all material that a requesting entity is entitled to access along with an indication of data that has changed since the last update for the requesting entity. The requesting entity then selects from the table the desired data items to be received and obtains same from the source database.

Claims

1. A method of managing data distribution of selected portions of data from a source server database over a network to a remote entity target database, comprising the steps of:

assigning a unique identifier to a remote target entity;

receiving an update request from the remote target entity at said source server;

sending a first source server message from said source server to said target entity indicating all items that have changed since the last previous update for said target that the target is entitled to receive;

defining selected types of data to be accessible in conjunction with said unique identifier; and

granting download of data selected from the first source server message by the remote target entity, conforming to the unique identifier defined types of data, upon request by said remote entity.

2. The method of claim 1 wherein the granting of download of data from a source server associated with said source database to a remote entity target includes the steps of:

returning an acknowledgement message from said source server to said target when the source server is ready to provide an update;

creating a transaction context in a storage location of said target;

sending a first target message from said target to said source server indicating the time of occurrence of last previous update at said target;

creating a transaction context in a storage location of said source server upon receipt of the response message from said target;

returning a second target message, from said target to said source server, detailing the items required from said source server as selected from said first source server message;

sending the items, as part of a second source server message and as requested in said second target message, from said source server to said target;

checking the data received by said target as part of said second source server message to determine if all requested data has been received;

notifying said source server to supply any remaining requested data if the checking by said target determines any deficiency;

sending a third target message from said target to said source server when said target deems that the transaction is complete; and

returning an acknowledgement third source server message to said target that the source server has received the transaction complete third target message.

3. A method of managing data distribution of selected portions of data from a source server database over a network to a remote entity target database, comprising the steps of:

assigning a unique identifier to a remote entity;

defining selected types of data to be accessible in conjunction with said unique identifier;

receiving an update request at the said source server from the remote target entity;

sending a first source message from said source server to said target entity indicating all items that have changed since last previous update for said target that said target is entitled to receive; and

downloading specified data selected by the target entity, conforming to the unique identifier defined types of data available to be downloaded, upon request by said remote entity target.

4. The method of claim 3 wherein the downloading of data from a source server associated with said source database to a remote entity target includes the steps of:

returning an acknowledgement message from said target to said source server when the target is ready to receive an update;

creating a transaction context at said target;

sending a first target message from said target to said source server indicating the time of occurrence of last previous update at said target;

creating a transaction context at said source server upon receipt of the response message from said target;

returning a second target message, from said target to said source server, detailing the items required from said source server as selected from said first source server message;

sending the items, as part of a second source server message and as requested in said second target message, from said source server to said target;

sending a third target message from said target to said source server when said target deems that the transaction is complete; and

returning an acknowledgement third source server message to said target that the source server has received the transaction complete third target message.

5. A method of selectively supplying updating data from a source database to one of a plurality of remotely located target databases, comprising the steps of:

assigning unique identifiers to each of said plurality of target databases;

associating each of said unique identifiers with selected items of said source database in accordance with predetermined criteria;

determining which database items, contained in the source database, have changed since the last update of the database at a given target of those database items that a given target database is entitled to receive as ascertained in accordance with said predetermined criteria;

transmitting a list of database items, from the source database to a control mechanism associated with said target database, that may be supplied from said source database to update said target database;

returning a selected itemization message, from the control mechanism associated with said target database to the control mechanism associated with said source database, requesting the selected items;

supplying the selected items from said source database to said target database; and

notifying the control mechanism associated with said source database when the control mechanism associated with said target database determines that all requested data has been satisfactorily received.

6. The method of claim 5 wherein either one of the control mechanisms associated with the source and target databases may initiate the target database updating procedure.

7. The method of claim 5 wherein the control mechanism associated with the target database supplies the unique identifier applied to the target database to be updated as part of one of the communications with the source database control mechanism before any of the selected items are supplied to the target database.

8. A server system, comprising:

a source database from which predetermined data items may be selected to update each of a plurality of uniquely identifiable target databases;

source computer means associated with said source database;

means for creating a temporary transaction context upon receipt of information from a computer associated with a target database indicating the date of the last update to said target database;

means for preparing a table of contents of all items, to which that uniquely identifiable target database is entitled to receive, that have changed since the last update of said target database occurred;

means for supplying said table of contents to the computer associated with the target database;

means for receiving, from the computer associated with the target database, a list of items to be transferred to said target database as selected from the table of contents supplied to the computer associated with the target database;

means for supplying the selected list of items to the computer associated with the target database; and

means for receiving and acknowledging a transaction complete message from the computer associated with the target database.

9. A server system, comprising:

a uniquely identified target database that may need periodic updates from a source database where the target database is only permitted to receive predetermined items from the source database;

target computer means associated with said target database;

means for creating a temporary transaction context upon determination that both the target computer and a source computer associated with said source database are ready to attempt the completion of an updating procedure;

means for supplying to the source computer associated with said source database information indicating the date of the last update to said target database;

means for receiving a table of contents, from the source computer associated with said source database, of all items, to which that uniquely identifiable target database is entitled to receive, that have changed since the last update of said target database occurred;

means for providing a list of items to be transferred to said target database, as selected from the table of contents, to the source computer associated with said source database;

means for receiving the selected list of items from the source computer associated with said source database; and

means for supplying to and acknowledging a transaction complete message from the computer associated with the source database.

10. Database updating apparatus, comprising:

source database;

source control associated with said source database;

target control apparatus including a target database and a uniquely identifiable target entity;

means for communicating between said source and target controls;

specification means, associated with said source control and source database, for defining the access limitations for each uniquely identifiable target entity entitled to access the source database;

means, associated with said target control apparatus, for requesting data from said source database for a given uniquely identifiable target entity;

means, associated with said source control, for supplying a table of data to which the requesting uniquely identifiable target entity is entitled to receive;

means, associated with said target control, for returning a list of items, selected from said table, to said source control; and

means, associated with said source control, for transferring the latest version of the selected data from said source database to said target control.

11. Database updating apparatus, comprising:

source database;

source control associated with said source database;

means for communicating between said source and target entities;

specification means, associated with said source control and source database, for defining the access limitations for each uniquely identifiable target entity entitled to access the source database;

means, associated with said source control, for supplying a table of data to which the requesting uniquely identifiable target entity is entitled to receive; and

means, associated with said source control, for transferring the latest version of data selected by the target entity from the table of data to the target entity.

12. Database updating apparatus, comprising:

target control apparatus including a target database and a uniquely identifiable target entity;

means for communicating with a limited access source database;

means, associated with said target control apparatus, for requesting up-to-date data from the limited access source database for a given uniquely identifiable target entity;

means, associated with said target control, for returning a list of items, selected from a table of data obtained from the source database and which table is limited to only data to which the target entity is entitled to access, to said source control; and

means, associated with said target control, for storing the latest version of the selected data received from said source database.