Invention Grant
US07870110B2 Method and system for generating a transaction-bound sequence of records in a relational database table
有权
用于在关系数据库表中生成交易绑定的记录序列的方法和系统
- Patent Title: Method and system for generating a transaction-bound sequence of records in a relational database table
- Patent Title (中): 用于在关系数据库表中生成交易绑定的记录序列的方法和系统
-
Application No.: US12038074Application Date: 2008-02-27
-
Publication No.: US07870110B2Publication Date: 2011-01-11
- Inventor: Ricardo N. Olivieri , Mark B. Whelan
- Applicant: Ricardo N. Olivieri , Mark B. Whelan
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Dillon & Yudell LLP
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/00

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.
Public/Granted literature
- US20090216813A1 METHOD AND SYSTEM FOR GENERATING A TRANSACTION-BOUND SEQUENCE OF RECORDS IN A RELATIONAL DATABASE TABLE Public/Granted day:2009-08-27
Information query