CN-122023001-A - Method and system for managing transaction record database of digital exchange platform

CN122023001ACN 122023001 ACN122023001 ACN 122023001ACN-122023001-A

Abstract

The invention relates to the technical field of data management, in particular to a method and a system for managing a transaction record database of a digital exchange platform. The method comprises the steps of collecting current exchange transaction request information and request information resources responded by a user, storing the current exchange transaction request information into an instant transaction buffer area, obtaining all exchange transaction request information in the instant transaction buffer area within a period of time, utilizing a transaction collecting module to collect data of all exchange transaction request information, determining user identity information and transaction request collecting data of each exchange transaction request information after collecting, and utilizing the user identity information to conduct database storage management on the transaction request collecting data so as to complete data storage management of the current exchange transaction request information responded by the user. The invention aims to solve the problem that the management performance is reduced due to poor system stability of the existing database management mode under the scene of frequent transaction of a digital exchange platform.

Inventors

SHI SHUYING
WANG XINLEI

Assignees

浙江集星数字科技有限公司

Dates

Publication Date: 20260512
Application Date: 20260129

Claims (10)

1. A method for managing a transaction record database of a digital exchange platform, comprising the steps of: Collecting current exchange transaction request information responded by a user and request information resources occupied by the current exchange transaction request information; Storing the current exchange transaction request information into an instantaneous transaction buffer area, and feeding back the confirmation information received by the request to the user and releasing the request information resources occupied by the current exchange transaction request information; Acquiring all exchange transaction request information in the instant transaction buffer area within a period of time; utilizing a transaction collecting module to collect data of all exchange transaction request information, and determining user identity information and transaction request collecting data of each exchange transaction request information after collecting; And carrying out database storage management on transaction request collection data by utilizing the user identity information of each exchange transaction request information after collection so as to finish the data storage management of the current exchange transaction request information responded by the user.
2. The method of claim 1, wherein storing the current exchange transaction request information in an instantaneous transaction buffer area, and feeding back to the user the request for confirmation information received and releasing the request information resources occupied by the current exchange transaction request information comprises: Judging the user type of the current exchange transaction request information, and confirming the user type of the current exchange transaction request information; If the user type of the current exchange transaction request information is an active type, storing the current exchange transaction request information into an instantaneous transaction buffer area by utilizing the storage position identification after acquiring the storage position identification, and feeding back the received confirmation information to the user and releasing the request information resources occupied by the current exchange transaction request information; and if the user type of the current exchange transaction request information is the inactive type, randomly storing the current exchange transaction request information into an instantaneous transaction buffer area, feeding back the confirmation information received by the request to the user, and releasing the request information resources occupied by the current exchange transaction request information.
3. The method for managing a transaction record database of a digital exchange platform according to claim 2, wherein if the user type of the current exchange transaction request information is an active type, the step of storing the current exchange transaction request information in an instantaneous transaction buffer area by using the storage location identifier after acquiring the storage location identifier, and feeding back the request information to the user, wherein the request information comprises the steps of: if the user type of the current exchange transaction request information is an active type, confirming a timestamp of the transaction request; respectively determining a time window index and an incremental serial number according to the timestamp of the transaction request and a preset identification pool; Combining the time window index and the incremental serial number to obtain a storage location identifier; and storing the current exchange transaction request information into an instantaneous transaction buffer area by using the storage position identification, and feeding back the confirmation information received by the request to the user and releasing the request information resources occupied by the current exchange transaction request information.
4. The method of claim 3, wherein the step of combining the time window index and the incremental serial number to obtain the storage location identifier comprises: Performing displacement processing on the time window index to obtain a processed time window index; And combining the processed time window index with the incremental serial number to obtain a storage location identifier.
5. The method for managing a transaction record database of a digital exchange platform according to claim 4, wherein the step of performing displacement processing on the time window index to obtain a processed time window index comprises: Determining the load state of the current database and the distribution state of transaction requests in the current time window according to the time window index; determining an adjustment displacement according to the load state of the current database and the distribution state of transaction requests in the current time window; And carrying out displacement processing on the time window index by utilizing the displacement adjustment quantity to obtain a processed time window index.
6. The digital redemption platform transaction record database management method of claim 1, wherein the step of acquiring all redemption transaction request information in the transient transaction buffer area over a period of time includes: acquiring all original request information of exchange transaction in a period of time in the instant transaction buffer area; and carrying out data processing on the original request information of all the exchange transactions to obtain the request information of all the exchange transactions in a period of time in the instantaneous transaction buffer area.
7. The method for managing a transaction record database of a digital exchange platform according to claim 6, wherein the step of performing data processing on the original request information of all exchange transactions to obtain the request information of all exchange transactions in a period of time in the instant transaction buffer area comprises: performing data preprocessing on the original request information of all the exchange transactions to obtain preprocessed request information of all the exchange transactions; And carrying out information verification on all the preprocessed exchange transaction request information to obtain all the exchange transaction request information in a period of time in the instantaneous transaction buffer area after verification is qualified.
8. The method of claim 1, wherein the step of using the transaction aggregation module to aggregate the data of all the exchange transaction request information and determining the user identity information and the transaction request aggregation data of each exchange transaction request information after aggregation comprises: utilizing a transaction collecting module to classify the information of all the exchange transaction request information to obtain exchange transaction request information of each type; And carrying out data aggregation on each type of exchange transaction request information, and determining user identity information and transaction request aggregation data of each exchange transaction request information after aggregation.
9. The method of claim 8, wherein the step of performing data aggregation for each type of exchange transaction request information, and determining user identity information and transaction request aggregation data for each type of aggregated exchange transaction request information comprises: Carrying out data aggregation on each type of exchange transaction request information to obtain aggregation original data; Carrying out integrity check on the collected original data to obtain collected data qualified in check; extracting user information in the qualified aggregation data to obtain user identity information of each exchange transaction request information after aggregation; and carrying out request data identification on the qualified collection data to obtain transaction request collection data.
10. A digital redemption platform transaction record database management system, the system comprising: the information acquisition module is used for acquiring current exchange transaction request information responded by a user and request information resources occupied by the current exchange transaction request information; The information storage module is used for storing the current exchange transaction request information into an instantaneous transaction buffer area, feeding back the confirmation information received by the request to the user and releasing the request information resources occupied by the current exchange transaction request information; The information acquisition module is used for acquiring all exchange transaction request information in the instant transaction buffer area within a period of time; the data aggregation module is used for utilizing the transaction aggregation module to conduct data aggregation on all the exchange transaction request information and determining user identity information and transaction request aggregation data of each exchange transaction request information after aggregation; and the storage management module is used for carrying out database storage management on the transaction request collection data by utilizing the user identity information of each exchange transaction request information after collection so as to finish the data storage management of the current exchange transaction request information responded by the user.

