JP6193625B2 - Identification information issuing device, identification information issuing method, and identification information issuing program - Google Patents

Description

  The present invention relates to an identification information issuing device, an identification information issuing method, and an identification information issuing program.

  In paragraph 0047 and FIG. 7 of Patent Document 1, an available ID number file storing ID numbers that can be assigned to terminals (for example, serial ID numbers) and ID numbers determined to be reusable are stored. A reuse ID number file is disclosed. In paragraphs 0027 to 0029 of FIG. 2 and FIG. 2, an ID numbering DB 13 for managing numbered IDs (numbered IDs, “in use” / “empty (not reused)” / DB that holds any status of “tag failure”, etc. is disclosed.

JP 2005-159516 A JP 2010-277188 A

  However, in both Patent Document 1 and Patent Document 2, number reuse is possible, but since number reuse is not prioritized over new numbering, the efficiency of number issuance (specifically, finite There is a problem that there is still room for improvement in terms of using number resources without waste.

  The present invention has been made in view of the above, and provides an identification information issuing device, an identification information issuing method, and an identification information issuing program capable of improving the efficiency of issuing identification information (for example, a number). With the goal.

  In order to solve the above-described problems and achieve the object, an identification information issuing device according to the present invention is an identification information issuing device including a control unit and a storage unit, and the storage unit is generated in the past. First storage means for storing generated identification information specifying information for specifying generated identification information that is identification information, and second storage for storing unused generated identification information that is the generated identification information that is not used Means for acquiring the unused generated identification information from the second storage means, and when the acquisition means cannot acquire the unused generated identification information, Generating means for generating the identification information different from the generated identification information with reference to the generated identification information specifying information stored in the first storage means.

  Here, the identification information may be composed of, for example, numbers, characters, symbols, figures, or combinations thereof.

  The identification information issuing device according to the present invention is the identification information issuing device, wherein the second storage means associates the unused generated identification information with the unused generated identification information in association with the unused generated identification information. It is further characterized by further storing usability information regarding the reason for use and whether or not the non-use generated identification information can be used.

  The identification information issuing device according to the present invention is the identification information issuing device, wherein the first storage unit and the second storage unit store information for each use in which the identification information is used, It is characterized by.

  In the identification information issuing device according to the present invention, in the identification information issuing device, the acquisition unit acquires the unused generated identification information from the second storage unit up to a predetermined number, and generates the generation information. When the acquisition unit cannot acquire any of the unused generated identification information, the unit refers to the generated identification information specifying information stored in the first storage unit, and the predetermined number of the identification information And the acquisition means can acquire the unused generation identification information less than the predetermined number with reference to the generated identification information specifying information stored in the first storage means. The number of pieces of the identification information that has been acquired by the means is generated by subtracting the number of the pieces of unused generated identification information from the predetermined number.

  In the identification information issuing device according to the present invention, in the identification information issuing device, the identification information corresponds to an order scale, and the obtaining unit continuously receives the predetermined number from the second storage unit. The unused generated identification information is acquired, and the generating unit stores in the first storage unit when the acquiring unit cannot acquire the predetermined number of unused generated identification information consecutively. The continuous predetermined number of pieces of the identification information are generated with reference to the generated identification information specifying information.

  Further, the identification information issuing device according to the present invention is the identification information issuing device, wherein the acquisition means is the predetermined number of the consecutively generated unused identification information, and the earliest included in these The non-used generated identification information immediately before the non-used generated identification information is not present in the second storage means, and the last non-used generated identification information included therein is 1 What is obtained after the second non-use generated identification information does not exist in the second storage means is obtained from the second storage means.

  In the identification information issuing device according to the present invention, the generated identification information specifying information may be the generated identification information, and the generated identification information after the generated identification information. The generated identification information different from that does not exist.

  In the identification information issuing device according to the present invention, in the identification information issuing device, the generation unit may store the generated identification information stored in the first storage unit after the predetermined number or the predetermined number. The number is updated by subtracting the number of unused generated identification information acquired by the acquisition means from the number, and the updated generated identification information, the predetermined number, and the acquisition means can be acquired. Further, the predetermined number of consecutive or the number of subtracted pieces of identification information is generated based on the number of the unused generated identification information.

  Further, the identification information issuing device according to the present invention is characterized in that, in the identification information issuing device, the control unit further comprises a return means for storing the generated identification information in the second storage means. To do.

  The identification information issuing method according to the present invention is an identification information issuing method executed in an identification information issuing apparatus including a control unit and a storage unit, and the storage unit is identification information generated in the past. First storage means for storing generated identification information specifying information for specifying generated identification information, and second storage means for storing unused generated identification information that is the generated identification information that is not used. The acquisition step of acquiring the unused generated identification information from the second storage means, which is executed in the control unit, and when the unused generated identification information cannot be acquired in the acquiring step, A generation step of generating the identification information different from the generated identification information with reference to the generated identification information specifying information stored in one storage means.

  An identification information issuing program according to the present invention is an identification information issuing program for execution in an identification information issuing apparatus including a control unit and a storage unit, and the storage unit is identification information generated in the past. First storage means for storing generated identification information specifying information for specifying certain generated identification information; second storage means for storing non-used generated identification information that is the generated identification information that is not used; An acquisition step of acquiring the unused generated identification information from the second storage means for execution in the control unit, and when the unused generated identification information could not be acquired in the acquisition step, Generating the identification information different from the generated identification information with reference to the generated identification information specifying information stored in the first storage means, And features.

  An identification information issuing system according to the present invention is an identification information issuing system in which an identification information storage device including a storage unit and an identification information issuing device including a control unit are communicably connected to each other. The first storage means for storing generated identification information specifying information for specifying generated identification information that is identification information generated in the past, and unused unused generated identification information that is not used Second storage means for storing information, and the control unit obtains the unused generated identification information from the second storage means, and acquires the unused generated identification information by the acquiring means. A generation unit configured to generate the identification information different from the generated identification information with reference to the generated identification information specifying information stored in the first storage unit when the information cannot be acquired; Characterize

  The identification information issuing device according to the present invention is an identification information issuing device having a control unit, which is communicably connected to an identification information storage device having a storage unit, wherein the storage unit is generated in the past. A first storage means for storing generated identification information specifying information for specifying the generated identification information that is generated identification information, and a second storage for storing unused generated identification information that is the generated generated identification information that is not used. Storage means, and the control unit acquires the unused generated identification information from the second storage means, and if the acquisition generated identification information could not be acquired by the acquiring means, Generating means for generating the identification information different from the generated identification information with reference to the generated identification information specifying information stored in the first storage means.

  According to the present invention, the storage unit includes a first storage unit that stores the generated identification information specifying information and a second storage unit that stores the non-used generated identification information, and the control unit stores the second storage unit. When the unused generated identification information is acquired from the means and the unused generated identification information cannot be acquired, the generated identification information specifying information stored in the first storage means is referred to and is different from the generated identification information. Since the identification information is generated, it is possible to improve the efficiency of issuing the identification information (for example, a number).

  According to the present invention, since the second storage means further stores the reason for non-use and the availability information in association with the non-use generated identification information, it becomes possible to clearly explain the reason why it is no longer used. There is an effect that it can be realized.

  According to the present invention, since the first storage unit and the second storage unit store information for each application, the identification information can be issued for each application.

  According to the present invention, the control unit obtains the unused generated identification information from the second storage unit with a predetermined number as the upper limit, and if no unused generated identification information can be acquired, the first storage unit The generated identification information stored in the first storage means is generated when a predetermined number of identification information is generated with reference to the generated identification information specifying information stored in Since the number of pieces of unused generated identification information that can be acquired is subtracted from the predetermined number by referring to the identification information specifying information, a plurality of pieces of identification information are issued in response to a single issue request. There is an effect that it can be performed.

  According to the present invention, the identification information corresponds to the order scale, and the control unit obtains a continuous predetermined number of non-used generated identification information from the second storage means, and the continuous predetermined number of non-uses When the generated identification information could not be obtained, the generated identification information specifying information stored in the first storage means is referred to generate a predetermined number of pieces of identification information. There is an effect that a plurality of pieces of continuous identification information can be issued.

  According to the present invention, the control unit is a continuous predetermined number of unused generated identification information, and the unused generated generated identification immediately before the earliest unused generated identification information included therein. Information that does not exist in the second storage means, and in which there is no unused generated identification information after the last unused generated identification information included in the second storage means, Since it is obtained from the second storage means, it is possible to suppress an increase in discontinuous single identification information in the second storage means, and as a result, it is possible to efficiently reuse a plurality of continuous identification information. There is an effect.

  According to the present invention, the generated identification information specifying information is generated identification information, and there is no generated identification information different from the generated identification information after the generated identification information. There is an effect that identification information that has not been generated can be identified efficiently.

  According to the present invention, the control unit adds the generated identification information stored in the first storage means after the predetermined number or the number obtained by subtracting the number of unused generated identification information obtained from the predetermined number. Since the generated identification information after the update, the predetermined number, and the number of unused generated identification information that can be acquired, the identification information of the predetermined number or the subtracted number is generated. Even in a situation where a plurality of issuance requests are received at almost the same timing, there is an effect that it is possible to issue a plurality of continuous identification information for each issuance request.

  According to the present invention, since the generated identification information is stored in the second storage means, it is possible to promote the reuse of the generated identification information that is not used.

FIG. 1 is a block diagram illustrating an example of the configuration of a business management system. FIG. 2 is a diagram illustrating an example of the counter table 206a. FIG. 3 is a diagram illustrating an example of the reuse counter table 206b. FIG. 4 is a block diagram illustrating another example of the configuration of the business management system. FIG. 5 is a flowchart illustrating an example of the main process. FIG. 6 is a flowchart illustrating an example of the reuse counter number acquisition process. FIG. 7 is a diagram illustrating a specific example of information stored in the reuse counter table 206b. FIG. 8 is a flowchart illustrating an example of the counter number acquisition process. FIG. 9 is a flowchart illustrating an example of the number return process.

  Embodiments of an identification information issuing device, an identification information issuing method, and an identification information issuing program according to the present invention will be described in detail with reference to the drawings. In addition, this invention is not limited by this embodiment. Specifically, in this embodiment, a number defined by a number is used as identification information, and a difference between two adjacent numbers (interval between numbers) is 1 (for example, 1 of the number “1”). As an example, the next (next) number is “2” and the next number is “3”. However, the present invention is not limited to this case.

[1. Constitution]
An example of the configuration of a business management system including the present invention will be described with reference to FIG. FIG. 1 is a block diagram showing an example of the configuration of a business management system.

  The business management system includes one or a plurality of client terminals 100 (only one is illustrated in FIG. 1), a server device 200 including the identification information issuing device of the present invention, and a network 300.

  The network 300 is, for example, the Internet, an intranet, or a LAN (Local Area Network).

  The client terminal 100 is a stationary or portable information processing apparatus (for example, a desktop personal computer, etc.) in which a business application (for example, Web application) that supports business management (for example, sales management, inventory management, etc.) is installed. Notebook personal computers, PDA (Personal Digital Assistants), smart phones, tablet personal computers, and the like).

  The client terminal 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each unit included in the client terminal 100 is communicably connected via an arbitrary communication path.

  The control unit 102 is a CPU or the like that comprehensively controls the client terminal 100. The control unit 102 has an internal memory for storing a control program such as an OS, a program that defines various processing procedures, and necessary data, and performs various information processing based on these stored programs. Run.

  The communication interface unit 104 communicatively connects the client terminal 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with other devices via a communication line.

  The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 stores a computer program for giving various instructions to a CPU (Central Processing Unit) in cooperation with an OS (Operating System). As the storage unit 106, for example, a memory device such as a RAM (Random Access Memory) and a ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, and an optical disk can be used.

  An input device 112 and an output device 114 are connected to the input / output interface unit 108. As the output device 114, a speaker (including a home television), a speaker, and a printer can be used. As the input device 112, in addition to a keyboard, a mouse, and a microphone, a monitor that realizes a pointing device function in cooperation with the mouse can be used. In the following description, the output device 114 may be described as the monitor 114, and the input device 112 may be described as the keyboard 112 or the mouse 112.

  The server apparatus 200 stores business data (for example, order data, order data, purchase data, sales data, etc.) under the management of a business application.

  The server device 200 includes a control unit 202, a communication interface unit 204, and a storage unit 206. Each part with which the server apparatus 200 is provided is connected so that communication is possible via arbitrary communication paths.

  The communication interface unit 204 connects the server device 200 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 204 has a function of communicating data with other devices via a communication line.

  The storage unit 206 stores various databases, tables, files, and the like. The storage unit 206 stores a computer program for performing various processes by giving instructions to the CPU in cooperation with the OS. As the storage unit 206, for example, a memory device such as a RAM / ROM, a fixed disk device such as a hard disk, a flexible disk, and an optical disk can be used.

  The storage unit 206 includes a counter table 206a corresponding to the first storage unit of the present invention and a reuse counter table 206b corresponding to the second storage unit of the present invention.

  For each number type (corresponding to “use in which identification information is used” of the present invention), the counter table 206a is assigned a final number (“generated identification information of the present invention, This is a table in which the number identification (primary key) and the numbered final number are associated with each other and stored, for example. It is a table shown in FIG.

  Here, specific examples of number types in business management include orders, orders, purchases, sales, and the like. For example, when the number type is “order received”, the numbered final number stored in association with the number type corresponds to the order number.

  Returning to FIG. 1, the reuse counter table 206b includes a number that has not been used (corresponding to the non-used generation identification information of the present invention) and a reusable flag (usability information of the present invention) for each number type. And a reason for return (corresponding to a reason for non-use of the present invention), for example, a number type (primary key), a numbered number (primary key), a reusable flag, and a reason for return. 4 is a table shown in FIG. 3 stored in association with each other.

  Here, in the reusable flag, “True” indicating that reuse is possible or “False” indicating that reuse is not possible is set.

  In addition, for example, the reason why the numbered number is no longer used (for example, input cancellation, application error, registration error, etc.) is set as the return reason.

  Returning to FIG. 1, the control unit 202 is a CPU or the like that comprehensively controls the server device 200. The control unit 202 has an internal memory for storing a control program such as an OS, a program that defines various processing procedures, required data, and the like, and performs various information processing based on these stored programs. Run.

  In terms of functional concept, the control unit 202 includes a request reception unit 202a, an acquisition unit 202b (corresponding to the acquisition unit of the present invention), a generation unit 202c (corresponding to the generation unit of the present invention), and a return unit 202d (return unit of the present invention). Equivalent).

  The request reception unit 202a receives a number issue request (numbering request) and a number return request (return request) issued from a business application installed in the client terminal 100.

  Here, in the numbering request, for example, the number type (for example, the type ID “X” for specifying the number type, etc.), the reuse setting regarding whether to use the reuse counter table 206b (used) : No, not used: No), number of numbers to be numbered (N: N is an integer of 1 or more), and continuous numbering setting regarding whether or not consecutive numbers are numbered (continuous) Numbering: Yes, No continuous numbering: No), etc. are included.

  In addition, the return request includes, for example, a number type, an unused number, a return reason, a reusable flag (reusable: True, reusable: False), and the like.

  When the reuse setting is “Yes” and the consecutive numbering setting is “No”, the acquisition unit 202b has the type ID “X” and can be reused from the reuse counter table 206b. Numbered numbers whose flag is “True” are acquired in ascending order with N as the upper limit.

  In addition, when the reuse setting is “Yes” and the consecutive numbering setting is “Yes”, the acquisition unit 202b determines that the type ID is “X” from the reuse counter table 206b and the reuse setting is “Yes”. The available flag is “True” and N consecutive numbered numbers are acquired.

