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 |
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.
|