Methods and apparatus for tracking and reconciling database commands
First Claim
1. A method for tracking database access patterns comprising:
- receiving commands pertaining to changes in the database;
identifying, a tag command instructive of a log tagging for subsequently received commands;
extracting a tag identifier from the identified tag command;
capturing successively received commands; and
associating the received commands with the extracted tag identifier.
6 Assignments
0 Petitions
Accused Products
Abstract
A method for automatic reconciliation of database change requests associates administrative database commands with the change request via a context event command. A database monitoring system identifies a context event command that indicates that a particular context, or session, is beginning. The context event command is a tag command, and includes parameters specifying a context label indicative of a change request. Prior to entering a particular change request, the DBA issues the context event command with the context label as a parameter. The context label is an identifier of the change request to be associated with the set of operations, or commands, resulting from the particular change request. The database monitoring system logs and associates subsequently received commands with the context label in a database access log which is employed for later reconciliation of the operations with the corresponding change request.
121 Citations
23 Claims
-
1. A method for tracking database access patterns comprising:
-
receiving commands pertaining to changes in the database;
identifying, a tag command instructive of a log tagging for subsequently received commands;
extracting a tag identifier from the identified tag command;
capturing successively received commands; and
associating the received commands with the extracted tag identifier.
-
-
2. A method for automatic reconciliation of change requests comprising:
-
receiving database requests;
identifying, in one of the intercepted database requests, a tag command indicative of a session context applicable to subsequently received database requests;
extracting a context label from the identified tag command;
capturing successively received database requests; and
associating the captured database request with the extracted context label. - View Dependent Claims (3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13)
-
-
14. A method for automatic reconciliation of change requests with database operations comprising:
-
reading, from audited requests maintained by the DBMS, an ordered set of attempted database commands;
identifying a tag command corresponding to a change request, the tag command perceived as a null operation by the database;
retrieving a change request identifier from the identified tag command;
logging subsequently received commands corresponding to the change request; and
associating the change request identifier to subsequent logged commands. - View Dependent Claims (15)
-
-
16. A database monitor operable for monitoring data access requests for automatic reconciliation of change requests comprising:
-
an interface for receiving data access requests, the database monitor operable to identify, in one of the received data access requests, a tag command indicative of a session context applicable to subsequently received database requests, and further operable to extract a context label from the identified tag command; and
a database access log responsive to the database monitor operable to capture successively received database requests, and further operable to store an association of the captured database request with the extracted context label, the context label operable to identify a session corresponding to a change request. - View Dependent Claims (17, 18, 19, 20, 21)
-
-
22. A computer program product having a computer readable medium operable to store computer program logic embodied in computer program code encoded thereon, the computer program code receivable by a processor for executing computer program instructions for automatic reconciliation of change requests comprising:
-
computer program code for recording database requests receivable by DBMS tables;
computer program code for identifying, in one of the recorded database requests, a tag command indicative of a session context applicable to subsequently received database requests;
computer program code for extracting a context label from the identified tag command;
computer program code for capturing successively received database requests;
computer program code for scrutinizing the received database requests for operations pertaining to administrative changes;
associating the captured database request with the extracted context label. computer program code for reconciling the tagged entries by correlating the change request identifier with a corresponding change request; and
computer program code for flagging administrative metadata changes for which a corresponding change request identifier is unavailable.
-
-
23. A database monitor operable for nonintrusive monitoring of administrative metadata commands for automatic reconciliation of change requests comprising:
-
means for intercepting administrative database commands pertaining to metadata changes in the database;
means for identifying, a tag command instructive of a log tagging for subsequently received commands;
means for extracting a tag identifier from the identified tag command;
means for capturing successively received commands;
means for associating the captured commands with the extracted tag identifier by concatenating the captured command with the context label; and
means for reconciling the tagged entries by correlating the change request identifier with a corresponding change request.
-
Specification