US 12,001,430 B2
Service level goal processing for multi-environment data engine requests
Douglas Paul Brown, Rancho Santa Fe, CA (US); Michael Sean McIntire, Sacramento, CA (US); and Prama Agarwal, Irvine, CA (US)
Assigned to Teradata US, Inc., San Diego, CA (US)
Filed by Teradata Corporation, Dayton, OH (US)
Filed on Mar. 8, 2019, as Appl. No. 16/296,732.
Claims priority of provisional application 62/785,877, filed on Dec. 28, 2018.
Prior Publication US 2020/0210428 A1, Jul. 2, 2020
Int. Cl. G06F 16/2453 (2019.01); G06F 9/54 (2006.01)
CPC G06F 16/24542 (2019.01) [G06F 9/547 (2013.01)] 19 Claims
OG exemplary drawing
 
1. A method, comprising:
receiving, on a local data engine system, a data engine request, the local data engine system comprising a local database management system (DBMS);
identifying, on the local data engine system, a portion of the data engine request that is to be processed by an external data engine system, the external data engine system comprising an external DBMS different from the local DBMS, and a local portion of the data engine request that is to be processed by the local data engine system;
obtaining, on the local data engine system, external statistics from an external resource of the external data engine system to be used in fulfilling the portion of the data engine request that is to be processed by the external data engine system;
evaluating, on the local data engine system, the external statistics from the external resource of the external data engine system for compliance with Contract Negotiated Service Level Goal (CNSLG) classification criteria of a Service Level Goal (SLG) associated with the data engine request;
determining whether the SLG can be satisfied using the external data source based on the CNSLG classification criteria, wherein the CNSLG classification criteria provides automated actions that can be taken based on the external statistics from the external resource of the external data engine system;
when the CNSLG classification criteria determines that the SLG cannot be satisfied using the external data source:
providing a local database administrator (DBA) with automated alternative processing for the data engine request;
when the CNSLG classification criteria determines that the SLG can be satisfied using the external data source:
modifying, on the local data engine system, an optimization and an execution plan for processing the portion of the data engine request that is to be processed by an external data engine system and the local portion of the data engine request that is to be processed by the local data engine system, based on the automated actions of the CNSLG classification criteria associated with the data engine request;
obtaining, on the local data engine system, actual resource utilization metrics from the external data engine system for the portion of the data engine request that was processed by the external data engine system;
evaluating, on the local data engine system, the actual resource utilization metrics from the external data engine system for compliance with the SLG associated with the data engine request; and
performing, on the local data engine system, further adjustments of the modified optimization and the modified execution plan, or a determination that the SLG associated with the data engine request cannot be satisfied, based on the evaluation of the actual resource utilization metrics.