Apparatus and method for automating the logging of table changes in a database
First Claim
1. An apparatus for creating history tables and batching transactions by entity comprising:
- a computer having a memory; and
a program in the memory wherein the program contains instructions to cause the computer to modify a source table by adding a entity column and a timestamp column, generate a history table corresponding to the selected source table, and to generate a plurality of metadata;
wherein when a change is made to the source table by a database application, the plurality of metadata automatically updates the history table independent of the database application.
2 Assignments
0 Petitions
Accused Products
Abstract
A system and method for logging changes to a database table are disclosed. The system comprises an administration tool, table metadata, a history table, and a service engine. The administration tool provides an interface through which a DBA, database programmer, or other user can manage the table metadata and the history table, including the selection of columns within the table for which the system will track changes. In the preferred embodiment, the service engine is a middleware application that tracks changes for the selected columns. The service engine processes all user-requested database operations and adds operations to manage the history table before relaying the request operations to a DBMS. Alternatively or additionally, the service engine may be a wrapper to existing services that the database application provides.
-
Citations
17 Claims
-
1. An apparatus for creating history tables and batching transactions by entity comprising:
-
a computer having a memory; and
a program in the memory wherein the program contains instructions to cause the computer to modify a source table by adding a entity column and a timestamp column, generate a history table corresponding to the selected source table, and to generate a plurality of metadata;wherein when a change is made to the source table by a database application, the plurality of metadata automatically updates the history table independent of the database application. - View Dependent Claims (2, 3)
-
-
4. A computer program product for creating history tables and batching transactions by entity comprising:
-
a computer readable medium a development tool comprising a plurality of instructions encoded on the computer readable medium to cause a computer to perform the following steps; generating a history table corresponding to the selected source table; generating a plurality of metadata comprising a plurality of mapping instructions between the source table and the history table, a service engine comprising a plurality of instructions encoded on the computer readable medium to cause the computer to perform the following steps; defining a transaction; accessing the plurality of metadata; and using the metadata, updating the source table and the history table independent of the database application. - View Dependent Claims (5, 6, 7, 8, 9, 10, 11, 12, 13)
-
-
14. A method of employing a service engine in a computer connected to a database application and a database comprising:
-
modifying a source table by adding a entity column and a timestamp column; generating a history table corresponding to the source table; and generating a plurality of metadata so that when a change is made to the source table by a database application, the plurality of meta data automatically updates the history table independent of the database application. - View Dependent Claims (15, 16, 17)
-
Specification