Database primary key acquisition method and device

An acquisition method and database technology, applied in the fields of database primary key acquisition device, database primary key acquisition method, computer-readable storage medium and electronic equipment, can solve problems such as unavailable business systems, slow performance, and unavailable systems, and achieve high availability Unique ID service, the effect of improving service performance

Active Publication Date: 2018-12-07
BEIJING JINGDONG SHANGKE INFORMATION TECH CO LTD +1
View PDF6 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The disadvantages of related technologies are: under high concurrent calls, a large number of inserts into the same table and an increase in the amount of data will cause very slow performance, and even cause the database to go down and the system to be unavailable
In addition, once the database that provides the unique ID goes down or is unavailable due to network problems, the entire business system will also be unavailable, and there is a single point of problem
Finally, if there are business tables that also need to obtain unique ID services, then another set of database servers needs to be deployed, resulting in waste of resources and poor scalability

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 primary key acquisition method and device
  • Database primary key acquisition method and device
  • Database primary key acquisition method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0055] Example embodiments will now be described more fully with reference to the accompanying drawings. Example embodiments may, however, be embodied in many forms and should not be construed as limited to the examples set forth herein; rather, these embodiments are provided so that this disclosure will be thorough and complete and will fully convey the concept of example embodiments to those skilled in the art. The described features, structures, or characteristics may be combined in any suitable manner in one or more embodiments.

[0056] Furthermore, the drawings are merely schematic illustrations of the present disclosure and are not necessarily drawn to scale. The same reference numerals in the drawings denote the same or similar parts, and thus repeated descriptions thereof will be omitted. Some of the block diagrams shown in the drawings are functional entities and do not necessarily correspond to physically or logically separate entities. These functional entities ...

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 relates to a database primary key acquisition method and device, a storage medium and electronic equipment. The method comprises the following steps: the primary key ID of at least a part of single data in each data table is preloaded into a corresponding queue from a plurality of data tables; receiving a service operation request and determining the current data table correspondingto the service operation request according to parameters carried by the service operation request; obtaining the queue corresponding to the current data table and obtaining the primary key ID of a piece of data corresponding to the service operation request from the queue corresponding to the current data table; and the preset binary algorithm is applied to perform preset binary calculation on theprimary key ID of one piece of data so as to obtain the unique primary key ID of one piece of data. The ID can be directly obtained from the queue without accessing the database so that the service performance can be greatly enhanced, the higher-performance unique ID service can be provided and the performance of the obtained unique primary key ID in the case of a large number of high concurrencycalls can be enhanced.

Description

technical field [0001] The present disclosure relates to the field of computer technology, and in particular to a method for obtaining a database master key, a device for obtaining a database master key, and a computer-readable storage medium and electronic equipment for realizing the method for obtaining a database master key. Background technique [0002] At this stage, with the growth of data volume and data access, the storage of data information has undergone tremendous changes compared with the past. The most obvious is the extensive use of sub-database and sub-table technology. Store a large amount of data in multiple database machines and multiple tables to solve the problems of database performance and storage space caused by a single form library, and facilitate data expansion. The amount of data in the database is not necessarily controllable. Without sub-database sub-tables, with the development of time and business, there will be more and more tables in the 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): G06F17/30
Inventor 马文军
Owner BEIJING JINGDONG SHANGKE INFORMATION TECH CO LTD
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