Database management system and method which monitors action results and adjusts user parameters in response
A system and method for automated database management are provided. Statistics relating to operation of a database may be collected, wherein the database comprises one or more database objects. Characteristics of the database objects may be determined, either automatically or by user intervention, using the collected statistics, one or more policies, and/or one or more definitions. The policies and definitions may be defaults or may be customized by a user. Actions to be performed on the database objects may be determined, either automatically or by user intervention, based on the characteristics of the database objects. A schedule for performing the actions on the database objects may be automatically determined. The actions may be performed on the database objects based on the schedule. The actions on the database objects may be confirmed. The results of the actions on the database objects may be analyzed or monitored. Policies and/or definitions may be reconfigured based on the results. The system and method may automatically decide to perform one or more REORG actions on the database objects based on the statistics. A recommendation of a modification to one or more of the database objects may be generated based on the statistics. The scheduled actions may be modified as a result of detecting a change in the characteristics or usage of at least one of the database objects.
1. An automated database management method for a database comprising one or more database objects, the method comprising:
associating management criteria with the database to manage database objects;
collecting statistics relating to operation of the database;
determining characteristics of the database objects based on the collected statistics;
determining actions to be performed on one or more database objects to modify the one or more database objects based on the management criteria and the determined characteristics of the database objects;
modifying the one or more database objects by performing the actions on the database objects;
monitoring results of modifying the database objects; and
reconfiguring the management criteria associated with the database based on the results of modifying the database objects.
2. The database management method of claim 1 , further comprising:
automatically determining a schedule to perform the actions on the database objects,
wherein the performing the actions on the database objects comprises performing the actions on the database objects based on the schedule.
3. The database management method of claim 2 , wherein the performing the actions on the database objects based on the schedule comprises automatically performing the actions on the database objects based on the schedule.
4. The database management method of claim 1 , further comprising:
confirming the performing the actions on the database objects.
5. The database management method of claim 1 , wherein the determining the characteristics of the database objects comprises automatically determining the characteristics of the database objects.
6. The database management method of claim 1 , wherein the determining the actions to be performed on the database objects based on the characteristics of the database objects comprises automatically determining the actions to be performed on the database objects based on the characteristics of the database objects.
7. The database management method of claim 1 , wherein the statistics comprise object-level statistics.
8. The database management method of claim 1 , wherein the statistics comprise activity-level statistics.
9. The database management method of claim 1 , wherein the determining the characteristics of the database objects comprises determining the characteristics of the database objects using one or more policies in the management criteria.
10. The database management method of claim 1 , wherein the determining the characteristics of the database objects comprises determining the characteristics of the database objects using one or more definitions in the management criteria.
11. The database management method of claim 1 , further comprising:
customizing one or more definitions in the management criteria.
12. The database management method of claim 1 , further comprising: customizing one or more policies in the management criteria.
13. A program storage device comprising program instructions stored thereon, wherein the program instructions are computer-executable to cause a programmable control device to implement:
associating management criteria with a database to manage database objects of the database;
collecting statistics relating to operation of the database;
determining characteristics of the database objects based on the collected statistics;
determining actions to be performed on one or more of the database objects to modify the one or more database objects based on the management criteria and the determined characteristics of the database objects;
modifying the one or more database objects by performing the actions on the database objects;
monitoring results of modifying the database objects; and
reconfiguring the management criteria associated with the database based on the results of modifying the database objects.
14. The program storage device of claim 13 , wherein the program instructions are further computer-executable to implement:
automatically determining a schedule to perform the actions on the database objects,
wherein the performing the actions on the database objects comprises performing the actions on the database objects based on the schedule.
15. The program storage device of claim 14 , wherein the performing the actions on the database objects based on the schedule comprises automatically performing the actions on the database objects based on the schedule.
16. The program storage device of claim 13 , wherein the program instructions are further computer-executable to implement:
confirming the performing the actions on the database objects.
17. The program storage device of claim 13 , wherein the determining the characteristics of the database objects comprises automatically determining the characteristics of the database objects.
18. The program storage device of claim 13 , wherein the determining the actions to be performed on the database objects based on the characteristics of the database objects comprises automatically determining the actions to be performed on the database objects based on the characteristics of the database objects.
19. The program storage device of claim 13 , wherein the statistics comprise object-level statistics.
20. The program storage device of claim 13 , wherein the statistics comprise activity-level statistics.
21. The program storage device of claim 13 , wherein the determining the characteristics of the database objects comprises determining the characteristics of the database objects using one or more policies in the management criteria.
22. The program storage device of claim 13 , wherein the determining the characteristics of the database objects comprises determining the characteristics of the database objects using one or more definitions in the management criteria.
23. The program storage device of claim 13 , wherein the program instructions are further computer-executable to implement:
customizing one or more definitions in the management criteria.
24. The program storage device of claim 13 , wherein the program instructions are further computer-executable to implement: customizing one or more policies in the management criteria.
25. A database management system comprising:
a CPU;
a database coupled to the CPU, wherein the database comprises one or more database objects; and
a memory coupled to the CPU, wherein the memory stores program instructions which are executable by the CPU to:
associate management criteria with the database to manage database objects;
collect statistics relating to operation of the database;
determine characteristics of the database objects based on the collected statistics;
determine actions to be performed on the database objects to modify the database objects based on the management criteria and the determined characteristics of the database objects;
modify the database objects by performing the actions on the database objects;
monitor results of modifying the database objects; and
reconfigure the management criteria associated with the database based on the results of modifying the database objects.
26. The database management system of claim 25 , wherein the program instructions are further executable by the CPU to:
automatically determine a schedule to perform the actions on the database objects,
wherein in performing the actions on the database objects, the program instructions are further executable by the CPU to perform the actions on the database objects based on the schedule.
27. The database management system of claim 26 , wherein in performing the actions on the database objects based on the schedule, the program instructions are further executable by the CPU to automatically perform the actions on the database objects based on the schedule.
28. The database management system of claim 25 , wherein the program instructions are further executable by the CPU to:
confirm the performing the actions on the database objects.
29. The database management system of claim 25 , wherein in determining the characteristics of the database objects, the program instructions are further executable by the CPU to automatically determine the characteristics of the database objects.
30. The database management system of claim 25 , wherein in determining the actions to be performed on the database objects based on the characteristics of the database objects, the program instructions are further executable by the CPU to automatically determine the actions to be performed on the database objects based on the characteristics of the database objects.
31. The database management system of claim 25 , wherein the statistics comprise object-level statistics.
32. The database management system of claim 25 , wherein the statistics comprise activity-level statistics.
33. The database management system of claim 25 , wherein in determining the characteristics of the database objects, the program instructions are further executable by the CPU to determine the characteristics of the database objects using one or more policies in the management criteria.
34. The database management system of claim 25 , wherein in determining the characteristics of the database objects, the program instructions are further executable by the CPU to determine the characteristics of the database objects using one or more definitions in the management criteria.
35. The database management system of claim 25 , wherein the program instructions are further executable by the CPU to:
customize one or more definitions in the management criteria.
36. The database management system of claim 25 , wherein the program instructions are further executable by the CPU to: customize one or more policies in the management criteria.