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
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 particular 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-02 04:38
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 controlled 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 environment, 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 environment, 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.