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:
Aug. 21, 2007
Filed:
Oct. 08, 2003
Bibhu Ranjan Priyadarshi, El Segundo, CA (US);
Grace Kwan-on AU, Rancho Palos Verdes, CA (US);
Kuorong Chiang, Cerritos, CA (US);
Bibhu Ranjan Priyadarshi, El Segundo, CA (US);
Grace Kwan-On Au, Rancho Palos Verdes, CA (US);
Kuorong Chiang, Cerritos, CA (US);
NCR Corp., Dayton, OH (US);
Abstract
A method, database system, and computer program are disclosed for optimized costing. The method includes identifying a join that identifies a first table and a second table. The method further includes determining an optimized cost of reading the first table. If the number of unique first table values is greater than the number of unique second table values, the number of instances where a unique first table value matches a unique second table value is returned. Otherwise, the number of unique first table values is returned. The method further includes determining an optimized cost of reading the second table. The optimized cost of reading the second table includes the number of unique second table values. The method also includes summing the optimized cost of reading the first table and the optimized cost of reading the second table.