UPDATE PROPAGATION TO A DATA WAREHOUSE WITH SPECIFIED LATENCY

摘要

A method and system thereof for performing real time transformations ofdynamically increasing databases is described. A session, identified as a realtime session, is initialized. The real time session repeatedly executes apersistent (e.g., continually running) data transport pipeline of the analyticapplication. The data transport pipeline extracts data from a changingdatabase, transforms the data, and writes the transformed data to storage(e.g., a data warehouse or data mart). The data transport pipeline is executedat the end of each time interval in a plurality of contiguous time intervalsoccurring during the real time session. The data transport pipeline remainsrunning after it is executed, until the real time session is completed.Accordingly, new data are transformed in a timely manner, and processingresources are not consumed by having to repeatedly re-establish (re-initialize) the data transport pipeline.