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

ID processing method in distributed database, management system and server

A management system and processing method technology, applied in the ID processing method in distributed database, management system and server field, can solve performance bottlenecks, performance impact, hardware maintenance and upgrade costs and other problems, and achieve the goal of reducing performance consumption and frequency. Effect

Active Publication Date: 2017-12-29
ZTE CORP +1
View PDF9 Cites 9 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The traditional centralized database system also shows its shortcomings: the use of centralized management will inevitably cause performance bottlenecks, and the single improvement of hardware performance can no longer meet the current needs of large data volume and high concurrent query writing on the Internet. Incur substantial hardware maintenance and upgrade costs
In related technologies, the generation method of the globally unique ID will cause certain performance bottlenecks in the distributed database system and the ID server. For example, when the client sends out an ID application, the distributed database management system needs to send the application to the ID server, the ID server generates the corresponding ID and then is distributed to the client by the distributed database management system
With the continuous increase of business volume and the emergence of high concurrency during peak hours, such an ID processing method will cause the performance of the distributed database system to be affected due to frequent ID applications.

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
  • ID processing method in distributed database, management system and server
  • ID processing method in distributed database, management system and server
  • ID processing method in distributed database, management system and server

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0093] Figure 8 is a schematic diagram of an ID generation process according to Embodiment 1 of the present invention. The ID in Embodiment 1 is a sequentially generated sequence value, such as image 3 , Figure 8 As shown, the ID generation process includes:

[0094] The ID server receives the ID generation request sent by the distributed database management system, wherein the ID generation request includes ID quantity information;

[0095] The ID quantity information may be carried by the client when sending the ID application to the distributed database management system, or may be added by the distributed database management system when sending the ID generation request to the ID server according to the ID application.

[0096] The ID server queries whether there is an available ID in the locally stored ID storage table according to the ID generation request;

[0097] The available IDs to be queried in this step refer to the part of IDs that are written back to the I...

Embodiment 2

[0102] Figure 9 It is a schematic diagram of the ID application process according to Embodiment 2 of the present invention. The ID in Embodiment 2 is a sequentially generated sequence value, and the sequence value is obtained by hash calculation, such as image 3 , Figure 9 As indicated, the application process includes:

[0103] The distributed database management system receives the ID application sent by the client and obtains the client's demand information. According to the above ID demand information, the distributed database management system inquires whether there is an ID that meets the demand in the session area of ​​the current link, that is, the sequence value . The session area is on the side of the distributed database system.

[0104] When it is found that there is an available sequence value in the session area of ​​the current link and can meet the needs of the current business, the sequence value is directly assigned to the client for use. Then update t...

Embodiment 3

[0113] Because in the embodiment of the present invention, the number of IDs cached in the session area of ​​the current link is likely to exceed the number actually needed, if these redundant and unused IDs are not returned to the ID server at the end of the session, these IDs will be lost in the distributed database system. In order to prevent waste caused by ID loss and possible sequence holes, the embodiment of the present invention provides a solution. Figure 10 It is a schematic diagram of the ID recycling process according to Embodiment 3 of the present invention. The ID in Embodiment 3 is a sequentially generated sequence value, and the sequence value is obtained by hash calculation, such as image 3 , Figure 10 As shown, the process includes:

[0114] After the ID server receives the recycling notification message sent by the distributed database management system, it first inquires whether there is a matching queue with the above-mentioned unused ID (i.e. sequenc...

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 provides an ID processing method in a distributed database. The method comprises the following steps: sending an ID generation request to an ID server according to ID demand information of a client, wherein the ID demand information comprises session identification information and ID number information; receiving N ID returned by the ID server, wherein N is an integer and is greater than a number value in the ID number information; and caching the N ID in a session area corresponding to the session identification information. A certain number of preset ID are cached in the corresponding session area, thereby reducing the application frequency of the ID, and thus the performance consumption of the distributed database system is reduced to a large extent.

Description

technical field [0001] The invention relates to the field of distributed databases, in particular to an ID processing method, a management system and a server in the distributed database. Background technique [0002] With the maturity of traditional database technology and the rapid development of Internet applications, database applications have generally appeared on the Internet. The traditional centralized database system also shows its shortcomings: the use of centralized management will inevitably cause performance bottlenecks, and the single improvement of hardware performance can no longer meet the current needs of large data volume and high concurrent query writing on the Internet. Generate a lot of hardware maintenance and upgrade costs. In addition, the centralized management of databases often results in multi-database associations. Once a certain database crashes, it will cause the entire system to crash. Therefore, the development of distributed database syst...

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): H04L29/06G06F17/30
CPCG06F16/27G06F16/22H04L65/1066H04L65/1083G06F16/00H04L9/40
Inventor 丁岩陈小强李彦中
Owner ZTE CORP