公开(公告)号：US20150081668A1

公开(公告)日：2015-03-19

申请号：US14321875

申请日：2014-07-02

Applicant: NEC LABORATORIES AMERICA, INC.

Inventor： Jagan Sankaranarayanan ,  Vahit Hacigumus ,  Jeffrey LeFevre ,  Junichi Tatemura

IPC: G06F17/30

CPC classification number: G06F16/24539 ,  G06F16/2282 ,  G06F16/2393 ,  G06F16/285

Abstract: Systems and methods are disclosed to run a multistore system by receiving by-products of query processing in the multistore system, wherein the by-products include views or materializations of intermediate data; placing the views or materializations across the stores based on recently observed queries as indicative of a future query workload; determining a benefit score for each view based on a predicted future query workload, wherein each store has an allotted view storage budget, and there is a view transfer budget for transferring views between the stores; and tuning a physical design of the multistore system.

Abstract translation: 公开了通过在多存储系统中接收查询处理的副产品来运行多存储系统的系统和方法，其中副产品包括中间数据的视图或实现; 根据最近观察到的查询将视图或实现放置在整个商店中，以表示未来的查询工作量; 基于预测的未来查询工作负载来确定每个视图的利益分数，其中每个商店具有分配的视图存储预算，并且存在用于在商店之间传送视图的视图传送预算; 并调整多存储系统的物理设计。

公开(公告)号：US09569491B2

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

申请号：US14321881

申请日：2014-07-02

Applicant: NEC Laboratories America, Inc.

Inventor： Jagan Sankaranarayanan ,  Vahit Hacigumus ,  Jeffrey LeFevre ,  Junichi Tatemura

IPC: G06F17/30

CPC classification number: G06F17/30457 ,  G06F17/30339 ,  G06F17/30383 ,  G06F17/30598

Abstract: 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.

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

公开(公告)号：US20160147832A1

公开(公告)日：2016-05-26

申请号：US14321881

申请日：2014-07-02

Applicant: NEC Laboratories America, Inc.

Inventor： Jagan Sankaranarayanan ,  Vahit Hacigumus ,  Jeffrey LeFevre ,  Junichi Tatemura

IPC: G06F17/30

CPC classification number: G06F17/30457 ,  G06F17/30339 ,  G06F17/30383 ,  G06F17/30598

Abstract: 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.

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