Tracking and reconciling database commands
US7933923B2 · kind B2 · utility
Assignee
Inventor
Key dates
| Filing date | Nov 4, 2005 |
| Grant date | Apr 26, 2011 |
| Priority date | — |
| Expiry date | Dec 21, 2026 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/2358
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
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.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.