Teradata Us, Inc.

Prama Agarwal

Douglas Paul Brown

John Douglas Frazier

Michael Sean McIntire

A data engine request is received on a local data system. The data engine request includes a portion of the request that is to be processed on an external data engine system. The portion is forwarded to the external data engine system and statistics for accessing external objects of the external data engine system is acquired. The statistics are evaluated for compliance with a Service Level Goal (SLG) associated with the request. Rules-based processing permits optimization and planning of the request on the local data engine system to be modified in view of the statistics received from the external data engine system to comply with the SLG. In an embodiment, actual resource utilization metrics noted during execution of the portion on the external data engine system is provided as feedback to the local data engine system for re-planning and re-optimizing the request with a modified execution plan.

Service level goal processing for multi-environment data engine requests

An apparatus is provided for facilitating a local database system to execute a query function at a foreign database system. The apparatus comprises a processor of the local database system and a storage device communicatively coupled with the processor. The processor is programmed to (i) receive a query request, (ii) retrieve query data associated with the query request, (iii) determine if the query request can be processed at the local database system, (iv) if the query request is unable to be processed at the local database system, connect to the foreign database system, (v) after the local database system is connected to the foreign database system, export the retrieved query data from the local database system to the foreign database system to allow the foreign database system to process the retrieved query data, (vi) after the retrieved query data has been exported from the local database system to the foreign database system, send the query request from the local database system to the foreign database system to allow the foreign database system to process the query request using the retrieved query data, and (vii) after the foreign database system has processed the query request using the query data, import a result dataset from the foreign database system.

Growing community of inventors

Irvine, CA, United States of America

Prama Agarwal