OBTAINING INCREMENTAL UPDATES FROM A DATABASE USING A PARTIAL QUERY

摘要

An example method of processing a query includes receiving a partial query including an identifier that identifies a full query corresponding to the partial query. The partial query is sent from a client and includes a command to select data from a database table stored in a database. The method also includes determining whether the table has been updated since a previous result set was sent to the client. The method further includes generating a partial result set including an indication of the updates to the table since the previous result set was sent to the client. The method also includes sending the partial result set to the client. The partial result set is an incomplete result set of the partial query.

主权项

1. A method of processing a query, comprising:
receiving, at a database server, a partial query including an identifier that identifies a full query corresponding to the partial query, the partial query being sent from a client and including a command to select data from a database table stored in a database; determining whether the table has been updated since a previous result set was sent to the client; generating a partial result set including an indication of the updates to the table since the previous result set was sent to the client; and sending the partial result set to the client, the partial result set being an incomplete result set of the partial query.