Data processing: database and file management or data structures – Database design – Data structure types
Patent
1997-05-08
1999-07-20
Black, Thomas G.
Data processing: database and file management or data structures
Database design
Data structure types
707 4, 707 5, G06F 1730
Patent
active
059268077
ABSTRACT:
A method and system for effectively representing a result set in a limited amount of memory is provided. The result set is made up of a number of ordered rows. At least some of the rows contain row data, while each of the rows contains a bookmark that may be used to retrieve row data for the row. When it is determined that the size of the result set should be reduced, a subset of the rows of the result set is identified. The identified subset of rows is contiguous within the order of the results set and includes rows that contain row data. For each row of the identified subset, the row data is removed from the result set while retaining in the result set the bookmarks of the rows in the identified subset. As the result of the removal of row data, the size of the result set is reduced. In a further embodiment of the invention, when a request is received to return the row data for a row among the identified subset of rows, the retained bookmarks for the identified subset of rows are used to retrieve row data for the rows back into the result set. The requested row data is then returned from the result set in response to the request.
REFERENCES:
patent: 4754326 (1988-06-01), Kram et al.
patent: 5157783 (1992-10-01), Anderson et al.
patent: 5199104 (1993-03-01), Hirayama
patent: 5524201 (1996-06-01), Shwarts et al.
patent: 5590319 (1996-12-01), Cohen et al.
patent: 5596686 (1997-01-01), Duluk, Jr.
patent: 5611076 (1997-03-01), Durflinger et al.
patent: 5615337 (1997-03-01), Zimowski et al.
patent: 5632015 (1997-05-01), Zimowski et al.
patent: 5668987 (1997-09-01), Schneider
patent: 5689698 (1997-11-01), Jones et al.
patent: 5701461 (1997-12-01), Dalal et al.
patent: 5710915 (1998-01-01), McElhiney
patent: 5713014 (1998-01-01), Durflinger et al.
patent: 5713020 (1998-01-01), Reiter et al.
patent: 5715450 (1998-02-01), Ambrose et al.
patent: 5787295 (1998-07-01), Nakao
Milewski Bartosz
Peltonen Kyle Gordon
Shoroff Srikanth
Whitney Alan
Black Thomas G.
Coby Frantz
Microsoft Corporation
LandOfFree
Method and system for effectively representing query results in 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 effectively representing query results in , we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and system for effectively representing query results in will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-1331674