Database operation method, apparatus and system

Abstract

The embodiment of the invention relates to a database operation method, which mainly comprises the steps that: an interfere-level database proxy is responsible for receiving data operation requests from a variety of application businesses, caches the obtained data operation requests in a message queue, and sends the data operation requests according to the sequence of the message queue to a selected target next-level database proxy so as to perform corresponding database processing. The embodiment of the invention also provides an apparatus and a system corresponding thereto. Thus, the data operation requests are cached and the target next-level database proxy is selected from one or a plurality of next-level database proxies to perform database processing, the processing of a plurality of data operation requests can be performed simultaneously, equalization for access load of distributed databases can be achieved, business processing ability of the databases is enhanced, business service expandability of the databases is strengthened, and normal performance of the processing of the data operation requests is ensured in order to enhance the safety of database operation.

Description

technical field [0001] The invention relates to the field of data processing, in particular to a database operation method, equipment and system. Background technique [0002] Database (Database, DB) is a warehouse that organizes, stores and manages data according to the data structure. With the development of information technology and market, data management is no longer just storing and managing data, but has transformed into various data management methods required by users. [0003] The traditional database operation method is generally as follows figure 1 The business service shown is directly connected to the database for processing, which is to embed the database access code directly into each database operation request of the business service. This form of relating the business logic of the database operation request to the database access causes the same When the database has multiple database operation requests, each database operation request can only occupy th...

AI Technical Summary

Problems solved by technology

[0003] The traditional database operation method is generally as follows figure 1 The business service shown is directly connected to the database for processing, which is to embed the database access code directly into each database operation request of the business service. This form of relating the business logic of the database operation request to the database access causes the same When the database has multiple database operation requests, each database operation request can only occupy thread resources in order to access the database one by one and process it one by one. In this way, when the business service continues to expand and the database operation requests increase sharply, on the one hand, the database’s The business processing ability cannot be improved, which seriously affects the scalability of business services. On the other hand, due to the concentration of a large number of business logic codes in the same business service, when a database operation request handles an exception, it will affect other database operation requests. normal execution, security is not guaranteed

Images