SYSTEMS AND METHODS FOR HOLDING A QUERY
First Claim
Patent Images
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 compiler to hold a query received at a query input, thereby preventing the query from executing based on a cost comparison between an estimated resource execution cost of a query plan for the query and cost rules.
2 Assignments
0 Petitions
Accused Products
Abstract
One example discloses a database management system that can comprise 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 can comprise a compiler to hold a query received at a query input, thereby preventing the query from executing based on a cost comparison between an estimated resource execution cost of a query plan for the query and cost rules.
55 Citations
20 Claims
-
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 compiler to hold a query received at a query input, thereby preventing the query from executing based on a cost comparison between an estimated resource execution cost of a query plan for the query and cost rules. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9)
-
-
10. A method for managing a database comprising:
-
generating a query plan for a received query; estimating a resource execution cost of the query plan; and determining whether to hold the received query based on the estimated resource execution cost of the query plan, where holding the received query prevents execution of the query. - View Dependent Claims (11, 12)
-
-
13. A database management system (DMBS) comprising:
-
a query repository comprising; cost rules that characterize a resource execution cost limit for a query plan; a hold queue to store an entry comprising a query plan; and a modified queue to store an entry comprising a modified query plan; a query input to receive a query from a query requestor; a compiler comprising a query optimizer to generate a query plan for the query received at the query input, the compiler is to; determine whether to hold the query received at the query input, thereby preventing the query received at the query input from executing based on a cost comparison between an estimated resource execution cost of the query plan and the cost rules of the query repository; and write an entry into the hold queue of the query repository if the query received at the query input has been held; a query executor comprising a monitor to monitor an actual execution resource cost of the query plan, the query executor to; execute the query plan on a database stored in data storage if the query plan has not been held; determine whether to cancel and hold the query received at the query input, thereby preventing the query from executing, based on a cost comparison between the actual resource execution cost of the query plan and the cost rules of the query repository; and write an entry into the hold queue of the query repository if the query has been held; a cost control to; notify a user of the cost control that the entry has been written into the hold queue of the query repository; retrieve the entry from the hold queue of the query repository to provide a retrieved entry; provide a query plan editor for modifying the query plan of the retrieved entry to provide a modified query plan; and write an entry into the modified queue of the query repository that includes the modified query plan. - View Dependent Claims (14, 15)
-
- 16. A computer readable medium having computer executable instructions comprising a compiler to determine whether to hold a query on a database based on an estimated resource execution cost of a query plan for the query, such that holding the query prevents the query from being executed.
Specification