Patent ID: 7870110

Claim:
A method for generating a transaction-bound sequence of records in a database table of a relational database, said method comprising: in response to an transaction attempting to add a record to a database table within a relational database, obtaining an identification (ID) of said transaction and a name of said database table; determining whether or not an entry having said obtained transaction ID and database table name is contained within a transaction-bound tracking table; in a determination that an entry having said obtained transaction ID and database table name are not contained within said transaction-bound tracking table, generating a new entry in said transaction-bound tracking table for said obtained transaction ID and database table name, and setting a value in a last_order_number column of said new entry to 1; in a determination that an entry having said obtained transaction ID and database table name are contained within said transaction-bound tracking table, incrementing a value in said last_order_number column of said entry by 1; copying said value in said last_order_number column of said entry to an order field in said record of said database table for said transaction; utilizing a pre-scheduled daemon that uses an Application Program Interface of said relational database to identify said completed transactions; and removing entries associated with completed transactions from said transaction-bound tracking table.