JP6991100B2 - Database configuration management device - Google Patents

Description

The present invention relates to a database configuration management device that manages data item names for registration in a database.

In the conventional database configuration management system, the data item names registered in the database are managed side by side in a list format, and are usually stored in the same hierarchy in the order of registration. However, in this management method, when the data item name is composed of a plurality of hierarchical elements, it is difficult to understand the relationship between the data item names. An example of a data item name composed of a plurality of hierarchical elements is a data item name composed of "modifier", "main word", and "classified word". For example, daily-sales. Data item names such as-quantity, monthly-sales-quantity are used.

As a method of managing the layered data, there is a file management method described in Patent Document 1. In the technique described in Patent Document 1, a hierarchical attribute is given to a file, and the file is searched along a tree representing the hierarchy.

Japanese Unexamined Patent Publication No. 2005-216129

It is considered that the relationship between the data item names can be easily understood by applying the technique described in Patent Document 1 to the management of the data item names. However, when manually registering a data item name, it is necessary to determine one by one whether the same data item name or a partially matching data item name has already been registered, which is troublesome. There was a problem that it would end up.

The present invention has been made in view of the above, and an object of the present invention is to obtain a database configuration management device capable of efficiently managing data item names composed of a plurality of hierarchical elements. ..

In order to solve the above-mentioned problems and achieve the object, the database configuration management device according to the present invention is a tree of a plurality of hierarchical elements constituting the data item name which is the name of the data item registered in the database. When the storage unit stored in the structure and the new data item name which is the data item name to be added are accepted, each of the plurality of elements constituting the new data item name and each of the plurality of elements stored in the storage unit Based on the comparison result, it is characterized by including a data item editing unit for specifying a registration location for registering an element constituting a new data item name in a tree structure.

According to the present invention, it is possible to efficiently manage data item names composed of a plurality of hierarchical elements.

The figure which shows the structure of the database configuration management apparatus which concerns on Embodiment 1 of this invention. The figure which shows the menu screen displayed by the database configuration management apparatus shown in FIG. The figure which shows the list inquiry screen of the data item name displayed by the database configuration management apparatus shown in FIG. The figure which shows the list inquiry screen of the data item name which concerns on the comparative example of this invention. The figure which shows the registration screen of the new data item name displayed by the database configuration management apparatus shown in FIG. A flowchart showing an operation in which the data item editing unit shown in FIG. 1 registers a new data item name. The figure which shows the hardware configuration example of the database configuration management apparatus shown in FIG.

Hereinafter, the database configuration management device according to the embodiment of the present invention will be described in detail with reference to the drawings. The present invention is not limited to this embodiment.

Embodiment 1.
FIG. 1 is a diagram showing a configuration of a database configuration management device 1 according to a first embodiment of the present invention. The database configuration management device 1 has a storage unit 11, a data item editing unit 12, and a display control unit 13.

The storage unit 11 stores a plurality of hierarchical elements constituting the data item name, which is the name of the data item registered in the database, in a tree structure. For example, the storage unit 11 can store the elements constituting the data item name in a tree structure by storing the elements constituting the data item name and the relationship between the elements.

The data item editing unit 12 can modify and delete the data item name stored in the storage unit 11 and newly register the data item name in the storage unit 11. When the data item editing unit 12 receives the new data item name which is the data item name to be added, the data item editing unit 12 constitutes the new data item name in the tree structure composed of a plurality of elements stored in the storage unit 11. Has a function to specify the registration location to register. For example, when the user inputs a character string in the input field provided for each element, the data item editing unit 12 can determine the element delimiter based on the input field. When the user inputs a series of character strings representing the data item names in the input field, the data item editing unit 12 sets the character strings into a plurality of elements according to a predetermined rule or by using a technique such as machine learning. Can be divided into.

The data item editing unit 12 specifies a registration location based on the comparison result between each of the plurality of elements constituting the new data item name and each of the plurality of elements stored in the storage unit 11. Specifically, the data item editing unit 12 compares each of the plurality of elements constituting the new data item name and each of the plurality of elements stored in the storage unit 11 in order from the upper layer. The registration location is specified based on whether or not the elements match each other. At this time, the data item editing unit 12 compares the elements of the same layer in order from the upper layer until the elements that do not match appear, and sets the elements that do not match to the lower element to be newly registered. At this time, the data item editing unit 12 generates a new branch from the hierarchy one level higher than the hierarchy in which the non-matching element appears, and specifies the branch point as the registration location. Further, the data item editing unit 12 registers the elements constituting the new data item name in the specified registration location.

