Teradata Us, Inc.

Pratik Patodi

Bhashyam Ramesh

Jaiprakash G Chimanchode

Sai Pavan Kumar Pakala

Dhrubajyoti Roy

Stephen Andrew Brobst

Stephen Molini

Todd Walter

Control versioning of records in a temporal table is provided to reduce data redundancy. New Data Definition Language (DDL) syntax is provided to make individual columns within a table sensitive or insensitive to whether new row versions are generated when Database Manipulation Language (DML) statements operate on the table. The database parser and back-end data processors are configured to create the table with the user-defined versioning attributes and to manage versioning of the rows without requiring additional programming.

Control versioning of temporal tables to reduce data redundancy

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.

Join elimination enhancement for real world temporal applications

Growing community of inventors

Raipur, India

Pratik Patodi