Database management system and method which monitors activity levels and determines appropriate schedule times
View Patent ↗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.
1. A database management method, comprising:
collecting statistics related to one or more database objects of a database;
determining characteristics characterizing the one or more database objects;
determining actions to perform on the one or more database objects based on the characteristics;
automatically determining a schedule to perform the actions based on the statistics; and
performing the actions on the one or more database objects based on the schedule.
2. The method of claim 1 , wherein the statistics comprise activity-level statistics measuring activity-levels of the one or more database objects, usage statistics characterizing usage of the one or more database objects, or object-level statistics characterizing space or access-path of the one or more database objects.
3. The method of claim 1 , wherein the act of determining the characteristics comprises using one or more of the statistics, policies, user-customizable policies, definitions, and user-customizable definitions to determine the characteristics.
4. The method of claim 1 , further comprising confirming that the actions have been performed on the one or more database objects.
5. The method of claim 1 , further comprising obtaining one or more results from performing the actions on the one or more database objects.
6. The method of claim 5 , further comprising:
analyzing the one or more results; and
reconfiguring one or more policies based on the analysis.
7. The method of claim 1 , wherein one or more of the acts of determining the characteristics, determining the actions, and performing the actions is performed automatically.
8. A program storage device, readable by a programmable control device, comprising instructions stored on the program storage device for causing the programmable control device to perform a method according to claim 1 .
9. A database management method comprising:
determining characteristics characterizing the one or more database objects;
determining usage of the one or more database objects;
determining actions to perform on the one or more database objects based on the characteristics;
automatically determining a schedule to perform the actions based on the usage; and
detecting a change in the characteristics or usage of at least one of the one or more database objects; and
modifying the actions scheduled to be performed in response to the detected change.
10. The method of claim 9 , wherein determining usage comprises collecting statistics related to the one or more database objects to determine the usage.
11. The method of claim 9 , wherein the act of determining the characteristics comprises using one or more of statistics, policies, user-customizable policies, definitions, and user-customizable definitions to determine the characteristics.
12. The method of claim 9 , further comprising performing the actions on the database objects based on the schedule.
13. The method of claim 12 , further comprising confirming that the actions have been performed on the one or more database objects.
14. The method of claim 12 , further comprising obtaining one or more results from performing the actions on the one or more database objects.
15. The method of claim 14 , further comprising:
analyzing the one or more results; and
reconfiguring one or more policies based on the analysis.
16. The method of claim 9 , wherein one or more of the acts of determining the characteristics, determining the usage, and determining the actions is performed automatically.
17. A program storage device, readable by a programmable control device, comprising instructions stored on the program storage device for causing the programmable control device to perform a method according to claim 9 .
18. A database management method, comprising:
collecting statistics related to operation of a database;
automatically determining one or more reorganization actions to perform on the database based on the statistics;
automatically determining a schedule to perform the one or more reorganization actions based on the statistics; and
performing the one or more reorganization actions on the database based on the schedule.
19. The method of claim 18 , wherein the statistics comprises statistics related to use of storage space by database objects of the database.
20. The method of claim 18 , wherein performing the one or more reorganization actions comprises:
instructing a reorganization engine to perform the one or more reorganization actions; and
performing the one or more reorganization actions with the reorganization engine.