Method of serial number generation based on database system

Abstract

The invention discloses a serial number generating method based on a database system. Serial numbers are used for distinguishing services in a plurality of single machines in communication with a database, and the serial number generating method comprises the steps that when a serial number distributing request proposed by a serial number request process accessing the database is received, a section of continuous serial numbers with a current first usable serial number as a head is distributed to a serial number service process; the serial numbers distributed to the serial number service process are eliminated from the current usable serial numbers. Through the method, the performance of the system can be improved, and stable services can still be provided when problems occur to the database system.

Description

technical field [0001] The present invention generally relates to a database system, and in particular relates to a technology for allocating serial numbers to services in a single machine communicating with a database. Background technique [0002] In a distributed computer system composed of a database and multiple stand-alone machines that interact with the database and independently process business, in order to distinguish multiple businesses carried out in each stand-alone machine, it is necessary to assign a unique serial number to each business, The value of the serial number is cyclically repeated within a certain range, and does not appear repeatedly within a certain time range. In order to maintain high reliability and high concurrent processing capabilities of the system, most of the current distributed computer systems adopt a distributed and parallel system architecture, but the serial number allocation still needs to be generated in an overall and unified mann...

AI Technical Summary

Problems solved by technology

[0003] 1. In the case of multiple machines and multiple applications, the centralized allocation of serial numbers will have a greater adverse effect on system performance;

[0004] 2. Lack of the ability to maintain the consistency of the system serial number during the master / standby switching process of the system;

[0005] 3. After the system recovers from the failure caused by the host or database, the system serial number is easy to repeat

[0006] At present, there is no solution that can solve the above problems well

Images