Note that the acquisition unit 202b has consecutive N numbered numbers, which is 1 from the earliest (first / first / first) numbered number included in the N numbered numbers. The previous numbered number (specifically, the number obtained by subtracting 1 from the first numbered number) does not exist in the reuse counter table 206b, and among the N numbered numbers Number in the reuse counter table 206b is one number after the last (Nth) numbered number (specifically, a number obtained by adding 1 to the Nth numbered number). Those not to be acquired may be acquired from the reuse counter table 206b.
For example, when a total of six numbers “1”, “2”, “4”, “6”, “7”, and “8” are stored in the reuse counter table 206b, When is 2, the two consecutive numbers are the following three patterns.
{“1”, “2”} (number set 1)
{“6”, “7”} (number set 2)
{“7”, “8”} (number set 3)
Here, the pair of the first (first) number and the last (second) number included in each number set is “1” and “2”, “6” and “7”, and “7”. ”And“ 8 ”, in each number set, a pair of a number one number before the first number and a number one number after the last number is as follows.
“0” and “3” (corresponding to number set 1)
“5” and “8” (corresponding to number set 2)
“6” and “9” (corresponding to number set 3)
No number exists in the reuse counter table 206b for the pair “0” and “3”, but “8” for the pair “5” and “8” in the reuse counter table 206b. For the pair of “6” and “9”, “6” exists in the reuse counter table 206b.
Accordingly, the number set 1 {“1”, “2”} corresponding to the pair “0” and “3” is acquired from the reuse counter table 206b.

