Invention Grant
- Patent Title: Implementing contract-based polymorphic and parallelizable SQL user-defined scalar and aggregate functions
-
Application No.: US15058590Application Date: 2016-03-02
-
Publication No.: US11243958B2Publication Date: 2022-02-08
- Inventor: Xin Tang , James Shau , Robert Wehrmeister , Daniel T. Yu
- Applicant: Teradata US, Inc.
- Applicant Address: US CA San Diego
- Assignee: Teradata US, Inc.
- Current Assignee: Teradata US, Inc.
- Current Assignee Address: US CA San Diego
- Agent James Stover
- Main IPC: G06F17/00
- IPC: G06F17/00 ; G06F16/2457 ; G06F16/2458

Abstract:
Disclosed are systems and methods for implementing contract-based polymorphic and parallelizable user-defined scalar and aggregate functions. The systems and methods can include receiving a query including a plurality of user-defined functions, parsing the query into a plurality of nodes (e.g., basic operation unit or atomic operator), generating an execution plan that minimizes data transfer between the plurality of nodes, and executing the plan in a distributed environment. Each of the plurality of user-defined functions can correspond to one of a plurality of nodes.
Public/Granted literature
Information query