Patent · US Active

Join elimination enhancement for real world temporal applications

US11567941B1 · kind B1 · utility

2Cited by

2References

20Claims

0Family size

Assignee

Teradata US, Inc. · US

Inventors

Jaiprakash Ganpatrao Chimanchode · Hyderabad, IN
Bhashyam Ramesh · San Diego, US
Stephen Brobst · Henderson, US
Pratik Patodi · Atal Nagar, IN
Dhrubajyoti Roy · Sherghati, IN
Sai Pavan Kumar Pakala · Hyderabad, IN

Key dates

Filing date	Oct 23, 2020
Grant date	Jan 31, 2023
Priority date	—
Expiry date	Apr 16, 2041

Classification

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

Abstract

A database system receives a query and determines that the query includes an inner join between a parent table and a child table. The database system determines that the following relationships exists between the parent table and the child table: referential integrity (“RI”) between a primary key attribute (pk) in the parent table and a foreign key attribute (fk) in the child table and a temporal relationship constraint (“TRC”) between a period attribute in the parent table and a TRC-attribute in the child table. The database system determines that the query satisfies non-temporal join elimination conditions and temporal join elimination conditions and that the query contains no other qualification conditions on the parent table's period attribute and eliminates the inner join when planning execution of the query.

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