When the reuse setting is “No”, or when the reuse setting is “Yes” and the acquisition unit 202b cannot acquire any numbered numbers, the generation unit 202c With reference to the numbered last number whose type ID is “X” stored in 206a, N consecutive new numbers including the number immediately after the numbered last number (next) are generated.
For example, when the assigned final number is “1”, the generation unit 202c generates N numbers from “2” to “N + 1”.

In addition, when the reuse setting is “Yes” and the acquisition unit 202b can acquire only n numbered numbers (n is an integer greater than or equal to 1 and less than N), the generation unit 202c has a counter table 206a. Referring to the numbered last number whose type ID is “X”, N−n consecutive new numbers including the number immediately after the numbered last number are generated.
For example, when the numbered number “2” can be acquired and the numbered final number is “3”, the generation unit 202c sets N−1 from the number “4” to the number “4+ (N−2)”. Number of pieces is generated.

Note that the generation unit 202c updates the numbered final number with the type ID "X" stored in the counter table 206a to the number after N if the number acquisition number in the acquisition unit 202b is zero, Also, if the number obtained is n, it is updated to the one after N-n, and N or N-n consecutive new numbers are generated with the last number after the number updated as the last number. Also good.
For example, if the numbered final number is “4”, the numbered final number is updated to “4 + N” if the number acquisition number is zero, and “4+ (N−) if the number acquisition number is n. n) ", N numbers from" 5 "to" 4 + N "or" 5 ", with the final number after the update being" 4 + N "or" 4+ (N-n) " N−n numbers from “4+ (N−n)” may be generated.
In this way, by updating the numbered final number in the counter table 206a before generating the number, even if the numbering requests are received almost simultaneously from the plurality of client terminals 100, the individual client terminals A number satisfying the request can be issued to 100.

  When the request receiving unit 202a receives a return request issued from a business application installed in the client terminal 100, the return unit 202d receives the number type, number assigned, reason for return, and reuse included in the return request. The possible flag is stored in the reuse counter table 206b. Specifically, the return unit 202d adds a record including a number type, a numbered number, a return reason, and a reusable flag to the reusable counter table 206b.

  Here, the configuration of the business management system is not limited to that shown in FIG. 1, but may be the one shown in FIG. 4, for example. Specifically, the above-described request reception unit, acquisition unit, generation unit, and return unit may be a business management system configured to be provided in the client terminal 100 instead of the server device 200.

