STANDARD OPERATING PROCEDURE AUTOMATION IN DATABASE ADMINISTRATION
First Claim
1. A computer system for managing a database, the computer system comprising:
- a machine capable of executing instructions embodied as software; and
a plurality of software portions, including one of said software portions configured to create a plurality of database standard operating procedures (“
SOPs”
);
one of said software portions configured to store in a memory the plurality of SOPs;
one of said software portions configured to monitor state information about the database;
one of said software portions configured to receive a tasking request identifying a subset of the plurality of SOPs;
one of said software portions configured to retrieve the subset of the plurality SOPs from the memory; and
one of said software portions configured to execute the subset of the plurality of SOPs on the database.
12 Assignments
0 Petitions
Accused Products
Abstract
A plurality of modules and/or engines to manage the operation and health of a plurality of databases through the use of standard operating procedures (SOPs). Modules of the present invention are configured to assist database administrators to create, and thereafter store in an accessible memory resource, a plurality of SOPs. These SOPs define procedures to address various database informational states. Database state information is monitored, collected and analyzed to determine, based either on a predetermined rule set or on manual input from an authorized database administrator, whether one or more SOPs will be applied to a particular database environment. These SOPs can be combined and/or executed on the database either automatically or manually.
-
Citations
43 Claims
-
1. A computer system for managing a database, the computer system comprising:
-
a machine capable of executing instructions embodied as software; and
a plurality of software portions, including one of said software portions configured to create a plurality of database standard operating procedures (“
SOPs”
);
one of said software portions configured to store in a memory the plurality of SOPs;
one of said software portions configured to monitor state information about the database;
one of said software portions configured to receive a tasking request identifying a subset of the plurality of SOPs;
one of said software portions configured to retrieve the subset of the plurality SOPs from the memory; and
one of said software portions configured to execute the subset of the plurality of SOPs on the database. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24)
-
-
25. A computer implemented method for managing a database, the method comprising:
-
monitoring state information about the database;
collecting state information about the database;
receiving a tasking request based on collected state information about the database;
retrieving from a storage medium at least one of a plurality of database standard operating procedures (“
SOPs”
) based on the tasking request; and
at the database, executing the at least one database SOP. - View Dependent Claims (26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39)
-
-
40. A computer-readable storage medium tangibly embodying a program of instructions executable by a machine wherein said program of instruction comprises a plurality of program codes for managing a database, said program of instruction comprising:
-
program code for creating a plurality of database standard operating procedures (“
SOPs”
);
program code for storing in a memory the plurality of SOPs;
program code for collecting state information about the database;
program code for receiving a tasking request identifying a subset of the plurality of SOPs;
program code for retrieving the subset of SOPs from the memory; and
program code for executing the subset of SOP on the database. - View Dependent Claims (41, 42, 43)
-
Specification