Updating multiple data records in a database

A system for updating multiple data records in a database, the system comprising:

• a server configured to:
• create a first session in the server;
• load, within the first session, multiple data records stored by the database into a memory of the server;
• update at least a first and a second of the multiple data records during the first session in the memory of the server;
• start a database transaction mechanism for the multiple data records after updating the at least first and second data records to write the updated data records to the database which insures that either all or none of the updated database records are committed, wherein the database transaction mechanism includes a write lock over the first and second data records stored in the database;
• and
• close the first session in the server after the updated database records are committed.

A non-transitory computer-readable storage medium comprising instructions that upon execution by a processor of a computing device cause the computing device update multiple data records in a database, wherein the instructions comprise:

• create a first session in the server;
• load, within the first session, multiple data records stored by the database into a memory of the server;
• update at least a first and a second of the multiple data records during the first session in the memory of the server;
• start a database transaction mechanism for the multiple data records after updating the at least first and second data records to write the updated data records to the database which insures that either all or none of the updated database records are committed, wherein the database transaction mechanism includes a write lock over the first and second data records stored in the database;
• and
• close the first session in the server after the updated database records are committed.