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. 04, 2014
Filed:
Nov. 14, 2011
Thomas A. Beavin, Milpitas, CA (US);
Mengchu Cai, San Jose, CA (US);
Ruiping LI, Cupertino, CA (US);
James A. Ruddy, San Jose, CA (US);
Thomas A. Beavin, Milpitas, CA (US);
Mengchu Cai, San Jose, CA (US);
Ruiping Li, Cupertino, CA (US);
James A. Ruddy, San Jose, CA (US);
International Business Machines Corporation, Armonk, NY (US);
Abstract
Various aspects of this disclosure are directed to receiving, by a computing device, a first table join query that may include a first group of table identifiers that identify the two or more tables. The computing device may determine whether the first table join query includes an outer join command. When the first table join query includes the outer join command, the computing device may compare the first group of table identifiers and a second group of table identifiers of one or more pre-joined tables to determine whether each of the first table identifiers matches at least one of the second group of table identifiers. The computing device may further determine whether a predicate associated with each table identifier matches a predicate associated with a matching second table identifier. When each of the predicates match, the computing device may rewrite the first table join query.