Patent Document ID: 8930344
Application ID: 13021051

Base Claim:
1. A database management system (DBMS) comprising: a memory for storing computer executable instructions; and a processing unit for accessing the memory and executing the computer executable instructions, the computer executable instructions comprising: a query optimizer to: generate a query plan for a query received at a query input; and determine an estimated resource execution cost of the query plan, the estimated resource execution cost comprises a plurality of estimated cost fields; a compiler to hold the query the holding prevents the query from executing based on a determination that the estimated resource execution cost of the query plan exceeds at least one of a plurality of cost rules, wherein the estimated resource execution cost is based on at least one of a number of join operations and a number of cross product operations in the query plan for executing the query; wherein the cost rules comprise: a fixed cost threshold; and a variable cost threshold; and the estimated cost comparison is based on a comparison between the plurality of estimated cost fields and the fixed cost threshold and the variable cost threshold of the cost rules; and wherein the query held at the compiler is prevented from executing for a given time period, the time period including one of an off-peak period, a low priority period, and an indefinite period.

---

Claim 2:
2. The DBMS of claim 1 , wherein the compiler further comprises: wherein the compiler is further to: hold the query based on a determination that a first estimated cost field of the estimated resource execution cost exceeds the fixed cost threshold or based on a determination that a second estimated cost field of the estimated resource execution cost exceeds the variable cost threshold by a predetermined amount; and write the query plan to a query repository of the DBMS based on a determination that the query has been held by the compiler.