Unisys Corporation

Jane Muccio

Ellen L Sorenson

A rollback record may be created for each step identifier (ID). The rollback record indicates how many times the step record identified by the step ID has been rolled back during operation of the database. The rollback record may be stored in a periodic save record (PSR), separate from or stored in an audit trail containing the step records. By processing the rollback records in the periodic save record during a recovery, a database may identify a time on an audit trail for initiating a recovery prior to the last resume point for a step without going back in the audit trail to a time before the initial start of the step.

Rollback counters for step records of a database

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.

Growing community of inventors

Roseville, MN, United States of America

Jane Muccio