Supercharge Your Innovation With Domain-Expert AI Agents!

Database routing method, system and equipment based on data service

A data service and database technology, applied in the field of data transmission, can solve problems such as difficult to add rules, expand maintenance, lack of database support, single database, etc.

Pending Publication Date: 2022-07-01
中孚安全技术有限公司 +3
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] With the popularization and development of informatization in various industries, data information is growing explosively, and the response of the core transaction system is becoming slower and slower. With the rapid growth of business data, it exceeds the limit of the stand-alone database and restricts business development; The data far exceeds the tolerance limit of the stand-alone database, and the distributed database routing method is produced thereupon. The inventors have found that the traditional database routing method has the following deficiencies: 1) the supported database is single, such as: the syntax analysis for the database is lacking. Other database support; 2) The registered routing center is not separated from the actual data service, and it is not easy to add rules for extended maintenance

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 routing method, system and equipment based on data service

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0046] refer to figure 1 , this embodiment is described from the mixed side of the data service, the business application system, and the routing service.

[0047] Specifically, the data service-based database routing method of this embodiment includes:

[0048] S101: The data service sends a notification to the routing service and informs the routing service of the routing rule.

[0049] In the specific implementation, the routing service is constructed based on different product scenarios, and different data infrastructure services are set up with different access policies.

[0050] In addition, in order to improve the accurate matching between the database and the data service, all database operations are encapsulated as a minimal data base service to be provided externally.

[0051] In a specific implementation, after the data service is enabled, the routing service is notified through the registration center. In this way, the scenario of mixed use and sub-database and ...

Embodiment 2

[0062] Corresponding to the first embodiment, the data service-based database routing system in this embodiment includes a data service, a business application system, and a routing service.

[0063] Among them, the data service, which is used to send notifications to the routing service and inform the routing service of the routing rules.

[0064] In the specific implementation, the routing service is constructed based on different product scenarios, and different data infrastructure services are set up with different access policies.

[0065] In addition, in order to improve the accurate matching between the database and the data service, all database operations are encapsulated as a minimal data base service to be provided externally.

[0066] In a specific implementation, after the data service is enabled, the routing service is notified through the registration center. In this way, the scenario of mixed use and sub-database and sub-table under different databases of the ...

Embodiment 3

[0077] This embodiment describes from the routing service side, the database routing method based on data service, including:

[0078] S201: Receive data service sending notification and routing rules;

[0079] S202: In response to the command of the business application system invoking the routing service during the business operation, the route is matched as a whole according to the routing rule;

[0080] S203: Return the invocation link of the matched overall route to the business application system, and the business application system performs data service routing according to the invocation link to invoke the data service, and then operates the corresponding database through the data service and returns the data to the business application system, Complete the overall operation.

[0081] In the specific implementation, the routing service is constructed based on different product scenarios, and different data infrastructure services are set up with different access polic...

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 belongs to the field of data transmission, and provides a database routing method, system and equipment based on data service. The database routing method based on the data service comprises the following steps: the data service sends a notification to a routing service and informs the routing service of a routing rule; the business application system calls a routing service during business operation, and integrally matches a route according to a routing rule; the routing service returns the calling link of the matched overall routing to the service application system; the business application system carries out data service routing according to the calling link and calls the data service; and the data service operates the corresponding database and returns the data to the business application system to complete the whole operation. The scene of mixed use and sub-database and sub-table under different databases of business is solved, and convenience is provided for subsequent expansion by a method of combining data service with a registration routing center.

Description

technical field [0001] The invention belongs to the field of data transmission, and in particular relates to a database routing method, system and device based on data service. Background technique [0002] The statements in this section merely provide background information related to the present invention and do not necessarily constitute prior art. [0003] With the popularization and development of informatization in various industries, data information is growing explosively, and the response of the core transaction system is getting slower and slower. With the rapid growth of business data, it exceeds the bearing limit of a single-machine database and restricts the development of business; The data far exceeds the bearing limit of a single-machine database, and a distributed database routing method is subsequently generated. The inventor found that the traditional database routing method has the following shortcomings: 1) The supported database is single, such as: gram...

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): G06F16/27G06F16/25G06F16/28
CPCG06F16/27G06F16/25G06F16/284
Inventor 苗功勋王金国崔新安姜旭东
Owner 中孚安全技术有限公司
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More