Method and system for generating a transaction-bound sequence of records in a relational database table

1. 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.

2. The method of claim 1 , wherein said method further includes utilizing a transaction log record to identify said completed transactions.

3. The method of claim 1 , wherein said transaction-bound tracking table also includes a transaction_id column and a table_name column.

4. A computer storage medium having a computer program product for generating a transaction-bound sequence of records in a database table of a relational database, said computer storage medium comprising:

computer program code for, 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;

computer program code for determining whether or not an entry having said obtained transaction ID and database table name is contained within a transaction-bound tracking table;

computer program code for, 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;

computer program code for, 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;

computer program code for 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;

computer program code for utilizing a pre-scheduled daemon that uses an Application Program Interface of said relational database to identify said completed transactions; and

computer program code for removing entries associated with completed transactions from said transaction-bound tracking table.

5. The computer storage medium of claim 4 , wherein said computer storage medium further includes computer program code for utilizing a transaction log record to identify said completed transactions.

6. The computer storage medium of claim 4 , wherein said transaction-bound tracking table also includes a transaction_id column and a table_name column.

7. A database system capable of generating a transaction-bound sequence of records in a database table within a relational database, said database system comprising:

means for, 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;

means for determining whether or not an entry having said obtained transaction ID and database table name is contained within a transaction-bound tracking table;

means for, 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;

means for, 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;

means for 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;

means for utilizing a pre-scheduled daemon that uses an Application Program Interface of said relational database to identify said completed transactions; and

means for removing entries associated with completed transactions from said transaction-bound tracking table.

8. The database system of claim 7 , wherein said database system further includes a transaction log record for identifying said completed transactions.

9. The database system of claim 7 , wherein said transaction-bound tracking table also includes a transaction_id column and a table_name column.