Method and system for generating a transaction-bound...

Details Method and system for generating a transaction-bound... Method and system for generating a transaction-bound...

2011-01-11

2011-01-11

Breene, John E (Department: 2162)

Data processing: database and file management or data structures

Data integrity

Transactional processing

C707S791000, C707S802000, C707S999103

Reexamination Certificate

active

07870110

ABSTRACT:
A method for generating a transaction-bound sequence of records in a database table is disclosed. In response to a transaction attempting to insert a record to a database table within a relational database, an identification (ID) of the transaction and the name of the associated database table are initially obtained. A determination is then made whether or not the obtained transaction ID and the associated database table name are found in the transaction-bound tracking table. If they are not found in the transaction-bound tracking table, a new entry is generated in the transaction-bound tracking table for the obtained transaction ID and database table name, and a value in a last_order_number column associated with the entry is set to 1; otherwise, a value in the last_order_number column associated with the entry is incremented by 1. The value in the last_order_number column associated with the entry is subsequently copied to the corresponding order tracking field associated with the record entry in the database table.

REFERENCES:
patent: 5799305 (1998-08-01), Bortvedt et al.
patent: 5930806 (1999-07-01), Taira et al.
patent: 5995980 (1999-11-01), Olson et al.
patent: 7167858 (2007-01-01), Naeymi-Rad et al.
patent: 2001/0044834 (2001-11-01), Bradshaw et al.
patent: 2003/0200212 (2003-10-01), Benson et al.
patent: 2003/0204420 (2003-10-01), Wilkes et al.
patent: 2004/0193655 (2004-09-01), Miyata et al.
patent: 2004/0267809 (2004-12-01), East et al.
patent: 2005/0027725 (2005-02-01), Kagalwala et al.
patent: 2005/0038671 (2005-02-01), Naeymi-Rad et al.
patent: 2005/0071341 (2005-03-01), Chkodrov et al.
patent: 2005/0131966 (2005-06-01), Lou
patent: 2007/0115738 (2007-05-01), Emaru et al.
patent: 2007/0203910 (2007-08-01), Ferguson et al.
patent: 2008/0098045 (2008-04-01), Radhakrishnan et al.
patent: 2009/0024871 (2009-01-01), Emaru et al.

Affiliated with

Also associated with

Rating

Method and system for generating a transaction-bound... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Method and system for generating a transaction-bound..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and system for generating a transaction-bound... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2628917