Invention Grant
- Patent Title: Cost based function optimization for coupled systems
-
Application No.: US15848491Application Date: 2017-12-20
-
Publication No.: US11645280B2Publication Date: 2023-05-09
- Inventor: John Mark Morris , Bhashyam Ramesh
- Applicant: Teradata US, Inc.
- Applicant Address: US OH Dayton
- Assignee: Teradata US, Inc.
- Current Assignee: Teradata US, Inc.
- Current Assignee Address: US CA San Diego
- Agent Howard Speight
- Main IPC: G06F16/27
- IPC: G06F16/27 ; G06F16/2453 ; G06F16/2455

Abstract:
A function reference for a function is identified in a query. A plurality of processing environments that can provide the function is identified. Function costs for the function to process in the processing environments are obtained. Input data transfer costs are acquired for providing input data identified in the query to each of the functions. A specific one of the functions from a specific processing environment is selected based on the function costs and the input data transfer costs. A query execution plan for executing the query with the specific function is generated. The query execution plan is provided to a database engine for execution.
Public/Granted literature
- US20190188298A1 COST BASED FUNCTION OPTIMIZATION FOR COUPLED SYSTEMS Public/Granted day:2019-06-20
Information query