The display control unit 13 controls the display content on the screen to be output using the display device. For example, the display control unit 13 can display the menu screen 130 for selecting the function of the database configuration management device 1. FIG. 2 is a diagram showing a menu screen 130 displayed by the database configuration management device 1 shown in FIG. The menu screen 130 includes operation buttons for registering, modifying, deleting, and inquiring data items. When "inquiry" is selected on the menu screen 130, the display control unit 13 can display the data item name list inquiry screen 131.

FIG. 3 is a diagram showing a list inquiry screen 131 of data item names displayed by the database configuration management device 1 shown in FIG. The display control unit 13 displays on the list inquiry screen 131 a plurality of elements constituting the data item names stored in the storage unit 11 in a tree structure. Specifically, the display control unit 13 connects each element and other related elements with a line to show a parent-child relationship between the elements constituting the data item name. Of the two connected elements, the element located on the left side is the parent node, and the element located on the right side is the child node. The data item name is composed of a plurality of hierarchical elements. Here, the number of layers of the elements constituting the data item name is a predetermined fixed number, and here, it is composed of the elements of the three layers. The data item name shown here is composed of elements of three layers of "modifier", "main word", and "classified word" in order from the upper layer. The "main word" is a character string representing the entity described by the data item, the "classified word" is a character string representing the domain to which the data item belongs, and the "modifying word" is ". It is a character string that classifies "main words" and "classified words" in more detail. In addition, the data item name may be composed of two elements by omitting the modifier among the modifier, the main word and the classified word. Examples of data item names composed of three elements of modifiers, main words, and classification words include "distribution / reception / number" and "contract / capacity unit / code". An example of a data item name composed of two elements, a main word and a classification word, is "construction / number of cases".

The modifier A is a root node, and the main word C and the main word D are child nodes having the modifier A as a parent node. The classification word G and the classification word H are child nodes having the main word C as the parent node. The classification word I is a child node whose parent node is the main word D. The modifier B is a root node, the main word E is a child node having the modifier B as a parent node, and the classification word J is a child node having the main word E as a parent node. The main word F is a root node having no parent node, and the classification word K is a child node having the main word F as a parent node. In the present embodiment, since it is predetermined that the data item name is composed of three layers of elements, the classification words G, H, I, J, and K are leaf nodes having no child nodes. Become.

FIG. 4 is a diagram showing a list inquiry screen 90 of data item names according to a comparative example of the present invention. When the data item name is not displayed by using the tree structure, the data item name is generally managed by a series of character strings as shown in the list inquiry screen 90. In this case, as the number of registered data item names increases, it becomes difficult to confirm whether or not the data item name to be registered is already registered, which is troublesome.

FIG. 5 is a diagram showing a registration screen 132 of a new data item name displayed by the database configuration management device 1 shown in FIG. FIG. 5 shows a new data item name “modifier B / main word E / classified word” in a state where a plurality of elements having a tree structure displayed on the list inquiry screen 131 shown in FIG. 3 are stored in the storage unit 11. This is the registration screen 132 displayed by the display control unit 13 when registering “X”. In this case, since the "modifier B / main word E / classification word J" having the common "modifier B / main word E" is already registered in the storage unit 11, the data item editing unit 12 is set to ". The registration location 22 of the "classifier X" can be specified as a subordinate of the main word E. The display control unit 13 can display the registration location 22 in the tree structure on the registration screen 132.

Subsequently, the operation of the database configuration management device 1 according to the present embodiment for registering the data item name will be described. FIG. 6 is a flowchart showing an operation in which the data item editing unit 12 shown in FIG. 1 registers a new data item name.

The data item editing unit 12 determines whether or not the modifier, which is the highest-level element among the plurality of elements constituting the new data item name, matches the registered modifier (step S101). When the modifier of the new data item name does not match the registered modifier (step S101: No), the data item editing unit 12 newly registers the modifier, main word, and classified word of the new data item name (step). S102).

When the modifier of the new data item name matches the registered modifier (step S101: Yes), the data item editing unit 12 is one of the plurality of elements constituting the new data item name, rather than the modifier. It is determined whether or not the main word, which is a lower element, matches the registered main word with the same modifier (step S103). When the main word of the new data item name does not match the registered main word (step S103: No), the data item editing unit 12 newly registers the main word and the classified word and associates them with the registered modifier (step S103: No). Step S104).

When the main word of the new data item name matches the registered main word (step S103: Yes), the data item editing unit 12 is one of the plurality of elements constituting the new data item name, rather than the main word. It is determined whether or not the classified word which is a lower element matches the registered classified word whose modifier and main word match (step S105). When the classified word of the new data item name does not match the registered classified word (step S105: No), the data item editing unit 12 newly registers the classified word and associates it with the registered modifier and the main word (step S105: No). Step S106). When the classification word of the new data item name matches the registered classification word (step S105: Yes), the registration is not performed because it is a registered data item (step S107).

