Unlock instant, AI-driven research and patent intelligence for your innovation.

Database request processing method and device, computer equipment and storage medium

A request processing and database technology, applied in the field of data processing, can solve problems such as request processing thread suspension, business system unavailability, failure to meet fault isolation requirements, etc., to improve processing accuracy, improve fault tolerance and stability, and realize The effect of fault isolation

Pending Publication Date: 2020-11-17
CHINA CONSTRUCTION BANK
View PDF0 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Since the requests sent to different databases still come from the same business system, when one of the databases fails, the request processing thread of the entire business system will be suspended, which will cause the entire business system to be unavailable, and eventually cause the entire business system to be unable to communicate externally. Provides service, fails to meet fault isolation requirements

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Database request processing method and device, computer equipment and storage medium
  • Database request processing method and device, computer equipment and storage medium
  • Database request processing method and device, computer equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0026] Figure 1a It is a schematic diagram of a flow chart of a database request processing method in Embodiment 1 of the present invention. The method can be executed by the database request processing device provided in the embodiment of the present invention. The device can be implemented in the form of software and / or hardware, and Generally, it can be integrated into computer equipment, such as a server. Such as Figure 1a As shown, the method of this embodiment specifically includes:

[0027] S110. When a database service request is received, extract a database selection parameter from the database service request.

[0028] The database service request is used to perform database operations on at least one database, where the database operations may include at least one of the following: operations such as querying, adding, modifying, and deleting data in the database. The database selection parameter is used to point to at least one database. The database selection p...

Embodiment 2

[0046] figure 2 It is a flow chart of a database request processing method in Embodiment 2 of the present invention, and this embodiment is embodied on the basis of the foregoing embodiments. The method of this embodiment specifically includes:

[0047] S210. When a database service request is received, extract a database selection parameter from the database service request.

[0048] For non-exhaustive descriptions of the embodiments of the present invention, reference may be made to the foregoing embodiments.

[0049] S220. Extract dimension information of sub-databases from the database selection parameters.

[0050] The sub-database dimension information is used to describe the rule information when the database is sub-database. Specifically, it can refer to the field indicating the database type and the attribute value corresponding to the field. The sub-database dimension information can be used to identify the database.

[0051] S230. Select at least one target ser...

Embodiment 3

[0063] image 3 It is a flowchart of a database request processing method in Embodiment 3 of the present invention, and this embodiment is embodied on the basis of the foregoing embodiments. The method of this embodiment specifically includes:

[0064] S310. When a database service request is received, extract a database selection parameter from the database service request.

[0065] For non-exhaustive descriptions of the embodiments of the present invention, reference may be made to the foregoing embodiments.

[0066] S320. Select at least one target server matching the database selection parameter from at least two servers.

[0067] S330. Select a target thread pool that matches the target server from at least two thread pools according to the pre-configured correspondence between the server and the thread pool. Different thread pools correspond to different servers.

[0068] Using the thread pool to process database business processing requests actually uses multi-thread...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The embodiment of the invention discloses a database request processing method and device, computer equipment and a storage medium. The method comprises the steps of when a database service request isreceived, extracting database selection parameters from the database service request; and selecting at least one target server matching the database selection parameters from at least two servers, and forwarding the database service request to each target server to indicate each target server to process a target database corresponding to each target server according to the database service request, wherein different databases correspond to different servers; and receiving response data sent by each target server, and returning the response data to a sender of the database service request. According to the embodiment of the invention, the database can be subjected to fault isolation, and the stability and fault tolerance of a database system are improved.

Description

technical field [0001] The embodiments of the present invention relate to the field of data processing, and in particular, to a database request processing method, device, computer equipment, and storage medium. Background technique [0002] At present, the business system will configure two databases, and use the main database as the production database to provide external services, and the standby database as the backup database to synchronize real-time data with the main database to ensure that when the main database fails, it can be switched seamlessly and with zero data loss. In order to meet the requirements of business continuity. [0003] However, the service provided by the above method always has only one database at a time point, and there is a small probability that 1+N databases will go down at the same time, resulting in the unavailability of the entire business system. In addition, with the development of time and business, the amount of data in the business ...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
IPC IPC(8): G06F9/50G06F16/245
CPCG06F9/5055G06F16/24569
Inventor 方红涛汪维杨代兵刘涛朱炜曹子钰肖翔
Owner CHINA CONSTRUCTION BANK