Primary key ID generation method and device, electronic equipment and storage medium

Abstract

The invention relates to the technical field of databases, and provides a primary key ID generation method and device, electronic equipment and a storage medium, applied to a first business system, the method comprises the following steps: receiving a business request; the service request is a service request successfully processed by the second service system; determining the number of to-be-generated primary key IDs based on the service request; if the number of the primary key IDs to be generated is multiple, generating a global tracking serial number, multiple first primary key IDs and first business elements corresponding to the primary key IDs based on the business request, and calling corresponding second primary key IDs and second business elements in a second business system based on the global tracking serial number, and updating the first primary key ID based on a comparison result of the first business element and the second business element. Therefore, the consistency of the primary key IDs stored in the databases in the systems of the two parties is guaranteed, a foundation is laid for double-sending account following of transaction of the systems of the two parties, and the method is low in configuration requirement and wide in application range.

Description

technical field [0001] The present application relates to the technical field of databases, and in particular to a primary key ID generation method, device, electronic equipment and storage medium. Background technique [0002] With the continuous development and changes of international trade, many banks are stepping up IOE work, that is, removing International Business Machines Corporation (IBM) minicomputers, Oracle databases, and EMC storage in Alibaba's IT architecture. Devices are gradually adjusted to a distributed architecture. The new core system of the bank usually adopts a distributed architecture, which is quite different from the old mainframe architecture system. How to ensure the unique code (Identity Document, ID) of the primary key of the database of the new and old systems in the stage of data comparison between the new and old systems? Consistency is the key to the success of data-to-account comparison. For example, the primary key ID can be customer numb...

AI Technical Summary

Problems solved by technology

[0004] However, the method of using the database primary key auto-increment mechanism to generate the primary key ID is only applicable when the logic of the new system and the old system are highly consistent, and the configuration requirements are relatively high. If a transaction is successfully processed in the old system but fails in the new system, then It will lead to confusion of the primary key IDs generated by the new and old systems; the way of generating primary key IDs by splicing timestamps and specific business fields has limited applicable conditions. It must be ensured that the clocks of the old and new systems are completely consistent, and the system concurrency cannot be very high. Otherwise, the primary key ID will be confused; the method of using a third-party number generation system to generate the primary key ID requires both the new system and the old system to have the conditions for outbound calls. At present, the architecture of the old system application of many banks does not allow outbound calls. The applicable scenarios of this solution are as follows: limitation

Images