The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Mar. 26, 2013
Filed:
Nov. 29, 2010
Bhashyam Ramesh, Secunderabad, IN;
Stephen A. Brobst, Henderson, NV (US);
Bhashyam Ramesh, Secunderabad, IN;
Stephen A. Brobst, Henderson, NV (US);
Teradata US, Inc., Dayton, OH (US);
Abstract
A query is received. It is determined that the query includes an inner join between a parent table and a child table. It is determined that the following relationships exist 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, where 'attribute' is defined to mean one or more columns, and a temporal relationship constraint (“TRC”) between a period attribute in the parent table and a TRC-attribute in the child table, the TRC-attribute being a date or time attribute. It is determined that the query does not access any attribute in the parent table other than the pk. It is determined that the query specifies an equality predicate of the form pk=fk. It is determined that the query selects a snapshot from the parent using a predicate of the form parent.[period attribute] contains a point in time (t). It is determined that the query selects from the child those rows whose TRC-attribute is equal to or prior to t. The inner join is eliminated when planning execution of the query. The query is executed to produce a result. The result is saved.