System for scheduling database transactions distributed over a network at a locktime of preset delay

• US 5,269,020 A
• Filed: 06/17/1991
• Issued: 12/07/1993
• Est. Priority Date: 06/18/1990
• Status: Expired due to Term

• Current Assignee: Kabushiki Kaisha Toshiba (Toshiba Corporation)
• Original Assignee: Kabushiki Kaisha Toshiba (Toshiba Corporation)
• Inventors: Kakimoto, Mitsuru
• Primary Examiner(s): Lee, Thomas C.
• Assistant Examiner(s): AMSBURY, WAYNE P
• Application Number:
  US07/714,905
• Time in Patent Office: 904 Days
• Field of Search: 364/200, 395/650, 395/425, 395/725, 395/600, 395/550
• 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

Abstract

A database management system has a plurality of nodes each having a computer, a database and a clock. The nodes are interconnected by a communication line. Each database stores a plurality of data for processing. When a transaction request is generated at a first node, a transaction management section of the first node computer determines which node database(s) includes necessary data for executing the transaction. A maximum delay decision section of the first node computer determines the maximum delay for sending an instruction to all of the nodes having necessary data. A locktime decision section of the first node computer determines a locktime according to the maximum delay determined and the current time of the clock. Then, a transaction management section of the first node computer sends the locktime through the communication line as a lock instruction to the node(s) having the necessary data. A scheduler section of the computer in the node(s) having the necessary data receives the lock instruction sent by the transaction management section of the first computer. An associated lock activation section activates the scheduler section when the locktime coincides with the current time of the clock. The scheduler section locks the necessary data in the database in response to activation by the lock activation section.

Claims

1. A database management system, comprising:

a plurality of nodes respectively having a computer, a database and a clock;

communication means for interconnecting the plurality of nodes to send instructions between the nodes;

the respective databases storing data for processing;

each node computer including;

transaction generation means for generating a transaction;

transaction management means for determining which node has the database that includes necessary data for executing the transaction generated by the transaction generation means;

delay decision means for determining the delay time required to send an instruction from the transaction generating node to the node having the necessary data;

locktime decision means for determining a locktime according to the determined delay time and current time of the clock, the transaction management means of the transaction generating node sending the locktime as a lock instruction through the communication means to the node having the necessary data;

scheduler means for receiving the lock instruction sent by the transaction management means of the transaction generating node;

lock activation means for activating the scheduler means when the locktime of the lock instruction coincides with current time of the clock;

transaction execution means for executing the transaction generated by the transaction generating means;

the scheduler means of the node having the necessary data locking the necessary data in the database in response to activation by the lock activation means;

said transaction management means of the transaction generating node sending the transaction generated by the transaction generation means through the communication means to the node having the necessary data, following the lock instruction;

said transaction executing means executing the transaction by using the necessary data in an associated database after the necessary data is locked by the associated scheduler means.

2. The database management system according to claim 1, wherein the transaction execution means of the node having the necessary data unlocks the necessary data in the database when the transaction execution means finishes executing the transaction.

3. The database management system according to claim 2, each computer further including a queue, for temporarily storing lock instructions corresponding to data items on a first-in first-out basis, the scheduler means of the node having the necessary data entering the lock instruction in the queue of the computer of the node having the necessary data, if the necessary data item has already been locked according to a previous lock instruction.

4. The database management system according to claim 3, wherein the scheduler means of the node having the necessary data locks the necessary data according to the lock instruction which is stored at the head row in an associated queue, when the necessary data is released by the transaction execution means.

5. The database management system according to claim 1, wherein the transaction management means of the transaction generating node sends the lock instruction to the scheduler means of its own node is the database of its own node includes necessary data for executing the transaction.

6. The database management system according to claim 1, wherein the delay decision means is a maximum delay decision means for selecting the maximum delay necessary to send the lock instruction to all of multiple nodes each of which has a database including necessary data for executing the transaction.

7. The database management system according to claim 1, wherein the locktime decision means determines locktime by adding to current time of the clock of its own node the delay and a clock error time between the clock of its own node and the clock of a second node having the necessary data.

8. The database management system according to claim 1, wherein the scheduler means of the node having the necessary data immediately locks the necessary data according to the lock instruction when the necessary data is free.