System for scheduling database transactions distributed over a n

Boots – shoes – and leggings

Patent

Rate now

  [ 0.00 ] – not rated yet Voters 0   Comments 0

Details

364DIG1, 3642821, 3642818, 3642813, 364271, 3642468, 395650, 395550, G06F 1540

Patent

active

052690202

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.

REFERENCES:
patent: 4096561 (1978-06-01), Trinchieri
patent: 4648036 (1987-03-01), Gallant
patent: 4819159 (1989-04-01), Shipley et al.
patent: 4853843 (1989-08-01), Ecklund
patent: 4881166 (1989-11-01), Thompson et al.
patent: 4887204 (1989-12-01), Johnson et al.
patent: 4914570 (1990-04-01), Peacock
patent: 4956772 (1990-09-01), Neches
patent: 4989733 (1991-01-01), May et al.
patent: 5095421 (1992-03-01), Freund
patent: 5140685 (1992-08-01), Sipple et al.
patent: 5161227 (1992-11-01), Dias et al.
patent: 5168570 (1992-12-01), Eckert et al.
Concurrency Control and Recovery in Database Systems by P. A. Bernstein, Vassos Hadzilacos and Nathan Goodman, pp. 76-87, Addison-Wesley, 1987.

LandOfFree

Say what you really think

Search LandOfFree.com for the USA inventors and patents. Rate them and share your experience with other people.

Rating

System for scheduling database transactions distributed over a n does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with System for scheduling database transactions distributed over a n, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System for scheduling database transactions distributed over a n will most certainly appreciate the feedback.

Rate now

     

Profile ID: LFUS-PAI-O-2022134

  Search
All data on this website is collected from public sources. Our data reflects the most accurate information available at the time of publication.