首页>
外国专利>
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
展开▼
机译:在关系数据库表中生成事务绑定记录序列的方法和系统
展开▼
页面导航
摘要
著录项
相似文献
摘要
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.
展开▼