Tracking premature termination of a database query
View Patent ↗Methods that utilize at least one prematurely terminated processing of a database query to improve the processing of the database query. The embodiments discussed track termination information associated with at least one user initiated premature termination of processing of a database query to improve the processing of the database query. Information related to the premature terminations of a database query may be utilized by a DBMS to generate and/or implement suggestions to improve the processing of the database query, resulting in improved query processing, improved performance, fewer premature terminations, and more satisfied users.
1. A method of processing a database query, the method comprising:
initiating processing of a database query, including detecting when at least one user prematurely terminates the processing of the database query;
tracking termination information based upon detection of the user prematurely terminating the processing of the database query; and
determining from the termination information a number of times processing of the database query is prematurely terminated.
2. The method of claim 1 , further comprising determining from the termination information an amount of processing time before processing of the database query is prematurely terminated.
3. The method of claim 1 , further comprising determining from the termination information a system configuration.
4. The method of claim 1 , further comprising determining from the termination information a user that prematurely terminates processing of the database query.
5. A method of processing a database query, the method comprising:
initiating processing of a database query, including detecting when at least one user prematurely terminates the processing of the database query;
tracking termination information based upon detection of the user prematurely terminating the processing of the database query; and
generating at least one suggestion for improving processing of the database query based upon the termination information of the database query.
6. The method of claim 5 , wherein generating at least one suggestion includes comparing the termination information with a threshold.
7. The method of claim 5 , wherein the suggestion includes rescheduling the database query.
8. The method of claim 5 , further comprising after generating the suggestion and in response to user input, performing an operation selected from the group consisting of receiving the suggestion, sending the suggestion to a database administrator, logging a suggestion, implementing a suggestion, resubmitting the database query, processing the database query without changes, terminating processing of the database query, and a combination thereof.
9. The method of claim 5 , wherein the suggestion includes creating a statistic.
10. The method of claim 5 , wherein the suggestion includes creating an index.
11. The method of claim 5 , wherein the suggestion includes changing a system configuration.
12. A method of processing a database query, the method comprising:
initiating processing of a database query, including detecting when at least one user prematurely terminates the processing of the database query;
tracking termination information based upon detection of the user prematurely terminating the processing of the database query; and
building a waiting value for a user based upon the detection of the user prematurely terminating the processing of the database query.
13. The method of claim 12 , wherein the waiting value includes at least one of
a) an amount of processing time the user approximately waits before terminating processing of the database query, or
b) an amount of processing time the user approximately waits before terminating processing of at least one other database query.
14. The method of claim 12 , further comprising generating at least one suggestion for processing the database query based upon the waiting value for the user processing the database query.
15. The method of claim 14 , wherein generating at least one suggestion includes comparing the waiting value and an estimated processing time for the database query.
16. The method of claim 12 , further comprising storing the waiting value in an access plan for the database query.
17. A method of processing a database query, the method comprising:
initiating processing of a database query, including detecting when at least one user prematurely terminates the processing of the database query;
tracking termination information based upon detection of the user prematurely terminating the processing of the database query; and
storing termination information in an access plan for the database query.
18. The method of claim 17 , further comprising updating termination information in an access plan for the database query based upon at least one other detection of a user prematurely terminating the processing of the database query.
19. A method of processing a database query, the method comprising:
initiating processing of a database query, including detecting when at least one user prematurely terminates the processing of the database query;
tracking termination information based upon detection of the user prematurely terminating the processing of the database query; and
determining from the termination information when processing of the database query is prematurely terminated.
20. A method of processing a database query, the method comprising:
initiating processing of a database query, including detecting when at least one user prematurely terminates the processing of the database query;
tracking termination information based upon detection of the user prematurely terminating the processing of the database query; and
determining from the termination information a pattern in how processing of the database query is prematurely terminated.
21. The method of claim 20 , wherein the determined pattern is based at least in part on multiple premature terminations by a same user.
22. The method of claim 20 , wherein the determined pattern is based at least in part on multiple premature terminations at approximately a same recurring time.
23. The method of claim 20 , wherein the determined pattern is based at least in part on multiple premature terminations after approximately a same amount of time of processing of the database query has elapsed.
24. The method of claim 20 , wherein the determined pattern is based at least in part on multiple premature terminations by many users.