Synchronization of server database with client database using distribution tables

• US 5,758,355 A
• Filed: 08/07/1996
• Issued: 05/26/1998
• Est. Priority Date: 08/07/1996
• Status: Expired due to Term

• Current Assignee: Aurum Software, Inc. (Baan Co. NV)
• Original Assignee: Aurum Software, Inc. (Baan Co. NV)
• Inventors: Buchanan, David D.
• Primary Examiner(s): Black, Thomas G.
• Assistant Examiner(s): Mizrahi, Diane D.
• Application Number:
  US08/695,242
• Time in Patent Office: 657 Days
• Field of Search: 707/1-19, 707/101-9, 707/201
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2308 Concurrency control transaction processing G06F9/466
• CPC Class Codes: G06F 16/2322 using timestamps
• 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: Y10S 707/99931 Database or file accessing
• CPC Class Codes: Y10S 707/99952 Coherency, e.g. same view to multiple users

Abstract

A storage medium encoded is provided for use in synchronization of a server database, which includes a plurality of tables and which is accessible on a server computer system, and a client database, which is accessible on a client computer system and which includes a subset of the tables in the server database, the storage medium comprising a first distribution point table in the server database which has the property that modification of such first distribution point table may influence distribution of information from the server database to the client database during a synchronization of the server database and the client database; a first distribution table which corresponds to the first distribution point table which is separate from the server database application tables and which includes identification information that identifies occurrences of information within the server database that may require distribution to the client database during a synchronization of the server database and the client database; and a first extract program which references the identification information in the first distribution table and corresponding information in the first distribution point table to identify information in the first distribution point table to be distributed to the client database during a synchronization of the server database and the client database.

Claims

1. A storage medium encoded for use in synchronization of a server database and multiple respective client databases, wherein the server database includes a plurality of server tables and is accessible on a server computer system, and wherein the respective client databases include respective subsets of the server database and are accessible on respective client computers, the storage medium comprising:

a first distribution point table in the server database which has the property that modification of such first distribution point table may influence the distribution requirements of respective client databases during respective synchronizations of the server database and such client databases;

a first distribution point table separate from the server database application tables which includes respective information that respectively identifies different client databases and that respectively relates the different identified client databases to respective information in the distribution point table that may affect distribution requirements during respective synchronizations of the server database and such respective identified client databases;

a first extract program which identifies information in said first distribution point table to be distributed to a respective synchronizing client database by referencing respective distribution information in the respective first distribution table that identifies such synchronizing client database and by referencing respective related corresponding information in said distribution point table.

2. The storage medium of claim 1, further including:

a first distribution relation table in the server database which has the property that modification of said first distribution point table may influence distribution of information from such first distribution relation table to respective client databases during respective synchronizations of the server database and respective client databases; and

a second extract program which identifies information in said first distribution relation table to be distributed to a respective synchronizing client database by referencing distribution information in the respective first distribution table that identifies such synchronizing client database and by referencing respective related corresponding information in said first distribution relation table.

3. The storage medium of claim 2, further including:

update time information in said first distribution relation table;

wherein the second extract program references the update time information in said first distribution relation table to determine whether distribution of information is required from the first distribution relation table to a respective client database during a synchronization of the server database and such respective client database.

4. The storage medium of claim 2, further including:

update client information in said first distribution relation table;

wherein the second extract program references the update client information in said first distribution relation table to determine whether distribution of information is required from the first distribution relation table to a respective client database during a synchronization of the server database and such respective client database.

5. The storage medium of claim 2, further including:

update time information and update client information in said first distribution relation table;

wherein the second extract program references the update time information and the update client information in said first distribution relation table to determine whether distribution of information is required from the first distribution relation table to a respective client database during a synchronization of the server database and such respective client database.

6. The storage medium of claim 1, further including:

a first distribution relation table in the server database which has the property that modification of said first distribution point table may influence distribution of information from such first distribution relation table to respective client databases during synchronizations of the server database and respective client database;

a second distribution relation table in the server database which has the property that modification of said first distribution point table may influence distribution of information from such first distribution relation table to respective client databases during respective synchronizations of the server database and respective client databases; and

a second extract program which identifies information in said second distribution relation table to be distributed to a respective synchronizing client database by referencing respective distribution information in the respective first distribution table that identifies such synchronizing client database and by referencing respective related corresponding information in said first distribution relation table and by referencing respective related corresponding information in said second distribution relation table.

7. The storage medium of claims 2 or 6 further including:

a distribution flag in the first distribution table which indicates whether respective distribution rules have been modified for a respective synchronizing client database since a prior synchronization by such respective client database;

