US 11,860,901 B1
SQL execution over HTTP for relational databases using connection pooling
Aravind Ramarathinam, Sammamish, WA (US); Sachin Honnudike, Seattle, WA (US); Parijatham Santosh Kumar Vodela, Seattle, WA (US); Brian Welcker, Seattle, WA (US); Anoop Gupta, Seattle, WA (US); Sandor Loren Maurice, Newcastle, WA (US); Amit Purohit, Issaquah, WA (US); Tanmoy Dutta, Sammamish, WA (US); Yuhui Yuan, Seattle, WA (US); Jagdeep Singh Sidhu, Vancouver (CA); Lawrence Webley, Seattle, WA (US); Sundaresan Krishnamurthy, Bothell, WA (US); James H. Mlodgenski, Brick, NJ (US); Ramakrishna Dwivedula, San Jose, CA (US); Serhii Poliakov, Mercer Island, WA (US); and Alexey Kuznetsov, New Westminster (CA)
Assigned to Amazon Technologies, Inc., Seattle, WA (US)
Filed by Amazon Technologies, Inc., Seattle, WA (US)
Filed on Mar. 29, 2019, as Appl. No. 16/370,384.
Int. Cl. G06F 16/28 (2019.01); G06F 16/901 (2019.01); H04L 67/02 (2022.01); G06F 16/953 (2019.01)
CPC G06F 16/284 (2019.01) [G06F 16/9017 (2019.01); G06F 16/953 (2019.01); H04L 67/02 (2013.01)] 20 Claims
OG exemplary drawing
 
1. A computer-implemented method comprising:
receiving, at a query processing service of a provider network, an endpoint configuration request to create a web service endpoint to a target database instance within the provider network, the endpoint configuration request comprising an identifier of the target database instance;
creating the web service endpoint to the target database instance;
configuring the web service endpoint to the target database instance;
receiving, at the web service endpoint to the target database instance, a query request originated by a client and comprising a Hyper Text Transfer Protocol (HTTP) message carrying a payload comprising a statement to be executed by the target database instance within the provider network, wherein the target database instance is a relational database;
identifying, by the query processing service, an existing connection to the target database instance by determining an association of the web service endpoint to a first connection pool server in a set of connection pool servers that connects to a plurality of target database instances, the plurality of target database instances including the target database instance, wherein the set of connection pool servers are initialized prior to receiving the query request;
transmitting the statement for execution at the target database instance via the existing connection;
obtaining a query result based on the execution of the statement;
transforming the query result into another structured format; and
transmitting a query response to the client, wherein the query response comprises the transformed query result.