×

Tracking and reconciling database commands

  • US 7,933,923 B2
  • Filed: 11/04/2005
  • Issued: 04/26/2011
  • Est. Priority Date: 11/04/2005
  • Status: Active Grant
First Claim
Patent Images

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 all claims
  • 6 Assignments
Timeline View
Assignment View
    ×
    ×