Invention Grant
US07870110B2 Method and system for generating a transaction-bound sequence of records in a relational database table 有权
用于在关系数据库表中生成交易绑定的记录序列的方法和系统

Method and system for generating a transaction-bound sequence of records in a relational database table
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.
Information query
Patent Agency Ranking
0/0