Business index set generation method and system
A technology of index collection and generation system, which is applied to other database indexes, other database retrieval, special data processing applications, etc., and can solve problems such as slow acquisition speed, time-consuming, unsatisfactory database recovery speed, etc.
Active Publication Date: 2015-09-02
SHENZHEN QIANHUA DATA SCI & TECH
View PDF3 Cites 4 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
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
Method used
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View moreImage
Smart Image Click on the blue labels to locate them in the text.
Smart ImageViewing Examples
Examples
Experimental program
Comparison scheme
Effect test
Embodiment Construction
[0023] In order to make the object, technical solution and advantages of the present invention clearer, the present invention will be further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described here are only used to explain the present invention, not to limit the present invention.
[0024] The embodiment of the present invention updates the transaction index set according to the constructed connection identification set, so that the records corresponding to the storage addresses of the database operation records under the same transaction are recorded in the sub-transaction set corresponding to the same transaction identification, thereby establishing the transaction identification and the The index of transaction-related database operation records. When it is found that the client has mishandled the database in front of it, the database operation sequence of related transactio...
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More PUM
Login to View More 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 ...
Claims
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More Application Information
Patent Timeline
Login to View More Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
CPCG06F16/901
Inventor 金清德
Owner SHENZHEN QIANHUA DATA SCI & TECH