| 摘要 |
Systems, methods, and computer readable media for automatically generating Data Definition Language (DDL) commands from database log information is described. In general, techniques are disclosed for analyzing database log entries to identify those associated with targeted DDL commands and associating those entries with a DDL command object. The DDL command object may be used (immediately or at some later time) to generate a DDL commands corresponding to the (possibly many) aggregated log records associated with the command object. The use of multiple database log entries as described herein enables the generation of DDL commands that capture database activity occurring over a period of time (full time context auditing) and can, therefore, naturally account for database schema changes. |
| 主权项 |
1. An automatic database command method, comprising:
obtaining a plurality of relevant database log entries, the relevant database log entries being directed to database catalog entities; determining a first portion of the plurality of relevant database log entries are part of a common unit of recovery, the first portion including a plurality of database log entries; assigning the first portion of database log entries to a particular Data Definition Language (DDL) command object based on analysis of attributes of a first entry in the first portion of the database log entries, the particular DDL command object including a timestamp, an action, a target, and data from each of the first portion of database log entries; determining a DDL command object break when an action or target of a next database log entry in the first portion is inconsistent with the particular DDL command object; storing the particular DDL command object in a memory in response to determining the DDL command object break; receiving an indication of an operation type subsequent to the storing, the operation type being an UNDO or a MIGRATE operation type; ordering the entries in the particular DDL command object in an order based on the type of operation, the targets, and the actions; and generating at least one database command based on the operation type, the action, target, and data in each of the ordered entries in the particular DDL command object. |
