公开(公告)号：US11500824B1

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

申请号：US15478017

申请日：2017-04-03

Applicant: Amazon Technologies, Inc.

Inventor： Dennis Tighe ,  Matthew Walters ,  Brian Welcker

IPC: G06F16/21 ,  G06F16/958

Abstract: A proxy server acts as an intermediary between a database client and a database server. The proxy server is configured with a set of user-defined rules. When a request is received from the database client, the proxy server may apply rules that modify, route, reject, log, or pass the request to the database server. Individual rules may be based on attributes of the client computer system, database server, or the request itself. In one embodiment, a rule may be used to translate a request from a format provided by the client into a format preferred by a destination database. In one embodiment, a rule may route a particular request to one of a number of databases based on the nature of the request.

公开(公告)号：US11182496B1

公开(公告)日：2021-11-23

申请号：US15478010

申请日：2017-04-03

Applicant: Amazon Technologies, Inc.

Inventor： Matthew Walters ,  Brian Welcker ,  Dennis Tighe

IPC: G06F16/24 ,  G06F21/62 ,  G06F21/60 ,  H04L29/06 ,  H04L29/08 ,  G06F16/2455 ,  G06F16/2457

Abstract: A proxy server acts as an intermediary between a database client and a database server. The proxy server establishes and maintains a set of logical connections to the database server. The proxy server receives a request from the database client, and generates a set of database commands that, when performed by the database server, are capable of fulfilling the request. The proxy server selects a particular logical connection from the set of logical connections based at least in part on a characteristic of the request, and submits the set of database commands to the database server via the selected particular logical connection. In various examples, the particular logical connection is selected so that various performance, efficiency, and security objectives are achieved.

公开(公告)号：US11106540B1

公开(公告)日：2021-08-31

申请号：US15477989

申请日：2017-04-03

Applicant: Amazon Technologies, Inc.

Inventor： Brian Welcker ,  Dennis Tighe ,  Matthew Walters

IPC: G06F11/14 ,  G06F16/11 ,  G06F16/21

Abstract: A proxy server receives requests from a client computer system and generates corresponding sets of database commands that are capable of fulfilling the requests when submitted to a database server. The proxy server may repeat processing associated with a particular request more than once under different operational conditions in order to improve future performance. In some examples, the proxy server submits a particular database command sequence to the database server using various operational parameters, and measures the performance of each submission to identify a particular set of operational parameters to be applied to the database server with future submissions. In another example, the proxy server determines a number of alternative command sequences that fulfill a particular request, and measures the performance of each of the alternative command sequences to determine how command sequences are generated for future requests.

公开(公告)号：US11860901B1

公开(公告)日：2024-01-02

申请号：US16370384

申请日：2019-03-29

Applicant: Amazon Technologies, Inc.

Inventor： Aravind Ramarathinam ,  Sachin Honnudike ,  Parijatham Santosh Kumar Vodela ,  Brian Welcker ,  Anoop Gupta ,  Sandor Loren Maurice ,  Amit Purohit ,  Tanmoy Dutta ,  Yuhui Yuan ,  Jagdeep Singh Sidhu ,  Lawrence Webley ,  Sundaresan Krishnamurthy ,  James H. Mlodgenski ,  Ramakrishna Dwivedula ,  Serhii Poliakov ,  Alexey Kuznetsov

IPC: G06F16/28 ,  G06F16/901 ,  H04L67/02 ,  G06F16/953

CPC classification number: G06F16/284 ,  G06F16/9017 ,  G06F16/953 ,  H04L67/02

Abstract: Techniques for query execution against relational databases using connection pooling are described. According to some embodiments, a query processing service is disclosed that enables users to execute queries against target relational databases implemented by a relational database service. The service receives query requests originated by a client application at a web service endpoint and identifies a connection to a particular target database. In some examples, the query request is a Hyper Text Transfer Protocol (HTTP) message comprising a query to be executed by a target database instance within the provider network. The service transmits the query for execution at the target database via the connection and obtains a query result based on the execution of the query. The service transforms the query result into a format suitable for the client and transmits a query response to the client.