System and method for altering database requests and database responses

• US 20040162836A1
• Filed: 09/11/2003
• Published: 08/19/2004
• Est. Priority Date: 02/06/2001
• Status: Abandoned Application

• Current Assignee: Quest Software, Inc.
• Original Assignee: Quest Software, Inc.
• Inventors: Kalderon, Eyal, Romine, William J., Aronoff, Eyal
• Application Number:
  US10/662,039
• Publication Number:
  US 20040162836A1
• Time in Patent Office: Days
• US Class Current: 707/100
• CPC Class Codes: H04L 67/1001 for accessing one among a plurality of replicated servers
• CPC Class Codes: H04L 67/10015 Access to distributed or replicated servers, e.g. using brokers
• CPC Class Codes: H04L 67/1029 using data related to the state of servers by a load balancer
• CPC Class Codes: H04L 67/1034 Reaction to server failures by a load balancer
• CPC Class Codes: H04L 9/40 Network security protocols

Abstract

Aspects of embodiments of the present disclosure include a host computer system including a database management system. The host computer system may alter communication between a client application and the database management system, including requests from the client application and responses from the database management system.

Claims

1. A method of altering SQL statements received from a client application, the method comprising:

receiving data packets from a client application;

assembling the data packets into at least one SQL statement;

determining whether the SQL statement should be altered;

when the SQL statement should be altered, forwarding an altered SQL statement to be acted upon by a database management system; and

when the SQL statement should not be altered, forwarding the SQL statement to be acted upon by a database management system.

2. The method of claim 1, wherein the determining whether the SQL statement should be altered further comprises:

searching a lookup table for the SQL statement; and

modifying the SQL statement with information from the appropriate location in the lookup table.

3. The method of claim 2, wherein the lookup table includes at least one replacement SQL statement.

4. The method of claim 2, wherein the lookup table includes at least one inaccessible object, and wherein the modification comprises delaying the SQL statement attempting to access the inaccessible object.

5. The method of claim 1, wherein the determining whether the SQL statement should be altered further comprises:

forwarding the SQL statement to an expert system; and

modifying the SQL statement according to the expert system.

6. The method of claim 1, wherein the altering the SQL statement comprises replacing the SQL statement.

7. The method of claim 1, further comprising performing replication of one or more data files.

8. The method of claim 1, further comprising transparently moving a connection to the client application to another database management system.

9. The method of claim 1, further comprising:

performing replication of one or more data files; and

transparently moving a connection to the client application to another database management system.

10. A data processing system for modifying statements to be executed on a database management system, the data processing system comprising:

a monitoring process which receives data packets from a client application; and

one or more assembly processes which assemble the data packets into at least one data request, which determine whether the data request should be altered, and when the data request should be altered, which forward an altered data request to be acted upon by a database management system, or when the data request should not be altered, which forward the data request to be acted upon by a database management system.

11. The data processing system of claim 10, wherein the one or more assembly processes search a lookup table for the data request and modify the data request with information from the appropriate location in the lookup table.

12. The data processing system of claim 11, wherein the lookup table includes at least one replacement data request.

13. The data processing system of claim 11, wherein the lookup table includes at least one inaccessible object, and wherein the modification comprises delaying data requests attempting to access the inaccessible object.

14. The data processing system of claim 10, wherein the one or more assembly processes forward the data request to an expert system and modify the data request according to the expert system.

15. The data processing system of claim 10, wherein the one or more assembly processes alter the data request by replacing the data request.

16. The data processing system of claim 10, further comprising a replication process which replicates one or more data files.

17. The data processing system of claim 10, further comprising a connection manager which can, transparent to the client application, move a first network connection with the client application to another network connection with the client application.

18. The data processing system of claim 10, further comprising:

a replication process which replicates one or more data files; and

a connection manager which can, transparent to the client application, move a first network connection with the client application to another network connection with the client application.

19. The data processing system of claim 10, wherein the data request comprises an SQL statement.

20. A method of monitoring data sent to a client application in a database cluster environment, the method comprising:

receiving an reply set of data to one or more database requests, wherein the database requests originated from a client application seeking the data from one or more data files accessible through a database management system;

determining access rights associated with the client application;

when the access rights indicate that the reply set of data includes data outside the access rights of the client application, altering the reply set of data; and

forwarding the reply set of data to the client application.

21. The method of claim 20, wherein the altering the reply set of data includes removing data from the reply set of data.

22. The method of claim 20, wherein the altering the reply set of data includes replacing portions of the reply set of data.

23. The method of claim 22, wherein the replacing portions of the reply set of data includes inserting data place holders.

24. The method of claim 23, wherein the inserting data place holders comprises inserting the “

*”

character.

25. The method of claim 20, further comprising performing replication of one or more data files.

26. The method of claim 20, further comprising transparently moving a connection to the client application to another database management system.

27. The method of claim 20, further comprising:

performing replication of one or more data files; and

transparently moving a connection to the client application to another database management system.