Patent Document ID: 7933894
Application ID: 11763490

Base Claim:
1. A computer-implemented system comprising: a processor; a plan generator component configured to scan a representation of a query for parameter sensitive predicates; one or more specialized plans generated based, at least, on the parameter sensitive predicates, wherein the one or more specialized plans is configured to execute the query; one or more guard expressions configured to: evaluate a validity of pairing at least one of the one or more specialized plans with the query, wherein a guard expression is paired with a specialized plan; and output a Boolean value indicative of a determination that at least one of the one or more specialized plans paired with the guard expression is proper for execution of the query; one or more dispatch expressions configured to match one or more query values, wherein at least one of the one or more dispatch expressions is configured to: include a plurality of the one or more guard expressions; and output a key identifying a one of the one or more guard expressions outputting the Boolean value indicative of the determination that at least one of the one or more specialized plans is proper for execution of the query, wherein the one or more dispatch expression is configured to output the key based, at least, on receiving the Boolean value indicative of the determination that at least one of the one or more specialized plans is proper for execution of the query; and a computer-readable storage medium storing instructions that, when executed by the processor, cause the processor to implement at least one of the plan generator component, the one or more specialized plans, the one or more dispatch expressions or the guard expression.

---

Claim 2:
2. The computer-implemented system of claim 1 , further comprising a procedure cache configured to store the one or more specialized plans.