File based and highly available hybrid database

• US 5,418,945 A
• Filed: 05/18/1992
• Issued: 05/23/1995
• Est. Priority Date: 05/18/1992
• Status: Expired due to Fees

• Current Assignee: Freescale Semiconductor, Inc. (NXP Semiconductors NV)
• Original Assignee: Motorola, Inc. (Motorola Solutions, Inc.)
• Inventors: Higgins, Warren F., Carter, Renee N., Lee, Richard O.
• Primary Examiner(s): Black, Thomas G.
• Assistant Examiner(s): HOMERE, JEAN RAYMOND
• Application Number:
  US07/884,816
• Time in Patent Office: 1,100 Days
• Field of Search: 395/650, 395/575, 395/600, 395/725, 364/DIG. 1
• 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/99938 Concurrency, e.g. lock management in shared database
• CPC Class Codes: Y10S 707/99939 Privileged access
• CPC Class Codes: Y10S 707/99952 Coherency, e.g. same view to multiple users

Abstract

A file based and highly available hybrid database using resident databases (16, 17, 18) on data control computer systems (31, 32, 33) which are linked together as part of a computer network (29). Resident databases (16, 17, 18) are selected to store master file groups (19,21,22,23) the information being copied to other resident databases (16, 17, 18). All database transactions are controlled by interacting client (11) and server (12, 13, 14) processes using the computer network (29) to copy a master file group (19, 21, 22, 23) to the client system for use and then restores the master file group (19, 21, 22, 23) to the appropriate master database (16, 17, 18).

Claims

1. A method of accessing file-based databases that are linked together across a computer network, comprising the steps of:

storing a first master file group on a first one of the databases where said first master file group is edited by down-loading said first master file group to a first remote user having checkout authorization and then replacing said first master file group on said first one of the databases with a first edited version created by said first remote user having checkout authorization;

storing a copy of said first master file group on other ones of the databases where said copy of said first master file group is down-loaded to a second remote user;

replacing said copy of said first master file group on other ones of the databases with said first edited version created by said first remote user having checkout authorization upon updating said first master file group on said first one of the databases;

allowing said second remote user with exclusive override authorization to locally edit said copy of said first master file group and replace said first master file group on said first one of the databases with a second edited version created by said second remote user having exclusive override authorization;

replacing said copy of said first master file group on other ones of the databases with said second edited version created by said second remote user having exclusive override authorization upon updating said first master file group on said first one of the databases;

storing a second master file group on a second one of the databases where said second master file group is edited by down-loading said second master file group to a third remote user having checkout authorization and then replacing said second master file group on said second one of the databases with a third edited version created by said third remote user having checkout authorization; and

storing a copy of said second master file group on other ones of the databases where said copy of said second master file group is down-loaded to a fourth remote user.

2. The method of claim 1 further comprising the step of allowing said fourth remote user with exclusive override authorization to locally edit said copy of said second master file group and replace said second master file group on said second one of the databases with a fourth edited version created by said fourth remote user having exclusive override authorization.

3. The method of claim 2 further comprising the step of replacing said copy of said second master file group on other ones of the databases with said fourth edited version created by said fourth remote user having exclusive override authorization upon updating said second master file group on said second one of the databases.

4. The method of claim 3 further comprising the step of establishing exclusive override authorization over said first master file group with said second remote user as owner of said first master file group.

5. The method of claim 4 further comprising the step of granting said checkout authorization over said first master file group to said first remote user by said second remote user.

6. The method of claim 5 further comprising the step of establishing exclusive override and checkout authorization over said second master file group with said third remote user as owner of said second master file group.

7. The method of claim 6 further comprising the step of granting said exclusive override and checkout authorization over said second master file group to said fourth remote user by said third remote user.

8. The method of claim 7 further comprising the step of tracking updates of said first and second edited versions to coordinate changes between said first master file group and said copy of said first master file group to ensure that said copy of said first master file group is consistent with said first master file group.

9. The method of claim 8 further comprising the step of tracking updates of said third and fourth edited versions to coordinate changes between said second master file group and said copy of said second master file group to ensure that said copy of said second master file group is consistent with said second master file group.