Techniques for protective validation in a non-distributed database

A non-transitory computer-readable medium storing a set of instructions for managing execution of database transactions in a non-distributed database system, the set of instructions comprising:

• one or more instructions that, when executed by one or more processors of a device, cause the device to:
• during a validation of a transaction, identify conditional conflicts and their corresponding conflicting transactions, wherein the corresponding conflicting transactions are reading-transactions conflicting with the transaction;
• for each conditional conflict, determine if the transaction can commit, with respect to the conditional conflict, before the corresponding conflicting transaction;
• place an active protective declaration, issued by the transaction and sourced by a corresponding conflicting transaction, when the transaction can commit, with respect to the conditional conflict, before the corresponding conflicting transaction;
• marking the transaction as dependent on the corresponding conflicting transaction when the transaction cannot commit before the corresponding conflicting transaction;
• and
• when validation conditions are met, place a commit pause on data cells modified by the transaction, thereby allowing the transaction to commit before any corresponding conflicting transactions.

A system for managing execution of database transactions in a non-distributed database system comprising:

• one or more processors configured to:
• during a validation of a transaction, identify conditional conflicts and their corresponding conflicting transactions, wherein the corresponding conflicting transactions are reading-transactions conflicting with the transaction;
• for each conditional conflict, determine if the transaction can commit, with respect to the conditional conflict, before the corresponding conflicting transaction;
• place an active protective declaration, issued by the transaction and sourced by a corresponding conflicting transaction, when the transaction can commit, with respect to the conditional conflict, before the corresponding conflicting transaction;
• mark the transaction as dependent on the corresponding conflicting transaction when the transaction cannot commit before the corresponding conflicting transaction;
• and
• when validation conditions are met, place a commit pause on data cells modified by the transaction, thereby allowing the transaction to commit before any corresponding conflicting transactions.