Patent ID: 7711730
Filing Date: 2010-05-04
Classification: G06F

Abstract:
1. A computer-implemented method for generating a single execution plan for updating and retrieving data from a database in a single process, the method comprising: receiving and storing a statement by a server to both update the database with a first set of data and retrieve a second set of data from the database, wherein receiving the statement by the server comprises receiving a single statement comprising a first portion to update the database with the first set of data and a second portion to retrieve the second set of data from the database; parsing the statement into the first portion corresponding to the update of the database with the first set of data and the second portion corresponding to the retrieval of the second set of data from the database; building a first execution plan for the first portion of the statement to update the database with the first set of data; building a second execution plan for the second portion of the statement to retrieve the second set of data from the database; building the single execution plan comprising a combination of both the first execution plan and the second execution plan; executing the single execution plan derived from the single statement to update and retrieve, wherein the database is updated with the first set of data and the second set of data is retrieved from the database in said single process, the first set of data comprising at least one or more different rows of data in relation to the second set of data, and being independent from the second set of data; and displaying the second set of data received from the database to a user.