Database identifier generation in transaction processing systems
First Claim
Patent Images
1. A computer system for identifier generation in transaction processing systems, comprising:
- one or more computer processors;
one or more computer readable storage medium; and
program instructions stored on the computer readable storage medium for execution by at least one of the one or more processors, 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 that respectively represent either an instance range or a partition range, wherein a definition of the secondary range includes a maximum number of values in the 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 the primary range and the secondary range, wherein calculating the offset values includes;
determining a first product by multiplying a value included in the primary range and the maximum number of values in the secondary range;
adding the first product to a value included in the secondary range to generate a first total; and
multiplying the first total by the maximum number of values in the unique sequence range;
program instructions to add the offset value to the unique sequence value to generate an identifier value for a database; and
program instructions to process a transaction of a plurality of transactions by using the identifier value as a database primary key in a database of a transaction processing system.
1 Assignment
0 Petitions
Accused Products
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.
-
Citations
18 Claims
-
1. A computer system for identifier generation in transaction processing systems, comprising:
-
one or more computer processors; one or more computer readable storage medium; and program instructions stored on the computer readable storage medium for execution by at least one of the one or more processors, 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 that respectively represent either an instance range or a partition range, wherein a definition of the secondary range includes a maximum number of values in the 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 the primary range and the secondary range, wherein calculating the offset values includes; determining a first product by multiplying a value included in the primary range and the maximum number of values in the secondary range; adding the first product to a value included in the secondary range to generate a first total; and multiplying the first total by the maximum number of values in the unique sequence range; program instructions to add the offset value to the unique sequence value to generate an identifier value for a database; and program instructions to process a transaction of a plurality of transactions by using the identifier value as a database primary key in a database of a transaction processing system. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9)
-
-
10. 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 that initiate a generation of an identifier based, at least in part, on definitions of both a primary range and a secondary range that respectively represent either an instance range or a partition range, wherein a definition of the secondary range includes a maximum number of values in the secondary range; program instructions that obtain a unique sequence value from a unique sequence range of known maximum number of values; program instructions that calculate an offset value based on the primary range and the secondary range, wherein calculating the offset value includes; determining a first product by multiplying a value included in the primary range and the maximum number of values in the secondary range; adding the first product to a value included in the secondary range to generate a first total; and multiplying the first total by the maximum number of values in the unique sequence range; program instructions that add the offset value to the unique sequence value to generate an identifier value for a database; and program instructions that processes a transaction of a plurality of transactions by using the identifier value as a database primary key in a database of a transaction processing system. - View Dependent Claims (11, 12, 13, 14, 15, 16, 17, 18)
-
Specification