首页>
外国专利>
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.
展开▼