Systems, methods and software for automating database tasks
First Claim
1. In a database environment, a software framework for managing system resources, the software framework comprising:
- a maintenance window during which system tasks may be executed without significantly impacting user tasks;
a resource manager configured to establish at least one resource plan, wherein the resource plan defines how system resources should be allocated among a plurality of competing tasks, the plurality of competing tasks comprising at least one user task and at least one system task; and
a job scheduler configured to govern the execution of the at least one system task;
wherein;
the resource manager is configured to allocate relatively more system resources for the at least one system task during the system defined maintenance window; and
the job scheduler is configured to inhibit the at least one system task from executing automatically except during the system-defined maintenance window.
1 Assignment
0 Petitions
Accused Products
Abstract
Various embodiments of the invention provide solutions to facilitate the management and/or automation of various database tasks, in particular system tasks. Merely by way of example, some embodiments provide methods systems and/or software products that can facilitate automation of such tasks. In accordance with certain embodiments, a maintenance window may be defined. The maintenance window can provide an opportunity for system tasks (and/or other tasks, especially those that consume significant database resources) to execute without significantly impacting the usability of the database. In particular embodiments, a maintenance window may be defined to coincide with a period of relatively low user activity. In some cases, a maintenance window may be implemented in conjunction with a job scheduler and/or a resource manager. Merely by way of example, a resource manager might allocate relatively more system and/or database resources to system tasks during the maintenance window, and/or a job scheduler may schedule system tasks to execute during the maintenance window.
-
Citations
36 Claims
-
1. In a database environment, a software framework for managing system resources, the software framework comprising:
-
a maintenance window during which system tasks may be executed without significantly impacting user tasks;
a resource manager configured to establish at least one resource plan, wherein the resource plan defines how system resources should be allocated among a plurality of competing tasks, the plurality of competing tasks comprising at least one user task and at least one system task; and
a job scheduler configured to govern the execution of the at least one system task;
wherein;
the resource manager is configured to allocate relatively more system resources for the at least one system task during the system defined maintenance window; and
the job scheduler is configured to inhibit the at least one system task from executing automatically except during the system-defined maintenance window.
-
-
2. In a database environment, a computer-implemented method for managing system resources, the method comprising:
-
defining a maintenance window during which system tasks may be executed without significantly impacting user tasks;
scheduling at least one system task to execute during the maintenance window, such that the execution of the at least one system task imposes a relatively minimal impact on at least one user task;
allocating relatively greater system resources to the at least one system task during the defined maintenance window; and
inhibiting the at least one system task from executing except during the defined maintenance window. - View Dependent Claims (3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32)
-
-
33. A computer system comprising:
-
a database;
a processor in communication with the database; and
a computer readable medium in communication with the processor, the computer readable medium comprising instructions executable by the processor to;
define a maintenance window for the database during which system tasks may be executed without significantly impacting user tasks;
schedule at least one system task to execute during the maintenance window, such that the execution of the at least one system task imposes a relatively insignificant impact on at least one user task;
allocate relatively greater system resources to the at least one system task during the defined maintenance window; and
inhibit the at least one system task from executing except during the defined maintenance window.
-
-
34. A computer program stored on a computer-readable storage medium for managing system resources for a database, the computer program comprising instructions executable by a computer to:
-
define a maintenance window for the database during which system tasks may be executed without significantly impacting user tasks;
schedule at least one system task to execute during the maintenance window, such that the execution of the at least one system task imposes a relatively insignificant impact on at least one user task;
allocate relatively greater system resources to the at least one system task during the defined maintenance window; and
inhibit the at least one system task from executing except during the defined maintenance window. - View Dependent Claims (35, 36)
-
Specification