Fragmented database routing method, system and device and storage medium

A database and routing technology, applied in the database field, can solve the problems of loss of data, business paralysis, increased pressure and overhead of central database and data routing, etc., to reduce load pressure, improve utilization, and reduce data torsion and interaction.

Pending Publication Date: 2020-07-03
卓望数码技术(深圳)有限公司
View PDF3 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, after the database is fragmented, the processing of business data in the existing technology mostly depends on the central database, routing through the central database, or using route mapping to reverse and interact with the data of the fragmented database, thus increasing the central database and The pressure and overhead of data routing, once the central database fails, it will lead to paralysis of the entire business, and even the risk of data loss

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
  • Fragmented database routing method, system and device and storage medium
  • Fragmented database routing method, system and device and storage medium
  • Fragmented database routing method, system and device and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0061] refer to figure 1 , which shows a schematic flowchart of a specific embodiment of a method for routing a fragmented database in an embodiment of the present invention. Such as figure 1 As shown, a fragmented database routing method in the embodiment of the present invention includes the following specific steps:

[0062] S100. The client initiates a service data processing request including a shard key, and the shard key is used to determine the distribution of the service data in the shard database.

[0063] The client initiates a business data processing request, and the request includes a shard key, which determines the distribution of business data in the shard database. The shard key can be a single index or a mixed index of business data. Only the ID field index of the shard and the single or mixed index of business data are the only indexes that point to the shard where the business data is located. The client is an application program on the terminal device,...

Embodiment 2

[0085] refer to figure 2 , which shows a schematic flowchart of another specific embodiment of a fragmented database routing method in the embodiment of the present invention. Such as figure 2 As shown, based on Embodiment 1, a fragmented database routing method in the embodiment of the present invention specifically includes the following steps:

[0086] S200. The client initiates a service data processing request including a shard key, and the shard key is used to determine the distribution of the service data in the shard database.

[0087] S210. The client acquires fragment element mapping data according to the fragment key.

[0088] S220. The client acquires a target shard database instance including service data according to the shard element mapping data.

[0089] S230. The client creates an independent thread, uses the target shard database instance, switches the data source on the central database instance to the target shard database instance, and routes the ser...

Embodiment 3

[0095] refer to image 3 , shows a system block diagram of a specific embodiment of a fragmented database routing system in an embodiment of the present invention. Such as image 3 As shown, a fragmented database routing system according to an embodiment of the present invention includes a business data request unit, a data source switching unit, and a business data processing unit, and the data source switching unit is respectively connected to the business data requesting unit and the business data processing unit.

[0096] Wherein, the service data requesting unit is used to initiate a service data processing request including a shard key, and the shard key is used to determine the distribution of the service data in the shard database.

[0097] The data source switching unit is used to obtain fragmentation element mapping data according to the fragmentation key; obtain a target fragmentation database instance including business data according to the fragmentation element ...

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 fragmented database routing method, system and device and a storage medium, and relates to the database technology, and the fragmented database routing method comprises the steps that a client initiates a business data processing request comprising fragmented keys, and the fragmented keys are used for determining the distribution of business data in a fragmented database;the client obtains fragmentation element mapping data according to the fragmentation key; the client acquires a target fragmentation database instance including the service data according to the fragmentation meta-mapping data; and the client uses the target fragmentation database instance to route the service data processing request to the target fragmentation database. According to the fragmented database routing method, the service data processing request is directly routed to the target fragmented database, and the central database is bypassed, so that the utilization rate of the fragmented database is improved, the load pressure of the central database is reduced, and the fault probability of the central database is reduced.

Description

technical field [0001] The present invention relates to database technology, in particular to a routing method, system, equipment and storage medium for fragmented databases. Background technique [0002] In the era of mobile Internet, with the explosive growth of business data, database sharding has become a common data optimization technology, that is, the database is divided into multiple different sharded databases (Sharded Database, SDB), so as to alleviate the performance of a single database. question. However, after the database is fragmented, the processing of business data in the existing technology mostly depends on the central database, routing through the central database, or using routing mapping to reverse and interact with the data of the fragmented database, thereby increasing the central database and Due to the pressure and overhead of data routing, once the central database fails, the entire business will be paralyzed, and there may even be a risk of data...

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/22
CPCG06F16/217G06F16/2255
Inventor 何瑞星
Owner 卓望数码技术(深圳)有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap