DATABASE IDENTIFIER GENERATION IN TRANSACTION PROCESSING SYSTEMS

• US 20160239530A1
• Filed: 02/12/2015
• Published: 08/18/2016
• Est. Priority Date: 02/12/2015
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Dunne, Sean K., Flint, Martin A., McGrath, Peter, Harpur, Liam S.
• Granted Patent: US 10,169,395 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/21 Design, administration or maintenance of databases
• CPC Class Codes: G06F 16/2282 Tablespace storage structures; Management thereof
• CPC Class Codes: G06F 16/2365 Ensuring data consistency and integrity
• CPC Class Codes: G06F 16/2379 Updates performed during online database operations; commit processing

Abstract

One or more processors initiate generation of an identifier based on the definitions of both a primary range and a secondary range. One or more processors obtain a unique sequence value from a unique sequence range of known maximum number of values. One or more processors calculate an offset value based on, at least in part, the primary range and the secondary range. One or more processors add the offset value to the unique sequence value to generate an identifier value.

Claims

1-11. -11. (canceled)

12. A system for identifier generation in transaction processing systems, comprising:

an initiating component configured to initiate a generation of an identifier based, at least in part, on definitions of both a primary range and a secondary range;

a unique sequence value obtaining component configured to obtain a unique sequence value from a unique sequence range of known maximum number of values;

an offset component configured to calculate an offset value based on, at least in part, the primary range and the secondary range; and

an identifier value component configured to add the offset value to the unique sequence value to generate an identifier value.

13. The system as claimed in claim 12, wherein the setting component includes a database aligning component, and wherein one or both of the primary range the secondary range are aligned to a partitioned database.

14. The system as claimed in claim 12, including:

a new identifier value request component configured to receive a new identifier value request; and

a new identifier offset component configured to determine whether a new offset value is required.

15. The system as claimed in claim 12, wherein the primary range defines a range of database instances, and the secondary range defines a range of database partitions.

16. The system as claimed in claim 12, wherein the primary range defines a range of client identifiers, and the secondary range defines a range of database partitions allocated per client.

17. The system as claimed in claim 12, wherein the primary range and the secondary range in combination define a range of database partitions.

18. The system as claimed in claim 12, wherein the primary range defines a range of values based on business content, and the secondary range defines a range of database partitions.

19. The system as claimed in claim 12, wherein the offset component configured to calculate an offset value is configured to:

determine a first product by multiplying a value included in the primary range and the maximum number of values in the secondary range;

add the first product to a value included in the secondary range to generate a first total; and

multiply the first total by the maximum number of values in the unique sequence range to.

30. The system as claimed in claim 14, wherein the offset component is configured to respond to a determination that the new offset value is required by calculating the new offset value.

31. The system as claimed in claim 14, wherein the new identifier offset component is configured to determine whether it is the first time that the offset value is required for an individual activity based, at least in part, on a determination of whether the new offset value is required.

20. A computer program product for identifier generation in transaction processing systems, the computer program product comprising:

one or more computer-readable storage media and program instructions stored on the one or more computer-readable storage media, the program instructions comprising;

program instructions to initiate a generation of an identifier based, at least in part, on definitions of both a primary range and a secondary range;

program instructions to obtain a unique sequence value from a unique sequence range of known maximum number of values;

program instructions to calculate an offset value based on, at least in part, the primary range and the secondary range; and

program instructions to add the offset value to the unique sequence value to generate an identifier value.

21. The computer program product as claimed in claim 20, wherein one or both of the primary range and the secondary range are aligned to a partitioned database.

22. The computer program product as claimed in claim 20, including:

program instructions to receive a new identifier value request;

program instructions to determine whether a new offset value is required; and

program instructions to respond to a determination that the new offset value is required by calculating a new offset value.

23. The computer program product as claimed in claim 22, including:

program instructions to determine whether it is the first time that the offset value is required for an individual activity based, at least in part, on whether the new offset value is required.

24. The computer program product as claimed in claim 20, wherein the primary range defines a range of database instances, and the secondary range defines a range of database partitions.

25. The computer program product as claimed in claim 20, wherein the primary range defines a range of client identifiers, and the secondary range defines a range of database partitions allocated per client.

26. The computer program product as claimed in claim 20, wherein the primary range and the secondary range in combination define a range of database partitions.

27. The computer program product as claimed in claim 20, wherein the primary range defines a range of values based on business content, and the secondary range defines a range of database partitions.

28. The computer program product as claimed in claim 20, including:

program instructions to define, at least in part, the primary range and a secondary range based on a maximum number of values in the secondary range;

wherein the program instructions to calculate the offset value include;

program instructions to determine a first product by multiplying a value included in the primary range and the maximum number of values in the secondary range;

program instructions to add the first product to a value included in the secondary range to generate a first total; and

program instructions to multiply the first total by the maximum number of values in the unique sequence range.

29. The computer program product as claimed in claim 20, wherein the primary range and the secondary range are defined, at least in part, based on a number of binary digits for the primary range and a number of binary digits for the secondary range.