Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

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

A successful and business technology, applied in the database field, it can solve the problems of limited application conditions, disordered primary key ID, and high system concurrency, achieving the effect of wide application scope and low configuration requirements

Pending Publication Date: 2022-03-11
CHINA CONSTRUCTION BANK
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

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

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
  • Primary key ID generation method and device, electronic equipment and storage medium
  • Primary key ID generation method and device, electronic equipment and storage medium
  • Primary key ID generation method and device, electronic equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0051] Reference will now be made in detail to the exemplary embodiments, examples of which are illustrated in the accompanying drawings. When the following description refers to the accompanying drawings, the same numerals in different drawings refer to the same or similar elements unless otherwise indicated. The implementations described in the following exemplary embodiments do not represent all implementations consistent with this application. Rather, they are merely examples of apparatuses and methods consistent with aspects of the present application as recited in the appended claims.

[0052] The term "plurality" in this application means two or more. The term "and / or" in this application is only an association relationship describing associated objects, which means that there may be three relationships, for example, A and / or B, which may mean: A exists alone, A and B exist simultaneously, and A and B exist alone. There are three cases of B. In addition, the characte...

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 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...

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
IPC IPC(8): G06F16/23G06F16/22G06F16/2458
CPCG06F16/2365G06F16/2282G06F16/2474
Inventor 刘家志
Owner CHINA CONSTRUCTION BANK
Features
  • Generate Ideas
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More