wherein the second extract program further references the distribution flag in the first distribution table to determine whether distribution of information is required from the server database to a respective client database during a respective synchronization of the server database and such respective client database.

8. The storage medium of claim 6, further including:

update time information in said second distribution relation table;

wherein the second extract program references the update time information in said second distribution relation table to determine whether distribution of information is required from the second distribution relation table to a respective client database during a synchronization of the server database and such respective client database.

9. The storage medium of claim 6, further including:

update client information in said second distribution relation table;

wherein the second extract program references the update client information in said second distribution relation table to determine whether distribution of information is required from the second distribution relation table to a respective client database during a synchronization of the server database and such respective client database.

10. The storage medium of claim 6, further including:

update time information and update client information in said second distribution relation table;

wherein the second extract program references the update time information and the update client information in said second distribution relation table to determine whether distribution of information is required from the second distribution relation table to a respective client database during a synchronization of the server database and such respective client database.

11. The storage medium of claim 2, further including:

a distribution flag in the first distribution table which indicates whether respective distribution rules have been modified for a respective synchronizing client database since a prior synchronization by such respective client database;

last modify information in the first distribution relation table;

wherein the second extract program further references the distribution flag in the first distribution table and further references the last modify information in the first distribution relation table to determine whether distribution of information is required from the second distribution relation table to a respective client database during a synchronization of the server database and such respective client database in accordance with a rule that distribution is determined to be require if the distribution flag indicates that a modification has occurred.

12. The storage medium of claim 6, further including:

a distribution flag in the first distribution table which indicates whether respective distribution rules have been modified for a respective synchronizing client database since a prior synchronization by such respective client database;

last modify information in the first distribution relation table;

wherein the second extract program further references the distribution flag in the first distribution table and further references the last modify information in the second distribution relation table to determine whether distribution of information is required from the second distribution relation table to a respective client database during a synchronization of the server database and such respective client database in accordance with a rule that distribution is determined to be require if the distribution flag indicates that a modification has occurred.

13. The storage medium of claim 1, further including:

a first distribution relation table in the server database which has the property that modification of said first distribution point table may influence distribution of information from such first distribution relation table to respective client databases during respective synchronizations of the server database and such respective client databases;

a second distribution relation table in the server database which has the property that modification of said first distribution point table may influence distribution of information from such server database distribution relation table to respective client databases during respective synchronizations of the server database and such respective client databases;

a second distribution table separate from the server database application tables which includes respective distribution information that respectively identifies different client databases and that respectively relates the different identified client databases to corresponding information in the first distribution relation table that may affect distribution requirements during respective synchronizations of the server database and such respective identified client databases;

a second extract program which identifies information in said second distribution relation table to be distributed to a respective synchronizing client database by referencing respective distribution information in the respective second distribution table that identifies such synchronizing client database and by referencing respective related corresponding information in said second distribution relation table.

14. The storage medium of claim 13, further including:

update time information in said second distribution relation table;

wherein the second extract program references the update time information in said second distribution relation table to determine whether distribution of information is required from the second distribution relation table to a respective client database during a synchronization of the server database and such respective client database.

15. The storage medium of claim 13, further including:

update client information in said second distribution relation table;

wherein the second extract program references the update client information in said second distribution relation table to determine whether distribution of information is required from the second distribution relation table to a respective client database during a synchronization of the server database and such respective client database.

16. The storage medium of claim 13, further including:

update time information and update client information in said second distribution relation table;

wherein the second extract program references the update time information and the update client information in said second distribution relation table to determine whether distribution of information is required from the second distribution relation table to a respective client database during a synchronization of the server database and such respective client database.

17. The storage medium of claim 13, further including:

a distribution flag in the second distribution table which indicates whether respective distribution rules have been modified for a respective synchronizing client database since a prior synchronization by such respective client database;

wherein the second extract program further references the distribution flag in the second distribution table to determine whether distribution of information is required from the server database to a respective client database during a respective synchronization of the server database and such respective client database.

18. The storage medium of claim 13, further including:

a distribution flag in the first distribution table which indicates whether respective distribution rules have been modified for a respective synchronizing client database since a prior synchronization by such respective client database;

last modify information in the second distribution relation table;

wherein the second extract program further references the distribution flag in the second distribution table and further references the last modify information in the second distribution relation table to determine whether distribution of information is required from the second distribution relation table to a respective client database during a synchronization of the server database and such respective client database in accordance with a rule that distribution is determined to be require if the distribution flag indicates that a modification has occurred.

19. The storage medium of claim 1, further including:

update time information in said first distribution point table;