[2. processing]
An example of processing executed in the business management system will be described in detail with reference to FIGS.

[2-1. Main processing]
Here, an example of main processing (number issuing processing) executed in the business management system will be described with reference to FIG. FIG. 5 is a flowchart illustrating an example of the main process.

  In the present description, the request receiving unit 202a has a number type (type ID “X”) and a number of numbers that are output from the business application at a predetermined timing in a situation where the business application is running on the client terminal 100. It is assumed that a numbering request including “N”, a reuse setting (“Yes” or “No”), and a continuous numbering setting (“Yes” or “No”) is received.

  When the reuse setting is “Yes” (step SA1: Yes), the acquisition unit 202b executes a reuse counter number acquisition process to be described later, and the acquisition result (“acquisition success” or “acquisition failure”) If it can be acquired, the acquisition number (the number that has been copied) is output (step SA2). If the reuse setting is “No” (step SA1: No), the process proceeds to step SA5.

  Here, when the consecutive numbering setting is “Yes”, acquisition success means that N numbered numbers whose type ID is “X” and the reusable flag is “True” can be copied continuously. The acquisition failure is when it is not (in short, when no number has been copied).

  Further, when the consecutive numbering setting is “No”, “acquisition success” means that N numbered numbers having the type ID “X” and the reusable flag “True” have been copied. Yes, acquisition failure means that when no numbered number whose type ID is “X” and the reusable flag is “True” cannot be copied, or the type ID is “X” and This is when n numbered numbers whose reusable flag is “True” have been copied.

  When the acquisition result output in step SA2 is “acquisition success” (step SA3: Yes), the acquisition unit 202b reuses the record including the numbered number corresponding to the acquisition number output in step SA2. Delete (erase) from the counter table 206b (step SA4).

  When the acquisition result output in step SA2 is “acquisition failure” (step SA3: No), the generation unit 202c executes a counter number acquisition process described later, and outputs an acquisition number (new number) ( Step SA5).

  The request reception unit 202a returns the acquisition number output in step SA2 and the acquisition number output in step SA5 to the business application (client terminal 100) (step SA6).

[2-2. Reuse counter number acquisition process]
Here, an example of the reuse counter number acquisition process executed by the acquisition unit 202b will be described with reference to FIGS. FIG. 6 is a flowchart illustrating an example of the reuse counter number acquisition process.

  When the consecutive numbering setting is “Yes” (step SB1: Yes), the acquisition unit 202b determines from the reuse counter table 206b that the type ID is “X” and the reusable flag is “True”. A numbered number set composed of at least consecutive numbered numbers (the number of numbered numbers included in the set is M (M is an integer equal to or greater than N)), and the numbered numbers extracted The last assigned number (Mth assigned number) included in the set is identified, and is the last assigned number, the number of assigned numbers being the smallest and the first (first ) Are acquired (copied) from the reuse counter table 206b (step SB2). For example, when the number of numbers is 2, when two number sets {“2”, “3”} and {“5”, “6”} are extracted from the reuse counter table 206b, the two number sets are extracted. The number of elements is 2 but the number set with the smallest first number is {"2", "3"}, so the last number included in the number set {"2", "3"} No. “3” is acquired (copied) from the reuse counter table 206b.

Here, the acquisition unit 202b includes, for example, (1) at the time of extracting a numbered number set composed of N or more consecutive numbered numbers in the process of step SB2, and included in the numbered number set. The reusable flag of all records corresponding to the assigned number may be switched to “False”, and (2) when the last assigned number is copied, the copied number is supported. The reusable flag may be switched to “False” for the records from the record to be recorded to the record corresponding to the number N−1 before the copied number.
Thereby, even if the numbering request is received from the plurality of client terminals 100 almost simultaneously, a number satisfying the request can be issued to each client terminal 100.

  The acquisition unit 202b outputs an acquisition result “acquisition failure” when the numbered number set including N or more consecutive numbered numbers cannot be extracted in the process of step SB2. Then, this process ends.

  Next, based on the numbered number copied in step SB2, the acquiring unit 202b obtains N-1 consecutive numbers including the number immediately before the numbered number from the numbered number. It generates in descending order (while subtracting the numbered number one by one), and outputs the acquisition result “acquisition success” and the acquisition number (the copied numbered number and the generated number) (step SB3). Note that the number generated in step SB3 corresponds to the number already assigned.

  Note that the access time and the number of accesses to the reuse counter table 206b can be minimized by the processing in step SB2 and step SB3.

