Method and system for generating transaction index set

Abstract

The invention is applied to the field of computers, and provides a business index set generation method and a business index set generation system. The method comprises the following steps of constructing a connection identifier set and a business index set; sequentially reading a database operation record set, and acquiring connection identifiers, operation type identifiers and unique identifiers of database operation records; updating the business index set and the connection identifier set according to the connection identifier set, the connection identifiers, the operation type identifiers and the unique identifiers. According to the embodiment of the invention, the connection identifier set is constructed, and the business index set and the connection identifier set are dynamically updated according to the connection identifier set, the connection identifiers, the operation type identifiers and the unique identifiers, so that records corresponding to storage addresses of database operation records under the same business are in a sub-business set corresponding to the same business identifier, and indexes of the business identifier and the database operation records related to the business are established.

Description

technical field [0001] The invention belongs to the field of computers, and in particular relates to a method and system for generating a transaction index set. Background technique [0002] The database server usually provides external services through the network. The client application program establishes a network session with the database server by sending operation instructions to the database server, and interacts with the database server through this session to obtain various services provided by the database server. In the process of the client operating the database through the database server, the database may be misoperated, such as mistaken deletion and modification of data, etc. These misoperations often bring huge losses to users, especially in the financial industry. . [0003] When it is found that the client has misoperated the database in front of it, it is necessary to quickly and accurately obtain one or several related transactions (a transaction is a ...

AI Technical Summary

Problems solved by technology

[0004] In the prior art, when it is found that the client has mishandled the database, it obtains one or several related data by traversing the network message collection between the database server and the client or the transaction log in the database. The database operation sequence of the transaction, because the database operation sequence of each transaction has no regular storage rules in the network message collection or transaction log, the process of obtaining the relevant database operation sequence takes a lot of time, and the acquisition speed is slow, which cannot meet the needs of the financial industry. Requirements for database recovery speed

Images