wherein the first extract program references the update time information in said first distribution point table to determine whether distribution of information is required from the distribution point table to a respective client database during a synchronization of the server database and such respective client database.

20. The storage medium of claim 1, further including:

update client information in said first distribution point table;

wherein the first extract program references the update client information in said first distribution point table to determine whether distribution of information is required from the first distribution point table to a respective client database during a synchronization of such respective server database and the client database.

21. The storage medium of claim 1, further including:

update time information and update client information in said first distribution point table;

wherein the first extract program references the update time information and the update client information in said first distribution point table to determine whether distribution of information is required from the distribution point table to a respective client database during a synchronization of the server database and such respective client database.

22. The storage medium of claim 1, further including:

an update field and an update client field in the first distribution point table;

wherein modification of at least one prescribed column of the first distribution point table may influence distribution of a subset of records from the distribution point table to the client database during a synchronization of the server database and a respective client database; and

wherein the first extract program further references the update date field and the update client field in the first distribution point table to determine whether distribution of information is required from the distribution point table to a respective client database during a synchronization of the server database and such respective client database.

23. The storage medium of claim 1 further including:

a distribution flag in the first distribution table which indicates whether respective distribution rules have been modified for a respective synchronizing client database since a prior synchronization by such respective client database;

wherein the first extract program further references the distribution flag in the first distribution table to determine whether distribution of information is required from the server database to a respective client database during a respective synchronization of the server database and such respective client database.

24. The storage medium of claim 1, further including:

a distribution flag in the first distribution table which indicates whether respective distribution rules have been modified for a respective synchronizing client database since a prior synchronization by such respective client database;

last update information in the first distribution point table;

wherein the first extract program further references the distribution flag in the first distribution table and further references the in the last update information first distribution point table to determine whether distribution of information is required from the distribution point table to the client database during a synchronization at distribution is determined to be required if the distribution flag indicates that a modification has occurred.

25. The storage medium of claims 1, 19, 20, 21, 22, or 24 wherein the first distribution point table also serves as a distribution relation table.

26. A storage medium encoded for use in synchronization of a server database and multiple respective client databases, wherein the server database includes a plurality of server tables and is accessible on a server computer system, and wherein the respective client databases include respective subsets of the server database and are accessible on respective client computers, the storage medium comprising:

a first server database table which has the property that modification of different server database table may influence the distribution requirements of respective client databases during respective synchronizations of the server database and such respective client databases;

a distribution table separate from the server database application tables which includes respective distribution information that respectively identifies different client databases and that respectively relates the different respective client databases to respective information in the different server table that may affect distribution requirements during respective synchronizations of the server database and such respective identified client databases; and

a first extract program which identifies information in said first server table to be distributed to a respective synchronizing client database by referencing respective first distribution information in the respective first distribution table that identifies such synchronizing client database and by referencing respective related information in said first server table.

27. The storage medium of claim 26, further including:

update time information in said database;

wherein the extract program references the update time information in said first server database table to determine whether distribution of information is required from the first database table to a respective client database during a synchronization of the server database and such respective client database.

28. The storage medium of claim 26, further including:

update client information in said first server database table;

wherein the extract program references the update client information in said first server database table to determine whether distribution of information is required from the first server database table to a respective client database during a synchronization of the server database and such respective client database.

29. The storage medium of claim 26, further including:

update time information and update client information in said first server database table;

wherein the extract program references the update time information and the update client information in said first server database table to determine whether distribution of information is required from the first server database table to a respective client database during a synchronization of the server database and such respective client database.

30. The storage medium of claim 26, further including:

a distribution flag in the first distribution table which indicates whether respective distribution rules have been modified for a respective synchronizing client database since a prior synchronization by such respective client database;

wherein the extract program further references the distribution flag in the distribution table to determine whether distribution of information is required from the first server database table to a respective client database during a synchronization of the server database and such respective client database.

31. The storage medium of claim 26, further including:

a distribution flag in the first distribution table which indicates whether respective distribution rules have been modified for a respective synchronizing client database since a prior synchronization by such respective client database;

an update time field and an update client field in the first server table;

wherein the extract program further references the distribution flag in the distribution table and further references the update time field and the update client field in the first server database table to determine whether distribution of information is required from the first server database table to a respective client database during a synchronization of the server database and such respective client database in accordance with a rule that distribution is determined to be required if the distribution information indicates that a modification has occurred.

32. A server database extract process for use during synchronization of a server database and multiple respective client databases, wherein the server database includes a plurality of server tables and is accessible on a server computer system, and wherein the respective client databases include respective subsets of the server database and are accessible on respective client computers, the extract process comprising the steps of:

providing the server database in an electronic storage medium;

