Patent EP0280893A2 successfully refreshed from Google Patents.
← Back to Patent Explorer
EP0280893A2 Expired / Lapsed EP ⏱️ 0.0 years remaining

Relational data base lock avoidance system

Assignee: International Business Machines Corp
•
Filing: 1988-02-02
•
Granted: —
•
Expires: 2008-02-02
📄 Original PDF 🌐 Google Patents 🔄 Sync Now

Abstract

Abstract The present invention is directed to a relational data base system which is operating in a virtual machine environment. The invention provides a system that includes a disconnected virtual machine which is running in the same virtual machine environment as is the relational data base. Insert and Update requests to the system are generated by programs running in user controlled virtual machines. Other users issue select and view requests which lock out insert and update requests which relate to the same data domain. With the present invention Insert and Update requests go to the disconnected virtual machine which ques them and applies them against the relational data base in the order that the requests are received. In this way, while a select is being executed on data in a par­ticular domain of the data base, update and insert request for the same domain will be held by the virtual machine and the operator will not be "locked out" of the system.

Inventors

  • 👤 Neil Harrison Clayton
  • 👤 Kuo-Chang Sun
  • 👤 Jose Luis Rivero

Bibliographic Details

Application Number —
Jurisdiction EP
Data Source google_patents
Last Synchronized 2026-11-08 02:52
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/23; G06F16/2308; G06F16/2336; G06F16/2343; G06F16/28; G06F16/284; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99938

Claims Analysis

Total Claims: 10
Claim 1
Independent Claim 216 words
A computer system comprising an operating system program which provides a virtual machine environment, a relational data base program operating in said virtual machine environment, said relational data base having means for responding to insert, update, veiw and select requests which operate on a particular domain of data, insert and update requests being locked out from a particular data domain when a select request is being executed in said particular data domain, a disconnected virtual machine running in said virtual machine environment, a user terminal that issues select requests to said relational data base, whereby areas of said data base are locked out while said select requests are being executed, a plurality of user controlled virtual machines that issue update and insert requests, means for sending requests from the user con­trolled virtual machine go to said disconnected virtual machine, means in the disconnected virtual machine for queuing insert and update requests and for applying them against the relational data (claim 1 continued) base in the order that the requests are received whereby when a select request is being executed on data in a particular domain of the data base, other update and insert request for the same domain will be held by the virtual machine and the user will not be locked out of the system.
Claim 2
Dependent Claim 16 words
The system recited in claim 1 wherein said relational data base is an SQL/DS data base.
Claim 3
Dependent Claim 21 words
The system recited in claim 1 wherein said means in the disconnected virtual machine for queuing requests is an EXEC program.
Claim 4
Dependent Claim 23 words
The system recited in claim 1 wherein said means for sending, sends files to said disconnected virtual machine, said files having identifying names.
Claim 5
Dependent Claim 14 words
The system recited in claim 1 wherein said operating system is a VM/SP system.
Claim 6
Dependent Claim 23 words
The system recited in claim 1 wherein said view requests lock out insert and update requests from direct execution in said data base.
Claim 7
Dependent Claim 174 words
A computer system comprising an operating system program which provides a virtual machine environ­ment, a relational data base program operating in said virtual machine environment, said relational data base having means for responding to insert, update and select requests which operate on a particular domain of data, insert and update requests being locked out from a particular data domain when a select request is being executed in said particular data domain, a disconnected virtual machine running in said virtual machine environment, a plurality of user controlled virtual machines, means for sending requests from said user controlled virtual machine go to the disconnected virtual machine, means in the disconnected virtual machine for queuing requests and for applying them against the relational data base in the order that the requests are received whereby when a Select is being executed on data in a particular domain of the data base, other update and insert request for the same domain will be held by the virtual machine and the user will not be locked out of the system.
Claim 8
Dependent Claim 174 words
A computer system comprising an operating system program which provides a virtual machine environ­ment, a relational data base program operating in said virtual machine environment, said relational data base having means for responding to insert, update and select requests which operate on a particular domain of data, insert and update requests being locked out from a particular data domain when a select request is being executed in said particular data domain, a disconnected virtual machine running in said virtual machine environment, a plurality of user controlled virtual machines, means for sending requests from said user controlled virtual machine go to the disconnected virtual machine, means in the disconnected virtual machine for queuing requests and for applying them against the relational data base in the order that the requests are received whereby when a Select is being executed on data in a particular domain of the data base, other update and insert request for the same domain will be held by the virtual machine and the user will not be locked out of the system.
Claim 9
Dependent Claim 21 words
The system recited in claim 7 wherein said Select requests and said view requests are sent directly to said data base,
Claim 10
Dependent Claim 15 words
The system recited in claim 7 wherein said data base is a SQL/DS data base.

References Cited (Backward Citations)

No citation records indexed.

USPTO Annuity & Maintenance Windows

Maintenance schedule is calculated for granted US utility patents.

Assigned Categories & Tags

No categories assigned to this patent yet.

Assign Category Tag