Network concurrency control for autonomous databases featuring independent lock release and lock ownership transfer

• US 5,459,862 A
• Filed: 09/30/1993
• Issued: 10/17/1995
• Est. Priority Date: 06/14/1990
• Status: Expired due to Fees

• Current Assignee: Sunquest Information Systems, Inc. (Roper Technologies, Inc.)
• Original Assignee: Sunquest Information Systems, Inc. (Roper Technologies, Inc.)
• Inventors: Siml, Paul E., Hiscox, Jane D., Friedrichsen, Terry R., Garliepp, James F.
• Primary Examiner(s): Black, Thomas G.
• Assistant Examiner(s): Lintz, Paul R.
• Application Number:
  US08/129,965
• Time in Patent Office: 747 Days
• Field of Search: 395/650, 395/600, 395/425
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2343 Locking methods, e.g. distributed locking or locking implementation details
• 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 system for maintaining the integrity of two substantially identical databases across a computer network consisting of two central processing units interconnected by a communications network includes means within a lock manager for maintaining a lock database on one of the central processing units, means within an application program for initiating a request for a lock to be placed on an identified entity in both of the databases to enable a data update transaction to be performed on the identified entity in both of the databases, and means within the lock manager for locking the identified entity in both of the databases by establishing an entry for the identified entity in the lock database. Such a system for maintaining database integrity also includes means within the application program for entering the data update transaction in a transaction processor queue, means within a network processor for transmitting the data update transaction to a network processor on the other central processing unit, means within a transaction processor for performing the data update transaction on the identified entity and for initiating an unlock request on the identified entity after the data update transaction has been performed, and means within the lock manager for unlocking the identified entity by modifying the entry for the identified entity in the lock database.

Claims

1. A system for maintaining the integrity of two autonomous databases across a computer network, the computer network consisting of two central processing units interconnected by a communications network, two autonomous databases each consisting of the same plurality of entities and wherein one of the databases resides on each of the central processing units, a transaction processor residing on each of the central processing units, application programs residing on each of the central processing units, a network processor residing on each of the central processing units, and a lock manager residing on each of the central processing units, said system for maintaining the value assigned to each entity the same between the two databases, said system comprising:

means, within each lock manager, for maintaining a lock database on one of the central processing units;

means, within each application program, for initiating a request for a lock to be placed on an identified entity in both of the databases to enable a data update transaction to be performed on said identified entity in both of the databases;

means, within each lock manager, for enabling one of the lock managers to lock said identified entity in both of the databases, in response to said means for initiating said lock request, by establishing an entry for said identified entity in said lock database;

means, within each application program, for entering said data update transaction in a transaction processor queue;

means, within each network processor, for transmitting said data update transaction to the other network processor;

means, within each transaction processor for performing said data update transaction on said identified entity in the database on the central processing unit on which that transaction processor resides and for initiating an unlock request on said identified entity after said data update transaction has been performed; and

means, within each lock manager, for unlocking said identified entity only in the database on the central processing unit on which that lock manager resides, in response to said means for initiating said unlock request, by modifying said entry for said identified entity in said lock database and transferring ownership of the lock, when necessary, to the CPU where the update transaction was performed.

2. A system for maintaining the integrity of two autonomous databases across a computer network, the computer network consisting of two central processing units interconnected by a communications network, two databases each consisting of the same plurality of entities and wherein one of the databases resides on each of the central processing units, a transaction processor residing on each of the central processing units, application programs residing on each of the central processing units, a network processor residing on each of the central processing units, and a lock manager residing on each of the central processing units, said system for maintaining the value assigned to each entity the same between the two databases, said system comprising:

means, within the lock manager on each central processing unit, for maintaining a lock database on one of the central processing units;

means, within the application program on one of the central processing units, for initiating a request for a lock to be placed on an identified entity in both of the databases to enable a data update transaction to be performed on said identified entity in both of the databases;

means, within the lock manager residing on the same central processing unit as said means for initiating said lock request, for locking said identified entity in both of the databases, in response to said means for initiating said lock request, by establishing an entry for said identified entity in said lock database;

means, within the application program containing said means for initiating said lock request, for entering said data update transaction in a transaction processor queue residing on the same central processing unit as said means for initiating said lock request;

