System for categorizing database statements for performance tuning
View Patent ↗A database statement categorization system can enable DBAs or other users to more easily find tunable database statements by categorizing the database statements. The database categorization system can analyze a DBMS to identify the types of database statements executed on the DBMS and can then categorize the statements automatically, outputting the categorization for presentation to a DBA (or other user). This categorization can advantageously separate less relevant statements that warrant less tuning or investigation from more relevant statements that may have a measurable impact on the performance of the database. By allowing users to focus on statements that are more likely to warrant attention, in certain embodiments the database categorization system streamlines the tuning process.
1. A system for categorizing database statements, the system comprising:
a data collector configured to electronically access, from a database management system, a plurality of database statements executed on the database management system; and
a statement classifier comprising computer hardware, the statement classifier configured to:
programmatically analyze the database statements to identify characteristics of the database statements,
categorize the database statements into categories based at least in part on the identified characteristics of the database statements;
a user interface configured to be electronically generated for presentation to a user, the user interface comprising a description of the categories and comprising functionality for the user to select one of the categories to access a subset of the database statements that have been assigned to the selected category.
2. The system of claim 1 , wherein the statement classifier is further configured to detect patterns in the database statements and to group the database statements together based on the detected patterns.
3. The system of claim 2 , wherein the statement classifier is further configured to detect the patterns by at least determining whether a sequence of selected ones of the database statements reoccurs.
4. The system of claim 1 , further comprising functionality for the statement classifier to access a central categorization system to obtain suggested categorizations based on categorizations generated by a separate installation of the statement classifier.
5. The system of claim 4 , in combination with the central categorization system.
6. The system of claim 4 , wherein the suggested categorizations comprises suggested application categories.
7. The system of claim 6 , wherein the suggested application categories correspond to applications that communicate with the database management system.
8. The system of claim 6 , wherein the suggested categorizations enable the user to assign costs to applications associated with the suggested application categories.
9. A method of categorizing database statements, the method comprising:
by a computer system comprising computer hardware:
electronically accessing, from a database management system, a plurality of database statements executed on the database management system;
programmatically analyzing the database statements to identify characteristics of the database statements;
categorizing the database statements into categories based at least in part on the identified characteristics of the database statements;
electronically generating a user interface that includes a description of the categories; and
outputting the user interface for presentation to a user, thereby enabling the user to select one of the categories to access a subset of the database statements that have been assigned to the selected category.
10. The method of claim 9 , further comprising:
detecting patterns in the database statements; and
grouping the database statements together based on the detected patterns.
11. The method of claim 10 , wherein the detecting comprises detecting the patterns by at least determining whether a sequence of selected ones of the database statements reoccurs.
12. The method of claim 9 , further comprising accessing a central categorization system to obtain suggested categorizations.
13. The method of claim 12 , wherein the suggested categorizations comprise suggested application categories.
14. The method of claim 13 , wherein the suggested application categories correspond to applications that communicate with the database management system.
15. The method of claim 13 , wherein the suggested categorizations enable the user to assign costs to applications associated with the suggested application categories.
16. A computer-program product comprising a non-transitory computer-usable medium having computer-readable program code embodied therein, the computer-readable program code adapted to be executed to implement a method comprising:
electronically accessing, from a database management system, a plurality of database statements executed on the database management system;
programmatically analyzing the database statements to identify characteristics of the database statements;
categorizing the database statements into categories based at least in part on the identified characteristics of the database statements;
electronically generating a user interface that includes a description of the categories; and
outputting the user interface for presentation to a user, thereby enabling the user to select one of the categories to access a subset of the database statements that have been assigned to the selected category.
17. The computer-program product of claim 16 , the method further comprising:
detecting patterns in the database statements; and
grouping the database statements together based on the detected patterns.
18. The computer-program product of claim 17 , wherein the detecting comprises detecting the patterns by at least determining whether a sequence of selected ones of the database statements reoccurs.
19. The computer-program product of claim 16 , the method further comprising accessing a central categorization system to obtain suggested categorizations.
20. The computer-program product of claim 19 , wherein the suggested categorizations comprise suggested application categories.
21. The computer-program product of claim 20 , wherein the suggested application categories correspond to applications that communicate with the database management system.
22. The computer-program product of claim 20 , wherein the suggested categorizations enable the user to assign costs to applications associated with the suggested application categories.