providing in the server database a first distribution point table which has the property that modification of such first distribution point table may influence the distribution requirements of respective client databases during respective synchronizations of the server database and such respective client databases;

providing in the electronic medium, separate from the server database application tables, a first distribution table which includes respective distribution rules that respectively relates different respective client databases to respective information in the distribution point table; and

identifying information in said first distribution point table to be distributed to a respective synchronizing client database by referencing respective distribution rules in the respective first distribution table.

33. The process of claim 32 including the further steps:

providing a first distribution relation table in the server database which has the property that modification of said first distribution point table may modify required distribution of information from such first distribution relation table to such a respective identified client database; and

identifying information in said first distribution relation table to be distributed to a respective synchronizing client database by referencing respective distribution rules in the respective first distribution table.

34. The process of claim 32 including the further steps of:

identifying modifications in respective distribution rules that relate to a respective synchronizing client database; and

modifying the distribution table that is related to such respective identified client database based upon such identified modifications in the distribution rules.

35. The process of claim 32 including the further steps of:

identifying modifications in respective distribution rules that relate to a respective synchronizing client database;

modifying the distribution table that is related to such respective identified client database based upon such identified modifications in the distribution rules;

providing a distribution flag in the first distribution table which indicates whether respective distribution rules have been modified for the respective synchronizing client database since a prior synchronization by such respective client database;

referencing the distribution flag in the first distribution table to determine whether distribution of information is required from the first server database table to a respective client database during a synchronization of the server database and such respective client database.

36. A server database extract process for use during synchronization of a server database and multiple respective client databases, wherein the server database includes a plurality of server tables and is accessible on a server computer system, and wherein the respective client databases include respective subsets of the server database and are accessible on respective client computers, the extract process comprising the steps of:

providing the server database in an electronic storage medium;

providing in the server database a first server database table which has the property that modification of different server database application table may influence the distribution requirements of respective client databases during respective synchronizations of the server database and such respective client databases;

providing in the electronic medium, separate from the server database application tables, a first distribution table which includes respective distribution rules that respectively relates different respective client databases to respective information in the different server database application table that may affect distribution requirements; and

identifying information in said first server table to be distributed to a respective synchronizing client database by referencing respective distribution rules in the respective first distribution table and by referencing respective related information in said first server table.

37. A storage medium encoded for use in synchronization of a server database and multiple respective client databases, the storage medium comprising:

a first distribution point table in the server database which includes a column which has the property that modification of entries in such column may influence the distribution of information subsets from at least one server database application table to respective client databases during respective synchronizations of the server database and such respective client databases;

a first distribution table which is separate from the server database application tables and which includes a column which identifies different respective client databases and which includes a column that respectively relates the different respective identified client databases to respective entries in the at least one server database application table for which modification may affect distribution requirements during respective synchronizations of the server database and such respective identified client databases;

first means for identifying information in said first distribution point table to be distributed to a respective synchronizing client database by referencing a respective column in the first distribution table that identifies such respective synchronizing client database and by referencing respective related information in the at least one server database application table.

38. The storage medium of claim 37 wherein the at least one server database application table is the first distribution point table.

39. The storage medium of claim 37, further including:

update time information in said first distribution point table;

wherein said first means references the update time information in said first distribution point table to determine whether distribution of information is required from the at least one server database table to a respective client database during a synchronization of the server database and such respective client database.

40. The storage medium of claim 37, further including:

update client information in said first distribution point table;

wherein said first means references the update client information in said first distribution point table to determine whether distribution of information is required from the at least one server database table to a respective client database during a synchronization of such respective server database and the client database.

41. The storage medium of claim 37, further including:

update time information and update client information in said first distribution point table;

wherein said first means references the update time information and the update client information in said first distribution point table to determine whether distribution of information is required from the at least one server database table to a respective client database during a synchronization of the server database and such respective client database.

42. The storage medium of claim 37, further including:

a distribution flag in the first distribution table which indicates whether respective distribution rules have been modified for a respective synchronizing client database since a prior synchronization by such respective client database;

wherein said first means further references the distribution flag in the first distribution table to determine whether distribution of information is required from the at least one server database table to a respective client database during a respective synchronization of the server database and such respective client database.

43. The storage medium of claim 37, further including:

a distribution flag in the first distribution table which indicates whether respective distribution rules have been modified for a respective synchronizing client database since a prior synchronization by such respective client database;

last update information in the first distribution point table;

wherein said first means further references the distribution flag in the first distribution table and further references the in the last update information first distribution point table to determine whether distribution of information is required from the at least server database table to the client database during a synchronization at distribution is determined to be required if the distribution flag indicates that a modification has occurred.