Join elimination enhancement for real world temporal applications

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 prim...

Full description

Saved in:
Bibliographic Details
Main Authors Patodi, Pratik, Roy, Dhrubajyoti, Chimanchode, Jaiprakash G, Pakala, Sai Pavan Kumar, Ramesh, Bhashyam, Brobst, Stephen A
Format Patent
LanguageEnglish
Published 31.01.2023
Subjects
CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
Online AccessGet full text

Cover

More Information
Summary: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.
Bibliography:Application Number: US202017078997