Data query method and device for payment and settlement system

Abstract

The invention provides a data query method and device for a payment and settlement system. The method comprises the following steps: receiving at least one piece of transaction data, and writing the transaction data into a transaction data storage database of the payment and settlement system; synchronizing the at least one transaction data to an Elasticsearch cluster database from a transaction data storage database; receiving a transaction data query instruction; and querying in the Elasticsearch cluster database to obtain transaction data to be queried. The transaction data are written intothe transaction data storage database of the payment clearing system, the data is synchronized to the Elasticsearch cluster database in real time to be queried, read-write separation of the transaction data is realized, the pressure of the transaction data storage database is reduced, the consumption of the payment and settlement system is reduced, and the occurrence of faults of the payment andsettlement system is avoided, so that the accuracy and availability of data query of the payment and settlement system are improved, and the user experience is improved.

Description

technical field [0001] The invention relates to the technical field of data processing, in particular to a data query method and device for a payment and clearing system. Background technique [0002] The payment and settlement system is a very important part of the bank's IT system, and most of the banking business needs to rely on the payment and settlement system. However, at present, the payment and settlement system mainly deals with large-value transactions, the process is complex, and there are many database tables involved, and there are large XML fields in the main table, which consumes a lot of database resources during business processing. In addition, due to the business system It is also necessary to monitor all kinds of transactions in real time, and there will be a large number of queries. During the period of large transaction volume, the background business processing, coupled with the real-time reading and writing brought by a large number of business queri...

AI Technical Summary

Problems solved by technology

However, at present, the payment and settlement system mainly deals with large-value transactions, the process is complex, and there are many database tables involved, and there are large XML fields in the main table, which consumes a lot of database resources during business processing. In addition, due to the business system It is also necessary to monitor all kinds of transactions in real time, and there will be a large number of queries. During the period of large transaction volume, the background business processing, coupled with the real-time reading and writing brought by a large number of business queries and monitoring, will give the transaction data storage database (ORACLE large database) brought a lot of pressure, resulting in slow response of the database, causing a huge burden on the system, causing a large area of ​​the system to hang, the accuracy and availability of data are not high, and it also seriously affects the customer experience.

Images