Here, the processing of step SB2 and step SB3 will be described more specifically. Here, the reuse counter table 206b is as shown in FIG. 7, and the type ID, number of numbers, reuse setting, and continuous number setting included in the numbering request are as shown below. Assumption.
-Type ID: X001
・ Number of numbers: 2
・ Reuse setting: Yes
・ Consecutive numbering setting: Yes

  Since all the records stored in the reuse counter table 206b have the type ID “X001” and the reusable flag is “True”, in step SB2, first of all, two records among all the records A numbered number set including the consecutive numbered numbers is extracted. In this case, two numbered number sets {“1”, “2”, “3”} and {“9”, “10”} are extracted.

  Next, in step SB2, the last numbered number (the largest number in the extracted numbered number sets {“1”, “2”, “3”} and {“9”, “10”}) is extracted. ). Here, the number “3” and the number “10” are specified.

  Next, in step SB2, the reuse counter table 206b includes the identified number “3” and number “10” that are included in the extracted numbered number set with the smallest number of elements. Copy from. Here, among the extracted numbered number sets, the one with the smallest number of elements is {“9”, “10”}, and among the identified numbers “3” and “10”, this set is assigned to this set. Since the number included is “10”, the number “10” is copied from the reuse counter table 206b.

  Next, in step SB3, the number “9” is generated by subtracting 1 from the copied number “10” once (the number obtained by subtracting 1 from the number of numbers). For example, in the case of 3 times, by repeating the subtraction, the number “9”, the previous number “8”, and the previous number “7” are generated.

Returning to the description of FIG. 6, when the consecutive numbering setting is “No” (step SB1: No), the acquisition unit 202b determines from the reuse counter table 206b that the type ID is “X” and the reusable flag. Acquire (copy) N numbered numbers with "True" in ascending order, and when N number is acquired, output the acquisition result and acquisition number "acquired successfully", and when n number is acquired An acquisition result “acquisition failure” and an acquisition number are output, and if no acquisition is possible, an acquisition result “acquisition failure” is output (step SB4).
Specifically, the acquisition unit 202b determines from the reuse counter table 206b an arbitrary number that has a type ID of “X” and a reusable flag of “True” (for example, the first number that has been assigned). ) May be identified, and N numbered numbers including the numbered numbers may be acquired (copied) from the reuse counter table 206b in ascending order from the identified numbered numbers.

[2-3. Counter number acquisition process]
Here, an example of the counter number acquisition process executed by the generation unit 202c will be described with reference to FIG. FIG. 8 is a flowchart illustrating an example of the counter number acquisition process.

  When the reuse setting is “No” or the acquisition number is not output from the acquisition unit 202b, the generation unit 202c sets the number of numbers to be newly assigned to N, and the acquisition number from the acquisition unit 202b is When n are output, a value obtained by subtracting n from N is calculated, and the number of numbers to be newly assigned is set to N−n (step SC1).

  The generation unit 202c updates the numbered final number with the type ID “X” stored in the counter table 206a to the number after the number (N or N−n) set in step SC1 (step SC2). . Specifically, N or N−n is added to the final number that has been assigned.

  Note that, even if the numbering request is received from the plurality of client terminals 100 almost simultaneously by the process of step SC2, a number satisfying the request can be issued.

  The generation unit 202c copies the numbered final number after the update in Step SC2 (Step SC3). Note that the number copied in step SC3 corresponds to the new number.

  Based on the new number copied in step SC3, the generation unit 202c includes a number that is subtracted by 1 from the number set in step SC1 including the number immediately before the new number (N−1 or N−n−). (1) consecutive numbers are generated in descending order from the new numbers (while subtracting the new numbers one by one) (step SC4).

[2-4. Return processing]
Here, an example of the number return process executed by the return unit 202d will be described with reference to FIG. FIG. 9 is a flowchart illustrating an example of the number return process.

  In the present description, the request receiving unit 202a has issued a number type (type ID), which is no longer used, issued from the business application at a predetermined timing in a situation where the business application is running on the client terminal 100. It is assumed that a return request including a completed number, a return reason (missing reason), and a reusable flag (“True” or “False”) has been received.

  The return unit 202d stores, in the reuse counter table 206b, a record including the number type, number assigned, return reason, and reusable flag included in the return request (step SD1).

