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:
Nov. 14, 2006
Filed:
Dec. 19, 2002
Paul L. Sinclair, Manhattan Beach, CA (US);
Steven B. Cohen, Redondo Beach, CA (US);
Paul L. Sinclair, Manhattan Beach, CA (US);
Steven B. Cohen, Redondo Beach, CA (US);
NCR Corp., Dayton, OH (US);
Abstract
A method, computer program, and computer system are disclosed for indexing database table rows. A first set of one or more columns of the database table is chosen. A second set of one or more columns of the database table is chosen. An index record is generated for each unique result of applying a second function to a value corresponding to the second set for the database table rows. In each index record, only a single copy of each unique result of applying a first function to a value corresponding to the first set for the database table rows having the result of applying the second function to a value corresponding to the second set for that index record is included. The first set is not identical to the second set. At least two rows of the database table rows have the same result of applying the second function to a value corresponding to the second set and have the same result of applying the first function to the value corresponding to the first set.