Prioritization of search requests using search templates

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.

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.

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

• computer program instructions on a computer readable 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.