[3. Summary of Embodiments and Other Embodiments]
As described above, according to the present embodiment, when the request receiving unit 202a receives a numbering request issued from the client terminal 100 (business application), a number that matches the requested number type and is reusable is targeted. (1) The acquisition unit 202b acquires a numbered number from the reuse counter table 206b, and (2) when the acquisition unit 202b cannot acquire a numbered number, the generation unit 202c stores the numbered number in the counter table 206a. Referring to the stored numbered last number (numbered number that is different from the numbered number after the numbered number), the numbered last A new number after the number is generated, and (3) the request receiving unit 202a returns the acquired numbered number and the generated new number to the client terminal 100 (business application). Thereby, the efficiency of number issuing can be improved. In addition, it is possible to efficiently identify a number that has not yet been generated.

  Further, according to the present embodiment, the reuse counter table 206b further stores a return reason and a reusable flag in association with the numbered number. This makes it possible to clearly explain the reason why it is no longer used, thus realizing IT control.

  Further, according to the present embodiment, the counter table 206a stores the numbered final number for each number type, and the reuse counter table 206b stores the numbered number, reason for return, and reuse for each number type. Store possible flag. Thereby, number issue can be performed for every number classification.

  Further, according to the present embodiment, the acquisition unit 202b acquires a number that has been assigned from the reuse counter table 206b with the number of numbers included in the numbering request as an upper limit, and the generation unit 202c is the acquisition unit 202b. If no number has already been acquired, a new number is generated with reference to the final number stored in the counter table 206a, and the acquisition unit 202b generates a number less than the number. When the numbered number can be acquired, the number of the numbered number acquired by the acquiring unit 202b is subtracted from the numbered number by referring to the numbered final number stored in the counter table 206a. Is generated. Thereby, a plurality of numbers can be issued for one numbering request.

  Further, according to the present embodiment, the acquisition unit 202b acquires the number of consecutive numbers assigned from the reuse counter table 206b, and the generation unit 202c acquires the number of consecutive numbers assigned by the acquisition unit 202b. In the case where the numbered number has not been acquired, a new number of consecutive numbered numbers is generated with reference to the numbered last number stored in the counter table 206a. Thereby, a plurality of consecutive numbers can be issued in response to a single numbering request.

  Further, according to the present embodiment, the acquisition unit 202b is a number that has been consecutively numbered, and is a number that has been numbered immediately before the earliest number that has been included. Are not present in the reuse counter table 206b, and the reuse counter table 206b indicates that the number assigned after the last assigned number included in these is not present in the reuse counter table 206b. Obtained from 206b. Thereby, it is possible to suppress an increase in discrete single numbers in the reuse counter table 206b, and as a result, it is possible to efficiently reuse a plurality of consecutive numbers.

  Further, according to the present embodiment, the generation unit 202c subtracts the number of the numbered final number stored in the counter table 206a, or the number of the numbered number that can be acquired from the numbered number. The number of consecutive numbering or the number of the subtracted number is updated based on the numbered final number after the update, the number of numbered numbers, and the number of numbered numbers obtained. Therefore, even when a plurality of numbering requests are received at substantially the same timing, a plurality of consecutive numbers can be issued for each numbering request.

  Further, according to the present embodiment, when the request receiving unit 202a receives a return request issued from the business application, the return unit 202d reuses the number type, numbered number, return reason, and reusable flag. It is stored in the counter table 206b. Thereby, it is possible to promote the reuse of the number that has not been used.

Here, a number is usually assigned from a counter. In order to maintain the uniqueness of the number, the counter is configured so that once the number is assigned, the same number is not assigned again. The counter can only generate a predetermined number of numbers. Therefore, in the conventional numbering, in order to avoid unnecessary numbering, numbering can only be performed when necessary. Conventionally, when the counter generates a finite number, it searches for a missing number from the numbers that have been assigned so far and reuses it. However, it takes a lot of time to search for a reusable number from a huge number of numbers that have been assigned in the past.
However, according to this embodiment, when a number exists in the reuse counter, the number existing in the reuse counter is preferentially used. Further, according to the present embodiment, when the number that has been assigned is no longer used due to deletion of business data or the like, it is returned to the reuse counter. Therefore, according to the present embodiment, since the number can be reused, there is no missing number, and the limited resources of the counter can be used efficiently. Further, the numbering mechanism of this embodiment can be realized by two counters and a reuse counter, so that modularization is easy. In addition, according to the present embodiment, since the destination for searching for a reusable number is one reuse counter table, not only modularization can be easily realized, but also an unnecessary number for reuse. The search time can be shortened compared to the conventional method.

Moreover, in the conventional numbering, only one number can be assigned to one numbering request. However, according to the present embodiment, the numbering request can be made by specifying the number of numbers to be acquired, and a plurality of numbers can be assigned at once, or a plurality of consecutive numbers can be assigned at once. I can do it.
Here, in a business application, there are scenes where numbering must be performed in large quantities. For example, a company that conducts sales business has an obligation to issue invoices to a plurality of suppliers at once.
However, in the conventional numbering, it is necessary to number each bill (each transaction), and when a large number of bills are issued, so many numbers are necessary. Also, considering that one database access occurs for a single numbering request, a round trip between the computer on which the application operates and the computer on which the database operates affects the response. In addition, when the numbering request is made at the same time in other terminals, the numbering process is performed for each request, which causes a problem that consecutive numbers cannot be acquired.
However, according to the present embodiment, a plurality of numbers can be numbered consecutively in response to a single numbering request.

  In addition, when business data is deleted in a business application, the business number assigned to the business data is not used, but according to this embodiment, the business number that is no longer used is returned to the reuse counter table, The business numbers stored in the reuse counter table are acquired with priority over the counter table when assigning business numbers of the same business type, and the acquired business numbers are deleted from the reuse counter table.

  In addition, IT control may require that a free number not be allowed. This is a case where consecutive numbers are required on the business management system in order to prove the continuity of business data. However, when business data is deleted, missing numbers occur. Therefore, according to the present embodiment, the reason for missing numbers can be explained by storing the reason for missing numbers in the reuse counter table. The reason for the missing number can be used as information for proving that the unauthorized operation data is not operated.

  Further, according to the present embodiment, intentional missing numbers can be realized by setting a reusable flag. Here, the reason for intentionally missing numbers is that missing numbers of slip numbers assigned to data important for corporate accounting such as journal data may be subject to audit. Therefore, according to the present embodiment, IT control is realized by clarifying the reason for missing numbers. Specifically, IT control can be performed by adding a reason for missing numbers to a reuse counter and storing the numbers that are no longer used. Also, as a reason for return, IT control is realized by setting a reason for explaining why it is “invalid” when the reusable flag is “invalid (False)”.

  In addition, when a function for deleting registered business data is implemented in a business application, in this embodiment, a numbered number is returned at the timing of deletion. When deleting data important for corporate accounting, such as journal data, set the reusable flag to "Invalid" and set the reason for the deletion together with the reason for deletion. You may go. Further, in the case of a simple registration mistake regarding a normal transaction, the reusable flag may be operated as “valid”.

  In the past, in business applications and the like, numbering was performed at the time of data registration in order to reduce missing numbers as much as possible. However, in this embodiment, numbering can be performed at an arbitrary timing. Further, in this embodiment, since it becomes easy to perform numbering before business data registration, the user of the business management system can confirm the relation of business data before registration.

  In addition, when the numbering timing is arbitrary, it is assumed that the input is interrupted after the numbering. In this embodiment, the return process is performed at the timing when the input is interrupted, and the numbered number is reused. Further, in the present embodiment, during nighttime data maintenance, a return process is performed by searching for an unused number. In other words, in this embodiment, numbers can be returned in a lump at the time of nighttime data maintenance without performing return processing at the time of real-time input by the operator.

  Further, since the counter is a finite number, it is required not to use as many unnecessary numbers as possible. Until now, in order not to assign useless numbers, numbering was performed when registering business data. However, according to this embodiment, for example, if a number is temporarily assigned and the number is not used, the number can be reused.

