US 11,741,120 B2
Remote data gateway with support for peer-to-peer routing for use with a data analytics warehouse
Manish Barman, Bangalore (IN); Sambit Kumar Nanda, San Ramon, CA (US); and Giri Jagumantri, Bangalore (IN)
Assigned to ORACLE INTERNATIONAL CORPORATION, Redwood Shores, CA (US)
Filed by ORACLE INTERNATIONAL CORPORATION, Redwood Shores, CA (US)
Filed on Jul. 15, 2021, as Appl. No. 17/376,879.
Claims priority of provisional application 63/083,318, filed on Sep. 25, 2020.
Prior Publication US 2022/0100773 A1, Mar. 31, 2022
Int. Cl. G06F 16/25 (2019.01); G06F 16/245 (2019.01); H04L 67/1074 (2022.01); G06F 9/50 (2006.01); G06F 16/2455 (2019.01); G06F 16/28 (2019.01); G06F 16/248 (2019.01); H04L 67/60 (2022.01)
CPC G06F 16/254 (2019.01) [G06F 9/5083 (2013.01); G06F 16/245 (2019.01); G06F 16/248 (2019.01); G06F 16/2455 (2019.01); G06F 16/283 (2019.01); H04L 67/1074 (2013.01); H04L 67/60 (2022.05)] 18 Claims
OG exemplary drawing
 
1. A system for providing a remote data gateway for use with a data analytics environment, including support for peer-to-peer routing, comprising:
a computer including one or more processors, that provides access by an analytics environment to a data warehouse for storage of data, wherein the analytics environment comprises a plurality of remote data gateway servers operable to receive, from remote data gateway clients, queries directed to an on-premise environment and database at a remote network; and
wherein the analytics environment comprising the remote data gateway servers communicates with a remote data gateway agent installed in the on-premise environment that channels database queries between the analytics environment and the on-premise database;
wherein the analytics environment comprising the remote data gateway servers issues and queues the queries, for processing by the remote data gateway agent at the on-premise environment;
wherein the remote data gateway agent at the on-premise environment connects periodically to the analytics environment to check for queries to process, executes received queries against the on-premise database, and returns query results to the analytics environment;
wherein the system uses a peer-to-peer routing, wherein a remote data gateway client has a request to be processed, but a first remote data gateway server, of the plurality remote data gateway servers, has not yet called into that client, then the client hands off the request to a peer remote data gateway server, of the plurality remote data gateway servers, which retrieves and processes that request, including that:
the peer remote data gateway server delegates the job to the remote data gateway agent; and
upon receipt, at the peer remote data gateway server, of a result from the remote data gateway agent, the peer remote data gateway server determines the first remote data gateway server to be an originating server, and provides the result to the first remote data gateway server.