Method, apparatus, and computer program for processing a queue of messages
OwnerStephen Toddinventor
Life of this patent
Estimating the term…
Abstract
The invention relates to the processing of a queue of messages, each message representing at least one request for an update to a database. A message is browsed and at least one update request is extracted from the message. The update request is sent to a database management system (DBMS) which is responsible for the database which is to be updated. An indication is also sent to the DBMS to indicate that the update request is a pretend update request and that the DBMS should not execute the update but should prefetch data that will be required when a corresponding real update is requested.
Claims20
A method for processing a queue of messages, each message representing at least one request for an update to a database, the method comprising:
- browsing a message;
- extracting from a browsed message an update request;
- and
- sending a pretend update request to a database management system (DBMS) responsible for the database which is to be updated, the pretend update request comprising an indication that directs the DBMS to not execute the update, but instead to prefetch data that will be required when a corresponding real update is requested.
A computer program product comprising a computer readable medium having computer usable program code for pre-processing at a database management system (DBMS) of update requests to a database controlled by the DBMS, the computer program product comprising:
- computer usable program code for receiving an update request at the DBMS;
- computer usable program code for receiving an indication at the DBMS indicating that the update request is a pretend update request that directs the DBMS to not execute an update request but instead to prefetch data for the update request;
- computer usable program code for translating the pretend update request into a prefetch request;
- and
- computer usable program code for prefetching required data based on the prefetch request.
A computer program product comprising a computer readable medium having computer usable program code for processing a queue of messages, each message representing at least one request for an update to a database, the computer program product comprising:
- computer usable program code for browsing an unexecuted message;
- computer usable program code for extracting an update request from an unexecuted message;
- and
- computer usable program code for translating the update request into a query request to prefetch data for the unexecuted update request.
A computer implemented method for facilitating database performance by pre-processing update requests to a database management system (DBMS) for a queue of messages, comprising:
- executing a computer program product configured to:
- receive an update request at the DBMS;
- receive an indication at the DBMS indicating that the update request is a pretend update request that directs the DBMS to not execute the update but instead to prefetch data for the update request;
- translate the pretend update request into a prefetch request;
- prefetch required data based on the prefetch request;
- and
- receiving a real update request at the DBMS;
- and
- executing the real update request using the prefetched data.
Dependencies are inferred from the claim text.