Tracking and reconciling database commands
First Claim
1. A method for tracking database access patterns to a database server comprising:
- receiving database commands pertaining to metadata changes in the database, wherein the received database commands include one or more sets of commands with the commands of each set collectively performing a corresponding desired data modification for a database;
identifying, from the database commands, a tag command initiating a log tagging for a subsequently received set of database commands that collectively perform a desired data modification for the database, the tag command included in a recognized syntax of database commands received as database requests by a database server, further comprising;
receiving the tag command indicating a start of a session context at a command interpreter in the database server; and
recognizing the tag command as initiating the session context for the subsequently received set of database commands that collectively perform the desired data modification for the database, the session context defined by the set of database commands performing the desired data modification and encapsulated between the received start context and an end context command;
extracting a tag identifier from the identified tag command, the tag identifier for identifying the session context, and discarding the tag command in a benign manner as a null operation so as not to cause undesirable operation by the database server;
capturing successively received database commands of the set, the captured database commands for performing metadata changes and collectively performing the desired data modification of the database, the encapsulated database commands corresponding to a particular session defined by operator activity on a terminal device; and
associating the captured received commands to generate tagged entries by recording the captured database commands of the set as logged commands with the extracted tag identifier, wherein the extracted tag identifier identifies the logged commands as the set of commands within the received database commands that is associated with and performs the desired data modification for the database.
7 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.
-
Citations
23 Claims
-
1. A method for tracking database access patterns to a database server comprising:
-
receiving database commands pertaining to metadata changes in the database, wherein the received database commands include one or more sets of commands with the commands of each set collectively performing a corresponding desired data modification for a database; identifying, from the database commands, a tag command initiating a log tagging for a subsequently received set of database commands that collectively perform a desired data modification for the database, the tag command included in a recognized syntax of database commands received as database requests by a database server, further comprising; receiving the tag command indicating a start of a session context at a command interpreter in the database server; and recognizing the tag command as initiating the session context for the subsequently received set of database commands that collectively perform the desired data modification for the database, the session context defined by the set of database commands performing the desired data modification and encapsulated between the received start context and an end context command; extracting a tag identifier from the identified tag command, the tag identifier for identifying the session context, and discarding the tag command in a benign manner as a null operation so as not to cause undesirable operation by the database server; capturing successively received database commands of the set, the captured database commands for performing metadata changes and collectively performing the desired data modification of the database, the encapsulated database commands corresponding to a particular session defined by operator activity on a terminal device; and associating the captured received commands to generate tagged entries by recording the captured database commands of the set as logged commands with the extracted tag identifier, wherein the extracted tag identifier identifies the logged commands as the set of commands within the received database commands that is associated with and performs the desired data modification for the database. - View Dependent Claims (2, 3, 4)
-
-
5. A method for automatic reconciliation of change requests comprising:
-
receiving database requests, wherein the received database requests include one or more sets of database requests with each set performing a corresponding desired data modification for a database; identifying, in one of the received database requests, a tag command for initiating a session context for a subsequently received set of database requests that collectively perform a desired data modification for the database; extracting a context label identifying the session context from the identified tag command, the tag command included in a recognized syntax of database commands received as database requests by a command interpreter in a database server, further comprising; receiving the tag command indicating a start of the session context at a command interpreter in the database server; recognizing the tag command as initiating the session context for the subsequently received set of database requests that collectively perform the desired data modification for the database, the session context defined by the set of database requests performing the desired data modification and encapsulated between the received start context and an end context command; and discarding the tag command in a benign manner as a null operation so as not to cause undesirable operation by the database server; capturing successively received database requests of the set, the captured database requests being database commands for performing metadata changes and the desired data modification for the database, the encapsulated commands corresponding to a particular session defined by operator activity on a terminal device; and associating the captured database requests of the set with the extracted context label, wherein the extracted context label identifies the associated database requests as the set of database requests within the received database requests that is associated with and performs the desired data modification for the database. - View Dependent Claims (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 a database server, an ordered set of attempted database commands, wherein the database commands include one or more sets of commands with each set associated with a change request and performing a corresponding desired data modification for a database; identifying, from the database commands, a tag command corresponding to a change request for a desired data modification for the database, the tag command included in a recognized syntax of database commands received as database requests by a database server, further comprising; receiving the tag command at a command interpreter in the database server; recognizing the tag command as initiating a session context for a subsequently received set of database commands that perform the desired data modification of the corresponding change request, the session context defined by the set of database commands performing the desired data modification and encapsulated between a received start context and an end context command; and discarding the tag command in a benign manner, the tag command perceived as a null operation so as not to cause undesirable operation by the database server; retrieving a change request identifier from the identified tag command; logging subsequently received database commands of the set corresponding to the change request, the subsequently received database commands for performing metadata changes and collectively performing the desired data modification of the corresponding change request, the encapsulated database commands corresponding to a particular session defined by operator activity on a terminal device; and associating the change request identifier to the subsequent logged commands via the session context, wherein the change request identifier identifies the logged commands as the set of commands within the received database commands that is associated with the corresponding change request and performs the desired data modification for the database. - View Dependent Claims (15)
-
-
16. A database monitor having a set of instructions on a computer readable storage medium that, when executed by a computer, perform a method for monitoring data access requests for automatic reconciliation of change requests to a database, the monitor comprising:
-
an interface for receiving data access requests, wherein the received data access requests include one or more sets of data access requests with each set performing a corresponding data modification for a database, the database monitor operating to identify, in one of the received data access requests, a tag command indicative of a start of a session context applicable to subsequently received data access requests of a set performing a desired data modification for the database, the tag command included in a recognized syntax of database commands, and further operating to; recognize the tag command as a start context command for initiating a session context for the subsequently received set of data access requests, the session context defined by the set of data access requests encapsulated between the received start context and an end context command; and extract a context label from the identified tag command; and a database access log responsive to the database monitor for capturing successively received data access requests of the set, the captured database requests of the set being database commands for performing metadata changes and collectively performing the desired data modification of the database, the encapsulated database commands corresponding to a particular session defined by operator activity on a terminal device, and further for storing an association of the captured data access requests of the set with the extracted context label, the context label identifying a change request session corresponding to a change request indicating the desired data modification for the database and to identify the associated data access requests as the set of data access requests within the received data access requests that is associated with the change request and performs the desired data modification, the database monitor receiving data access requests in the identified session until receiving a successive tag command indicative of termination of the set and change request session, the tag commands selected to be logged for encapsulating and identifying the database commands received for the change request session without incurring additional change operations by the database monitor so as not to cause undesirable operation by the database monitor. - View Dependent Claims (17, 18, 19, 20)
-
-
21. A computer program product having a computer readable storage medium to store computer program logic embodied in computer program code encoded thereon, the computer program code received by a processor that, when executed by the processor, cause the computer to perform steps for automatic reconciliation of change requests comprising:
-
recording database requests received by DBMS tables in a database server, wherein the recorded database requests include one or more sets of database requests with each set performing a corresponding desired data modification for a database; identifying, in one of the recorded database requests, a tag command indicative of a start of a session context applicable to a subsequently received set of database requests that collectively perform a desired data modification for the database, the tag command included in a recognized syntax of database commands received by a command interpreter in the database server; recognizing the tag command as initiating the session context for the subsequently received set of database requests, the session context defined by the set of database requests performing the desired database modification and encapsulated between the received start context and an end context command; extracting a context label identifying the session context from the identified tag command; capturing successively received database requests, in the identified session until receiving a successive tag command indicative of termination of the set and session, the captured database requests being database commands for performing metadata changes and collectively performing the desired data modification of the database, the encapsulated commands corresponding to a particular session defined by operator activity on a terminal device, the tag commands selected to be logged for encapsulating and identifying the commands received in the session without incurring additional change operations by the database server so as not to cause undesirable operation by the database server; scrutinizing the received database requests for operations pertaining to administrative changes; associating the captured database requests of the set with the extracted context label, wherein the context label identifies the associated database requests as the set of database requests within the received database requests that is associated with and performs the desired data modification for the database; reconciling the logged commands by correlating the context label with a corresponding change request indicating the desired data modification for the database; and flagging administrative metadata changes of database requests for which a corresponding context label is unavailable.
-
-
22. A method for auditing a change request session for reconciling with a particular context comprising:
-
receiving a set of database change requests, each change request including a set of database commands for collectively defining an organizational change to a database via metadata changes; identifying, in one of the received database change requests, a tag command indicative of a start of a session context applicable to a subsequently received set of database commands for that change request, the tag command included in a recognized syntax of database commands received by a command interpreter in a database server, the tag command for encapsulating the set of database commands in the database change request as a change request session for later reconciliation with a change log; recognizing the tag command as a start context command initiating a session context of received commands, the session context defined by the set of database commands encapsulated between the received start context and an end context command; extracting a context label from the identified tag command, the context label indicative of the session context; capturing successively received database commands until receiving a successive tag command indicative of termination of the set and change request session, the captured database commands being for performing metadata changes and collectively defining the organizational change, the encapsulated commands corresponding to a particular session defined by operator activity on a terminal device, the tag commands selected to be logged for encapsulating and identifying the commands received in the change request session without incurring additional operations by a database server so as not to cause undesirable operation by the database server; and associating the database change request with the extracted context label for identifying, for each database change request, the corresponding session context and the set of database commands associated with that change request for providing an audit trail of database changes. - View Dependent Claims (23)
-
Specification