Techniques for dynamic rule-based response to a request for a resource on a network

• US 7,243,138 B1
• Filed: 05/14/2002
• Issued: 07/10/2007
• Est. Priority Date: 02/01/2002
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Sharma, Vivek, Majkut, Keith
• Primary Examiner(s): Chang; Jungwon
• Application Number:
  US10/146,335
• Time in Patent Office: 1,883 Days
• Field of Search: 709/229, 709/226, 709/225, 709/203, 709/201, 709/223, 709/219, 713/201, 713/202, 715/700, 707/10, 707/3
• US Class Current: 709/219
• CPC Class Codes: G06F 16/2443 Stored procedures
• CPC Class Codes: G06F 21/6218 to a system of files or objects, e.g. local or distributed file system or database
• CPC Class Codes: H04L 67/51 Discovery or management thereof, e.g. service location protocol [SLP] or web services
• CPC Class Codes: H04L 67/564 Enhancement of application control based on intercepted application data
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching

Abstract

Techniques for responding to a request for a resource on a network include receiving at a server the request from a client process for the resource. The server transmits a set of request information items associated with the request. In response to this transmission, a database server receives at least a subset of the set of request information items. Within the database server, at least one particular request information item of the subset is used as a key to identify a routine. The routine is executed to generate a set of access information items. The server responds to the request based on the set of access information items. Using these techniques, the server responds to the request differently without taking the server offline, by changing the routine indicated within the database server.

Claims

1. A method for responding to a request for a resource on a network, the method comprising the steps of:

receiving at a first server the request from a client process for the resource;

transmitting from the first server a set of request information items associated with the request;

in response to said transmitting, receiving at a database server at least a subset of the set of request information items, wherein the database server manages a database that stores, for each of a plurality of executable routines, one or more key values mapped to an identifier for each said routine;

using, within the database server, at least one particular request information item of the subset to form a key value to identify a routine from among the plurality of executable routines, wherein each of the executable routines comprise executable code;

executing code from the identified routine to generate a set of access information items; and

responding to the request at the first server based on the set of access information items.

2. The method of claim 1 further comprising the step of passing at least one request information item from the set of request information items to the routine.

3. The method of claim 1 further comprising the steps of:

receiving the set of request information items at a broker process on a host different from the first server and the database server;

determining, at the broker process, the subset of the set of request information items to send to the database server; and

sending the subset to the database server.

4. The method of claim 3, further comprising managing, at the broker process, a pool of one or more connections with the database server for sending the subset to the database server.

5. The method of claim 3, further comprising the step of performing, at the broker process, authentication of a user of the client process.

6. The method of claim 3, further comprising the step of performing, at the broker process, authentication of a user of the client process.

7. The method of claim 1, further comprising the step of responding to the request differently at the first server without taking the first server offline by changing the routine indicated within the database server.

8. The method of claim 1, wherein:

the resource is one resource of a set of one or more resources; and

the first server is one server of a plurality of servers that receive requests for any resource of the set of one or more resources.

9. The method of claim 8, further comprising the steps of:

receiving the set of request information items at a broker process on a host different from the first server and the database server;

determining, at the broker process, the subset of the set of request information items to send to the database server;

for at least one resource of the set of one or more resources, sending the subset to the database server; and

for at least a different resource of the set of one or more resources, using, at the broker process, at least one item of the set of request information items to identify the routine.

10. The method of claim 8, wherein:

said step of transmitting the set of request information is performed for at least one resource of the set of one or more resources; and

the method further comprises, for at least a different resource of the set of one or more resources, identifying the routine at the first server.

11. The method of claim 1, wherein:

said step of executing the routine further comprises including data indicating authorization for the resource in the set of access information items; and

said step of responding comprises providing the resource to the client.

12. The method of claim 1, wherein:

said step of executing the routine further comprises including data indicating redirection to a second resource different from the resource in the set of access information items; and

said step of responding comprises directing the client to the second resource.

13. The method of claim 1, wherein:

said step of executing the routine further comprises including data indicating no authorization for the resource in the set of access information items; and

said step of responding comprises not providing the resource to the client.

14. The method of claim 1, said step of receiving at the database server at least the subset of the set of request information items includes receiving data indicating a universal resource identifier (URI) for the resource.

15. The method of claim 14, said step of receiving at the database server at least the subset of the set of request information items includes receiving data distinguishing requests directed to different domain names received at the first server.

16. The method of claim 1, further comprising the step of performing, at the server, authentication of a user of the client process.

17. The method of claim 1, further comprising the step of performing, at the database server, authentication of a user of the client process.

18. The method of claim 1, further comprising

storing at the first server data associating with each resource of a plurality of resources a corresponding host of the first server, the database server, and a broker that intercedes in communications between the server and the database server, the corresponding host for performing authentication of a user of the client process;

and

causing authentication to be performed at a particular host associated with the resource.

19. The method of claim 1, further comprising

storing at the first server data associating with each resource of a plurality of resources a corresponding host of the server, the database server, and a broker that intercedes in communications between the server and the database server, the corresponding host for executing the routine;

and

causing the routine to be executed at a particular host associated with the resource.

20. The method of claim 1, wherein the database includes a table that has one or more columns containing, for each said routine, the one or more key values that are mapped to an identifier for each said routine.

21. The method of claim 1, wherein the plurality of executable routines are stored in the database.

22. The method of claim 1, further comprising, for a particular routine, changing at least one of the one or more key values mapped to an identifier for the particular routine.

23. The method of claim 1, further comprising, without taking the database server offline, changing executable code in a particular routine to change how a request having a particular set of request information items will be responded to.

