Query modification in a database management system
AssigneeInternational Business Machines Corporation
InventorsSheshnarayan Agrawal, Azad Khan, Kapish Kumar
Life of this patent
Estimating the term…
Abstract
Disclosed aspects relate to automated query modification in a database management system (DBMS). A triggering event related to an execution of a query may be detected by an automated query modification engine. A query modification operation may be determined by the automated query modification engine based on a nature of the triggering event. The query modification operation may be determined to debug the triggering event related to the execution of the query. The query modification operation may be carried-out by the automated query modification engine. The query modification operation may be carried-out to modify the query to debug the triggering event related to the execution of the query.
Claims17
A computer-implemented method for automated query modification in a database management system (DBMS), the method comprising:
- detecting, by an automated query modification engine, a triggering event related to an execution of a query;
- determining, by the automated query modification engine based on a nature of the triggering event, a query modification operation to debug the triggering event related to the execution of the query;
- collecting, with respect to the execution of the query, an execution temporal period value, wherein the execution temporal period value indicates an amount of time required for the query to fail;
- comparing the execution temporal period with a threshold temporal period value, wherein the threshold temporal period value is a benchmark amount of time;
- responsive to determining that the execution temporal period value exceeds the threshold temporal period value and a session level switch is set on for the query, modifying the query to carry-out the query modification operation;
- storing, by the automated query modification engine, the query modification operation in a learning catalog, wherein the stored query modification operation is utilized to debug a future triggering event identical to the triggering event;
- carrying-out, by the automated query modification engine, the query modification operation to modify the query to debug the triggering event related to the execution of the query;
- parsing, the query to search for a set of candidate superfluous code which utilizes a set of computing resources, wherein the superfluous code includes an unnecessary code component;
- identifying, by analyzing the set of candidate superfluous code which utilizes the set of computing resources, a set of actual superfluous code;
- and
- modifying, to affect a utilization factor of the set of computing resources, the set of actual superfluous code, wherein a total number of operations to be performed by the query is reduced by at least a count operation.
A system for automated query modification in a database management system (DBMS), the system comprising:
- a memory having a set of computer readable computer instructions, and
- a processor for executing the set of computer readable instructions, the set of computer readable instructions including:
- detecting, by an automated query modification engine, a triggering event related to an execution of a query;
- determining, by the automated query modification engine based on a nature of the triggering event, a query modification operation to debug the triggering event related to the execution of the query;
- collecting, with respect to the execution of the query, an execution temporal period value, wherein the execution temporal period value indicates an amount of time required for the query to fail;
- comparing the execution temporal period with a threshold temporal period value, wherein the threshold temporal period value is a benchmark amount of time;
- responsive to determining that the execution temporal period value exceeds the threshold temporal period value and a session level switch is set on for the query, modifying the query to carry-out the query modification operation;
- storing, by the automated query modification engine, the query modification operation in a learning catalog, wherein the stored query modification operation is utilized to debug a future triggering event identical to the triggering event;
- carrying-out, by the automated query modification engine, the query modification operation to modify the query to debug the triggering event related to the execution of the query;
- parsing, the query to search for a set of candidate superfluous code which utilizes a set of computing resources, wherein the superfluous code includes an unnecessary code component;
- identifying, by analyzing the set of candidate superfluous code which utilizes the set of computing resources, a set of actual superfluous code;
- and
- modifying, to affect a utilization factor of the set of computing resources, the set of actual superfluous code, wherein a total number of operations to be performed by the query is reduced by at least a count operation.
A computer program product for automated query modification in a database management system (DBMS), the computer program product comprising a computer readable storage medium having program instructions embodied therewith, wherein the computer readable storage medium is not a transitory signal per se, the program instructions executable by a processor to cause the processor to perform a method comprising:
- detecting, by an automated query modification engine, a triggering event related to an execution of a query;
- determining, by the automated query modification engine based on a nature of the triggering event, a query modification operation to debug the triggering event related to the execution of the query;
- collecting, with respect to the execution of the query, an execution temporal period value, wherein the execution temporal period value indicates an amount of time required for the query to fail;
- comparing the execution temporal period with a threshold temporal period value, wherein the threshold temporal period value is a benchmark amount of time;
- responsive to determining that the execution temporal period value exceeds the threshold temporal period value and a session level switch is set on for the query, modifying the query to carry-out the query modification operation;
- storing, by the automated query modification engine, the query modification operation in a learning catalog, wherein the stored query modification operation is utilized to debug a future triggering event identical to the triggering event;
- carrying-out, by the automated query modification engine, the query modification operation to modify the query to debug the triggering event related to the execution of the query;
- parsing, the query to search for a set of candidate superfluous code which utilizes a set of computing resources, wherein the superfluous code includes an unnecessary code component;
- identifying, by analyzing the set of candidate superfluous code which utilizes the set of computing resources, a set of actual superfluous code;
- and
- modifying, to affect a utilization factor of the set of computing resources, the set of actual superfluous code, wherein a total number of operations to be performed by the query is reduced by at least a count operation.
Dependencies are inferred from the claim text.