Data processing: database and file management or data structures – Miscellaneous
Reexamination Certificate
2001-03-28
2011-11-29
Chen, Susan (Department: 2154)
Data processing: database and file management or data structures
Miscellaneous
C707S713000, C707S759000, C703S027000
Reexamination Certificate
active
08069193
ABSTRACT:
A method and system for utilizing a column function for a relational database in a structure query language (SQL) environment is disclosed. The column function is capable of performing an operation on an indeterminate number of entries. The relational database utilizes data including a plurality of entries capable of being organized into at least one column and at least one row. The method and system include allowing a user to specify the at least one row as an argument for a generalized scalar function and simulating a column environment for the at least one row using the generalized scalar function to allow the at least one row to be provided to the column function as though the at least one row was a column. The method and system also include performing the column function on the at least one row to provide at least one output.
REFERENCES:
patent: 5513366 (1996-04-01), Agarwal et al.
patent: 5548754 (1996-08-01), Pirahesh et al.
patent: 5590324 (1996-12-01), Leung et al.
patent: 5615361 (1997-03-01), Leung et al.
patent: 5822750 (1998-10-01), Jou et al.
patent: 5918225 (1999-06-01), White et al.
patent: 6289336 (2001-09-01), Melton et al.
patent: 6317738 (2001-11-01), Lohman et al.
patent: 6366903 (2002-04-01), Agrawal et al.
patent: 6438538 (2002-08-01), Goldring
patent: 6553366 (2003-04-01), Miller et al.
patent: 6691099 (2004-02-01), Mozes
patent: 6691259 (2004-02-01), Mackey et al.
patent: 6947934 (2005-09-01), Chen et al.
patent: 7269580 (2007-09-01), Matichuk
Compute Date/Time Scalar Functions at Compile Time When All Arguments Are Constants,IBM Technical Disclosure Bulletin, vol. 34, No. 4B, Sep. 1991, pp. 174-175.
Enhancements to the SQL Date/Time Scalar Functions,IBM Technical Disclosure Bulletin, vol. 34, No. 4B, Sep. 1991, pp. 298-300.
Crone Christopher John
Cu Jason Alexander
Lurie Andrei Fedorovich
Chen Susan
International Business Machines - Corporation
Sawyer Law Group P.C.
LandOfFree
Method and system for utilizing a generic scalar function to... 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 and system for utilizing a generic scalar function to..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and system for utilizing a generic scalar function to... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-4270493