Compiling extract, transform, and load job test data cases

    公开(公告)号:US10140355B2

    公开(公告)日:2018-11-27

    申请号:US14843398

    申请日:2015-09-02

    IPC分类号: G06F17/30 G06F11/36

    摘要: Compiling test cases. The method may include uploading at least one extract, transform, load job (ETL job) and a plurality of test cases. The method may also include identifying a plurality of design features associated with the at least one uploaded ETL job. The method may further include identifying at least one feature change within the plurality of identified design features. The method may also include determining a plurality of related test cases within the plurality of uploaded test cases corresponding to the at least one identified feature change. The method may further include creating a test bucket based on a grouping of the determined plurality of related test cases. The method may also include adding at least one of a plurality of corresponding ETL jobs and a plurality of corresponding ETL job stages associated with the at least one identified feature change to the created test bucket.

    COMPILING EXTRACT, TRANSFORM, AND LOAD JOB TEST DATA CASES

    公开(公告)号:US20180210949A1

    公开(公告)日:2018-07-26

    申请号:US15928452

    申请日:2018-03-22

    IPC分类号: G06F17/30 G06F11/36

    CPC分类号: G06F16/285 G06F11/368

    摘要: Compiling test cases. The method may include uploading at least one extract, transform, load job (ETL job) and a plurality of test cases. The method may also include identifying a plurality of design features associated with the at least one uploaded ETL job. The method may further include identifying at least one feature change within the plurality of identified design features. The method may also include determining a plurality of related test cases within the plurality of uploaded test cases corresponding to the at least one identified feature change. The method may further include creating a test bucket based on a grouping of the determined plurality of related test cases. The method may also include adding at least one of a plurality of corresponding ETL jobs and a plurality of corresponding ETL job stages associated with the at least one identified feature change to the created test bucket.

    AUTOMATING EXTRACT, TRANSFORM, AND LOAD JOB TESTING

    公开(公告)号:US20170060969A1

    公开(公告)日:2017-03-02

    申请号:US14843425

    申请日:2015-09-02

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30563

    摘要: A method for testing an extract, transform, load job (ETL job) is provided. The method may include receiving an uploaded ETL job. The method may also include executing a functionality test of the uploaded ETL job using a test bucket. The method may further include determining the executed functionality test produces a failure result. The method may also include creating at least one test sub-job corresponding to at least one stage within on the uploaded ETL job. The method may further include generating a plurality of test data for each of the at least one created test sub-job. The method may also include executing the at least one created test sub-job using the plurality of generated test data. The method may further include creating a report based on a plurality of results associated with the at least one executed test sub-job.

    AUTOMATED DATA ANALYSIS AND TRANSFORMATION
    7.
    发明申请
    AUTOMATED DATA ANALYSIS AND TRANSFORMATION 有权
    自动数据分析与转换

    公开(公告)号:US20140025625A1

    公开(公告)日:2014-01-23

    申请号:US14041009

    申请日:2013-09-30

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30563

    摘要: A transformation method and system is provided. The method includes generating a data hub application configured to embed extract, transform, and load (ETL) processes. The data hub application is linked to source tables and target tables. Meta data associated with the source and target tables is transferred from virtual views of the data hub application to an ETL work area of the ETL processes. An ETL job is generated and linked to the data hub application. ETL processes are executed and results are determined.

    摘要翻译: 提供了转换方法和系统。 该方法包括生成被配置为嵌入提取,变换和加载(ETL)过程的数据集线器应用。 数据中心应用程序链接到源表和目标表。 与源表和目标表相关联的元数据从数据中心应用程序的虚拟视图传输到ETL进程的ETL工作区。 生成ETL作业并链接到数据中心应用程序。 执行ETL流程并确定结果。

    Dynamic communication session management
    8.
    发明授权

    公开(公告)号:US10673801B2

    公开(公告)日:2020-06-02

    申请号:US15825515

    申请日:2017-11-29

    摘要: A computer detects initialization of a first messaging session. The computer receives one or more message commands relating to one or more messages. The computer monitors message progress of the first messaging session. The computer detects errors in the message progress. The computer starts one or more additional messaging session(s). The computer monitors message progress of the first messaging session and the one or more additional messaging session(s). The computer detects contraction of messaging sessions is appropriate. The computer closes one or more messaging sessions.

    Automating extract, transform, and load job testing

    公开(公告)号:US10579638B2

    公开(公告)日:2020-03-03

    申请号:US15358186

    申请日:2016-11-22

    IPC分类号: G06F17/30 G06F16/25

    摘要: A method for testing an extract, transform, load job (ETL job) is provided. The method may include receiving an uploaded ETL job. The method may also include executing a functionality test of the uploaded ETL job using a test bucket. The method may further include determining the executed functionality test produces a failure result. The method may also include creating at least one test sub-job corresponding to at least one stage within on the uploaded ETL job. The method may further include generating a plurality of test data for each of the at least one created test sub-job. The method may also include executing the at least one created test sub-job using the plurality of generated test data. The method may further include creating a report based on a plurality of results associated with the at least one executed test sub-job.

    Automating extract, transform, and load job testing

    公开(公告)号:US10042903B2

    公开(公告)日:2018-08-07

    申请号:US14843425

    申请日:2015-09-02

    IPC分类号: G06F17/30

    摘要: A method for testing an extract, transform, load job (ETL job) is provided. The method may include receiving an uploaded ETL job. The method may also include executing a functionality test of the uploaded ETL job using a test bucket. The method may further include determining the executed functionality test produces a failure result. The method may also include creating at least one test sub-job corresponding to at least one stage within on the uploaded ETL job. The method may further include generating a plurality of test data for each of the at least one created test sub-job. The method may also include executing the at least one created test sub-job using the plurality of generated test data. The method may further include creating a report based on a plurality of results associated with the at least one executed test sub-job.