Patent ID: 6032158
Filing Date: 2000-02-29
Classification: G06F,Y10S

Abstract:
A method for updating a target table of a data mart in response to changes made by a transaction to data stored in a source table of an operational database, comprising the steps of:determining data that was changed in the source table by the transaction;storing the data that was changed in a first table of a dedicated databases, wherein the dedicated database is separate from the operational database;determining data that was not changed in the source table by the transaction and which is being mapped to the target table;storing data that was not changed in a second table of the dedicated database;propagating the data that was changed from the first table of the dedicated database and the data that was not changed from the second table of the dedicated database to a transformation process, wherein the transformation process transforms the data without impacting the operational database;storing transformed data in the target table of the data mart.