Management of client requests in a client-server environment

• US 5,857,188 A
• Filed: 04/29/1996
• Issued: 01/05/1999
• Est. Priority Date: 04/29/1996
• Status: Expired due to Term

• Current Assignee: NCR Corporation
• Original Assignee: NCR Corporation
• Inventors: Douglas, Jeffrey G.
• Primary Examiner(s): Lall, Parshotam S.
• Assistant Examiner(s): Coulter, Kenneth R.
• Application Number:
  US08/639,496
• Time in Patent Office: 981 Days
• Field of Search: 395/200.09, 395/200.47, 395/610-614, 707/9, 707/5, 707/10
• US Class Current: 1/1
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application
• CPC Class Codes: Y10S 707/99935 Query augmenting and refining, e.g. inexact access
• CPC Class Codes: Y10S 707/99939 Privileged access

Abstract

A method, apparatus, and article of manufacture for monitoring and regulating access to a database. Requests for the database are intercepted and evaluated against one or more restrictions established by a database administrator for the database and generating an indication signal representative of the evaluation. The intercepted requests are rejected or allowed in accordance with the indication signal.

Claims

1. A computer-implemented method of monitoring and regulating access to a database, comprising the steps of:

(a) transparently intercepting requests to access the database that are transmitted from a device manager to a device driver that processes requests to access the database;

(b) transmitting the intercepted requests to a server that determines whether the intercepted requests can access the database;

(c) at the server;

i) receiving the intercepted requests;

ii) retrieving the restrictions from a restriction information database;

iii) evaluating the restrictions against the intercepted requests to produce an indication signal representative of the evaluation; and

iv) returning the indication signal;

(d) allowing the intercepted requests in accordance with the indication signal received from the server; and

(e) transmitting allowed intercepted requests to the device manager for processing.

2. The method of claim 1, wherein the requests conform to an Open Database Connectivity (ODBC) interface.

3. The method of claim 1, wherein the device manager is an Open Database Connectivity (ODBC) driver program.

4. The method of claim 3, further comprising the step of receiving results from the intercepted requests from the Open Database Connectivity (ODBC) driver program.

5. The method of claim 1, further comprising the step of preempting the intercepted requests in accordance with the indication signal.

6. The method of claim 5, wherein the preempting step further comprises the step of interacting with an operator subsequent to the preemption of the intercepted requests.

7. The method of claim 1, wherein the transparently intercepting step comprises the step of intercepting requests generated by an Open Database Connectivity (ODBC) application.

8. The method of claim 1, wherein the device manager is an ODBC Driver Manager, wherein the transparently intercepting step comprises the step of receiving requests transmitted from the ODBC Driver Manager, and wherein the requests are originated from an ODBC application.

9. A system for monitoring and regulating access to a database, comprising:

(a) a computer;

(b) means, performed by the computer, for transparently intercepting requests to access the database that are transmitted from a device manager to a device driver that processes requests to access the database and for

transmitting the intercepted requests to a server that determines whether the intercepted requests can access the database;

(c) means, performed by the server, for;

i) receiving the intercepted requests;

ii) retrieving the restrictions from a restriction information database;

iii) evaluating the restrictions against the intercepted requests to produce an indication signal representative of the evaluation; and

iv) returning the indication signal to the computer;

(d) means, performed by the computer, for allowing the intercepted requests in accordance with the indication signal received from the server; and

(e) means, performed by the computer, for transmitting allowed intercepted requests to the device manager for processing.

10. The apparatus of claim 9, wherein the requests conform to an Open Database Connectivity (ODBC) interface.

11. The apparatus of claim 9, wherein the device manager is an Open Database Connectivity (ODBC) driver program.

12. The apparatus of claim 11, further comprising the means for receiving results from the intercepted requests from the Open Database Connectivity (ODBC) driver program.

13. The apparatus of claim 9, further comprising the means for preempting the intercepted requests in accordance with the indication signal.

14. The apparatus of claim 13, wherein the means for preempting further comprises the means for interacting with an operator subsequent to the preemption of the intercepted requests.

15. The apparatus of claim 9, wherein the transparently intercepting means comprises the means for intercepting requests generated by an Open Database Connectivity (ODBC) application.

16. The apparatus of claim 9, wherein the device manager is an ODBC Driver Manager, wherein the transparently intercepting means comprises the means for receiving requests transmitted from the ODBC Driver Manager, and wherein the requests are originated from an ODBC application.

17. A program storage medium readable by a computer having a memory, the medium tangibly embodying one or more programs of instructions executable by the computer to perform method steps for monitoring and regulating access to a database, the method comprising the steps of:

(a) transparently intercepting requests to access the database that are transmitted from a device manager to a device driver that processes requests to access the database;

(b) transmitting the intercepted requests to a server that determines whether the intercepted requests can access the database;

(c) at the server;

i) receiving the intercepted requests;

ii) retrieving the restrictions from a restriction information database;

iii) evaluating the restrictions against the intercepted requests to produce an indication signal representative of the evaluation; and

iv) returning the indication signal to the computer;

(d) allowing the intercepted requests in accordance with the indication signal received from the server; and

(e) transmitting allowed intercepted requests to the device manager for processing.

18. The method of claim 17, wherein the requests conform to an Open Database Connectivity (ODBC) interface.

19. The method of claim 17, wherein the device manager is an Open Database Connectivity (ODBC) driver program.

20. The method of claim 19, further comprising the step of receiving results from the intercepted requests from the Open Database Connectivity (ODBC) driver program.

21. The method of claim 17, further comprising the step of preempting the intercepted requests in accordance with the indication signal.

22. The method of claim 21, wherein the preempting step further comprises the step of interacting with an operator subsequent to the preemption of the intercepted requests.

23. The method of claim 17, wherein the transparently intercepting step comprises the step of intercepting requests generated by an Open Database Connectivity (ODBC) application.

24. The method of claim 17, wherein the device manager is an ODBC Driver Manager, wherein the transparently intercepting step comprises the step of receiving requests transmitted from the ODBC Driver Manager, and wherein the requests are originated from an ODBC application.