公开(公告)号：US20130110574A1

公开(公告)日：2013-05-02

申请号：US13666438

申请日：2012-11-01

Applicant: NEC Laboratories America, Inc.

Inventor： Jagan Sankaranarayanan ,  Vahit Hakan Hacigumus ,  Mohamed Sarwat ,  Haopeng Zhang

IPC: G06Q10/06

CPC classification number: G06Q10/06 ,  G06Q10/0631 ,  G06Q10/101 ,  H04L41/5003

Abstract: Systems and methods for data sharing include generating at least one sharing plan with a cheapest cost and/or a shortest execution time for one or more sharing arrangements. Admissibility of the one or more sharing arrangements is determined such that a critical time path of the at least one sharing plan does not exceed a staleness level and a cost of the at least one sharing plan does not exceed a capacity. Sharing plans of admissible sharing arrangements are executed while maintaining the staleness level.

Abstract translation: 用于数据共享的系统和方法包括以最便宜的成本生成至少一个共享计划和/或用于一个或多个共享安排的最短执行时间。 确定一个或多个共享安排的可接受性，使得至少一个共享计划的关键时间路径不超过平均级别，并且至少一个共享计划的成本不超过容量。 共同安排的共享计划在保持平级的同时执行。

公开(公告)号：US08825506B2

公开(公告)日：2014-09-02

申请号：US13666438

申请日：2012-11-01

Applicant: NEC Laboratories America, Inc.

Inventor： Jagan Sankaranarayanan ,  Vahit Hakan Hacigumus ,  Mohamed Sarwat ,  Haopeng Zhang

IPC: G06Q10/00 ,  G06F15/173 ,  G06Q10/10 ,  G06Q10/06 ,  H04L12/24

CPC classification number: G06Q10/06 ,  G06Q10/0631 ,  G06Q10/101 ,  H04L41/5003

Abstract: Systems and methods for data sharing include generating at least one sharing plan with a cheapest cost and/or a shortest execution time for one or more sharing arrangements. Admissibility of the one or more sharing arrangements is determined such that a critical time path of the at least one sharing plan does not exceed a staleness level and a cost of the at least one sharing plan does not exceed a capacity. Sharing plans of admissible sharing arrangements are executed while maintaining the staleness level.

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

公开(公告)号：US20130110575A1

公开(公告)日：2013-05-02

申请号：US13666544

申请日：2012-11-01

Applicant: NEC Laboratories America, Inc.

Inventor： Jagan Sankaranarayanan ,  Vahit Hakan Hacigumus ,  Mohamed Sarwat ,  Haopeng Zhang

IPC: G06Q10/06

CPC classification number: G06Q10/06 ,  G06Q10/0631 ,  G06Q10/101 ,  H04L41/5003

Abstract: Systems and methods for data sharing include merging sharing plans of admissible sharing arrangements to provide a merged sharing plan. A set of all possible plumbings are determined for the merged sharing plan. A plumbing with a maximum profit is iteratively applied, using a processor, to the merged sharing plan for each plumbing of the set such that a staleness level is maintained to provide an optimized sharing plan.

Abstract translation: 数据共享的系统和方法包括合并共享安排的共享计划，以提供合并的共享计划。 确定合并共享计划的一系列可能的管道。 使用处理器迭代应用具有最大利润的管道，将集合中的每个管道的合并共享计划应用于维持平级以提供优化的共享计划。

公开(公告)号：US09477708B2

公开(公告)日：2016-10-25

申请号：US14073782

申请日：2013-11-06

Applicant: NEC Laboratories America, Inc.

Inventor： Vahit Hakan Hacigumus ,  Jagan Sankaranarayanan ,  Jeffrey Paul LeFevre ,  Junichi Tatemura ,  Neoklis Polyzotis

IPC: G06F17/30

CPC classification number: G06F17/30463

Abstract: Systems and methods are disclosed for managing a multi-store execution environment by applying opportunistic materialized views to improve workload performance and executing a plan on multiple database engines to increase query processing speed by leveraging unique capabilities of each engine by enabling stages of a query to execute on multiple engines, and by moving materialized views across engines.

Abstract translation: 公开了用于管理多存储执行环境的系统和方法，通过应用机会性物化视图来改善工作负载性能并且在多个数据库引擎上执行计划以通过利用查询执行阶段来利用每个引擎的独特能力来提高查询处理速度 在多个引擎上，并通过在引擎之间移动物化视图。

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

公开(公告)号：US20140207755A1

公开(公告)日：2014-07-24

申请号：US14073782

申请日：2013-11-06

Applicant: NEC Laboratories America, Inc.

Inventor： Vahit Hakan Hacigumus ,  Jagan Sankaranarayanan ,  Jeffrey Paul LeFevre ,  Junichi Tatemura ,  Neoklis Polyzotis

IPC: G06F17/30

CPC classification number: G06F17/30463

Abstract: Systems and methods are disclosed for managing a multi-store execution environment by applying opportunistic materialized views to improve workload performance and executing a plan on multiple database engines to increase query processing speed by leveraging unique capabilities of each engine by enabling stages of a query to execute on multiple engines, and by moving materialized views across engines.

Abstract translation: 公开了用于管理多存储执行环境的系统和方法，通过应用机会性物化视图来改善工作负载性能并且在多个数据库引擎上执行计划以通过利用查询执行阶段来利用每个引擎的独特能力来提高查询处理速度 在多个引擎上，并通过在引擎之间移动物化视图。

公开(公告)号：US20130226878A1

公开(公告)日：2013-08-29

申请号：US13706475

申请日：2012-12-06

Applicant: NEC Laboratories America, Inc.

Inventor： Jagan Sankaranarayanan ,  Vahit Hakan Hacigumus

IPC: G06F17/30

CPC classification number: G06F16/2365 ,  G06F9/542

Abstract: Methods and systems for seamless context transfers include receiving a context object from one or more applications, where the context object including updated context information for a user having an associated timestamp; entering the updated context information into a context information database; determining entries of the context information database for the user having a timestamp older than a predetermined threshold using a processor; purging the determined entries from the context information database; and sending an updated context object to one or more applications that reflects a current state of the context information for the user.

Abstract translation: 用于无缝上下文传送的方法和系统包括从一个或多个应用接收上下文对象，其中所述上下文对象包括具有关联时间戳的用户的更新的上下文信息; 将更新的上下文信息输入到上下文信息数据库中; 使用处理器确定具有早于预定阈值的时间戳的用户的上下文信息数据库的条目; 从上下文信息数据库中清除确定的条目; 以及将更新的上下文对象发送到反映用户的上下文信息的当前状态的一个或多个应用。