means, within the network processor residing on the same central processing unit as said means for initiating said lock request, for transmitting said data update transaction to the network processor residing on the other central processing unit;

means, within the transaction processor on each central processing unit, for performing said data update transaction on said identified entity in the database on the central processing unit on which that transaction processor resides;

means, within the transaction processor on each central processing unit, for initiating an unlock request on said identified entity after said data update transaction has been performed on said identified entity in the database on the central processing unit on which that transaction processor resides; and

means, within the lock manager on each central processing unit, for unlocking said identified entity only in the database on the central processing unit on which that lock manager resides, in response to said means for initiating said unlock request, by modifying said entry for said identified entity in said lock database and transferring ownership of the lock, when necessary, to the CPU where the update transaction was performed.

3. The system of claim 2 wherein said means for locking said identified entity includes means for establishing said entry for said identified entity in said lock database by storing in said lock database an entity name, a lock expiration time, an originating central processing unit, a current lock count, and an original lock count.

4. The system of claim 3 wherein said means for locking said identified entity includes means for assigning a lock sequence number to said lock request thereby forming a unique entity name-lock sequence number pair to identify said lock request.

5. The system of claim 4 wherein a location of said established entry in said lock database corresponds to said assigned lock sequence number and wherein said lock sequence number is stored with said entity name in a cross-reference table.

6. The system of claim 5 wherein said means for locking said identified entity includes means for initializing both said current lock count in said established entity and said original lock count in said established entity to a value of two.

7. The system of claim 6 wherein said means for locking said identified entity includes means for determining whether said entity name of said identified entity is stored in said lock database.

8. The system of claim 7 wherein said means for determining whether said entity name of said identified entity is stored in said lock database includes means for determining whether said entity name is stored in said cross-reference table.

9. The system of claim 8 wherein said means for locking said identified entity includes means for granting said lock request if said entity name does not appear in said lock database.

10. The system of claim 9 wherein said means for locking said identified entity includes means for granting said lock request if said entity name appears in said lock database, said current lock count in said established entry is equal to one, and said originating central processing unit in said established entry is the same as the central processing unit from which said lock request originated.

11. The system of claim 3 wherein said means for unlocking said identified entity includes means for decrementing said current lock count in said established entry by one.

12. The system of claim 11 wherein said means for unlocking said identified entity includes means for removing said established entry from said lock database if said current lock count in said established entry equals zero.

13. The system of claim 12 wherein said means for unlocking said identified entity includes means for modifying said originating central processing unit in said established entry if said originating central processing unit in said established entry is not the same as the central processing unit from which said unlock request originated.

14. The system of claim 3 wherein said means for locking said identified entity initializes said lock expiration time to zero to create an infinite lock and wherein said means for locking said identified entity initializes said lock expiration time to a non-zero integer to create a finite lock.

15. The system of claim 14 wherein said means for locking said identified entity includes means for granting said lock request if said lock expiration time in said established entry is a non-zero integer which corresponds to a time of day earlier than a time of day at which said lock request was initiated.

16. A method for maintaining the integrity of two autonomous databases across a computer network, the computer network consisting of two central processing units interconnected by a communications network and two autonomous databases each consisting of the same plurality of entities and wherein one of the databases resides on each of the central processing units, said method for maintaining the value assigned to each entity the same between the two databases, said method comprising the steps of:

maintaining a lock database on one of the central processing units;

initiating a request for a lock to be placed on an identified entity in both of the databases to enable a data update transaction to be performed on said identified entity in both of the databases;

establishing an entry for said identified entity in said lock database, in response to said step of initiating said lock request, thereby locking said identified entity in both of the databases;

entering said data update transaction in a transaction processor queue;

transmitting said data update transaction to a transaction processor queue on the other central processing unit in the computer network;

performing said data update transaction on said identified entity in one of the databases;

initiating an unlock request on said identified entity in only said one of the databases after performing said data update transaction on said identified entity in said one of the databases; and

unlocking said identified entity in only said one of the databases, in response to said step of initiating said unlock request, by modifying said entry for said identified entity in said lock database and transferring ownership of the lock, when necessary, to the CPU where the update transaction was performed.