Database management system and method which automatically schedules and performs actions and monitors results
First Claim
1. A database management method comprising:
- collecting statistics relating to operation of a database, wherein the database comprises one or more database objects;
determining characteristics of the database objects;
determining actions to be performed on the database objects based on the characteristics of the database objects;
automatically determining a schedule for performing the actions on the database objects;
performing the actions on the database objects based on the schedule;
confirming the performing the actions on the database objects; and
monitoring results of the performing the actions on the database objects.
12 Assignments
0 Petitions
Accused Products
Abstract
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.
-
Citations
39 Claims
-
1. A database management method comprising:
-
collecting statistics relating to operation of a database, wherein the database comprises one or more database objects; determining characteristics of the database objects; determining actions to be performed on the database objects based on the characteristics of the database objects; automatically determining a schedule for performing the actions on the database objects; performing the actions on the database objects based on the schedule; confirming the performing the actions on the database objects; and monitoring results of the performing the actions on the database objects. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13)
-
-
14. A carrier medium comprising program instructions, wherein the program instructions are computer-executable to implement:
-
collecting statistics relating to operation of a database, wherein the database comprises one or more database objects; determining characteristics of the database objects; determining actions to be performed on the database objects based on the characteristics of the database objects; automatically determining a schedule for performing the actions on the database objects; performing the actions on the database objects based on the schedule; confirming the performing the actions on the database objects; and monitoring results of the performing the actions on the database objects. - View Dependent Claims (15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26)
-
-
27. A database management system comprising:
-
a CPU; a database coupled to the CPU, wherein the database comprises one or more database objects; a memory coupled to the CPU, wherein the memory stores program instructions which are executable by the CPU to; collect statistics relating to operation of the database; determine characteristics of the database objects; determine actions to be performed on the database objects based on the characteristics of the database objects; automatically determine a schedule for performing the actions on the database objects; perform the actions on the database objects based on the schedule; confirm the performing the actions on the database objects; and monitor results of the performing the actions on the database objects. - View Dependent Claims (28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39)
-
Specification