Patent ID: 7574421

Claim:
A method of retrieving a page of records from a database system, the method comprising: receiving a first query from a client device that, when processed by the database system, identifies a plurality of records in a database, the plurality of records having a specified order and being transmittable to the client device in pages, each page comprising a fixed number of records from the plurality of records; receiving input identifying a specific page of records to retrieve and transmit to the client device; generating a second query from the first query and the received input, wherein the second query, when processed by the database system, (i) identifies a first subset of the plurality of records, the first subset consisting of records having positions in the specified order from a first position to a position corresponding to a last record of the identified specific page of records; (ii) identifies a second subset of the plurality of records including records having positions corresponding to a record that immediately precedes the identified specific page of records and in the specified order from the first position to a position corresponding to the fixed number multiplied by a number corresponding to the identified specific page of records, minus the fixed number; and (iii) determines records in the first subset that are not in the second subset; submitting the second query to the database system for processing to retrieve the determined records; and transmitting the retrieved, determined records to the client device.