Step identifier based on a universal timestamp

摘要

One or more transactions, and their audited update actions, operating on a database may be identified by a step ID. The step ID may include a first set of bits identifying a time the step was created. The step ID may also include a second set of bits uniquely identifying a step created at a certain time from other step created at the same time. The first set of bits may be generated from a coordinated universal time (UTC) that does not change with local seasons, such as daylight saving time.

主权项

1. A method, comprising:
receiving a request to process a transaction on a database; processing the transaction on the database; assigning an identification number to the transaction, in which the step of assigning comprises:
obtaining a current universal time, in a coordinated universal time (UTC) format, that does not change with seasonal offsets; andobtaining a nine bit unique transaction identification value; setting the identification number to the current universal time; shifting off nine bits of the identification number; appending the unique transaction identification value to the identification number; and adjusting a first bit of the identification number to indicate a format of the identification number after setting the identification number to the current universal time.