Using ad-hoc stored procedures for online transaction processing

A system, comprising:

• a memory;
• and
• a processing device, coupled to the memory, the processing device to:
• identify one or more values for updating a dataset stored in a database;
• create an ad-hoc stored procedure comprising a sequence of commands specifying atomically-executable database update operations with respect to the dataset, wherein the atomically-executable database update operations utilize the one or more values that are encoded into the sequence of commands by respective inline constant values;
• execute the ad-hoc stored procedure, wherein the executing comprises acquiring a temporary lock of at least part of the dataset;
• and
• drop the ad-hoc stored procedure.

A non-transitory computer-readable storage medium comprising executable instructions that, when executed by a computer system, cause the computer system to:

• identify one or more values for updating a dataset stored in a database;
• create an ad-hoc stored procedure comprising a sequence of commands specifying atomically-executable database update operations with respect to the dataset, wherein the atomically-executable database update operations utilize the one or more values that are encoded into the sequence of commands by respective inline constant values;
• execute the ad-hoc stored procedure, wherein the executing comprises acquiring a temporary lock of at least part of the dataset;
• and
• drop the ad-hoc stored procedure.