In the case of a data item name consisting of a main word and a classified word without a modifier, if a data item name without a modifier is registered, the modifier is a registered modifier. It is judged to match.

FIG. 7 is a diagram showing a hardware configuration example of the database configuration management device 1 shown in FIG. The functions of the storage unit 11, the data item editing unit 12, and the display control unit 13 of the database configuration management device 1 can be realized by using the processor 31, the memory 32, the input device 33, and the display device 34. ..

The processor 31 is a CPU (Central Processing Unit), and is also called a central processing unit, a processing unit, an arithmetic unit, a microprocessor, a microcomputer, a DSP (Digital Signal Processor), or the like. The memory 32 is, for example, a non-volatile or volatile semiconductor memory such as a RAM (Random Access Memory), a ROM (Read Only Memory), a flash memory, an EPROM (Erasable Programmable ROM), or an EEPROM (registered trademark) (Electrically EPROM). Magnetic discs, flexible discs, optical discs, compact discs, mini discs, DVDs (Digital Versatile Disk), etc.

The input device 33 is a keyboard, a mouse, a touch sensor, and the like. The display device 34 is an output device that outputs a display screen, and is a liquid crystal display, an organic EL (Electro Luminescence) display, or the like.

The processor 31 can realize each function of the database configuration management device 1 by reading and executing the computer program stored in the memory 32. The memory 32 is also used as a temporary memory in each process executed by the processor 31.

As described above, according to the database configuration management device 1 according to the present embodiment, a plurality of elements constituting the data item name, which is the name of the data item registered in the database, are managed in a tree structure. Then, when adding the data item name, the tree is based on the comparison result between each of the plurality of elements constituting the new data item name and each of the plurality of registered elements stored in the storage unit 11. In the structure, the registration location 22 for registering the elements constituting the new data item name is specified. With such a configuration, the user does not need to confirm the data item name registered in the storage unit 11, and simply inputs the new data item name to the database configuration management device 1, and the new data item name in the tree structure. It is possible to specify the registration location where the elements constituting the above are registered. Therefore, it becomes possible to efficiently manage the data item name composed of a plurality of hierarchical elements.

Further, the database configuration management device 1 according to the present embodiment can display a plurality of elements constituting the registered data item names on the screen in a tree structure. This makes it easier to visually understand the relationship between the currently registered data item names. Further, when the database configuration management device 1 specifies the registration location 22 of the new data item name, the registration location 22 in the tree structure can be displayed on the screen. This makes it easier to visually understand the relationship between the currently registered data item name and the new data item name.

The configuration shown in the above-described embodiment shows an example of the content of the present invention, can be combined with another known technique, and is one of the configurations as long as it does not deviate from the gist of the present invention. It is also possible to omit or change the part.

For example, in the above embodiment, the data item name is composed of three hierarchical elements, but the present embodiment is not limited to such an example. The data item name may be composed of two or more hierarchical elements. Further, in the above embodiment, the three elements constituting the data item name are a modifier, a main word, and a classification word, but the present embodiment is not limited to such an example. The above elements are an example, and the present embodiment can be widely applied to the management of data item names composed of a plurality of hierarchical elements.

1 Database configuration management device, 11 Storage unit, 12 Data item editing unit, 13 Display control unit, 22 Registration location, 31 Processor, 32 Memory, 33 Input device, 34 Display device, 90, 131 List inquiry screen, 130 Menu screen, 132 Registration screen.

Claims (7)

A storage unit that stores multiple hierarchical elements that make up the data item name, which is the name of the data item registered in the database, in a tree structure.
When a new data item name, which is the data item name to be added, is accepted, it is based on the comparison result between each of the plurality of elements constituting the new data item name and each of the plurality of elements stored in the storage unit. , A data item editorial unit that specifies a registration location for registering elements constituting the new data item name in the tree structure.
A database configuration management device characterized by being equipped with. The data item editing unit compares each of the plurality of elements constituting the new data item name and each of the plurality of elements included in the tree structure in order from the upper hierarchy, and the elements of the same hierarchy are compared with each other. The database configuration management device according to claim 1, wherein the registration location is specified based on whether or not the data match. A display control unit that displays a plurality of the elements stored in the storage unit on the screen in a tree structure.
The database configuration management apparatus according to claim 1 or 2, further comprising. The database configuration according to claim 3, wherein the display control unit displays the position of the registration location in the tree structure on the screen when the data item editing unit identifies the registration location. Management device. The database configuration management device according to any one of claims 1 to 4, wherein the number of layers of the elements constituting the data item name is a predetermined fixed number. The database configuration management device according to claim 1, wherein the elements constituting the data item name are a modifier, a main word, and a classified word. The database configuration management device according to claim 1, wherein the data item editing unit additionally registers an element constituting the new data item name in the specified registration location.

Images