公开(公告)号：US07599903B2

公开(公告)日：2009-10-06

申请号：US10891521

申请日：2004-07-15

申请人： Christian Günther ,  Michael Aakolk ,  Jochen Kountz ,  Nuran Adal

发明人： Christian Günther ,  Michael Aakolk ,  Jochen Kountz ,  Nuran Adal

IPC分类号： G06F17/00

CPC分类号： G06F17/30563 ,  Y10S707/99931 ,  Y10S707/99939

摘要： Systems and methods are provided for extracting data sets from an online relational database into a data warehouse. 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 sets that have been imported twice may be filtered out with the use of, for example, an operational data store (ODS) objects. The filtered out data sets may be available in the data warehouse for the drilldown reporting.

摘要翻译： 提供了系统和方法，用于将数据集从在线关系数据库提取到数据仓库中。 执行基于特殊时间戳技术的数据查询。 时间戳记只能提取自上次提取点以来发生变化的这些数据集。 已经导入的数据集保持不变，在新导入时不需要删除。 定义包括下限和上限所包含的时间窗口的数据集的提取间隔。 可以使用例如操作数据存储（ODS）对象来过滤输出两次的提取的数据集。 过滤掉的数据集可能在数据仓库中可用于深入报告。

公开(公告)号：US20050065944A1

公开(公告)日：2005-03-24

申请号：US10891521

申请日：2004-07-15

申请人： Christian Gunther ,  Michael Aakolk ,  Jochen Kountz ,  Nuran Adal

发明人： Christian Gunther ,  Michael Aakolk ,  Jochen Kountz ,  Nuran Adal

IPC分类号： G06F17/30 ,  G06F17/00

CPC分类号： G06F17/30563 ,  Y10S707/99931 ,  Y10S707/99939

摘要： Systems and methods are provided for extracting data sets from an online relational database into a data warehouse. 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 sets that have been imported twice may be filtered out with the use of, for example, an operational data store (ODS) objects. The filtered out data sets may be available in the data warehouse for the drilldown reporting.

摘要翻译： 提供了系统和方法，用于将数据集从在线关系数据库提取到数据仓库中。 执行基于特殊时间戳技术的数据查询。 时间戳记只能提取自上次提取点以来发生变化的这些数据集。 已经导入的数据集保持不变，在新导入时不需要删除。 定义包括下限和上限所包含的时间窗口的数据集的提取间隔。 可以使用例如操作数据存储（ODS）对象来过滤输出两次的提取的数据集。 过滤掉的数据集可能在数据仓库中可用于深入报告。