Method and apparatus for updating a database using table staging and queued relocation and deletion

摘要

Methods and systems for updating a database with one or more update records are provided in the present application. A staged table corresponding to a primary table of the database is generated. The update record is processed to validate the update record to determine whether there is an error in the update record and to add the update record to the staged table. The update record is copied from the staged table to the primary table when there is no error in the update record. The update record is deleted from the staged table after the update record is processed.