一种SQL执行计划的确定方法及装置

    公开(公告)号:WO2017140085A1

    公开(公告)日:2017-08-24

    申请号:PCT/CN2016/090222

    申请日:2016-07-15

    Abstract: 一种SQL执行计划的确定方法及装置,涉及计算机技术领域,可以优化SQL执行计划的确定,提高SQL执行计划的执行效率。其中,所述SQL执行计划对应至少一个关系表,在第N次迭代中,该方法包括:获取在第N次迭代中对所述至少一个关系表执行第一计划树后产生的第一迭代参数,其中N为大于1的自然数;根据所述第一迭代参数建立第二计划树;当所述第二计划树与所述第一计划树的差异不大于第一阈值时,将所述第一计划树或所述第二计划树确定为所述SQL执行计划。

    EFFICIENT DIFFERENTIAL TECHNIQUES FOR METAFILES
    2.
    发明申请
    EFFICIENT DIFFERENTIAL TECHNIQUES FOR METAFILES 审中-公开
    METAFILES有效的差分技术

    公开(公告)号:WO2017075194A1

    公开(公告)日:2017-05-04

    申请号:PCT/US2016/059077

    申请日:2016-10-27

    Applicant: NETAPP, INC.

    Inventor: SHETTY, Rithin

    Abstract: Exemplary embodiments provide methods, mediums, and systems for replicating metafiles between a source and a destination. The metafile may be subdivided into blocks. The contents of the metafile may be transferred by locating the blocks which are changed between the source version of the metafile and the destination version of the metafile. The changed blocks may be examined to retrieve the contents of the changed blocks. The records in the changed blocks may be evaluated to determine whether to create a corresponding record at the destination, delete a corresponding record at the destination, or update a corresponding record atthe destination. Accordingly, the metafile may be replicated in a logical manner, by transferring only changed records rather than the entirety of a changed block. Moreover, the transfer is conducted efficiently because unchanged blocks are eliminated from consideration at the outset.

    Abstract translation: 示例性实施例提供了用于在源和目的地之间复制图元文件的方法,介质和系统。 图元文件可以细分为块。 元文件的内容可以通过定位在元文件的源版本和元文件的目标版本之间改变的块来传送。 可以检查改变的块以检索改变的块的内容。 可以评估改变块中的记录以确定是否在目的地处创建相应的记录,删除目的地处的相应记录,或者更新目的地处的相应记录。 因此,可以通过仅传送改变的记录而不是整个改变的块来以逻辑方式复制图元文件。 而且,转移是有效地进行的,因为从一开始就不考虑未改变的块。

    DATA COMMUNICATIONS SYSTEM AND METHOD THAT MAXIMIZE EFFICIENT USAGE OF COMMUNICATIONS RESOURCES
    3.
    发明申请
    DATA COMMUNICATIONS SYSTEM AND METHOD THAT MAXIMIZE EFFICIENT USAGE OF COMMUNICATIONS RESOURCES 审中-公开
    数据通信系统和方法,最大限度地提高通信资源的有效利用率

    公开(公告)号:WO2017074837A1

    公开(公告)日:2017-05-04

    申请号:PCT/US2016/058377

    申请日:2016-10-24

    CPC classification number: G06F17/30327 G06F17/3053 G06Q30/0251

    Abstract: There is provided a method that includes (a) receiving a unique identifier of a first entity, (b) constructing a family tree of entities that includes the first entity, (c) calculating a decision-making power score for each entity in the family tree in accordance with a rule, thus yielding decision-making power scores, (d) identifying a decision-making entity in the family tree, based on the decision-making power scores, thus yielding an identification of the decision-making entity, and (e) controlling a messaging system to direct a correspondence to a recipient, based on the identification of the decision-making entity. There is also provided a system that performs the method, and a storage device for storing instructions for a processor to perform the method.

    Abstract translation: 提供了一种方法,其包括(a)接收第一实体的唯一标识符,(b)构建包括第一实体的实体的家族树,(c)计算决策制定 根据规则对家族树中的每个实体进行权力评分,从而得出决策权力评分;(d)基于决策权力评分来识别家族树中的决策实体,从而产生识别 以及(e)基于决策实体的标识,控制消息传递系统以指引信息给接收者。 还提供了一种执行该方法的系统和一种用于存储处理器执行该方法的指令的存储设备。

    DETECTING CHANNEL CHANGE IN AUTOMATIC CONTENT RECOGNITION FINGERPRINT MATCHING
    5.
    发明申请
    DETECTING CHANNEL CHANGE IN AUTOMATIC CONTENT RECOGNITION FINGERPRINT MATCHING 审中-公开
    检测自动内容识别中的通道改变指纹匹配

    公开(公告)号:WO2016200622A1

    公开(公告)日:2016-12-15

    申请号:PCT/US2016/034401

    申请日:2016-05-26

    Inventor: CHEN, Juikun

    Abstract: The disclosed system and method receives, from a media device, a query fingerprint that includes an ordered sequence of frames of content being consumed, and matches the query fingerprint with frame fingerprints by determining a distance between respective frame fingerprints and corresponding ones of the ordered sequence of frames. The matching may be performed by populating a binary tree structure with respective distances, chronologically across leaf nodes of the binary tree structure, and then noting a value of the root node. If below a maximum threshold, then there is a match. The system and method may detect a channel change at the media device by traversing a sub-tree of the binary tree structure, and locating a low value (or a zero) at the first or second nodes of the sub-tree. This channel change may be useful in targeting media to content being streamed to the media device.

    Abstract translation: 所公开的系统和方法从媒体设备接收包括被消费的内容帧的有序序列的查询指纹,并且通过确定相应帧指纹之间的距离和相应的有序序列之间的距离来将查询指纹与帧指纹匹配 的框架。 可以通过以二进制树结构的叶节点按时间顺序填充具有相应距离的二叉树结构,然后注意根节点的值来执行匹配。 如果低于一个最大阈值,那么就有一个匹配。 系统和方法可以通过遍历二叉树结构的子树并且在子树的第一或第二节点处定位低值(或零)来检测媒体设备处的信道变化。 此频道更改可能会有助于将媒体定位到正在流式传输到媒体设备的内容。

Patent Agency Ranking