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:
Feb. 20, 2007
Filed:
Dec. 21, 2004
Mark Steven Ramsey, Colleyville, TX (US);
Milind Chitgupakar, Omaha, NE (US);
Calisto Paul Zuzarte, Pickering, CA;
Mark Steven Ramsey, Colleyville, TX (US);
Milind Chitgupakar, Omaha, NE (US);
Calisto Paul Zuzarte, Pickering, CA;
International Business Machines, Corporation, Armonk, NY (US);
Abstract
Application of a scalar function across a varying number of records within an RDBMS using the RDBMS's SQL capabilities. This is accomplished by determining a last row in a group of rows, sorting the rows and passing the sorted rows to a scalar function, where the scalar function accepts each row and stores the accepted rows in a temporary file space. When the last row is encountered, the aggregate value is calculated using all of the rows in the group, and then a filter is applied on the rows so that only a row with the aggregate value is returned.