Database primary key generating device and database primary key generating method

A technology for generating a device and a database, applied in the computer field, can solve the problem that the self-incrementing field scheme cannot meet the requirements, etc.

Active Publication Date: 2013-01-16
YONYOU NETWORK TECH CO LTD
View PDF4 Cites 25 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Obviously, the GUID scheme can ensure that the primary key is still unique in a distributed environment, but the auto-increment field scheme cannot meet the requirements

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0031] In order to understand the above-mentioned purpose, features and advantages of the present invention more clearly, the present invention will be further described in detail below in conjunction with the accompanying drawings and specific embodiments.

[0032]In the following description, many specific details are set forth in order to fully understand the present invention, but the present invention can also be implemented in other ways different from those described here, therefore, the present invention is not limited to the specific embodiments disclosed below limit.

[0033] figure 1 A block diagram of a database primary key generating device according to an embodiment of the present invention is shown.

[0034] Such as figure 1 As shown, the database master key generation device 100 according to the embodiment of the present invention includes: a reading unit 102, which reads a preset master key configuration table, and obtains the site number of the data center ...

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 a database primary key generating device comprising a reading unit and a primary key generating unit. The reading unit reads a preset primary key configuration list and acquires site codes of a data center from the primary key configuration list. The primary key generating unit reads a primary distribution list according to the acquired site codes, acquires the maximum value of a primary key recorded in the primary key distribution list and acquires distributable values for the primary key currently according to the maximum value of the primary key, and the primary key includes the side codes of the data center and the date of generating the primary key and serial numbers. According to the technical scheme, high-performance primary key of the database can be acquired, so that the primary key has the advantages of visuality and easiness like service codes and can support the distribution type data deployment environment. The invention further provides a database primary key generating method.

Description

technical field [0001] The invention relates to the technical field of computers, in particular to a database primary key generation device and a database primary key generation method. Background technique [0002] In software system development, if you need to use the database system to store and manage data, you cannot avoid the design of the database primary key. A good database primary key design has the characteristics of high efficiency, ease of use and reliability. At present, the mainstream generation methods of database primary keys include database self-increment field method and GUID (Global Uniform Identifier) ​​method. The self-increment field method is implemented by the database self-increment type field, which is automatically generated and maintained by the database, and uniqueness is ensured. The GUID method is to use the unique characteristics of the machine hardware (such as the uniqueness of the MAC address of the network card) combined with the gener...

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 YONYOU NETWORK 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