JPH0795300B2 - Name management method in database - Google Patents

Description

DETAILED DESCRIPTION OF THE INVENTION [Outline] Regarding a name management system for managing real names and aliases of information stored in a database, real names and aliases are arranged in the same row for one piece of information, and both are associated with each other. By registering the attribute only for the purpose of reducing the trouble of registration and preventing the update of the attribute information, the real name of the information stored in the database is an alias,
A pointer that points to the real name in the case of an alias, a name table that stores at least attributes in the case of the real name, a name search unit that searches the name table to find the notified name, and the found name is the real name. In this case, the attribute of this real name is taken out, and on the other hand, when it is an alias, it is provided with an attribute information fetching unit that fetches the attribute of the real name by tracing a pointer, and is configured to output the attribute information fetched by this attribute information fetching unit. .

[Industrial application field]

The present invention relates to a name management system for managing real names and aliases of information stored in a database.

[Conventional technology]

2. Description of the Related Art Conventionally, in a system that manages the names and attributes of resources stored in a system dictionary, a user may use different names for the same resource as the usage mode of the system dictionary. For example, when handling the same information across a plurality of departments, the names of the same information may differ for each department.

At this time, with respect to one resource, the name and the attribute thereof are registered independently for each department. Also,
When changing the attribute of a resource, the changing process is performed on all information having the same attribute.

[Problems to be solved by the invention]

For this reason, if the user separately registers the name and the attribute of the same resource, the attribute information having the same content as a whole is repeatedly registered, which requires a lot of labor for registration. There was a problem that it would become.

In addition, since attributes are independently registered for each of a plurality of names for one resource, the attribute of a name with the same resource is updated, but the attribute of another name of the same resource is forgotten to be updated. However, there is a problem in that it is easy to occur and that an update leak easily occurs.

According to the present invention, the real name and the alias are arranged in the same row for one information and the two are associated with each other, and the attribute is registered only for the real name, thereby reducing the labor of registration and updating the attribute information. The purpose is to prevent.

[Means for solving problems]

Means for solving the problem will be described with reference to FIG.

In FIG. 1, the name table 1 stores real names and aliases that are names in the same column, stores attribute information only for real names, and allows the aliases to access this attribute information by following a pointer. It was done.

The name search unit 2 searches the name table 1 for an input name (real name or alias) and finds it.

The result discriminating unit 3 discriminates whether the name retrieved by the name searching unit 2 is a real name or an alias.

The attribute information extraction unit 4 extracts the attribute information stored in association with the real name based on the information notified from the result determination unit 3.

[Action]

In the present invention, as shown in FIG. 1, the name search unit 2 searches the name table 1 for a name (real name or alias) corresponding to the notified (input) name, and the result determination unit 3 The extracted name determines the real name or the alias, and the attribute information extraction unit 4 extracts the attribute information of the real name when the determination result is the real name. On the other hand, in the case of the alias, the attribute information of the real name is extracted by tracing the pointer. I am trying to output.

Therefore, it is only necessary to register the attribute information in one place by associating it with the real name, and it is possible to reduce the trouble of registration and also to change the attribute information associated with the real name when changing it, and prevent the change. Is possible.

〔Example〕

Next, the configuration and operation of one embodiment of the present invention will be sequentially described in detail with reference to FIGS. 1 to 5.

In FIG. 1, a name table 1 stores names (real name or alias) as shown. Specifically, in the case of a real name, the real name is from the beginning, the real name / alias identification flag is the real name, and the pointer is unnecessary, so "NUL
L ", attribute information (for data items, type (Japanese, English, etc.), number of digits, administrator, initial value, etc.) are stored. In case of an alias, alias from the beginning, real name / identification flag is an alias , Pointer (pointer pointing to real name), and attribute information is not registered and "NULL" is stored.The real name and aliases are searched for by keywords (search words) at the time of search, and these are the necessary attributes Information is taken out.The real name and the alias have the same data structure, and NULL is stored in the unnecessary part, for example, at the position of the attribute information of the alias, but when storing this in the actual system dictionary, the so-called RDB Since the compression function is used for the compression, no extra space is required in the system dictionary (database), and the real name is the most representative of multiple names. To select things. The other names and aliases.

The name search unit 2 searches for and finds a corresponding real name or alias from the name table 1 using the input name (real name or alias) as a keyword.

