Patent · US Active

Optimizing the execution order between analytical functions and joins in SQL queries

US11409745B2 · kind B2 · utility

0Cited by

1References

18Claims

0Family size

Assignee

Teradata US, Inc. · US

Inventors

Christina Pavlopoulou · Emeryville, US
Mahbub Hasan · Chandler, US
B. Anantha Subramanian · Savanuru, IN
Mohammed Al-Kateb · Rancho Palos Verdes, US
Awny K. Al-Omari · Cedar Park, US
Kashif A. Siddiqui · Round Rock, US
Robert M. Wehrmeister · Austin, US
Mohamed Yassin Eltabakh · Hammond Heights, US

Key dates

Filing date	Dec 5, 2019
Grant date	Aug 9, 2022
Priority date	—
Expiry date	Sep 24, 2040

Classification

Technology area (CPC G)Physics
CPC primaryG06F16/24547
WIPO fieldComputer technology
WIPO sectorElectrical engineering

Abstract

Execution of a query invoking an analytical function (AF) is optimized. The query includes a join operation between an AF table and an AuxiliaryTable. A determination is made that the AF includes a plurality of AF properties. Query-level properties about the query are inferred. A determination is made to change an order of the join operation from the plurality of AF properties and query-level properties.

Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.