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

    IPC分类号: G06F7/00 G06F17/00

    CPC分类号: G06F17/30442

    摘要: 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.

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

    APPARATUS AND METHOD FOR PERFORMING TABLE COMPARISONS
    2.
    发明申请
    APPARATUS AND METHOD FOR PERFORMING TABLE COMPARISONS 有权
    用于执行表比较的装置和方法

    公开(公告)号:US20090171959A1

    公开(公告)日:2009-07-02

    申请号:US11965351

    申请日:2007-12-27

    IPC分类号: G06F7/08

    CPC分类号: G06F17/30557

    摘要: A computer readable storage medium includes executable instructions to analyze sort options associated with an input table and a comparison table. It is determined whether a consistent sort can be performed by a first database associated with the input table and a second database associated with the comparison table. A first sort operation is performed on the input table at the first database and a second sort operation is performed on the comparison table at the second database when a consistent sort can be achieved. Sort operations on the input table and the comparison table are executed at a common sort engine when a consistent sort cannot be performed by the first database and the second database.

    摘要翻译: 计算机可读存储介质包括用于分析与输入表和比较表相关联的排序选项的可执行指令。 确定是否可以由与输入表相关联的第一数据库和与比较表相关联的第二数据库执行一致排序。 在第一数据库的输入表上执行第一分类操作,并且当可以实现一致的排序时,在第二数据库的比较表上执行第二分类操作。 当第一个数据库和第二个数据库无法执行一致的排序时,输入表和比较表上的排序操作将在通用排序引擎执行。

    System and method for performing centralized common tasks for a set of functions
    3.
    发明授权
    System and method for performing centralized common tasks for a set of functions 有权
    用于执行一组功能的集中式通用任务的系统和方法

    公开(公告)号:US08819155B2

    公开(公告)日:2014-08-26

    申请号:US13329055

    申请日:2011-12-16

    IPC分类号: G06F15/16

    摘要: Methods, systems, and apparatuses for processing function calls using a hooking routines to perform pre-execution tasks are disclosed. A server computer receives a function call including a hooking routine and a request to run a particular function from a client computer. Based on a function group identifier and the credentials of the user or client computer, the server computer can perform various pre-execution tasks. The tasks can be common to all functions in the function group or be customized Both pre-execution tasks can be stored remotely from the client computer, so that updates to the pre-execution task can be made without the need to update computer readable code stored on the client computer. If the pre-execution tasks, such as an authorization, passes, then the server computer can execute the requested function, the server computer can reject or abort the requested function.

    摘要翻译: 公开了使用挂钩例程处理函数调用以执行预执行任务的方法,系统和装置。 服务器计算机接收包括挂接例程和从客户端计算机运行特定功能的请求的功能调用。 基于功能组标识符和用户或客户端计算机的凭据,服务器计算机可以执行各种预执行任务。 这些任务对于功能组中的所有功能可以是通用的,或者可以被定制。两个预执行任务可以从客户端计算机远程存储,从而可以对预执行任务进行更新,而无需更新存储的计算机可读代码 在客户端计算机上。 如果预执行任务(例如授权)通过,则服务器计算机可以执行所请求的功能,服务器计算机可以拒绝或中止所请求的功能。

    System and Method for Performing Centralized Common Tasks for a Set of Functions
    4.
    发明申请
    System and Method for Performing Centralized Common Tasks for a Set of Functions 有权
    执行一组功能的集中式通用任务的系统和方法

    公开(公告)号:US20130159385A1

    公开(公告)日:2013-06-20

    申请号:US13329055

    申请日:2011-12-16

    IPC分类号: G06F15/16

    摘要: Methods, systems, and apparatuses for processing function calls using a hooking routines to perform pre-execution tasks are disclosed. A server computer receives a function call including a hooking routine and a request to run a particular function from a client computer. Based on a function group identifier and the credentials of the user or client computer, the server computer can perform various pre-execution tasks. The tasks can be common to all functions in the function group or be customized Both pre-execution tasks can be stored remotely from the client computer, so that updates to the pre-execution task can be made without the need to update computer readable code stored on the client computer. If the pre-execution tasks, such as an authorization, passes, then the server computer can execute the requested function, the server computer can reject or abort the requested function.

    摘要翻译: 公开了使用挂钩例程处理函数调用以执行预执行任务的方法,系统和装置。 服务器计算机接收包括挂接例程和从客户端计算机运行特定功能的请求的功能调用。 基于功能组标识符和用户或客户端计算机的凭据,服务器计算机可以执行各种预执行任务。 这些任务对于功能组中的所有功能可以是通用的,或者可以被定制。两个预执行任务可以从客户端计算机远程存储,从而可以对预执行任务进行更新,而无需更新存储的计算机可读代码 在客户端计算机上。 如果预执行任务(例如授权)通过,则服务器计算机可以执行所请求的功能,服务器计算机可以拒绝或中止所请求的功能。

    Apparatus and method for performing table comparisons
    5.
    发明授权
    Apparatus and method for performing table comparisons 有权
    用于执行表比较的装置和方法

    公开(公告)号:US07945529B2

    公开(公告)日:2011-05-17

    申请号:US11965351

    申请日:2007-12-27

    IPC分类号: G06F7/16

    CPC分类号: G06F17/30557

    摘要: A computer readable storage medium includes executable instructions to analyze sort options associated with an input table and a comparison table. It is determined whether a consistent sort can be performed by a first database associated with the input table and a second database associated with the comparison table. A first sort operation is performed on the input table at the first database and a second sort operation is performed on the comparison table at the second database when a consistent sort can be achieved. Sort operations on the input table and the comparison table are executed at a common sort engine when a consistent sort cannot be performed by the first database and the second database.

    摘要翻译: 计算机可读存储介质包括用于分析与输入表和比较表相关联的排序选项的可执行指令。 确定是否可以由与输入表相关联的第一数据库和与比较表相关联的第二数据库执行一致排序。 在第一数据库的输入表上执行第一分类操作,并且当可以实现一致的排序时,在第二数据库的比较表上执行第二分类操作。 当第一个数据库和第二个数据库无法执行一致的排序时,输入表和比较表上的排序操作将在通用排序引擎执行。