Conventionally, since it is difficult to discard or reuse a number once assigned, a business management system has been designed so as to avoid assigning as many unnecessary numbers as possible. Specifically, assuming the case where the operator abandons the input of business data halfway or the input business data cannot be finally registered due to a business application error, the numbering timing is The business application is generally performed immediately before registration of business data or when a database storing business data is updated.
However, according to the present embodiment, the number can be discarded or reused easily, so that the timing of the numbering process can be designed more flexibly than in the past. For example, it is possible to design numbering at any timing, such as immediately after starting a business application or while inputting business data.
Further, according to the present embodiment, since the numbering can be performed at an arbitrary timing, it is possible to exclude the restriction on the registration of the business data first. For example, in order to associate the business data registered in the database storing business data with the business file managed by the computer, it is easy to design when managing this file name with the number assigned. It is done.
In addition, in the conventional numbering, business data must be registered first, but when business data is extracted from a created business file and registered, the file must be created before data registration. . For example, a company that manufactures mechanical products needs to create a drawing using drafting software and assign a number for linking with a business application. In addition, there was a requirement to use the number to match the file name of the file created by the drafting software. In conventional numbering, a file created using a temporary file name must be handled, and the file name must be changed and saved again with the number assigned at the time of data registration. However, according to the present embodiment, since only the numbering process can be performed in advance, it is possible to create a file in advance, extract information from the created file, and register data in the database become.

Further, the system according to the present embodiment can be used in fields where it is necessary to generate a finite number other than business applications.
For example, the system according to this embodiment includes a telephone number (for example, a subscriber number excluding an area code and a city code for a Japanese landline phone, a mobile number and a carrier identification number for a Japanese mobile phone). It can be used for numbering (excluding customer numbers, etc.). A telephone number is a finite number that cannot easily increase the number of digits. Therefore, if the system according to this embodiment is used, for example, numbering can be performed when a mobile phone is newly purchased, and the number can be effectively used by returning the number to the system when use is stopped.
Further, for example, the system according to the present embodiment can be used for number management in the national gross number system. The current Japanese population is on a downward trend, but the cumulative population continues to increase. However, it is estimated that it is very difficult to change the number of digits required for the national gross number system with the system transition. Therefore, if the system according to the present embodiment is used, for example, numbering is performed at the time of birth, and when the number of years has passed since the death, it is not necessary to take a legal procedure, and the number is returned. It can solve problems that must continue to increase.

Further, the system according to the present embodiment can be used in a business for issuing and managing numbers.
For example, assuming a service for managing mobile phone numbers, a customer (for example, a service using company) requests a service provider company (a company that manages the server device of the system according to the present embodiment) to issue a number, and the service The provider issues a number to the customer.
Since the issued number becomes an asset of the customer, the customer pays a service usage fee to the service provider as the number management fee.
When the customer stops using the number issued by the service provider, the customer returns the number to the service provider, and the service provider confirms the return.
In addition, if you decide to charge the service usage fee according to the number of numbers to be managed, customers will be able to receive the service cheaper if you return the number that is no longer needed, so the active number Return occurs. In other words, even if the service providing company does not prompt the customer to return the number, the service providing company can automatically return the number from the customer.

  Further, although the embodiments of the present invention have been described so far, the present invention can be implemented in various different embodiments within the scope of the technical idea described in the claims other than the above-described embodiments. It ’s good.

  For example, among the processes described in the above-described embodiments, all or a part of the processes described as being automatically performed can be manually performed, or the processes described as being manually performed All or a part of the above can be automatically performed by a known method.

  In addition, unless otherwise specified, the processing procedures, control procedures, specific names, information including registration data for each processing, parameters such as search conditions, screen examples, and database configurations shown in the above documents and drawings Can be changed arbitrarily.

  Further, regarding the business management system, each illustrated component is functionally conceptual and does not necessarily need to be physically configured as illustrated.

  For example, regarding the processing functions provided in the client terminal 100 and the server device 200, in particular, the processing functions performed by the control unit 100 and the control unit 202, all or any part thereof is interpreted and executed by the CPU and the CPU. It may be realized by a program or hardware based on wired logic. The program is recorded on a non-transitory computer-readable recording medium including a programmed instruction for causing the information processing apparatus to execute the identification information issuing method according to the present invention. 200 mechanically read. That is, a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded in the storage unit 206 such as a ROM or a HDD (Hard Disk Drive). This computer program is executed by being loaded into the RAM, and constitutes a control unit in cooperation with the CPU.

  The computer program may be stored in an application program server connected to the client terminal 100 or the server device 200 via an arbitrary network, and may be downloaded in whole or in part as necessary. Is also possible.

  Further, the identification information issuing program according to the present invention may be stored in a computer-readable recording medium that is not temporary, or may be configured as a program product. Here, the “recording medium” refers to a memory card, USB (Universal Serial Bus) memory, SD (Secure Digital) card, flexible disk, magneto-optical disk, ROM, EPROM (Erasable Programmable Read Only Memory), EEPROM (registration). Trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magneto-Optical disk), DVD (Digital Digital, Trademark) Any “portable physical media It is intended to include.

  The “program” is a data processing method described in an arbitrary language or description method, and may be in any form such as source code or binary code. Note that the “program” is not necessarily limited to a single configuration, and functions are achieved in cooperation with a separate configuration such as a plurality of modules and libraries or a separate program represented by the OS. Including things. In addition, a well-known structure and procedure can be used about the specific structure and reading procedure for reading a recording medium in each apparatus shown to embodiment, the installation procedure after reading, etc.

  The storage unit 106 and various databases stored in the storage unit 206 are storage means such as a memory device such as a RAM and a ROM, a fixed disk device such as a hard disk, a flexible disk, and an optical disk. Stores various programs, tables, databases, web page files, and the like used for provision.

  In addition, the client terminal 100 and the server device 200 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device to which an arbitrary peripheral device is connected. . Further, the client terminal 100 and the server device 200 may be realized by installing software (including a program or data) for realizing the identification information issuing method of the present invention in the information processing device.

  Furthermore, the specific form of distribution / integration of the devices is not limited to that shown in the figure, and all or a part of them may be functionally or physically in arbitrary units according to various additions or according to functional loads. It can be configured to be distributed and integrated. That is, the above-described embodiments may be arbitrarily combined and may be selectively implemented.

  The identification information issuing device, the identification information issuing method, and the identification information issuing program according to the present invention are particularly useful for number management in a business application.

