公开(公告)号：US09747335B2

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

申请号：US14313741

申请日：2014-06-24

申请人： Boyung Lee ,  Ki Hong Kim ,  Yongsik Yoon

发明人： Boyung Lee ,  Ki Hong Kim ,  Yongsik Yoon

IPC分类号： G06F17/30

CPC分类号： G06F17/30442 ,  G06F17/30595

摘要： In accordance with aspects of the disclosure, systems and methods are provided for query optimization including generating a knowledge based container for one or more new operators, building a generic operator structure for the knowledge based container generated for each new operator, and applying optimization rules to each new operator based on the generic operator structure built for each new operator to thereby increase extensibility of the query optimizer using a structured query language (SQL).

公开(公告)号：US20150370853A1

公开(公告)日：2015-12-24

申请号：US14313741

申请日：2014-06-24

申请人： Boyung LEE ,  Ki Hong KIM ,  Yongsik YOON

发明人： Boyung LEE ,  Ki Hong KIM ,  Yongsik YOON

IPC分类号： G06F17/30

CPC分类号： G06F17/30442 ,  G06F17/30595

摘要： In accordance with aspects of the disclosure, systems and methods are provided for query optimization including generating a knowledge based container for one or more new operators, building a generic operator structure for the knowledge based container generated for each new operator, and applying optimization rules to each new operator based on the generic operator structure built for each new operator to thereby increase extensibility of the query optimizer using a structured query language (SQL).

摘要翻译： 根据本公开的方面，提供了用于查询优化的系统和方法，包括为一个或多个新运营商生成基于知识的容器，为为每个新运营商生成的基于知识的容器构建通用运营商结构，以及将优化规则应用于 每个新的运算符基于为每个新运算符构建的通用运算符结构，从而增加使用结构化查询语言（SQL）的查询优化器的可扩展性。

公开(公告)号：US10387395B2

公开(公告)日：2019-08-20

申请号：US14531406

申请日：2014-11-03

申请人： Di Wu ,  Boyung Lee ,  Yongsik Yoon

发明人： Di Wu ,  Boyung Lee ,  Yongsik Yoon

IPC分类号： G06F16/22 ,  G06F16/27 ,  G06F16/2455

摘要： A window operator can be processed according to a variety of techniques that introduce parallelism. Window function sub-results can be calculated separately on different nodes. Overall superior performance can result. Skewness in input data can be accounted for by controlling a degree of parallelism at nodes.

公开(公告)号：US09852184B2

公开(公告)日：2017-12-26

申请号：US14531209

申请日：2014-11-03

申请人： Boyung Lee ,  Yongsik Yoon

发明人： Boyung Lee ,  Yongsik Yoon

IPC分类号： G06F17/30

CPC分类号： G06F17/30486

摘要： Partition-aware calculation of a window operator can be supported. Different nodes can calculate window function sub-results on database partitions locally, in parallel and independently. Recognition of scenarios in which such parallelism is permissible can be performed. Overall superior performance can result.

公开(公告)号：US20160125032A1

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

申请号：US14531209

申请日：2014-11-03

申请人： Boyung Lee ,  Yongsik Yoon

发明人： Boyung Lee ,  Yongsik Yoon

IPC分类号： G06F17/30

CPC分类号： G06F17/30486

摘要： Partition-aware calculation of a window operator can be supported. Different nodes can calculate window function sub-results on database partitions locally, in parallel and independently. Recognition of scenarios in which such parallelism is permissible can be performed. Overall superior performance can result.

摘要翻译： 可以支持窗口操作符的分区感知计算。 不同的节点可以平行和独立地在本地计算数据库分区上的窗口函数子结果。 识别允许这种并行性的场景可以被执行。 总体上优越的性能可以产生。

公开(公告)号：US20160125009A1

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

申请号：US14531406

申请日：2014-11-03

申请人： Di Wu ,  Boyung Lee ,  Yongsik Yoon

发明人： Di Wu ,  Boyung Lee ,  Yongsik Yoon

IPC分类号： G06F17/30

CPC分类号： G06F16/221 ,  G06F16/24554 ,  G06F16/278

摘要： A window operator can be processed according to a variety of techniques that introduce parallelism. Window function sub-results can be calculated separately on different nodes. Overall superior performance can result. Skewness in input data can be accounted for by controlling a degree of parallelism at nodes.

摘要翻译： 可以根据引入并行性的各种技术来处理窗口操作符。 窗口函数子结果可以在不同的节点上单独计算。 总体上优越的性能可以产生。 可以通过控制节点上的并行度来解释输入数据的偏差。