Framework for retrieval and display of large result sets
View Patent ↗A computer-implemented technique for managing large results sets returned from a data request for a database. The technique comprises retrieving the primary keys responsive to the data request and sub-setting of the primary keys returned into at least one subset list. The data is then retrieved on a second pass of the database retrieving data from the database using the primary keys of the at least one subset list. Data retrieval is selectively repeated as required until all requested data has been retrieved. The technique is implemented within a framework. The framework comprises an interface defining a desired protocol of behaviour using common methods and an abstraction of the interface implementing the common methods as defined by the interface. Call back methods provide access to the framework by the primary keys.
1. A computer-implemented method for managing large results sets returned from a data request for a database, the computer-implemented method comprising the steps of:
retrieving primary keys responsive to the data request, the primary keys being retrieved on a first pass of the database;
sub-setting the primary keys retrieved into at least one subset list, the primary keys being subset prior to a second pass of the database, the primary keys being cached to include the at least one subset list on a first pass of the database;
retrieving data from the database using the primary keys of the at least one subset list, the retrieving data from the database using the subset list of primary keys on a second pass of the database;
selectively repeating said step of retrieving data as required until all requested data has been retrieved; and
implementing the computer-implemented method within a framework comprising
an interface defining a desired protocol of behaviour using common methods; and
an abstraction of the interface implementing the common methods as defined by the interface and a plurality of call back methods providing access of the primary keys to the framework.