公开(公告)号：US20160253385A1

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

申请号：US15150363

申请日：2016-05-09

Applicant: Amazon Technologies, Inc.

Inventor： Neil Thombre ,  Anurag Windlass Gupta ,  Stefano Stefani ,  Aleksandras Surna

IPC: G06F17/30

CPC classification number: G06F17/30474 ,  G06F17/30442 ,  G06F17/30448 ,  G06F17/30463 ,  G06F17/30589

Abstract: A query optimizer may receive a query (e.g., from a source that generated the query). Input that specifies both a query hint string and a hint may be received to a hint specification interface. The hint may be applied to the query, from outside the query, to optimize a query execution plan. Applying the hint may be based, at least in part, on a query hint string. For example, which query block is associated with the query hint string may be determined. Upon such a determination, the hint may be applied to the determined query block.

Abstract translation: 查询优化器可以接收查询（例如，从生成查询的源）。 指定查询提示字符串和提示的输入可以被接收到提示规范界面。 提示可以从查询外部应用于查询，以优化查询执行计划。 应用提示可能至少部分地基于查询提示字符串。 例如，可以确定哪个查询块与查询提示字符串相关联。 在这样的确定时，提示可以应用于确定的查询块。

公开(公告)号：US10592506B1

公开(公告)日：2020-03-17

申请号：US13766683

申请日：2013-02-13

Applicant: Amazon Technologies, Inc.

Inventor： Neil Thombre ,  Zelaine Fong ,  Stefano Stefani ,  Hakan Jakobsson ,  Anurag Windlass Gupta

IPC: G06F16/2453

Abstract: A query optimizer may receive a query block that includes a hint. The hint may include a unique object identifier to specify an object to which the hint applies. In some instances, the object may correspond to a nested query block. A query optimization plan may be determined based, at least in part, on the hint. The query execution plan may then be executed to query a data store.

公开(公告)号：US10311055B2

公开(公告)日：2019-06-04

申请号：US15150363

申请日：2016-05-09

Applicant: Amazon Technologies, Inc.

Inventor： Neil Thombre ,  Anurag Windlass Gupta ,  Stefano Stefani ,  Aleksandras Surna

IPC: G06F16/24 ,  G06F16/2453 ,  G06F17/30 ,  G06F16/28

Abstract: A query optimizer may receive a query (e.g., from a source that generated the query). Input that specifies both a query hint string and a hint may be received to a hint specification interface. The hint may be applied to the query, from outside the query, to optimize a query execution plan. Applying the hint may be based, at least in part, on a query hint string. For example, which query block is associated with the query hint string may be determined. Upon such a determination, the hint may be applied to the determined query block.

公开(公告)号：US09336272B1

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

申请号：US13766684

申请日：2013-02-13

Applicant: Amazon Technologies, Inc.

Inventor： Neil Thombre ,  Anurag Windlass Gupta ,  Stefano Stefani ,  Aleksandras Surna

IPC: G06F17/30

CPC classification number: G06F17/30474 ,  G06F17/30442 ,  G06F17/30448 ,  G06F17/30463 ,  G06F17/30589

Abstract: A query optimizer may receive a query (e.g., from a source that generated the query). Input that specifies both a query hint string and a hint may be received to a hint specification interface. The hint may be applied to the query, from outside the query, to optimize a query execution plan. Applying the hint may be based, at least in part, on a query hint string. For example, which query block is associated with the query hint string may be determined. Upon such a determination, the hint may be applied to the determined query block.

Abstract translation: 查询优化器可以接收查询（例如，从生成查询的源）。 指定查询提示字符串和提示的输入可以被接收到提示规范界面。 提示可以从查询外部应用于查询，以优化查询执行计划。 应用提示可能至少部分地基于查询提示字符串。 例如，可以确定哪个查询块与查询提示字符串相关联。 在这样的确定时，提示可以应用于确定的查询块。