24. The method of claim 1, further comprising, without taking the database server offline, changing the executable routine that is identified by a key value formed from a particular set of request information items to change how a request having the particular set of request information items will be responded to.

25. A computer-readable storage medium carrying one or more sequences of instructions for responding to a request for a resource on a network, wherein execution of the one or more sequences of instructions by one or more processors causes the one or more processors to perform the steps of:

receiving the request from a client process for the resource;

transmitting a set of request information items associated with the request;

in response to said transmitting, receiving a set of access information items that are determined by executing a routine identified, based on at least a portion of the request information items, from among a plurality of executable routines in a database managed by a databases server, wherein each of the executable routines comprise executable code, wherein the database stores, for each of a plurality of executable routines, one or more key values mapped to an identifier for each said routine,

wherein the access information items includes an item that indicates whether to respond to the request with a resource other than the resource specified in the request; and

responding to the request based on the set of access information items.

26. The computer-readable storage medium of claim 25, wherein execution of the one or more sequences of instructions further causes the one or more processors to perform the step of responding to the request differently without taking the server offline by changing the routine indicated within the database server.

27. The computer-readable storage medium of claim 25 wherein execution of the one or more sequences of instructions further causes the one or more processors to perform the steps of:

storing data associating with each resource of a plurality of resources a corresponding host of a request server for receiving the request, a database server for the database, and a broker that intercedes in communications between the request server and the database server, the corresponding host for performing authentication of a user of the client process; and

causing authentication to be performed at a particular host associated with the resource.

28. The computer-readable storage medium of claim 25 wherein execution of the one or more sequences of instructions further causes the one or more processors to perform the steps of:

storing data associating with each resource of a plurality of resources a corresponding host of a request server for receiving the request, a database server for the database, and a broker that intercedes in communications between the request server and the database server, the corresponding host for executing the routine; and

causing the routine to be executed at a particular host associated with the resource.

29. A computer-readable storage medium carrying one or more sequences of instructions for responding to a request for a resource on a network, wherein execution of the one or more sequences of instructions by one or more processors causes the one or more processors to perform the steps of:

receiving from a server a set of request information items associated with the request;

using at least one particular request information item of the set to form a key for retrieving data from a database object that is managed by a database server,

wherein the data base object comprises, for each of a plurality of executable routines, one or more key values mapped to an identifier for each said executable routine;

wherein the retrieved data identifies a routine from among the plurality of executable routines; and

wherein each of the executable routines comprise executable code;

executing code from the identified routine to generate a set of access information items; and

sending the set of access information items to the server.

30. The computer-readable storage medium of claim 29, wherein execution of the one or more sequences of instructions further causes the one or more processors to perform the step of passing at least one request information item from the set of request information items to the routine.

31. A computer-readable storage medium carrying one or more sequences of instructions for responding to a request for a resource on a network, wherein execution of the one or more sequences of instructions by one or more processors causes the one or more processors to perform the steps of:

receiving from a server on a separate host a set of request information items associated with the request;

determining a subset of the set of request information items to send to a database server on another separate host, wherein the database server manages a database that stores, for each of a plurality of executable routines, one or more key values mapped to an identifier for each said routine, and wherein at least one particular request information item of the subset is usable form a key to identify a routine of the plurality of executable routines;

sending the subset to the database server;

in response to said sending, receiving a set of access information items that are determined by executing a routine identified from among a plurality of executable routines in a database on the database server, wherein each of the executable routines comprise executable code, and wherein the routine is identified based on the key; and

causing the server to respond to the request based on the set of access information items.

32. The computer-readable storage medium of claim 31, wherein execution of the one or more sequences of instructions further causes the one or more processors to perform the step of managing a pool of one or more connections with the database server for sending the subset to the database server.

33. The computer-readable storage medium of claim 31, wherein execution of the one or more sequences of instructions further causes the one or more processors to perform the step of performing authentication of a user of the client process.

34. A system for responding to a request for a resource on a network, comprising:

a network;

a server connected to the network, the server comprising;

one or more server processors; and

a first computer-readable storage medium carrying a first set of one or more sequences of instructions, wherein execution of the first set by the one or more server processors causes the one or more server processors to perform the steps of

receiving the request from a client process for the resource,

transmitting a set of request information items associated with the request,

in response to said transmitting, receiving a set of access information items, and

responding to the request based on the set of access information items; and

a database server connected to the network, the database server comprising one or more database processors; and

a second computer-readable storage medium carrying a second set of one or more sequences of instructions, wherein execution of the second set by the one or more database processors causes the one or more database processors to perform the steps of

receiving the set of request information items;

using at least one particular request information item of the set to form a key for retrieving data from a database object that is managed by a database server,

wherein the data base object comprises, for each of a plurality of executable routines, one or more key values mapped to an identifier for each said executable routine;

wherein the retrieved data identifies a routine from among the plurality of executable routines; and

wherein each of the executable routines comprise executable code;

causing code from the identified routine to be executed to generate the set of access information items; and

causing the set of access information items to be sent to the server.

35. The system of claim 34, further comprising:

a broker connected to the network, the broker comprising;

one or more broker processors; and

a third computer-readable storage medium carrying a third set of one or more sequences of instructions, wherein execution of the third set by the one or more broker processors causes the one or more broker processors to perform the steps of

receiving from the server the set of request information items;

determining a subset of the set of request information items to send to the database server;

sending the subset to the database server;

in response to sending the subset, receiving the set of access information items; and

sending to the server the set of access information items.