A SYSTEM AND METHOD FOR EXTRACTING DATA SETS FROM AN ONLINE RELATIONAL DATABASE INTO A DATA WAREHOUSE

摘要

A system and method for extracting data set from an online relational database into a data warehouse is described. A data query based on special timestamping technique is executed. Timestamping allows extraction of only these data sets that have changed since the last extraction point. The data sets that have been already imported stay unchanged and do not need to be deleted at the time of the new import. Extraction interval of data sets including a time window enclosed by lower and upper limits is defined. The extracted data set that have been imported twice are filtered out with the use of an operational data store objects (ODS objects). The filtered out data sets are available in the data warehouse for the drilldown reporting.