DESCRIPTION OF SYMBOLS 100 Client terminal 102 Control part 104 Communication interface part 106 Storage part 108 Input / output interface part 112 Input device 114 Output device 200 Server apparatus 202 Control part
202a Request reception part
202b acquisition unit
202c generator
202d Return unit 204 Communication interface unit 206 Storage unit
206a counter table
206b Reuse counter table 300 network

Claims (10)

An identification information issuing device comprising a control unit and a storage unit,
The storage unit
First storage means for storing generated identification information specifying information for specifying generated identification information that is identification information generated in the past;
Second storage means for storing unused generated identification information that is the generated identification information that is not used;
With
The controller is
Obtaining means for obtaining the unused generated identification information from the second storage means with a predetermined number as an upper limit ;
When none of the unused generated identification information can be acquired by the acquisition means, the predetermined number of the generated identification information is referred to by referring to the generated identification information specifying information stored in the first storage means. Generating the identification information different from
When the acquisition means can acquire the unused generated identification information less than the predetermined number, it can be acquired by the acquisition means with reference to the generated identification information specifying information stored in the first storage means. Generating means for generating the identification information different from the generated identification information, the number obtained by subtracting the number of the unused generated identification information from the predetermined number ;
Having
An identification information issuing device characterized by the above. The second storage means associates with the non-used generated identification information and indicates whether or not the non-used generated identification information is no longer used and whether or not the non-generated generated identification information can be used. Storing more information,
The identification information issuing device according to claim 1. The first storage means and the second storage means store information for each application in which the identification information is used;
The identification information issuing device according to claim 1 or 2. The identification information corresponds to an order scale;
The acquisition unit acquires the predetermined number of the unused generated identification information consecutively from the second storage unit,
When the generation unit is not able to acquire the predetermined number of unused generated identification information consecutively by the acquisition unit, refer to the generated identification information specifying information stored in the first storage unit, Generating the predetermined number of the identification information consecutively;
The identification information issuing device according to any one of claims 1 to 3 . The acquisition means includes the predetermined number of the unused generated identification information consecutively, and the unused generated identification information immediately before the earliest unused generated identification information included therein. Does not exist in the second storage means, and the unused generated identification information immediately after the last unused generated identification information included in the second storage means does not exist in the second storage means Obtaining from the second storage means,
The identification information issuing device according to claim 4 . The generated identification information specifying information is the generated identification information, and the generated identification information different from the generated identification information does not exist after the generated identification information.
The identification information issuing device according to claim 4 or 5 . The generating means subtracts the number of the unused generated identification information acquired by the acquiring means from the predetermined number after the predetermined number of the generated identification information stored in the first storage means. The predetermined number that is continuously updated based on the generated identification information after the update, the predetermined number, and the number of the unused generated identification information acquired by the acquisition unit. Or generating the subtracted number of identification information,
The identification information issuing device according to claim 6 . The control unit further includes return means for storing the generated identification information in the second storage means,
Identification information issuing apparatus according to any one of claims 1 to 7, characterized in. An identification information issuing method executed in an identification information issuing device including a control unit and a storage unit,
The storage unit
First storage means for storing generated identification information specifying information for specifying generated identification information that is identification information generated in the past;
Second storage means for storing unused generated identification information that is the generated identification information that is not used;
With
Executed in the control unit,
An acquisition step of acquiring the unused generated identification information from the second storage means with a predetermined number as an upper limit ;
When none of the unused generated identification information can be acquired in the acquiring step, the predetermined number of the generated identification information is referred to by referring to the generated identification information specifying information stored in the first storage means. Generating the identification information different from
When it is possible to acquire the unused generated identification information less than the predetermined number in the acquiring step, it can be acquired in the acquiring step with reference to the generated identification information specifying information stored in the first storage means. Generating the identification information different from the generated identification information by subtracting the number of the unused generated identification information from the predetermined number ;
Including,
An identification information issuing method characterized by the above. An identification information issuing program for execution in an identification information issuing device comprising a control unit and a storage unit,
The storage unit
First storage means for storing generated identification information specifying information for specifying generated identification information that is identification information generated in the past;
Second storage means for storing unused generated identification information that is the generated identification information that is not used;
With
For executing in the control unit,
An acquisition step of acquiring the unused generated identification information from the second storage means with a predetermined number as an upper limit ;
When none of the unused generated identification information can be acquired in the acquiring step, the predetermined number of the generated identification information is referred to by referring to the generated identification information specifying information stored in the first storage means. Generating the identification information different from
When it is possible to acquire the unused generated identification information less than the predetermined number in the acquiring step, it can be acquired in the acquiring step with reference to the generated identification information specifying information stored in the first storage means. Generating the identification information different from the generated identification information by subtracting the number of the unused generated identification information from the predetermined number ;
Including,
An identification information issuing program characterized by:

Images