COLUMN BASED DATA TRANSFER IN EXTRACT TRANSFORM AND LOAD (ETL) SYSTEMS
    1.
    发明申请
    COLUMN BASED DATA TRANSFER IN EXTRACT TRANSFORM AND LOAD (ETL) SYSTEMS 有权
    提取变换和负载(ETL)系统中的基于数据的数据传输

    公开(公告)号:US20130073515A1

    公开(公告)日:2013-03-21

    申请号:US13238145

    申请日:2011-09-21

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30563

    摘要: Executing a plurality of transform stages in an extract, transform and load (ETL) job including, for each of the transform stages, receiving a plurality of input row identifiers (RIDs) corresponding to a first plurality of source database table rows in a source database table. Data is retrieved directly from a subset of the source database table columns in the first plurality of source database table rows based on the input RIDs and transform logic. Partial row data including data from the subset of the source database table columns is generated for each of the first plurality of source database table rows. Transformed data is generated based on the partial row data and to the transform logic. Output RIDs corresponding to a second plurality of rows in the source database table that include a least a subset of the transformed data are output to a downstream stage.

    摘要翻译: 在提取,变换和加载(ETL)作业中执行多个变换阶段,包括对于每个变换阶段,接收与源数据库中的第一多个源数据库表行相对应的多个输入行标识符(RID) 表。 基于输入的RID和变换逻辑,直接从第一多个源数据库表行中的源数据库表列的子集中检索数据。 对于第一多个源数据库表行中的每一个生成包括源数据库表列的子集的数据的部分行数据。 基于部分行数据和变换逻辑生成变换数据。 包含源数据库表中包含变换数据的至少一个子集的第二多行的输出RID被输出到下游阶段。

    Crowd sourced, content aware smarter television systems
    6.
    发明授权
    Crowd sourced, content aware smarter television systems 失效
    人群来源,内容感知更智能的电视系统

    公开(公告)号:US08689250B2

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

    申请号:US13537765

    申请日:2012-06-29

    摘要: Method, system, and computer program product for performing an operation, the operation including broadcasting one or more media streams to one or more remote devices, the remote devices configured to provide feedback related to the one or more media streams, the remote devices configured to display a media stream on a television coupled to the remote device. The operation then aggregates, based on a predefined aggregation criterion, feedback received from the remote devices related to a first media stream. The operation then, upon determining that the aggregated feedback of the first media stream exceeds a predefined threshold for the predefined aggregation criterion, marks the first media stream based on the predefined aggregation criterion, the remote devices configured to, responsive to receiving the marked first media stream, perform a predefined operation to effect prioritized display of the first media stream on the television.

    摘要翻译: 用于执行操作的方法,系统和计算机程序产品,所述操作包括将一个或多个媒体流广播到一个或多个远程设备,所述远程设备被配置为提供与所述一个或多个媒体流相关的反馈,所述远程设备被配置为 在连接到远程设备的电视上显示媒体流。 然后,操作基于预定义的聚合标准聚合从与第一媒体流相关的远程设备接收到的反馈。 然后,在确定第一媒体流的聚合反馈超过预定义聚合标准的预定阈值之后,操作基于预定义的聚合标准来标记第一媒体流,所述远程设备被配置为响应于接收到标记的第一媒体 流,执行预定义的操作以实现电视上的第一媒体流的优先显示。

    CROWD SOURCED, CONTENT AWARE SMARTER TELEVISION SYSTEMS
    7.
    发明申请
    CROWD SOURCED, CONTENT AWARE SMARTER TELEVISION SYSTEMS 失效
    CROWD SOVERCED,内容小巧的电视系统

    公开(公告)号:US20140007150A1

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

    申请号:US13537765

    申请日:2012-06-29

    IPC分类号: H04N21/24

    摘要: Method, system, and computer program product for performing an operation, the operation including broadcasting one or more media streams to one or more remote devices, the remote devices configured to provide feedback related to the one or more media streams, the remote devices configured to display a media stream on a television coupled to the remote device. The operation then aggregates, based on a predefined aggregation criterion, feedback received from the remote devices related to a first media stream. The operation then, upon determining that the aggregated feedback of the first media stream exceeds a predefined threshold for the predefined aggregation criterion, marks the first media stream based on the predefined aggregation criterion, the remote devices configured to, responsive to receiving the marked first media stream, perform a predefined operation to effect prioritized display of the first media stream on the television.

    摘要翻译: 用于执行操作的方法,系统和计算机程序产品,所述操作包括将一个或多个媒体流广播到一个或多个远程设备,所述远程设备被配置为提供与所述一个或多个媒体流相关的反馈,所述远程设备被配置为 在连接到远程设备的电视上显示媒体流。 然后,操作基于预定义的聚合标准聚合从与第一媒体流相关的远程设备接收到的反馈。 然后,在确定第一媒体流的聚合反馈超过预定义聚合标准的预定阈值之后,操作基于预定义的聚合标准来标记第一媒体流,所述远程设备被配置为响应于接收到标记的第一媒体 流,执行预定义的操作以实现电视上的第一媒体流的优先显示。

    Column based data transfer in extract transform and load (ETL) systems
    8.
    发明授权
    Column based data transfer in extract transform and load (ETL) systems 有权
    提取变换和负载(ETL)系统中的基于列的数据传输

    公开(公告)号:US08515898B2

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

    申请号:US13238145

    申请日:2011-09-21

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30563

    摘要: Executing a plurality of transform stages in an extract, transform and load (ETL) job including, for each of the transform stages, receiving a plurality of input row identifiers (RIDs) corresponding to a first plurality of source database table rows in a source database table. Data is retrieved directly from a subset of the source database table columns in the first plurality of source database table rows based on the input RIDs and transform logic. Partial row data including data from the subset of the source database table columns is generated for each of the first plurality of source database table rows. Transformed data is generated based on the partial row data and to the transform logic. Output RIDs corresponding to a second plurality of rows in the source database table that include a least a subset of the transformed data are output to a downstream stage.

    摘要翻译: 在提取,变换和加载(ETL)作业中执行多个变换阶段,包括对于每个变换阶段,接收与源数据库中的第一多个源数据库表行相对应的多个输入行标识符(RID) 表。 基于输入的RID和变换逻辑,直接从第一多个源数据库表行中的源数据库表列的子集中检索数据。 对于第一多个源数据库表行中的每一个生成包括源数据库表列的子集的数据的部分行数据。 基于部分行数据和变换逻辑生成变换数据。 包含源数据库表中包含变换数据的至少一个子集的第二多行的输出RID被输出到下游阶段。