Patent ID: 8768902

Claim:
A computer-readable storage medium configured with data and with instructions that when executed by at least one processor causes the processor(s) to perform a process for managing changes in a multi-user database application environment, the process comprising the steps of: collecting proposed changes to the multi-user database application environment prior to committing any of those changes; identifying for a particular proposed change Y at least one precondition PreY presumed by Y and at least one postcondition PostY to be caused by committing Y; identifying for a particular proposed change X at least one precondition PreX presumed by X and at least one postcondition PostX to be caused by committing X; analyzing a dependency of change X and change Y by doing at least one of the following: determining that PostY renders PreX unavailable, determining that PostX allows PreY; and then ordering the proposed changes to form an ordered change list with change X preceding change Y in order of commitment in the list; committing both change X and change Y in a single transaction, instead of committing change X in one transaction and committing change Y in a different transaction; ordering a total of at least three proposed changes in order of commitment based on a total of at least two analyzed dependencies, these proposed changes being in at least two of the following change categories: data changes, schema changes, application changes; verifying that precondition(s) of each of these proposed changes will be satisfied at a commitment time of that proposed change; and committing these proposed changes in order of commitment in a single transaction during which any change that would conflict with these proposed changes is barred.