System for accessing shared data using a serialization graph constructed from a history file showing completed locking dependencies between transactions

• US 5,280,619 A
• Filed: 05/17/1990
• Issued: 01/18/1994
• Est. Priority Date: 05/17/1990
• Status: Expired due to Term

• Current Assignee: Texas Instruments, Inc.
• Original Assignee: Texas Instruments, Inc.
• Inventors: Wang, Chung C.
• Primary Examiner(s): Lee, Thomas C.
• Assistant Examiner(s): WANG, PETER
• Application Number:
  US07/524,775
• Time in Patent Office: 1,342 Days
• Field of Search: 395/725, 395/600, 395/275, 395/650, 395/425
• US Class Current: 710/200
• 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

Abstract

Apparatus for scheduling at least two concurrent transactions accessing a shared data is provided. When a lock request is granted, the apparatus provides for constructing a history file for the shared data to show each data accessing transaction, and also provides for constructing a serialization graph with each node denoting an active transaction, and each directed edge denoting a dependency between two transactions. The serialization graph is searched for a cycle formed by transactions, and if any is found, the transactions are aborted and restarted.

Claims

1. Apparatus for scheduling at least two concurrent transactions accessing shared data, comprising:

means for constructing a history file for said shared data showing the intended effect of each accessing transaction to be scheduled;

means for constructing a serialization relationship from said history file, said serialization relationship showing completed locking dependencies between said transactions;

means for detecting a cycle in said serialization relationship and formed by said transactions;

means for aborting said scheduling of said transactions in response to detecting said cycle; and

aborting said scheduling of said transactions in said cycle in response to said detection of said cycle.

2. The apparatus, as in claim 1, wherein said history file constructing means includes means for recording a type of data access.

3. The apparatus, as in claim 2, wherein said recording means includes means for recording a read access or a write access as executed in accordance with said transactions.

4. The apparatus, as in claim 1, wherein said shared data includes a plurality of data items, and said history file constructing means includes means for forming a history file for each of said plurality of data items.

5. The apparatus, as in claim 1, wherein said serialization relationship constructing means forms a node for each active transaction and a directed edge from a first node representing a first transaction to a second node representing a second transaction to show completed locking dependency of said first transaction on said second transaction.

6. The apparatus, as in claim 1, wherein said means for detecting said cycle includes means for searching for a simple path originating from a node and ending at the same node.

7. The apparatus, as in claim 1, wherein the apparatus further comprises means for employing a more conservative locking scheme for said restarted transactions than a previous locking scheme.

8. The apparatus, as set forth in claim 7, wherein said employing means employs a two-phase locking scheme for said restarted transactions.

9. The apparatus, as set forth in claim 1, wherein said aborting means aborts all transactions in said detected cycle and any transaction dependent on said transactions in said cycle.

10. The apparatus, as in claim 1, wherein said apparatus further comprises means for locking an unlocked data item and immediately unlocking said locked data item after accessing said locked data item.

11. The apparatus, as in claim 10, wherein said apparatus further comprises means for employing a more conservative locking scheme than a previous locking scheme.

12. The apparatus, as set forth in claim 11, wherein said employing means employs a two-phase locking scheme.

13. The apparatus, as set forth in claim 1, wherein at least one of said concurrent transactions corresponds to a group of cooperative transactions.

14. A method for scheduling at least two concurrent transactions accessing shared data, comprising the steps of:

forming a history file associated with said shared data and forming each accessing transaction sequentially;

constructing from said history file a serialization relationship including completed locking dependencies between said transactions;

searching for a cycle in said serialization relationship;

detecting said cycle formed by said transactions in response to said searching step; and

aborting said transactions in said cycle and any transaction dependent therefrom after said cycle is detected.

15. The method, as set forth in claim 14, wherein said step of forming a history file includes the step of recording the type of data access.

16. The method, as set forth in claim 15, wherein said step of recording the type of data access includes the step of recording a read or a write in accordance with said transactions.

17. The method, as set forth in claim 14, wherein said shared data includes a plurality of data items, and wherein said step of forming said history file includes the step of forming a history file for each of said plurality of data items.

18. The method, as set forth in claim 14, wherein said step of constructing a serialization relationship includes the steps of:

forming a node for each of said transactions;

forming a directed edge from a first node to a second node to show completed locking dependency of said transaction represented by said first node on said transaction represented by said second node; and

repeating said above two steps for each transaction.

19. The method, as set forth in claim 18, wherein said step of forming said node for each of said transaction includes the step of forming said node only for active transactions.

20. The method, as set forth in claim 14, wherein the step of searching for a cycle includes the step of searching for a simple path originating from a node and ending at the same node.

21. The method, as set forth in claim 14, further comprising the step of restarting said aborted transactions.

22. The method, as set forth in claim 21, wherein said restarting step includes the step of employing a more conservative locking scheme with respect to a previous locking scheme.

23. The method, as set forth in claim 22, wherein said step of employing a more conservative locking scheme includes the step of employing a two-phase locking scheme.

24. The method as set forth in claim 14, wherein said method further comprises the steps of:

locking an unlocked data item; and

immediately unlocking said locked data item after accessing said locked data item.

25. The method, as set forth in claim 24, further comprising the step of employing a more conservative locking scheme than a previous locking scheme.

26. The method, as set forth in claim 25, where said employing step employs a two-phase locking scheme.

27. A locking scheme for shared database access control of a shared database having at least two concurrent transactions to be committed, comprising the steps of:

requesting a data item to be locked in said shared database;

locking said data item in response to said data item being available;

recording locking said transaction in a history file associated with said data item;

constructing a serialization relationship from said history file;

accessing said data item;

releasing said locked data item immediately after said data item accessing step;

searching said serialization relationship for the presence of a cycle after said locked data item is released; and

committing said transaction in response to the absence of said cycle.

28. The locking scheme, as set forth in claim 27, further comprising the step of aborting any transaction forming said cycle in response to the presence of said cycle.