Apparatus and method to transform an extract transform and load (ETL) task into a delta load task
    1.
    发明授权
    Apparatus and method to transform an extract transform and load (ETL) task into a delta load task 有权
    将提取变换和加载(ETL)任务转换为增量负载任务的装置和方法

    公开(公告)号:US08200614B2

    公开(公告)日:2012-06-12

    申请号:US12113177

    申请日:2008-04-30

    CPC classification number: G06F17/30442

    Abstract: A computer readable storage medium includes executable instructions to support the definition of an Extract Transform and Load (ETL) task. An evaluation of source table structures, source data change indicators, and target table structures is performed. The ETL task is converted to a delta load task in accordance with the evaluation.

    Abstract translation: 计算机可读存储介质包括可执行指令以支持提取变换和加载(ETL)任务的定义。 执行源表结构,源数据变化指示符和目标表结构的评估。 根据评估将ETL任务转换为增量负载任务。

    Apparatus and method for dynamically auditing data migration to produce metadata
    2.
    发明申请
    Apparatus and method for dynamically auditing data migration to produce metadata 有权
    用于动态审计数据迁移以产生元数据的装置和方法

    公开(公告)号:US20060218405A1

    公开(公告)日:2006-09-28

    申请号:US11088520

    申请日:2005-03-23

    CPC classification number: G06F17/303

    Abstract: A computer readable medium includes executable instructions to audit data migration. The executable instructions include instructions to define a data migration path from a source to a target. Audit points are specified within the data migration path. Audit statistics to be generated at the audit points are identified. The audit statistics including data corresponding to individual data values transmitted over the data migration path. Audit rules to be applied against the audit statistics are established.

    Abstract translation: 计算机可读介质包括用于审计数据迁移的可执行指令。 可执行指令包括定义从源到目标的数据迁移路径的指令。 审计点在数据迁移路径中指定。 确定在审计点产生的审计统计数据。 审计统计数据包括与通过数据迁移路径传输的各个数据值相对应的数据。 建立审计统计规则。

    Dataset previews for ETL transforms
    3.
    发明授权
    Dataset previews for ETL transforms 有权
    ETL转换的数据集预览

    公开(公告)号:US08452723B2

    公开(公告)日:2013-05-28

    申请号:US13101418

    申请日:2011-05-05

    CPC classification number: G06F17/30563

    Abstract: Disclosed is a user interface on a display for editing data transformations comprising an ETL process. A first display area presents a data representation of a data transformation. A second display area presents a view of input data, and a third display are presents a view of output data. User input to modify the data transformation is received. In response to receiving the user input, the third display area is updated with output data generated by applying the modified data transformation to the input data.

    Abstract translation: 公开了用于编辑包括ETL处理的数据变换的显示器上的用户界面。 第一显示区域呈现数据变换的数据表示。 第二显示区域呈现输入数据的视图,第三显示器呈现输出数据的视图。 接收用户输入修改数据变换。 响应于接收到用户输入,通过将修改的数据变换应用于输入数据而生成的输出数据来更新第三显示区域。

    METHOD AND SYSTEM FOR AUTOMATIC BUSINESS CONTENT DISCOVERY
    4.
    发明申请
    METHOD AND SYSTEM FOR AUTOMATIC BUSINESS CONTENT DISCOVERY 审中-公开
    自动商业内容发现方法与系统

    公开(公告)号:US20110145005A1

    公开(公告)日:2011-06-16

    申请号:US12634967

    申请日:2009-12-10

    CPC classification number: G06Q10/10

    Abstract: A system and method for automatic business content discovery are described. In various embodiments, a system includes modules to bind business terms to data validation rules and search data sources for data matching data validation rules. In various embodiments, the system binds matching data to data validation rules. In various embodiments, a user interface is provided for creating and managing business terms and data validation rules. In various embodiments, a method for profiling and monitoring data via graphical controls is presented.

    Abstract translation: 描述了用于自动商业内容发现的系统和方法。 在各种实施例中,系统包括用于将业务术语绑定到数据验证规则的模块和用于数据匹配数据验证规则的搜索数据源。 在各种实施例中,系统将匹配数据绑定到数据验证规则。 在各种实施例中,提供用于创建和管理业务术语和数据验证规则的用户界面。 在各种实施例中,呈现通过图形控件对数据进行分析和监视的方法。

    APPARATUS AND METHOD TO TRANSFORM AN EXTRACT TRANSFORM AND LOAD (ETL) TASK INTO A DELTA LOAD TASK
    5.
    发明申请
    APPARATUS AND METHOD TO TRANSFORM AN EXTRACT TRANSFORM AND LOAD (ETL) TASK INTO A DELTA LOAD TASK 有权
    将提取变换和负载(ETL)任务转换为DELTA负载任务的装置和方法

    公开(公告)号:US20090276449A1

    公开(公告)日:2009-11-05

    申请号:US12113177

    申请日:2008-04-30

    CPC classification number: G06F17/30442

    Abstract: A computer readable storage medium includes executable instructions to support the definition of an Extract Transform and Load (ETL) task. An evaluation of source table structures, source data change indicators, and target table structures is performed. The ETL task is converted to a delta load task in accordance with the evaluation.

    Abstract translation: 计算机可读存储介质包括可执行指令以支持提取变换和加载(ETL)任务的定义。 执行源表结构,源数据变化指示符和目标表结构的评估。 根据评估将ETL任务转换为增量负载任务。

    Apparatus and method for dynamically auditing data migration to produce metadata
    8.
    发明授权
    Apparatus and method for dynamically auditing data migration to produce metadata 有权
    用于动态审计数据迁移以产生元数据的装置和方法

    公开(公告)号:US07725728B2

    公开(公告)日:2010-05-25

    申请号:US11088520

    申请日:2005-03-23

    CPC classification number: G06F17/303

    Abstract: A computer readable medium includes executable instructions to audit data migration. The executable instructions include instructions to define a data migration path from a source to a target. Audit points are specified within the data migration path. Audit statistics to be generated at the audit points are identified. The audit statistics including data corresponding to individual data values transmitted over the data migration path. Audit rules to be applied against the audit statistics are established.

    Abstract translation: 计算机可读介质包括用于审计数据迁移的可执行指令。 可执行指令包括定义从源到目标的数据迁移路径的指令。 审计点在数据迁移路径中指定。 确定在审计点产生的审计统计数据。 审计统计数据包括与通过数据迁移路径传输的各个数据值相对应的数据。 建立审计统计规则。

    Dataset Previews for ETL Transforms
    9.
    发明申请
    Dataset Previews for ETL Transforms 有权
    ETL变换的数据集预览

    公开(公告)号:US20120284223A1

    公开(公告)日:2012-11-08

    申请号:US13101418

    申请日:2011-05-05

    CPC classification number: G06F17/30563

    Abstract: Disclosed is a user interface on a display for editing data transformations comprising an ETL process. A first display area presents a data representation of a data transformation. A second display area presents a view of input data, and a third display are presents a view of output data. User input to modify the data transformation is received. In response to receiving the user input, the third display area is updated with output data generated by applying the modified data transformation to the input data.

    Abstract translation: 公开了用于编辑包括ETL处理的数据变换的显示器上的用户界面。 第一显示区域呈现数据变换的数据表示。 第二显示区域呈现输入数据的视图,第三显示器呈现输出数据的视图。 接收用户输入修改数据变换。 响应于接收到用户输入,通过将修改的数据变换应用于输入数据而生成的输出数据来更新第三显示区域。

    APPARATUS AND METHOD FOR MERGING METADATA WITHIN A REPOSITORY
    10.
    发明申请
    APPARATUS AND METHOD FOR MERGING METADATA WITHIN A REPOSITORY 审中-公开
    在报告中与元数据进行合并的装置和方法

    公开(公告)号:US20070255741A1

    公开(公告)日:2007-11-01

    申请号:US11741458

    申请日:2007-04-27

    CPC classification number: G06F16/24573 G06F16/2456

    Abstract: A computer readable storage medium includes executable instructions to create a database structure that contains groups of linked data tables to store different types of metadata selected from Business Metadata, Structural Metadata and Operational Metadata. At least two different types of metadata are received. The database structure is populated with the at least two different types of metadata to form composite metadata.

    Abstract translation: 计算机可读存储介质包括可执行指令,用于创建包含链接数据表组的数据库结构,以存储从业务元数据,结构元数据和操作元数据中选择的不同类型的元数据。 接收至少两种不同类型的元数据。 数据库结构用至少两种不同类型的元数据填充以形成复合元数据。

Patent Agency Ranking