Method, system, and program product for executing a scalar...

Details Method, system, and program product for executing a scalar... Method, system, and program product for executing a scalar...

2007-02-20

2007-02-20

Rimell, Sam (Department: 2164)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000

Reexamination Certificate

active

11018466

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.

REFERENCES:
patent: 6285996 (2001-09-01), Jou et al.
patent: 6411951 (2002-06-01), Galindo-Legaria et al.
patent: 6581068 (2003-06-01), Bensoussan et al.
patent: 6748392 (2004-06-01), Galindo-Legaria et al.
patent: 2002/0087516 (2002-07-01), Cras et al.
patent: 2002/0143748 (2002-10-01), Cu et al.
patent: 2004/0117731 (2004-06-01), Blyashov
patent: 2004/0153448 (2004-08-01), Cheng et al.

Affiliated with

Also associated with

Rating

Method, system, and program product for executing a scalar... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Method, system, and program product for executing a scalar..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method, system, and program product for executing a scalar... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3830527