Database operation statement processing method and device, electronic equipment and medium

Abstract

The invention provides a database operation statement processing method, which comprises the following steps: in response to a service processing request, obtaining m initial operation statements sentto a specified database, m being a positive integer; and screening out searchable operation sentences from the m initial operation sentences, wherein the searchable operation sentences comprise initial operation sentences screened out according to the service attribute identifiers of the services to be executed by the initial operation sentences and / or initial operation sentences screened out according to the execution performance identifiers of the initial operation sentences; conducting searching and killing operation on the searchable operation statements, so that the executable operationstatements are executed in the specified database to obtain a request result of the service processing request, wherein the executable operation statements are initial operation statements, except thesearchable operation statements, in the m initial operation statements. The invention further provides a database operation statement processing device, electronic equipment and a computer readable storage medium. The method and the device provided by the invention can be applied to the financial field or other fields.

Description

technical field [0001] The present disclosure relates to the technical field of databases, in particular to a processing method, device, electronic equipment and media for database operation statements. Background technique [0002] With the advent of the digital society, in many application scenarios, the query processing of massive data is becoming more frequent, and the pressure on the database system is showing an explosive growth trend. At the same time, the requirements for the timely response of the database and the continuity of business execution are also more stringent. Especially in business scenarios with a large number of active users and high user focus (such as double eleven, 618 and other shopping carnival flash sales, commemorative coin reservations), high database concurrency often occurs, which leads to users who use the same application at the same time The number is very large, which leads to a surge in the number of operation statements pouring into the...

AI Technical Summary

Problems solved by technology

[0005] For this reason, there is a great need for an effective way to ensure business continuity under the high concurrency pressure of the database, fundamentally improve the availability of the database, and ensure that the database is not dead. , to avoid affecting all customers and transactions, fundamentally solve the pressure of competition for database system resources brought by database operation statements in the high concurrency state of the database, and overcome the solutions provided by related technologies that cannot fundamentally solve the high concurrency of the database In the state, the technical problem of the competition pressure brought by the operation statement to the system resources of the database achieves the technical effect of ensuring the normality, stability and continuity of the core business transactions

Images