Method and system for committing transactions in a semi-distributed manner

A system, having at least one processor, storage, and a communication platform connected to a network for database operation, the system comprising:

• a transaction executer configured for executing a transaction to access a plurality of keys stored in a database;
• and
• an operation committer configured for:
• transmitting, to a transaction management engine, a request to commit the transaction, wherein the transaction management engine performs a conflict check between the transaction and one or more transactions running concurrently with the transaction, and generates an instruction based on the conflict check,
• receiving the instruction from the transaction management engine, and
• based on the instruction, updating one or more of the plurality of keys in the database or erasing data added by the transaction to the database.

A machine-readable tangible and non-transitory medium having information for database operation, when read by the machine, causes the machine to perform the following:

• executing a transaction to access a plurality of keys stored in a database;
• transmitting, to a transaction management engine, a request to commit the transaction, wherein the transaction management engine performs a conflict check between the transaction and one or more transactions running concurrently with the transaction, and generates an instruction based on the conflict check;
• receiving the instruction from the transaction management engine;
• and
• based on the instruction, updating one or more of the plurality of keys in the database or erasing data added by the transaction to the database.