The result discriminating unit 3 discriminates whether the name retrieved by the name searching unit 2 is a real name or an alias. This determination is made by the real name / alias identification flag. In addition, in the case described later with reference to FIGS. 4 and 5, since the real name table 1-1 and the alias name table 1-2 are separated from each other, which table is used to retrieve the corresponding real name or name? It can be determined as a real name or an alias by.

The attribute information extraction unit 4 extracts the information notified from the result determination unit 3, for example, if the extracted name is the real name, the attribute information of this real name, while if it is an alias, the pointer is followed to trace the attribute of the real name. It is to retrieve information.

The configuration and operation of FIG. 1 will be sequentially described in detail below.

FIG. 2 shows an example of the structure of the system dictionary database. In the figure, (a) represents real name information. In order from the beginning, name "AAA" (real name is "AAA"), real name (real name / alias identification flag is "0" and real name), pointer is "0" (real name is unnecessary and "0" Stored)), and attribute information is stored.

In the figure, (b) and (c) represent the alias information of (a) in this figure. For example, (c) in the figure shows the name "XXX" in order from the beginning.
(Alias is "XXX"), alias (real name / alias identification flag is "1"
Therefore, "NULL"("NULL" because it is unnecessary) is stored as the alias), the pointer (pointer to the real name), and the attribute information.

In the figure, (d) represents other real name information. This is (a) in the figure
The name "BBBB" is stored in the same manner as the real name information of.

As described above, the real name information and the alias information have the same data structure, and both are stored in one name table 1, and "NULL" is stored in an unnecessary portion. This "NULL" part is compressed by the RDB compression function and stored in the system dictionary database, so it does not take any extra space.

Next, the operation of the configuration of FIG. 1 when the name table 1 of FIG. 2 is used will be described in detail with reference to FIG.

Registration of real name information will be described with reference to FIG. In the figure, after the user inputs the real name registration command, information such as a name (real name) and attributes is designated and input as parameters.

The figure shows a state in which names, real names, attributes, etc. are registered in the dictionary. This corresponds to the real name registration command entered in the figure and the entered information, and as shown in FIG. 2A, the name of the real name information (real name) is "AAA" and the real name / alias identification flag. Means “0”, the pointer is “0”, and the entered attribute information (for example, in the case of a data item, attribute information such as type, number of digits, administrator, etc.) is registered.

By the above procedure, real name information as shown in FIG. 2 (a) is registered.

Registration of alias information will be described with reference to FIG. In the figure, after the user inputs the alias registration command, the name of the alias and the name of the real name are designated and input as parameters.

The figure shows a state in which the real name is searched. This means that the real name "AAA" that has already been registered is found by searching, for example, the FIG. 2 name table 1 by using the real name input in the drawing as a keyword.

The figure shows a state in which a name (alias) is displayed in the dictionary, an alias is displayed (the real name / alias identification flag is set to the alias), and a pointer to the real name table is registered. This corresponds to the alias registration command input in the figure and the input information, for example, as shown in FIG. 2 (b), the name (alias) of the alias information is "XXX", the real name / alias identification This means that the flag is "1", the pointer is set to point to the beginning of the real name information, and "NULL" is stored in the attribute information.

By the above procedure, the alias information as shown in FIG. 2B is registered.

The operation of extracting the attribute information from the real name or the alias input with reference to FIG. 3C will be described. The figure shows a state in which the user inputs a name after inputting a name search command.

The figure shows a state in which the name table 1 is searched using a name as a keyword.

The figure shows a state in which READ of the name table 1 is performed.

The figure shows a state in which it is determined whether or not the name read in the figure is the real name. This means to determine whether or not the real name / alias identification flag in the real name information is "0" (real name) as shown in (a) to (c) of FIG. . In the case of YES (in the case of real name), the attribute information of the real name is taken out from the figure and the user is notified. In the case of NO (in the case of an alias), the real name table (real name information) is read by following the pointer to the real name in the alias information in the figure, and the attribute information is extracted from this read real name information in the figure. And notify the user.

By the above procedure, in response to inquiries from users,
When the name table 1 is searched once using the name as a keyword, the attribute information of the real name can be notified in the case of the real name, while the attribute information of the real name can be notified by tracing the pointer in the case of the alias. .

