Amazon Technologies, Inc.

Jason Douglas Denton

Rahul Sharma Pathak

Abhishek Rajnikant Sinha

Xing Wu

Jian Fang

Turkay Mert Hocanin

Bhargava Ram Kalathuru

Luca Natali

Pratik Bhagwat Gawande

Yuanyuan Yue

Sumeetkumar Veniklal Maru

Armen Tangamyan

Yufeng Jiang

Andrew Edward Caldwell

Marc Howard Beitchman

Mehul A Shah

Anthony A Virtuoso

Xin Zhao

Dallas Lamont Willett

Mostafa Ead

Bharath Subramanian Pichai

Nitin Kumar Saxena

Lakshman Potluri

Prudhvi Janga

Akila Tennakoon

Seth Thomas Denney

Oleg Leizerov

Timothy David Ebringer

Techniques for building, validating, and utilizing custom database software in a shared management environment are described. A database customization service allows users to provide database installation files as part of a configuration to generate a custom database engine version. The creation of custom database engine versions may be governed by policy, and the database customization service may provide recommendations for creating custom database engine versions according to various criteria. The custom database engine version can be built, and its functionality and correctness verified. Users may launch database instances using these custom database engine versions that can be managed under a shared management scheme where both users and the database customization service can perform host-level management.

Policies and controls for building and validating database software in a shared management environment

Interruptible computing resources for executing queries may be selected. When queries are received, the probability that query can complete execution at interruptible computing resources may be determined. Computing resources to process the query may be selected based on the probability. For queries that are performed on computing resources that are interrupted, interruption handling techniques may retry the query on other computing resources or complete the query on other computing resources, in some embodiments.

Selecting interruptible resources for query execution

Queries may be received and executed by a managed query service. A query directed to data sets that are separately stored in a remote data store may be received. Computing resources to execute the query may be provisioned from a pool of computing resources that are configured to execute queries. The query may be routed to the provisioned computing resources to execute the query. Results may be obtained from the computing resource and provided to a submitter of the query.

Managed query service

Query execution status may be tracked to selectively route queries to resources for execution. The completion of queries executing at computing resources obtained from a pool of computing resources configured to execute queries may be detected. Instead of returning the computing resources to the pool, the computing resources may be identified as available in resource management data. When another query is received, the resource management data may be evaluated to select an available computing resource. The query may then be routed to the selected computing resource for execution.

Tracking query execution status for selectively routing queries

Techniques are described for an interactive query service that enables users to query data stored at a federated collection of data sources. An interactive query service provides interfaces that enable users to configure the interactive query service to query any number of heterogeneous data sources pertinent to a user. In general, the configuration of a data source can include identification of: a data source type, access configurations related to accessing the data source, and in some cases metadata describing a structure of the data stored by the data source (for example, a data catalog describing schemas, tables, columns, partitions, datatypes, or other metadata associated with the stored data). Once configured, an interactive query service can receive and execute queries that involve data stored at any combination of a user's data sources, where the queries may be expressed using a standard query language such as the Structured Query Language (SQL).

Enabling federated query access to Heterogeneous data sources

The configuration of computing resources for executing queries may be selected. A comparison of the configuration of computing resources that executed previous queries may be made to select the configuration of computing resources for a received query. A historical query execution model maybe applied, in some embodiments, to determine a resource configuration for computing resources to execute a query. The computing resources may be selected from available computing resources according to the determined resource configuration.

Selecting resource configurations for query execution

Available capacity of resources hosted in different networks may be evaluated to select resources for the performance of a query. A query may be received via an interface for one network. The available capacity of the one network and other networks may be evaluated to select resources hosted in another network to perform the query instead of the resources in the one network. The query may then be routed to the resources in the other network and result of the query performed at the resources in the other network provided.

Selecting resources hosted in different networks to perform queries according to available capacity

Growing community of inventors

Seattle, WA, United States of America

Jason Douglas Denton