×

Apparatus and method for capturing and propagating changes from an operational database to data marts

  • US 6,032,158 A
  • Filed: 05/02/1997
  • Issued: 02/29/2000
  • Est. Priority Date: 05/02/1997
  • Status: Expired due to Term
First Claim
Patent Images

1. 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.

View all claims
  • 5 Assignments
Timeline View
Assignment View
    ×
    ×