Patent ID: 8112394

Claim:
A computerized method comprising: starting a data transaction during a first user session; storing data associated with the data transaction in a temporary storage table, wherein the storing the data begins with a start of the data transaction and persists only for a life of the data transaction; mapping the temporary storage table to database tables in a source database, wherein the mapping is used to process the data transaction, and the mapping begins with the start of the data transaction and persists only for the life of the data transaction; reconstructing data in the source database, wherein the reconstructing is performed using the temporary storage table and the source database, and the reconstructing comprises: issuing at least one query to the database tables and joined tables of the database tables to populate at least a first set of data, issuing at least a second query to the temporary storage table to obtain at least a second set of data, wherein the at least second set of data represents changes to the database tables and the joined tables, superimposing the at least second set of data over the at least first set of data to generate at least one third set of data, and reconstructing the data in the source database using the at least one third set of data; and ending the data transaction during a second user session using contents of the temporary storage table.