Prioritization of search requests using search templates

• US 8,185,512 B2
• Filed: 12/04/2008
• Issued: 05/22/2012
• Est. Priority Date: 12/04/2008
• Status: Active Grant

• Current Assignee: Daedalus Blue LLC
• Original Assignee: International Business Machines Corporation
• Inventors: Brodfuehrer, Richard Joseph, Walsh, John Michael, Worm, Kim J., Maslak, Barbara Ann Marie
• Primary Examiner(s): Cottingham, John R.
• Assistant Examiner(s): Arjomandi, Noosha
• Application Number:
  US12/328,398
• Publication Number:
  US 20100145977A1
• Time in Patent Office: 1,265 Days
• Field of Search: 707/706
• US Class Current: 707/706
• CPC Class Codes: G06F 16/332 Query formulation

Abstract

A method, a computer system, and a computer program product that prioritizes search requests to a database directory by assigning the search requests to one or more templates. Attributes of the search requests, such as an IP address, the portion of the database to which the search is constrained, one or more return attributes, the scope of the search, and/or search filters used, are compared with values of those attributes of the templates. The template whose values of the attributes match the values of the attributes in the search request is selected. This template has a template identifier that is associated with a transaction name of a work unit enclave. The search request is then associated with the work unit enclave and the operating system of the computer system will execute the search request in accordance with the performance goals and priority of the service class into which the work unit enclave is assigned. Process steps include creating a search template if none exist, and configuring a database server to assign a transaction name to search requests based on attributes and their values of the search request and then associating that transaction name with a transaction name of the work unit enclave.

Claims

1. A method to prioritize execution of search requests to a database stored on a computer, the method comprising:

reading a value of at least one attribute of a search request;

determining that the value of the at least one attribute matches a value of at least one attribute in a search template;

creating a new search template when the value of the at least one attribute does not match the value of at least one attribute in a search template;

selecting the search template having values and attributes that closest match values and attributes of the search request;

determining that the selected search template is associated with a service class having an execution priority;

scheduling execution of the search request according to the execution priority of the associated service class;

assigning a database transaction name to a one or both of an IP address of a source of the search request and a requestor'"'"'s login ID;

creating a work unit of at least one task to be executed in the computer;

assigning at least three characteristics to the work unit comprising a work unit transaction name, an instance of a database server, and a processor complex; and

associating a service class to the work unit.

2. The method to prioritize execution of search requests to a database stored on a computer as in claim 1, further comprising:

assigning an identifier to the search template; and

associating the search template identifier with the database transaction name.

3. The method to prioritize execution of search requests to a database stored on a computer as in claim 1, further comprising:

associating the database transaction name with the work unit transaction name.

4. The method to prioritize execution of search requests to a database stored on a computer as in claim 1, further comprising:

one or both of the at least one attribute and its value of the search request is a wildcard.

5. The method to prioritize execution of search requests to a database stored on a computer as in claim 1, further comprising:

one or both of the at least one attribute and its value of the search template is a wildcard.

6. The method to prioritize execution of search requests to a database stored on a computer as in claim 1, further comprising:

the at least one attribute of the search request is a requestor'"'"'s logon ID.

7. The method to prioritize execution of search requests to a database stored on a computer as in claim 1, further comprising:

the at least one attribute of the search request is an IP address of a source of the search request.

8. The method to prioritize execution of search requests to a database stored on a computer as in claim 1, further comprising:

the at least one attribute of the search request is a portion of the database to which the search request is confined.

9. The method to prioritize execution of search requests to a database stored on a computer as in claim 1, further comprising:

the at least one attribute of the search request is a scope of the search request.

10. The method to prioritize execution of search requests to a database stored on a computer as in claim 1, further comprising:

the at least one attribute of the search request is one or more return attributes to be returned to the source when the search request has been executed.

11. The method to prioritize execution of search requests to a database stored on a computer as in claim 1, further comprising:

the at least one attribute of the search request is one or more search filters of the search request.

12. The method to prioritize execution of search request to a database stored on a computer as in claim 1, further comprising:

assigning a database transaction name to a one or both of an IP address of a source of the search request and a requestor'"'"'s login ID.

13. A computer system that prioritizes search requests to a database stored on the computer system, comprising:

at least one processor having an operating system, the operating system having a workload manager, the at least one processor identified by a processor complex id;

at least one database accessed by the operating system;

an instance of a database server managing access to the database by the operating system and its workload manager;

the instance of the database server further comprising;

a plurality of search templates stored in a memory, each of the plurality of search templates identified by a template id and characterized by values of one or more template attributes;

a search formatter that receives requests to access the database and formats one or more request attributes of each request, if necessary;

a search comparator that compares values of the one or more request attributes with the values of the one more template attributes;

a template selector that selects the search template whose template attributes and values have the closest match to the request attributes and values; and

an enclave selector that selects an enclave of the workload manager associated with the template id of the selected search template or with one or more request attributes and their values; and

a scheduler in the workload manager that schedules the request to access the database according to a service class associated with the selected enclave.

14. The computer system of claim 13 wherein the enclave selector further comprises:

a transaction name matcher that matches a database transaction name derived from the template id or from the one or more request attributes and their values and matches them with a enclave transaction name of the selected enclave.

15. The computer system of claim 14 wherein the one or more request attributes from which the database transaction name is derived comprises one or both of:

an IP address of a client issuing a request to access the database; and

a requestor'"'"'s logon id of a user requesting to access the database.

16. The computer system of claim 13, wherein the instance of the database server is connected to the at least one database on an Intranet or an Internet network.

17. The computer system of claim 13, wherein the operating system accessing the database is connected to the database on an Intranet or an Internet network.

19. The computer program product of claim 17, wherein the first program instructions read values of one or more of the following attributes of the search request:

a wildcard;

a requestor'"'"'s logon ID;

an IP address of a source of the search request;

a portion of the database to which the search request is confined;

a scope of the search request;

one or more return attributes to be returned to the source when the search request has been executed;

one or more search filters of the search request.

18. A computer program product comprising a computer readable storage medium having computer usable program code embodied thereon comprising:

computer program instructions on a tangible computer readable storage medium configured to prioritize search requests to a database in a computer system, the computer program instructions further comprising;

first program instructions that assign a database transaction name to a one or both of an IP address of a source of the search request and a requestor'"'"'s login ID;

second program instructions that read a value of one or more attributes of a search request;

third program instructions that determine that the value of the one or more attributes of the search request match a value of at least one attribute in a search template;

fourth program instructions that create a new search template when the value of the one or more attributes does not match the value of at least one attribute in a search template;

fifth program instructions that assign an identifier to the search template and associate the search template identifier with the database transaction name;

sixth program instructions that select the search template having values and attributes that closest match values and attributes of the search request;

sixth program instructions that associate the database transaction name with an execution priority,

wherein the program instructions are stored on the computer readable media.