Database-based operation request processing method and device

Abstract

The invention relates to a database-based operation request processing method and apparatus. The method comprises the steps of receiving a database operation request, wherein the database operation request comprises an access source identifier and a service identifier; determining a target thread pool from the plurality of thread pools according to the access source identifier and the obtained corresponding relationship table; obtaining a preset routing rule from the common data sub-library based on the target thread pool, wherein the preset routing rule comprises a corresponding relationshipbetween a plurality of access sources and a plurality of sub-libraries; determining a target sub-library according to the access source identifier and a preset routing rule; and sending a database operation request to the target sub-library to obtain data corresponding to the service identifier from the target sub-library. Therefore, the downtime influence range of the database can be reduced, andthe access pressure of the database can be dispersed, so that the system load capacity can be improved.

Description

technical field [0001] The present application relates to the technical field of data processing, in particular to a database-based operation request processing method and device. Background technique [0002] With the continuous development of banking business, the transaction volume of each important system is increasing, and the amount of data involved is also increasing. The types of databases include SQL Server, MySql, MS SqlServer, Oracle, etc.; most of the transaction systems of banks currently use a single database structure, and all transaction data involved in each transaction system are stored in a single database. [0003] For the core business of the bank, there are strict requirements on the two indicators of system recovery time objective (RTO) and recovery point objective (RPO). RTO refers to the time requirement for the information system or business function to be restored after the failure occurs, and RTO plays an important role in determining the priorit...

AI Technical Summary

Problems solved by technology

[0004] For the current transaction system of a bank based on a single database, even a short-term shutdown will cause immeasurable economic and reputation losses; and with the continuous increase in business volume, the complexity of the business model continues to increase. The hardware performance of a single set of database in the system will eventually reach the bottleneck, and there will be cases where there is no room for expansion in vertical expansion

Images