Description

Method and system for managing transaction record database of digital exchange platform Technical Field The invention relates to the technical field of data management, in particular to a method and a system for managing a transaction record database of a digital exchange platform. Background The digital exchange platform is a core hub for connecting users and various digital asset exchanges, the data access mode is gradually changed along with the explosive growth of the scale and transaction liveness of the users, and platform operation teams can frequently execute high-frequency inquiry for grasping service conditions so as to monitor key indexes such as daily transaction amount, active user number and the like. Meanwhile, when a large number of users conduct transactions on a platform, instantaneous high concurrent transaction peaks, high-strength and highly concentrated writing operations are formed, and serious resource contention is caused. Meanwhile, when the existing database management method processes high concurrent transaction requests, multiple transaction processing threads frequently try to lock and unlock data pages in the same batch of memory. To guarantee atomicity, consistency, isolation, and durability of transactions, the lock manager of the database must tightly control access to the data pages. Resulting in a large number of threads being suspended by waiting for lock release. In addition, at the operating system level, the logging burden of the file system increases dramatically, resulting in a significant increase in input/output latency at the system level, so that the central processor spends more time waiting for the disk to complete data read/write operations, rather than focusing on processing business logic. The method has the advantages that massive transaction logs are required to be written in real time, and meanwhile, complicated business query operation is carried out, so that the database query performance is obviously reduced, the data storage fragmentation is serious, the system breakdown and the data loss are extremely easy to occur, and the operation and maintenance cost is greatly increased. Disclosure of Invention The invention aims to provide a method and a system for managing a transaction record database of a digital exchange platform, which are used for solving the problem that the management performance is reduced due to poor system stability of the conventional database management mode under the scene of frequent transactions of the digital exchange platform. In order to achieve the purpose, the invention adopts the following technical scheme that the method for managing the transaction record database of the digital exchange platform comprises the following steps: Collecting current exchange transaction request information responded by a user and request information resources occupied by the current exchange transaction request information; Storing the current exchange transaction request information into an instantaneous transaction buffer area, and feeding back the confirmation information received by the request to the user and releasing the request information resources occupied by the current exchange transaction request information; Acquiring all exchange transaction request information in the instant transaction buffer area within a period of time; utilizing a transaction collecting module to collect data of all exchange transaction request information, and determining user identity information and transaction request collecting data of each exchange transaction request information after collecting; And carrying out database storage management on transaction request collection data by utilizing the user identity information of each exchange transaction request information after collection so as to finish the data storage management of the current exchange transaction request information responded by the user. Further, the step of storing the current exchange transaction request information in the instantaneous transaction buffer area, and feeding back the received confirmation information to the user and releasing the request information resources occupied by the current exchange transaction request information comprises the following steps: Judging the user type of the current exchange transaction request information, and confirming the user type of the current exchange transaction request information; If the user type of the current exchange transaction request information is an active type, storing the current exchange transaction request information into an instantaneous transaction buffer area by utilizing the storage position identification after acquiring the storage position identification, and feeding back the received confirmation information to the user and releasing the request information resources occupied by the current exchange transaction request information; and if the user type of the current exchange transaction request informatio