Sen Ma

US Patent:

20020198902, Dec 26, 2002

Filed:

Jun 25, 2001

Appl. No.:

09/891818

Inventors:

Mohan Sankaran - Union City CA, US
Sanjeev Gupta - Sunnyvale CA, US
Sen Ma - San Jose CA, US

International Classification:

G06F012/00

US Classification:

707/203000

Abstract:

A method and system thereof for performing real time transformations of dynamically increasing databases is described. A session, identified as a real time session, is initialized. The real time session repeatedly executes a persistent (e.g., continually running) data transport pipeline of the analytic application. The data transport pipeline extracts data from a changing database, transforms the data, and writes the transformed data to storage (e.g., a data warehouse or data mart). The data transport pipeline is executed at the end of each time interval in a plurality of contiguous time intervals occurring during the real time session. The data transport pipeline remains running after it is executed, until the real time session is completed. Accordingly, new data are transformed in a timely manner, and processing resources are not consumed by having to repeatedly re-establish (re-initialize) the data transport pipeline.