Method and system for generating a serializing portion of a record identifier

• US 7,660,801 B2
• Filed: 06/09/2004
• Issued: 02/09/2010
• Est. Priority Date: 10/24/2003
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: Fuchs, Gerhard, Muno, Andreas
• Primary Examiner(s): Mofiz; Apu M
• Assistant Examiner(s): Nguyen; Cindy
• Application Number:
  US10/863,354
• Publication Number:
  US 20050091293A1
• Time in Patent Office: 2,071 Days
• Field of Search: 707/100, 707/7, 707/1
• US Class Current: 1/1
• CPC Class Codes: G06F 16/30 of unstructured textual data document management systems G06F16/93
• CPC Class Codes: Y10S 707/944 Business related
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

Embodiments of the present invention relate generally to software for automatically generating alphabetic or alphanumeric representations for assigning as serializing portions of record identifiers.

Claims

1. A computer-implemented method of managing record identifiers, comprising:

responsive to a request to generate a record identifier for a record according to a sequence of arbitrarily-assigned record identifiers;

determining a next number in a numeric sequence to be assigned;

comparing the next number to a rule set governing record identifiers, the rule set including a plurality of rules, each of which governs a mutually-exclusive interval of numeric ranges in the numeric sequence and each of which maps to a respective range of record identifiers;

identifying, from the comparison, an interval in which the next number lies;

converting the next number to a corresponding record identifier according to a conversion defined by a rule associated with the identified interval; and

assigning the corresponding record identifier to the record.

2. The computer-implemented method of claim 1, wherein the record identifier comprises multiple fields, including source identifying fields and a field assigned according to claim 1.

3. The computer-implemented method of claim 2, wherein the rule set defines, for each interval, a range of record identifiers that correspond to the interval and format for the record identifiers in the respective interval.

4. The computer-implemented method of claim 3, wherein the record identifiers have a predetermined character length and the rule set define formats at each character position therein.

5. The computer-implemented method of claim 4, wherein the converting comprises

iteratively, at each character position of the record identifier:

determining a number of permissible characters that can be assigned for the record identifier at the respective position,

performing a modulo division of a remainder value by the number of permissible characters, resulting in a modulus value and a subsequent remainder value,

converting the modulus value to a character of the record identifier, and

repeating the determining, performing and converting operations on the subsequent remainder value in a subsequent iteration;

wherein the next number is used as the remainder value of a first iteration.

6. The computer-implemented method of claim 1, wherein the rule sets define each interval by respective start and end points of record identifier values.

7. The computer-implemented method of claim 6, wherein the converting comprises

iteratively, at each character position of the record identifier:

determining from the start and end point of the identified interval a number of permissible characters that can be assigned for the record identifier at the respective position,

performing a modulo division of a remainder value by the number of permissible characters, resulting in a modulus value and a subsequent remainder value,

converting the modulus value to a character of the record identifier, and

repeating the determining, performing and converting operations on the subsequent remainder value in a subsequent iteration;

wherein the next number is used as the remainder value of a first iteration.

8. The computer-implemented method of claim 6, wherein the start and end points each are expressed in the rule sets as combinations of alphabetic characters.

9. The computer-implemented method of claim 6, wherein the start and end points each are expressed in the rule sets as combinations of numeric characters.

10. The computer-implemented method of claim 6, wherein the start and end points each are expressed in the rule sets as combinations of alphabetic and numeric characters.

17. The computer-implemented method of claim 1, wherein the next number is of a first format and the respective ranges of record identifiers are of respective formats, each respective format different from the first format.

18. The computer-implemented method of claim 1, wherein the rule set comprises:

a rule in which an interval of numeric range map to a respective range of record identifiers of numeric characters,

a rule in which an interval of numeric range map to a respective range of record identifiers of alphabetic characters, and

a rule in which an interval of numeric range map to a respective range of record identifiers of alphanumeric combination of characters.

19. The computer-implemented method of claim 1, wherein the rules of the rule set are set by a user.

20. The computer-implemented method of claim 1, wherein the rule set is a stored table.

11. A machine-readable medium comprising computer-executable instructions to:

determine, in response to a request to generate a record identifier for a record according to a sequence of arbitrarily-assigned record identifiers, a next number in a numeric sequence to be assigned;

compare the next number to a rule set governing record identifiers, the rule set including a plurality of rules, each of which governs a mutually-exclusive interval of numeric ranges in the numeric sequence and each of which maps to a respective range of record identifiers;

identify, from the comparison, an interval in which the next number lies;

convert the next number to a corresponding record identifier according to a conversion defined by a rule associated with the identified interval; and

assign the record identifier to the record.

12. The medium of claim 11, wherein the rule set defines, for each interval, a range of record identifiers that correspond to the interval and format for record identifiers in the respective interval.

13. The medium of claim 12, wherein the record identifiers have a universal character length for all intervals and the rule set define formats at each character position therein.

14. The medium of claim 13, wherein the conversion comprises

iteratively, at each character position of the record identifier:

determining a number of permissible characters that can be assigned for the record identifier at the respective position,

performing a modulo division of a remainder value by the number of permissible characters, resulting in a modulus value and a subsequent remainder value,

converting the modulus value to a character of the record identifier, and

repeating the determining, performing and converting operations on the subsequent remainder value in a subsequent iteration;

wherein the next number is used as the remainder value of a first iteration.

15. The medium of claim 11, wherein the rule sets define each interval by respective start and end points of record identifier values.

16. The medium of claim 15, wherein the conversion comprises:

iteratively, at each character position of the record identifier;

determining from the start and end point of the identified interval a number of permissible characters that can be assigned for the record identifier at the respective position,

performing a modulo division of a remainder value by the number of permissible characters, resulting in a modulus value and a subsequent remainder value,

converting the modulus value to a character of record field identifier, and

repeating the determining, performing and converting operations on the subsequent remainder value in a subsequent iteration;

wherein the next number is used as the remainder value of a first iteration.