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

Self-adaptive routing database sharding method and system

A sub-database, sub-table, and self-adaptive technology, applied in the field of database query, can solve problems such as business impact and long cycle, and achieve the effect of non-perceptual expansion operation

Pending Publication Date: 2021-01-01
HANGZHOU TUYA INFORMATION TECH CO LTD
View PDF6 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The overall process cycle will be relatively long, which will have a greater impact on the business

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
  • Self-adaptive routing database sharding method and system
  • Self-adaptive routing database sharding method and system
  • Self-adaptive routing database sharding method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0045] In order to enable those skilled in the art to better understand the solution of the present application, the technical solution in the embodiment of the application will be clearly and completely described below in conjunction with the accompanying drawings in the embodiment of the application. Obviously, the described embodiment is only It is an embodiment of a part of the application, but not all of the embodiments. Based on the embodiments in this application, all other embodiments obtained by persons of ordinary skill in the art without creative efforts shall fall within the scope of protection of this application.

[0046] It should be noted that the terms "first" and "second" in the description and claims of the present application and the above drawings are used to distinguish similar objects, but not necessarily used to describe a specific sequence or sequence. It should be understood that the data so used may be interchanged under appropriate circumstances for...

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 self-adaptive routing database sharding method and system, which comprises the following steps of: establishing a rule table, and maintaining a database sharding data volume;establishing a mapping relationship between business dimension and database sharding newly adding a record of a business dimension value according to the mapping relationship; obtaining a database sharding record according to the rule table and a first preset rule; inserting the business dimension value and a database sharding into a routing table; acquiring the record according to the routing table; querying, modifying or deleting the record of the business dimension value; obtaining a specified database sharding from the routing table according to the business dimension value, and obtaininga discovered record; and obtaining the record according to the discovered record. The weight of the database sharding business dimension is considered, the data volume corresponding to each table ofthe database sharding is maintained, the mapping relationship between the business dimension value and the database sharding is established, and routing is performed according to the mapping relationship, so that the specified record is found, and the problem of unbalanced data volume for database sharding caused by a hash sub-table is avoided.

Description

technical field [0001] The present application relates to the field of database query, and in particular, relates to an adaptive route sub-database and table sub-method. Background technique [0002] In today's increasingly mature informatization, it has become a trend to use the Internet to realize the platformization of various industries. One of the more important and difficult problems that will be faced in the process of platformization is the problem of large data volume business data storage. This method is mainly applied to a scene of self-adaptive sub-database sub-table for large-volume business storage. Facing the ever-increasing business data, sub-database and sub-table is an effective technical means to solve storage and query bottlenecks. The traditional sub-database and table sub-method generally adopts the hash sub-database and sub-table method, and performs hierarchical routing according to a certain business dimension according to the hash value, first fin...

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/22G06F16/242
CPCG06F16/2282G06F16/2428
Inventor 李停王亚东
Owner HANGZHOU TUYA INFORMATION TECH CO LTD