公开(公告)号：US20060200451A1

公开(公告)日：2006-09-07

申请号：US11074343

申请日：2005-03-07

申请人： Ramakumar Kosuru ,  Awny Al-Omari

发明人： Ramakumar Kosuru ,  Awny Al-Omari

IPC分类号： G06F17/30

CPC分类号： G06F17/30466 ,  G06F17/30471 ,  Y10S707/99933

摘要： Methods and systems receive a query, receive a control statement that represents at least a portion of a desired execution plan associated with the query, and produce an execution plan that conforms to the desired plan to the extent that the produced plan preserves the semantics of the query, without requiring an exhaustive search. These methods also enable realization of bushy shaped plans that are outside the scope of the optimizer search space.

摘要翻译： 方法和系统接收查询，接收表示与查询相关联的期望的执行计划的至少一部分的控制语句，并且产生符合所需计划的执行计划，使得生成的计划保留语义 查询，而不需要详尽的搜索。 这些方法还可以实现超出优化器搜索空间范围的分类形状的计划。

公开(公告)号：US07343370B2

公开(公告)日：2008-03-11

申请号：US11074343

申请日：2005-03-07

申请人： Ramakumar Kosuru ,  Awny Al-Omari

发明人： Ramakumar Kosuru ,  Awny Al-Omari

IPC分类号： G06F7/00 ,  G06F17/00

CPC分类号： G06F17/30466 ,  G06F17/30471 ,  Y10S707/99933

摘要： Methods and systems receive a query, receive a control statement that represents at least a portion of a desired execution plan associated with the query, and produce an execution plan that conforms to the desired plan to the extent that the produced plan preserves the semantics of the query, without requiring an exhaustive search. These methods also enable realization of bushy shaped plans that are outside the scope of the optimizer search space.

摘要翻译： 方法和系统接收查询，接收表示与查询相关联的期望的执行计划的至少一部分的控制语句，并且产生符合所需计划的执行计划，使得生成的计划保留语义 查询，而不需要详尽的搜索。 这些方法还可以实现超出优化器搜索空间范围的分类形状的计划。

公开(公告)号：US20200210883A1

公开(公告)日：2020-07-02

申请号：US16235611

申请日：2018-12-28

申请人： Awny Al-Omari ,  Choudur K. Lakshminarayan ,  Yu-Chen Tuan

发明人： Awny Al-Omari ,  Choudur K. Lakshminarayan ,  Yu-Chen Tuan

IPC分类号： G06N20/00 ,  G06F16/2455 ,  G06F16/2453

摘要： A multi-staged sample and seed machine-learning training technique is presented. A sample proportion of a training data set is fed to a machine-learning algorithm (MLA) for purposes of configuring functions of the MLA to predict an output with a desired degree of accuracy. When iterating the sample proportion, if a deviation in an incrementally produced current accuracy of the MLA does not exceed a threshold, the sampled proportion is increased. This continues until the current degree of accuracy meets or exceeds the desired degree of accuracy, which is an indication that the functions of the MLA are configured as a desired model for producing the predicted output when the MLA is presented with input that may or may not have been associated with the training data set.

公开(公告)号：US20060282422A1

公开(公告)日：2006-12-14

申请号：US11150388

申请日：2005-06-10

申请人： Awny Al-Omari

发明人： Awny Al-Omari

IPC分类号： G06F17/30

CPC分类号： G06F17/30466

摘要： Methods and systems receive a normalized query tree and analyze the tree to collect information about join operators and their children, and tables in an associated query. This information is then made available to a rule based optimizer that is configured to produce, from the normalized query tree, an execution plan. In addition, in at least some embodiments, an extensible framework is provided for join order optimization via the use of a multi-join operator and multi-join rules as part of the general framework of a query optimizer.

摘要翻译： 方法和系统接收归一化的查询树，并分析树以收集有关连接运算符及其子节点的信息以及关联查询中的表。 然后，该信息可用于基于规则的优化器，其被配置为从归一化查询树生成执行计划。 此外，在至少一些实施例中，通过使用多连接运算符和多连接规则作为查询优化器的一般框架的一部分，提供了用于连接顺序优化的可扩展框架。

公开(公告)号：US11514070B2

公开(公告)日：2022-11-29

申请号：US16235819

申请日：2018-12-28

申请人： Awny Al-Omari ,  Louis Benton Landry ,  Stephen Andrew Brobst ,  Donald Raymond Pederson ,  Todd Walter ,  Oliver Ratzesberger

发明人： Awny Al-Omari ,  Louis Benton Landry ,  Stephen Andrew Brobst ,  Donald Raymond Pederson ,  Todd Walter ,  Oliver Ratzesberger

IPC分类号： G06F16/00 ,  G06F16/25 ,  G06F9/54 ,  G06F16/9038 ,  G06F16/23

摘要： An Application Programming Interface (API) processes object storage requests in an object storage format that are received from client applications. A mapper maps the object storage formatted requests into database statements and executes the statements within a database management system. Results returned from the statements are mapped by the mapper to object-storage constructs and provided to the API in object storage format. The object storage formatted requests are provided from the API to the client applications to satisfy the original client applications' requests.

公开(公告)号：US20050192943A1

公开(公告)日：2005-09-01

申请号：US10790285

申请日：2004-03-01

申请人： Kashif Siddiqui ,  Awny Al-Omari

发明人： Kashif Siddiqui ,  Awny Al-Omari

IPC分类号： G06F7/00 ,  G06F17/30

CPC分类号： G06F16/24545

摘要： A system that provides compressed histogram data comprises a compiler histogram interface that obtains histogram data about a table in a database, and a dynamic histogram compressor that receives output from the compiler histogram interface, input regarding a database query and table information to produce compressed histogram data for use by an optimizer.

摘要翻译： 提供压缩直方图数据的系统包括获取关于数据库中的表的直方图数据的编译器直方图接口以及接收来自编译器直方图界面的输出的动态直方图压缩器，关于数据库查询的输入和表信息以产生压缩直方图数据 由优化器使用。

公开(公告)号：US20060282423A1

公开(公告)日：2006-12-14

申请号：US11150803

申请日：2005-06-10

申请人： Awny Al-Omari ,  Kashif Siddiqui ,  Sergei Perfilov

发明人： Awny Al-Omari ,  Kashif Siddiqui ,  Sergei Perfilov

IPC分类号： G06F17/30

CPC分类号： G06F17/30466 ,  Y10S707/99933 ,  Y10S707/99934 ,  Y10S707/99935 ,  Y10S707/99942

摘要： Methods and systems receive a normalized query tree and analyze the tree to collect information about join operators and their children, and tables in an associated query. This information is then made available to a rule based optimizer that is configured to produce, from the normalized query tree, an execution plan. In addition, in at least some embodiments, an extensible framework is provided for join order optimization via the use of a multi-join operator and multi-join rules as part of the general framework of a query optimizer.