Database update management

摘要

A method and system for managing a transaction for updating tables of a database. An access order specifying a temporal order for updating tables of the database is stored. A received data request specifies records to be updated in the database for the transaction. The records identified in the data request are copied from the database to a virtual data area. It is determined from a list of updated records that the records identified in the data request have been updated in the virtual data area. It is ascertained that each record identified in the data request has not been updated in the database since the records were copied to the virtual data area. The list of updated records is sorted according to the temporal order in the access list. The database is updated by replacing in the database the records identified in the sorted list.