公开(公告)号：US10394611B2

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

申请号：US13685649

申请日：2012-11-26

Applicant: Amazon Technologies, Inc.

Inventor： Venkata Harish Mallipeddi ,  Aleksandras Surna

IPC: G06F9/50 ,  H04L29/08

Abstract: A currently operating computing cluster that has multiple nodes storing cluster data may be scaled. A cluster scaling request may be received for the current cluster indicating a change in a number or type of nodes in the current cluster. In response to receiving the cluster scaling request, a new cluster may be created as indicated in the cluster scaling request, a copy of the cluster data from the current cluster to the nodes in the new cluster may be initiated, a network endpoint for the current cluster may be moved to the new cluster, and the current cluster may be disabled. The current cluster may, in some embodiments, respond to read access requests during the copy of the cluster data.

公开(公告)号：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: 查询优化器可以接收查询（例如，从生成查询的源）。 指定查询提示字符串和提示的输入可以被接收到提示规范界面。 提示可以从查询外部应用于查询，以优化查询执行计划。 应用提示可能至少部分地基于查询提示字符串。 例如，可以确定哪个查询块与查询提示字符串相关联。 在这样的确定时，提示可以应用于确定的查询块。

公开(公告)号：US09449038B2

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

申请号：US13792643

申请日：2013-03-11

Applicant: Amazon Technologies, Inc.

Inventor： Anurag Windlass Gupta ,  Jakub Kulesza ,  Deepak Agarwal ,  Aleksandras Surna ,  Tushar Jain ,  Zelaine Fong ,  Stefano Stefani

IPC: G06F17/30

CPC classification number: G06F17/30575 ,  G06F11/1446 ,  G06F11/1471 ,  G06F17/30008 ,  G06F17/30371 ,  G06F17/30424 ,  G06F2201/82

Abstract: A distributed data warehouse system may maintain data blocks on behalf of clients in multiple clusters in a data store. Each cluster may include a single leader node and multiple compute nodes, each including multiple disks storing data. The warehouse system may store primary and secondary copies of each data block on different disks or nodes in a cluster. Each node may include a data structure that maintains metadata about each data block stored on the node, including its unique identifier. The warehouse system may back up data blocks in a remote key-value backup storage system with high durability. A streaming restore operation may be used to retrieve data blocks from backup storage using their unique identifiers as keys. The warehouse system may service incoming queries (and may satisfy some queries by retrieving data from backup storage on an as-needed basis) prior to completion of the restore operation.

Abstract translation: 分布式数据仓库系统可以代表数据存储中的多个集群中的客户端来维护数据块。 每个集群可以包括单个前导节点和多个计算节点，每个节点包括存储数据的多个磁盘。 仓库系统可以将每个数据块的主副本存储在集群中的不同磁盘或节点上。 每个节点可以包括维护关于存储在节点上的每个数据块的元数据的数据结构，包括其唯一标识符。 仓库系统可以备份具有高耐久性的远程键值备份存储系统中的数据块。 流式还原操作可用于使用其唯一标识符作为密钥从备份存储中检索数据块。 在完成还原操作之前，仓库系统可以服务传入的查询（并且可以根据需要从备份存储中检索数据来满足一些查询）。

公开(公告)号：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: 查询优化器可以接收查询（例如，从生成查询的源）。 指定查询提示字符串和提示的输入可以被接收到提示规范界面。 提示可以从查询外部应用于查询，以优化查询执行计划。 应用提示可能至少部分地基于查询提示字符串。 例如，可以确定哪个查询块与查询提示字符串相关联。 在这样的确定时，提示可以应用于确定的查询块。