System and method for an annotation search index

    公开(公告)号:US09773035B1

    公开(公告)日:2017-09-26

    申请号:US15510770

    申请日:2015-10-13

    申请人: YANDEX EUROPE AG

    IPC分类号: G06F17/30

    摘要: There is disclosed a method and a system for generating an annotated search index. The method is executable at a server. The method comprises retrieving a portion of a historical search session for a first search query, the portion including a first resource and a second resource, both the first and the second resource being relevant to the first search query; generating an association parameter for the second resource, the association parameter being based on a first historical parameter and a second historical parameter; and, responsive to the association parameter for the second resource being above a predetermined threshold, associating the second resource with one or more of the first resource and the included search terms, thereby generating an annotated search index for the included search terms.

    Method and system for providing statistical data from a data warehouse

    公开(公告)号:US09710506B2

    公开(公告)日:2017-07-18

    申请号:US13979699

    申请日:2012-02-20

    申请人: Gourab Nath

    发明人: Gourab Nath

    IPC分类号: G06F7/00 G06F17/30

    摘要: Methods, systems, and computer program products for providing statistical data relating to a plurality of input files from a data warehouse. A plurality of bins are associated with a plurality of hierarchically ordered index fields. Each index field is associated with a parameter of the input files and is configured to accept an index field value from a predefined value domain associated with the index field. A lookup table is defined that includes a plurality of hierarchically indexed data structures and data containers storing statistical data for each index within the data structures. For each data structure, a primary key and at least one secondary key are formed by concatenating one or more bins in compliance with a hierarchy of the hierarchically ordered index fields to form a sequence of bins, The lookup table includes only one primary key per data structure.

    MISO (multistore-online-tuning) system
    150.
    发明授权
    MISO (multistore-online-tuning) system 有权
    MISO(多存储在线调优)系统

    公开(公告)号:US09569491B2

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

    申请号:US14321881

    申请日:2014-07-02

    IPC分类号: G06F17/30

    摘要: A system includes first and second data stores, each store having a set of materialized views of the base data and the views comprise a multistore physical design; an execution layer coupled to the data stores; a query optimizer coupled to the execution layer; and a tuner coupled to the query optimizer and the execution layer, wherein the tuner determines a placement of the materialized views across the stores to improve workload performance upon considering each store's view storage budget and a transfer budget when moving views across the stores.

    摘要翻译: 系统包括第一和第二数据存储,每个存储具有一组基本数据的物化视图,并且视图包括多存储物理设计; 耦合到数据存储的执行层; 耦合到执行层的查询优化器; 以及耦合到所述查询优化器和所述执行层的调谐器,其中,所述调谐器在跨所述商店移动视图时,在考虑每个商店的视图存储预算和转移预算时,确定跨所述商店的物化视图的放置以改善工作负载性能。