Abstract: A method of retrieving a page of records from a database system may include receiving a first query from a client device that, when processed by a database system, identifies a plurality of records that have a specified order and that are transmittable to the client device in pages that each have a fixed number of records. The method may further include receiving input identifying a specific page of records; generating a second query from the first query and the received input; 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. When processed, the second query may (i) identify a first subset of the plurality of records; (ii) identify a second subset; and (iii) determine records in the first subset that are not in the second subset.

Abstract: A method for retrieving data from a database and providing the data to a client is provided. In one embodiment, a server receives a request for data from a client. The request comprises a set of parameters, which in one embodiment comprises three parameters: an SQL SELECT statement, an indication as the number of records per page, and an indication as to the page number of the one page to return. Database server paging software on the server analyzes the set of parameters to determine and create an appropriate page of data. The server then transmits the page of data to the client. Thus, only a single request by the client is necessary and the client is not required to sift through a large key set as in the prior art.