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

Multi-database routing method and system

A database and routing technology, applied in database indexing, database design/maintenance, electronic digital data processing, etc., can solve the problems of low query efficiency, uneven routing of faulty databases, poor business processing capability of a single database, etc., to improve business processing. Ability, simple implementation method, and the effect of solving uneven routing

Pending Publication Date: 2022-05-13
NETSUNION CLEARING CORP
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] In view of this, the embodiment of the present invention provides a multi-database routing method and system to solve the problems in the prior art such as poor single-database business processing capability, uneven routing when faulty databases appear in multiple databases, and low query efficiency.

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
  • Multi-database routing method and system
  • Multi-database routing method and system
  • Multi-database routing method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0027] The embodiment of the present invention provides a multi-database routing method, which is mainly to realize the routing scheme in the case of multiple databases, and how to realize the uniform routing problem of the database more easily when the database fails, and can quickly query the data in each database. Locate the database where the data is located, reduce unnecessary queries, and improve the efficiency of database operations. Routing in the embodiment of the present invention refers to the process in which a router receives a data packet from an interface, directs it according to the destination address of the data packet and forwards it to another interface. The main difference between routing and bridging is that bridging occurs in OSI The second layer (data link layer) of the reference model, while routing occurs at the third layer (network layer), this difference makes the two use different information in the process of transmitting information, thus completi...

Embodiment 2

[0073] An embodiment of the present invention provides a multi-database routing system, such as Figure 4 shown, including:

[0074] The receiving module 1 is used to receive a transaction request, and the transaction request carries the unique identification information of the transaction operation; this module executes the method described in step S1 in Embodiment 1, which will not be repeated here.

[0075] The first processing module 3 is configured to determine the first database according to the unique identification information; this module executes the method described in step S3 in Embodiment 1, which will not be repeated here.

[0076] The second processing module 5 is used to re-determine the first database according to the unique identification information and the preset character string in the case of a failure of the first database until the re-determined first database is normal; this module executes the method in Embodiment 1 The method described in step S5 wi...

Embodiment 3

[0080] An embodiment of the present invention provides an electronic device, such as Figure 5 As shown, it includes: at least one processor 401 , such as a CPU (Central Processing Unit, central processing unit), at least one communication interface 403 , memory 404 , and at least one communication bus 402 . Wherein, the communication bus 402 is used to realize connection and communication between these components. Wherein, the communication interface 403 may include a display screen (Display) and a keyboard (Keyboard), and the optional communication interface 403 may also include a standard wired interface and a wireless interface. The memory 404 may be a high-speed RAM memory (Ramdom Access Memory, volatile random access memory), or a non-volatile memory (non-volatile memory), such as at least one disk memory. Optionally, the memory 404 may also be at least one storage device located away from the aforementioned processor 401 . The processor 401 may execute the multi-datab...

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 invention discloses a multi-database routing method and system. The method comprises the following steps: receiving a transaction request carrying first identification information corresponding to a transaction operation; determining a first database according to the first identification information; under the condition that the first database fails, re-determining the first database according to the first identification information and the preset character string until the re-determined first database is normal; and under the condition that the first database is normal, determining the first database as a target database, and storing a transaction operation result corresponding to the transaction request in the target database. According to the method, the request with the unique first identification information is received, so that the uniqueness of the information is ensured, and the uniqueness of the matching process is further ensured; the technical problem that the flow of the fault database is averagely or similarly averagely distributed to the remaining normal databases is solved, the problem of uneven routing is solved, and the service processing capacity is improved.

Description

technical field [0001] The invention relates to the field of data storage, in particular to a multi-database routing method and system. Background technique [0002] The acquirer initiates a transaction request, routes it through the acquirer channel, and forwards it to the transaction service. After the transaction service processes the transaction, it selects the available database for the transaction storage operation, and the account channel forwards the transaction request to the account institution through processing such as adding signatures. However, with the continuous increase in business transaction volume, a single database can no longer support the current business volume, has poor business processing capabilities, and cannot provide high-availability services. In the case of multiple databases, once a database failure occurs in the existing routing method, problems such as uneven routing and low query efficiency will be caused. Contents of the invention [0...

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
Patent Type & Authority Applications(China)
IPC IPC(8): G06F16/21G06F16/22G06F16/245
CPCG06F16/217G06F16/22G06F16/245
Inventor 张深振李智年朱钦
Owner NETSUNION CLEARING CORP