Patent ID: 8234241

Claim:
A computer implemented method for reducing database workload volume, the method comprising: collecting a sequence of database commands directed to a single database record in a database, the database commands comprising instructions for modifying data in the database; setting, via the computer, a net result equal to a first database command in a sequence of database; determining whether the net result is a delete command; responsive to determining that the net result is not a delete command, preforming: updating, via the computer, the net result equal to no database command and exiting in response to determining that the first database command in the sequence of database commands is an insert command and a subsequent database command in the sequence of database commands is the delete command; updating, via the computer, the net result equal to the delete command in response to determining that the first database command is not the insert command and the subsequent database command in the sequence of database commands is the delete command; and updating, via the computer, a quantity in the net result equal to a quantity in the subsequent database command in the sequence of database commands in response to determining that the subsequent database command in the sequence of database commands includes the quantity and the net result is not equal to the delete command; and writing the net result to an output entity in response to determining that the net result includes at least one database command; wherein the reducing further comprises removing at least one database command in the sequence of database commands that is prior to the delete command in the sequence of database commands.