A database primary key generation method suitable for distributed system

Abstract

The invention provides a database primary key generation method suitable for a distributed system, which belongs to the technical field of computer application and solves the problem of primary key conflict of a traditional distributed system. Because the traditional distributed system has multiple terminals, each independent terminal transaction may operate the database at the same time, which iseasy to cause database primary key conflict. To solve this problem, the sequence number and timestamp mechanism are used to avoid primary key collision. Specifically: when the terminal of the distributed system needs to insert data into the database, the current timestamp is generated first, then the timestamp is stitched with the sequence number generated by the program, and finally the primarykey of the database is formed. Because the sequence number is unique, it ensures that the primary key inserted into the database is also unique. The invention can effectively solve the primary key conflict problem caused by the transaction operation of the distributed system, and ensures the uniqueness of the primary key in the database. Compared with the existing method, it is simple and efficient.

Description

technical field [0001] The invention relates to the field of computer application technology, in particular to a method for generating a database primary key suitable for a distributed system. Background technique [0002] When designing a distributed system, when multiple terminals in the distributed system simultaneously add more data items, a data item operation primary key conflict will occur. At this time, the uniqueness of the database primary key is broken, causing obstacles to subsequent operations such as query. [0003] The current mainstream database primary key generation methods are mainly auto-increment strategy and UUID primary key generation strategy. The auto-increment strategy generates integer-type primary keys incrementally, but this method is not suitable for distributed systems. The UUID primary key generation strategy can effectively guarantee the global uniqueness of the primary key of each data item generated by the new data item operation, but UUID...

AI Technical Summary

Problems solved by technology

[0005] The invention provides a database primary key generation method suitable for distributed systems, which can effectively solve the problem of primary key conflicts in traditional distributed systems

Images