US 12,353,922 B2
Automatic query routing
John Jeffrey Mayrack, Minneapolis, MN (US); Sriram K. Somayajula, Cerritos, CA (US); Thomas Julien, San Marcos, CA (US); John Chapra, Encinitas, CA (US); and John Lawrence Perkins, Jr., Escondido, CA (US)
Assigned to Teradata US, Inc., San Diego, CA (US)
Filed by Teradata US, Inc., Englewood, OH (US)
Filed on Jul. 31, 2019, as Appl. No. 16/527,190.
Prior Publication US 2021/0034433 A1, Feb. 4, 2021
Int. Cl. G06F 9/50 (2006.01); G06F 16/2455 (2019.01); G06F 16/2458 (2019.01)
CPC G06F 9/5083 (2013.01) [G06F 9/505 (2013.01); G06F 16/2455 (2019.01); G06F 16/2471 (2019.01)] 17 Claims
OG exemplary drawing
 
1. A data engine management system comprising:
at least one hardware processor; and
a non-transitory computer-readable storage medium having executable instructions representing a workload request manager, wherein the instructions are executable on the at least one hardware processor to cause the at least one hardware processor to:
receive a data engine query on a local data engine system;
identify a portion of the data engine query that is to be processed externally from the local data engine system;
obtain a list of external servers from a Data Definition Language (DDL) statement associated with the portion, wherein the list identifies each external server available to execute the portion of the data engine query;
attempt connections from the local data engine system to one or more of the external servers;
select at least one of the external servers to be connected to the local data engine system in response to the attempting, wherein the selecting is based on availability of the at least one of the external servers, at least one condition imposed on the external servers, and at least a portion of data from the one or more of the external servers having a data freshness level above a predetermined data freshness threshold;
connect the at least one selected external server; and
process the portion of the data engine query using the at least one connected selected external server.