Next, the operation of the configuration shown in FIG. 1 when the name table 1 in which the real name table 1-1 and the alias table 1-2 are separated is used will be described in detail with reference to FIG.
The real name table 1-1 and the alias table 1-2 shown in FIG. 4 are divided into two tables, and only necessary information (compared to the name table 1 shown in FIG.
In this example, the real name / alias identification flag and the pointer are deleted, and the real name / alias identification flag and attribute information (null) are deleted from the alias table 1-2.

Registration of real name information will be described with reference to FIG. In the figure, after the user inputs the real name registration command, information such as a name (real name) and attributes is designated and input as parameters.

The figure shows a state in which names, real names, attributes, etc. are registered in the dictionary. This corresponds to the real name registration command entered in the figure and the entered information, and the name of the real name information (real name) is "AA" as shown in FIG. 4 (e).
A "means that the entered attribute information (for example, in the case of a data item, attribute information such as type, number of digits, administrator, etc.) is registered.

By the above procedure, real name information as shown in FIG. 4 (e) is registered.

Registration of alias information will be described with reference to FIG. In the figure, after the user inputs the alias registration command, the name of the alias and the name of the real name are designated and input as parameters.

The figure shows a state in which the real name is searched. This means that the real name (real name information) "AAA" that has already been registered is found by searching, for example, the real name table 1 in FIG. 4 by using the real name input in the drawing as a keyword.

The figure shows a state in which a name (alias) is registered in the dictionary alias table and a pointer to the real name table 1-1 is registered. This corresponds to the alias registration command input in the figure and the input information, for example, as shown in (f) in FIG.
This means that X "and a pointer that points to the beginning of the real name information are stored.

By the above procedure, the alias information as shown in FIG. 4 (f) is registered.

The operation of extracting the attribute information from the real name or the alias that has been input will be described with reference to FIG. The figure shows a state in which the user inputs a name after inputting a name search command.

The figure shows a state in which the real name table 1-1 is searched using the name as a keyword to determine whether or not the corresponding name is found. In the case of existence (when found), since it is the real name, the corresponding real name information in the real name table 1-1 is read in the figure, and the attribute information in this real name information is taken out in the figure to the user. Notice. On the other hand, if none,
Since it is not the real name (because it is an alias), the alias table 1-2 is searched using the name entered in the figure as a keyword, and if found, the corresponding alias information in the alias table 1-2 is read in the figure, The real name table 1-1 is traced by tracing the pointer to the real name information in the read alias information in the figure.
The corresponding real name information is read out, and the attribute information in this real name information in the figure is taken out and notified to the user.

By the above procedure, in response to inquiries from users,
When the real name table 1-1 is first searched by using the name as a keyword, the real name attribute information is notified when found.
If not found, it is possible to search the alias table 1-2 and follow the pointer in the found alias information to notify the real name attribute information in the real name table 1-1.

〔The invention's effect〕

As described above, according to the present invention, since the attribute information is associated with the real name and registered in one place, and a pointer that points to the real name is stored and searched from the alias, the attribute information is stored. It is only necessary to register in one place associated with the real name, and the labor of registration can be reduced, and when changing the attribute information, the attribute information stored in one place can be changed. It is possible to prevent the change leak.

[Brief description of drawings]

FIG. 1 is a configuration diagram of one embodiment of the present invention, FIG. 2 and FIG. 4 are structural examples of a system dictionary database, FIG.
FIG. 5 shows a flowchart for explaining the operation of the present invention. In the figure, 1 is a name table, 1-1 is a real name table, 1-
2 is an alias table, 2 is a name search unit, 3 is a result discriminating unit, and 4 is an attribute information extracting unit.

Claims (1)

[Claims] 1. A name management system for managing real names and aliases of information stored in a database, wherein a real name or an alias of information stored in the database,
A pointer that points to the real name in the case of an alias, and a name table that stores at least the attributes in the case of the real name (1)
And a name search unit (2) that searches the name table (1) to find the notified name, and if the found name is a real name, retrieves the attribute of this real name, while if it is an alias, A name management system in a database, comprising: an attribute information extraction unit (4) for extracting an attribute of a real name by tracing a pointer, and outputting the attribute information extracted by the attribute information extraction unit (4). .