Granted Patent B2

US 10,198,494 · App. 14/877,669 · Granted Feb 5, 2019

Inventors: Martin McConnachie (Paradise Point, AU); Helen Johnson (Red Hill, AU); Geoffrey Toogood (Forest Lake, AU); Daniel Paul Ruul (Labrador, AU)

Assignee: Allotz.com Limited

G06F17/30578

Abstract

Claims (36)

1. A method of controlling distributed databases using a central computer system, which has a central relational database, systematically to refresh a distributed database that is distributed over a plurality of distributed computer systems and that includes distributed database fields that are for storing contingent values that are contingent on sporadic interactions between terminal computer systems and the distributed computer systems and that are affiliated with central database fields in the central relational database, the method comprising:

recurrently, at receiving times,

receiving contingent values of the distributed database fields from the distributed computer systems; and

storing, in the central relational database, the received contingent values of the distributed database fields in succession with previously received and stored contingent values of the distributed database fields, so as to build, for each distributed computer system an associated series of successive contingent values, and;

recurrently, at refreshing times and temporally independent of the receiving times,

determining fresh initial distribution values for the distributed database fields, based on the successive contingent values for the distributed computer systems and based on required initial distribution conditions;

and

distributing the fresh initial distribution values to the distributed database fields of the distributed computer systems.

2. The method as claimed in claim 1 , in which receiving the contingent values of the distributed database fields from the distributed computer systems includes: at some receiving times, prompting at least some of the distributed computer systems to send the contingent values of their distributed database fields to the central computer system.

3. The method as claimed in claim 1 , in which receiving the contingent values of the distributed database fields from the distributed computer systems includes: at some receiving times, automatically and periodically receiving the contingent values of the distributed database fields from at least some of the distributed computer systems.

4. The method as claimed in claim 1 , in which receiving the contingent values of the distributed database fields from the distributed computer systems includes: at some receiving times, automatically receiving the contingent values of the distributed database fields from at least some of the distributed computer systems, only when a change in the contingent values is caused in response to interactions between independent terminal computer systems and the at least some distributed computer systems.

5. The method as claimed in claim 1 , in which the distributed database that is distributed over the plurality of distributed computer systems includes distributed database fields that are for storing non-contingent values that are associated with the contingent values in the distributed database fields, the method including: at the refreshing times, determining the non-contingent values based on the successive contingent values in the database fields of the distributed computer systems and based on required non-contingent conditions; and distributing the non-contingent values to said database fields to refresh said database fields of the distributed computer systems.

6. The method as claimed in claim 1 , in which determining the fresh initial distribution values for the distributed database fields includes: determining individual control indicators for respective distributed computer systems, each individual control indicator being a function of a previously stored initial distribution value and a most recent contingent value, such that each of the individual control indicators are a measure of a rate at which the contingent value is caused to change by sporadic interactions between terminal computer systems and respective distributed computer systems.

7. The method as claimed in claim 6 , in which determining the fresh initial distribution values for the distributed database fields includes: determining, for each of the distributed computer systems of a group of the distributed computer systems, an associated group control indicator as a function of the respective individual control indicators of the group.

8. The method as claimed in claim 7 , which includes determining, for each of the distributed computer systems, an associated group control indicator as a function of successive non-contingent values for said each of the distributed computer systems.

9. The method as claimed in claim 1 , which includes, at the refreshing times, determining whether or not to proceed with determining the fresh initial distribution values for each one of the respective distributed computer systems.

10. The method as claimed in claim 6 , which includes a prior step of determining whether or not to determine the fresh initial distribution values for one of the distributed computer systems as a function of the individual control indicator for that distributed computer system.

11. The method as claimed in claim 7 , which includes a prior step of determining whether or not to determine fresh initial distribution values for one of the distributed computer systems as a function of the group control indicator for that distributed computer system.

12. The method as claimed in claim 6 , which includes a prior step of determining whether or not to determine fresh non-contingent values for one of the distributed computer systems as a function of the individual control indicator for that distributed computer system.

13. The method as claimed in claim 7 , which includes the prior step of determining whether or not to determine fresh non-contingent values for one of the distributed computer systems of the group of distributed computer systems as a function of the group control indicator.

14. The method as claimed in claim 6 , in which determining the fresh initial distribution values for the distributed database fields includes allocating number values to the database fields of the respective distributed computer systems, said number values being related to rates of change of the contingent values associated with said respective computer systems.

15. The method as claimed in claim 7 , in which determining the fresh non-contingent values for the non-contingent database fields includes allocating number values to the database fields of the respective distributed computer systems, said number values being related to rates of change of the non-contingent values associated with said respective computer systems.

16. A central computer system for controlling distributed databases, the computer system having a central relational database that is used systematically to refresh a distributed database that is distributed over a plurality of distributed computer systems and that includes distributed database fields that are for storing contingent values that are contingent on sporadic interactions between independent terminal computer systems and the distributed computer systems and that are affiliated with central database fields in the central relational database, the central computer system being configured to:

recurrently, at receiving times,

receive contingent values of the distributed database fields from the distributed computer systems; and

store, in the central relational database, the received contingent values of the distributed database fields in succession with previously received and stored contingent values of the distributed database fields, so as to build, for each distributed computer system an associated series of successive contingent values, and;

recurrently, at refreshing times and temporally independent of the receiving times,

determine fresh initial distribution values for the distributed database fields, based on the successive contingent values for the distributed computer systems and based on required initial distribution conditions; and

distribute the fresh initial distribution values to the distributed database fields of the distributed computer systems.

17. A non-transitory, computer-readable medium comprising instructions stored thereon that, when executed by a central computer system having a central relational database that is used systematically to refresh a distributed database that is distributed over a plurality of distributed computer systems and that includes distributed database fields that are for storing contingent values that are contingent on sporadic interactions between independent terminal computer systems and the distributed computer systems and that are affiliated with central database fields in the central relational database, causes the central computer system to perform the steps of:

recurrently, at receiving times,

receiving contingent values of the distributed database fields from the distributed computer systems; and

storing, in the central relational database, the received contingent values of the distributed database fields in succession with previously received and stored contingent values of the distributed database fields, so as to build, for each distributed computer system an associated series of successive contingent values, and;

recurrently, at refreshing times and temporally independent of the receiving times,

determining fresh initial distribution values for the distributed database fields, based on the successive contingent values for the distributed computer systems and based on required initial distribution conditions; and

distributing the fresh initial distribution values to the distributed database fields of the distributed computer systems.

Assignments (16)

Priority Claims (1)

Continuity (2)

Cited By (2)

US 12,236,253 US 12,688,165