Intelligent data caching

A method executed by one or more data processing devices, comprising:

• receiving a first data request from a client, the first data request including a database query and a query context, the query having a query condition, the query context specifying which portion of a result set will be processed, the result set comprising data records retrieved based on the query condition upon execution of the query, wherein the query context includes an offset and a limit, the offset specifying a starting position of the result set, the limit specifying a number of data records in the portion;
• storing, in a paging buffer, a plurality of data identifiers identifying each data record in the result set, where the paging buffer corresponds to the client and the query context;
• identifying, based on the query context and from the result set, one or more data records corresponding to the portion of the result set specified in the query context;
• and
• transmitting, to the client, the portion of the result set and the data identifiers, wherein only the one or more data records corresponding to the portion of the result set include data fields that are other than the data identifiers.

A non-transitory computer-readable medium storing a computer program product, the computer program product operable to cause one or more processors to perform operations comprising:

• submitting a first data request, the first data request including a database query and a query context, the query having a query condition, the query context specifying a portion of a result set that will be processed, the result set comprising data records retrieved based on the query condition upon execution of the query, wherein the query context includes an offset and a limit, the offset specifying a starting position of the result set, the limit specifying a number of data records in the portion;
• receiving a response to the first data request, the response including a plurality of data records, each data record including a data identifier, the data identifier identifying a corresponding data record in the result set, the one or more data records including the portion of the result set that correspond to the as specified in the query context, wherein only the one or more data records include data fields that are different from the data identifier;
• storing the data identifiers in a first buffer and storing the one or more data records of data in a second buffer for processing;
• in response to a selection input indicating that one or more data records that are different from the one or more data records stored in the second buffer will be processed, selecting, from the first buffer, one or more data identifiers corresponding to the one or more different data records;
• and
• submitting a second data request to update the second buffer, the second data request including a query for retrieving data fields of the one or more different data records using the one or more data identifiers data records, the data fields being different from the data identifiers.

A non-transitory computer-readable medium storing a computer program product, the computer program product operable to cause one or more processors to perform operations comprising:

• receiving a first data request from a client, the first data request including a database query and a query context, the query having a query condition, the query context specifying which portion of a result set will be processed, the result set comprising data records retrieved based on the query condition upon execution of the query, wherein the query context includes an offset and a limit, the offset specifying a starting position of the result set, the limit specifying a number of data records in the portion;
• storing, in a paging buffer, a plurality of data identifiers identifying each data record in the result set, where the paging buffer corresponds to the client and the query context;
• identifying, based on the offset and from the result set, the one or more data records corresponding to the portion of the result set specified in the query context;
• and
• transmitting, to the client, the portion of the result set and the data identifiers, wherein only the one or more data records corresponding to the portion of the result set include data fields that are other than the data identifiers.

A system comprising:

• one or more computers configured to perform operations comprising:
• submitting a first data request, the first data request including a database query and a query context, the query having a query condition, the query context specifying which portion of a result set will be processed, the result set comprising data records retrieved based on the query condition upon execution of the query, wherein the query context includes an offset and a limit, the offset specifying a starting position of the result set, the limit specifying a number of data records in the portion;
• receiving a response to the first data request, the response including a plurality of data records, each data record including a data identifier, the data identifier identifying a corresponding data record in the result set, the one or more data records including the portion of the result set as specified in the query context, wherein only the one or more data records include data fields that are different from the data identifier;
• storing the data identifiers in a first buffer and storing the one or more data records in a second buffer;
• in response to an input indicating one or more data records that are different from the one or more data records stored in the second buffer will be processed, identifying, from the first buffer, one or more data identifiers corresponding to the one or more different data records;
• and
• submitting a second data request to update the second buffer, the second data request including a query for retrieving data fields of the one or more different data records using the one or more data identifiers corresponding to the different data records, the data fields being different from the data identifiers.