JPH08221431A - Data management method and database system thereof - Google Patents

Abstract

(57) [Summary] (Corrected) [Purpose] It is possible to add additional information to keywords and attach variables to keywords as data, enabling data retrieval by numerical values without defining keyword fields in advance. A data management method and a database system thereof are provided. [Structure] When registering data, the corresponding keyword and accompanying information according to the attribute of the keyword are added and registered,
The registered data is managed based on the corresponding keyword and accompanying information according to the attribute of the keyword.
The management of the data is a search, and the data is searched based on the keyword and the accompanying information according to the attribute of the keyword S89. The type of the incidental information is selected based on the corresponding keyword, and the input of the incidental information is instructed corresponding to the selected type. Further, the keyword and the associated information corresponding to the attribute are registered in association with each other, and the associated information is notified based on the designation of the keyword.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a system for managing and retrieving data by keyword in a computer, filing device, etc., and by adding a keyword to data by an easy means, it enables easy data retrieval. The present invention relates to a data management method and its database system.

[0002]

2. Description of the Related Art Conventionally, data is managed by a personal computer, etc.
Various types of databases have been devised and put into practical use as search software. As a typical example, a card database, a relational database,
Examples include catalog type databases.

[0003]

However, the conventional method is complicated in handling because it enables complicated data retrieval, and conversely, the simple one is incapable of complex data retrieval. As you can see, there are advantages and disadvantages. For example, in a card type database, before registering data in the database, it is necessary to predefine a keyword field indicating the attribute of the keyword to build the database, and once the database is built, the keyword field is changed. There was an inconvenience that it could not be done.

On the other hand, a relational database is constructed by combining "tables" that define keyword fields, so that various data can be registered in the database and complicated data retrieval is possible. There is. However, there is a drawback in that the work itself of constructing a database by combining tables is complicated.

The catalog type database is basically for visually searching data from thumbnail images of registered data, and is mainly for the purpose of managing image data. It had the drawback that it could only be done. The present invention eliminates the above-mentioned conventional drawbacks, allows a keyword to have accompanying information, and allows variables to be attached to data as keywords.
(EN) Provided are a data management method and a database system thereof that can perform data search by numerical values etc. without previously defining a keyword field and the like.

[0006]

In order to solve the above-mentioned problems, a data management method of the present invention is a data management method for managing data by a keyword attached to the data, which is provided when data is registered. A keyword to be added and accompanying information corresponding to the attribute of the keyword are added and registered, and the registered data is managed based on the corresponding keyword and accompanying information according to the attribute of the keyword. To do.

[0007] Here, the management of the data is a search, and the data is searched based on the keyword and accompanying information according to the attribute of the keyword. Further, the method further comprises the step of inputting the accompanying information. Further, the method further includes a step of selecting a type of accompanying information based on the corresponding keyword and instructing input of the accompanying information corresponding to the selected type. Further, it further comprises a step of registering the keyword and associated information corresponding to the attribute in association with each other, and a step of notifying the associated information based on the designation of the keyword. Further, it further comprises a step of notifying a list of pre-registered keywords. Further, in the notification process, a list of pre-registered keywords is displayed in such a manner that it can be identified whether or not it has the accompanying information. Further, the accompanying information is set by a numerical value, a character, a voice, an image, etc., corresponding to the attribute of the keyword.

Further, the database system of the present invention is a database system that manages data by keywords attached to the data, and adds a database, corresponding keywords and accompanying information according to the attributes of the keywords. Data registration means for registering data in the database, and data registered in the database,
It is characterized by comprising data management means for managing based on the corresponding keyword and accompanying information according to the attribute of the keyword.

Here, the data managing means includes a searching means for searching the data registered in the database based on the keyword and accompanying information according to the attribute of the keyword. Further, it further comprises an input means for inputting the accompanying information at the time of data registration or data search. Further, it further comprises an instruction means for selecting a type of the incidental information based on the corresponding keyword and instructing the input of the incidental information corresponding to the selected type. Further, it is further provided with a keyword registration means for registering the keyword and a condition of the accompanying information corresponding to the attribute in association with each other, and a notifying means for notifying the condition of the accompanying information based on the designation of the keyword. Further, the keyword registration means includes a keyword dictionary that stores a keyword name, a type of associated information, and associated information in association with each other. Further, it is further provided with display means for displaying a list of pre-registered keywords in a distinguishable manner as to whether or not the keyword has the accompanying information. Further, the accompanying information is set by a numerical value, a character, a voice, an image, etc., corresponding to the attribute of the keyword.

[0010]

Embodiments of the present invention will be described in detail below using a database system to which the data management method of the present invention is applied. <Configuration Example of Hardware System> FIG. 1 is an external view of a hardware system of the present embodiment for implementing the present invention.
FIG. 2 is a block diagram of the hardware system of this embodiment.

The hardware system of this embodiment has an arithmetic processing unit (CPU) 21 as a control unit and an internal storage memory 22 composed of a ROM and a RAM as a storage unit.
And a hard disk device (H
D) 13, floppy disk device (FD) 14, CD
A ROM drive 15; The system further includes a user interface hardware, a mouse 11 and a keyboard 12 for a user to input data and instructions to the system, and a CRT controller 2.
And a monitor 16 for providing the user with data that can be viewed through the display device 3. Mouse 11 and keyboard 1
2, the hard disk device 13, the floppy disk device 14, and the CD-ROM drive 15 include a general-purpose input / output unit 24.
It is connected to the arithmetic processing unit 21 via.

<Configuration Example of Database System> FIG. 3 shows the configuration of a database system using the data management method of this embodiment. In FIG. 3, the control unit 31 controls the operation of this system. (GUI management unit) The GUI management unit 32 is a graphical
This is for providing an easy operating environment by a user interface (GUI). Here, mouse 1
1 manages the operation of the system by 1 and various information from the system is displayed to the operator by the monitor 16.

(Keyword Management Unit) Keyword Management Unit 3
Reference numeral 3 is a part for managing a keyword having accompanying information according to the data management method of this embodiment, and holds a keyword dictionary 35 for managing the keyword. The management of keywords is executed by the CPU 21 according to a program stored in the memory 22, and the keyword dictionary 35 is built in the hard disk 13, for example. In the database system according to the present embodiment, when a data is registered in the database, a keyword to be attached to the data is not inputted by key input, but a keyword to be attached to the data is selected from the keyword dictionary 35 managed by the keyword managing unit 33. I have to. Further, it is possible to use a variable as a keyword, and in this embodiment, as shown in FIG. 4, the keyword is divided into four types, and three types (date, continuity, discontinue) among them are divided.
It is possible to use a keyword of "intuity" as a variable.

[0014] The "normal" type keyword is
The keyword has no value, and only the text that is the keyword name and the information of the type "normal" are described in the keyword dictionary. A "date" type keyword is a keyword having date and time as a variable value (parameter). In the keyword dictionary, the text and the type "dat" are used.
The information "e" is managed.
A “y” type keyword is a type of keyword whose name is a variable name that changes with a series of values (parameters).
“Nutinity”, the minimum value Min and the maximum value Ma of the variable
x, the step width Step of the variable are stored. The step width mentioned here is the minimum value when the variable changes, and for example, the step width is "1" in the case of an integer. "D
The “iscontinuity” type keyword is a type of keyword having text data as a value (parameter). As an example of this type of keyword,
“Chairman”, “president”, “department manager”, etc. are listed as possible values for the keyword name “category name”. This type of keyword is a text that is a keyword name and type "discontinuity",
The possible values are managed by the keyword dictionary.

(Database Engine Unit) The database engine unit 34 is a part that manages data stored in the database by adding a keyword to the data, and also a part that performs a data search using the keyword. Here, the registration and the search in the database are executed by the CPU 21 according to the program stored in the memory 22, and the database is, for example, the floppy disk 14 or C.
It is built in the D-ROM 15. The database engine unit 34 in the data management according to the present embodiment.
Has the information associated with the keyword, the associated information is also attached to the data together with the keyword for management.

That is, as shown in FIG.
If the "l" type keyword is attached to the data,
The database engine unit 34, together with the data, is a text which is a keyword name and a type "normal"
Is managed in association with the information. "Dat
If a keyword of type "e" is attached to the data,
As the keyword, the text that is the keyword name, the type “date”, and the parameter indicating the date and time are managed together with the data registered in the database. "Co
If a keyword of the type "ntinuity" is attached to the data, the text that is the variable name and the type "con"
The "tinuity" and a parameter that is a numerical value are managed by the database engine unit together with the data.
In the case of "discontinuity" type, a value (parameter) selected from the text, the type "discontinuity" and the possible values of the keyword
And are managed by the database engine unit together with data as keywords.

<Example of Operation of Database System> (Example of Keyword Registration) In the database system according to the present embodiment, since a method of selecting a keyword from the keyword dictionary 35 managed by the keyword management unit 33 and attaching it to the data is used, It is necessary to register the keywords to be attached to the keyword dictionary 35. Therefore, a method of registering keywords in the keyword dictionary 35 of the database system according to this embodiment will be described with reference to the flowchart shown in FIG.

In FIG. 6, first, the text which is the keyword name of the keyword registered in step S61 is input.
Next, in step S62, one of the four keyword types shown in FIG. 4 is selected and input. Hereinafter, different processing is performed depending on the type of keyword. First, when the "normal" type is selected in step S62, the process proceeds from step S63 to step S69.
The text that is the keyword name and the type "n" shown in FIG.
“Normal” is stored in the keyword dictionary 35 by the keyword management unit 33.

When the "date" type is selected in step S62, the process proceeds from step S63 to step S64, then to step S69, and in step S69,
As shown in FIG. 5, the text and the type “date” are stored in the keyword dictionary 35. If the "continuity" type is designated in step S62,
The process proceeds from step S64 to step S65, and since the keyword is a variable that changes with a series of numerical values, step S6
The process moves from step 5 to step S67, and in step S67, the minimum value Min, the maximum value Max, and the step width Step of the variables shown in FIG. 4 are designated. After that, the process proceeds to step S69, and the text and the type "co
“Nintuity” and Min, Max, and Step are stored in the keyword dictionary 35.

In step S62, the keyword "disc"
In the case of the "intuity" type, the process proceeds from step S65 to step S66, and the process proceeds from step S66 to step S68. "Discontin
The “utility” type keyword has a plurality of texts as possible values, and the value is input in step S68. Then, in step S69, the text and the possible values of the type “discontinuity” are stored in the keyword dictionary 35 as the information of the keyword.

As described above, in the data management method according to this embodiment, it is possible to use variables as keywords, and the keyword dictionary 35 also stores such information. (Example of adding keyword) Next, a method of adding a keyword to the data registered in the database will be described with reference to the flowchart of FIG. In the database using the data management method of this embodiment, a keyword is added to the data to be registered by selecting the keyword from the keyword dictionary 35.

First, in step S71, a keyword to be attached to the data is selected and designated from the keyword dictionary 35. After that, the processing will be different depending on the type of the selected keyword. The keyword selected in step S71 is "norma
In the case of "l" type, steps S72 to S8
The process moves to 0. In step S80, the text that is the keyword name and the type "norm" are used as the information of the keyword added to the data in the database engine unit 34.
"al" is sent and registered.

If the selected keyword is the "date" type in step S71, the process proceeds from step S72 to step S73, and from step S73 to step S76.
Processing shifts to. In the case of a "date" type keyword, data representing date and time is taken as a parameter, so that value is input in step S76. Then, step S
At 80, the text, the type “date”, and the date and time as a parameter are sent to the database engine unit 34 and registered as the information of the keyword associated with the data.

The keyword selected in step S71 is "c
In the case of the "intuity" type, step S73
To S74, the process moves from S74 to S77. Since the "continuity" type keyword is a variable having a numerical value as a parameter, the numerical value to be added to the data is input in step S7.
In the next step S78, it is determined whether or not the value input in step S77 is included between the minimum value Min and the maximum value Max of the keyword while also considering the step width Step, and if it is included, the process proceeds to step S80. If not included, the process returns to step S77 and the value is input again. In step S80, the text, the type "continuity", and the numerical parameter are sent to the database engine unit 34.

The keyword selected in step S72 is "d
In the case of “iscontinuity” type, the process proceeds from step S74 to step S75, and the process proceeds from step S75 to step S79. Since this type of keyword has text data as a parameter, in step S79, a keyword to be added to the data is selected from the parameter list of the keyword managed by the keyword dictionary 35. Then, in step S80, the text and the type "discoutinuity" and the selected parameter are sent to the engine part of the database as the keyword information of the data.

(Data Search Example) Next, the keyword dictionary 3
A method of designating a keyword from 5 and using it as a search key to perform data retrieval will be described with reference to the flowchart of FIG. First, in step S81, the keyword dictionary 3
The keyword used for the search is selected from 5 and used as the search key. As shown in FIG. 4, the keyword dictionary 35 manages the type of the keyword used as the search key, so that the subsequent processing is divided.

First, when the keyword is the "normal" type, the process moves from step S82 to step S89, and in step S89, the text which is the keyword name and the type "normal" are sent to the database engine unit 34, whereby the database The engine unit 34 searches for data. After that, in step S90, the GUI management unit 32 displays the search result on the monitor 16.

If the keyword specified in step S81 is of "date" type, the process proceeds from step S82 to step S83, and from step S83 to step S86.
The processing moves to. Since this type of keyword has data representing date and time as a parameter, step S8
In 6 specify the date and time used for the search. To search by a date and time range, specify the first date and time and the last date and time in that range. After that, in step S89, data retrieval is performed by sending the text of the keyword, the type “date”, the first date and time and the last date and time to the database engine unit 34. In step S90, the search result is displayed.

When the keyword is the "continuity" type, the process proceeds from step S83 to step S84, and the process proceeds from step S84 to step S87.
In the case of the "continuity" type, since the keyword has a series of numerical values as variables, the range of variables to be searched is specified in step S87. Here, the minimum value and the maximum value of the search range are designated, or these values must be within the variable range of the parameter of the keyword managed by the keyword dictionary 35. Then, in step S89, the text of the keyword, the type "continuity", and the minimum value and the maximum value of the search range are sent to the database engine unit 34 to perform a data search.

The keyword is "discontinuit
In the case of "y" type, steps S84 to S8
In step 5, the process proceeds from step S85 to step S88. In the case of the "discontinuity" type, since text data is included as a parameter, the parameter used for the search is selected from the list in step S88. At this time, if a plurality of parameters are selected from the list, it is possible to search by the plurality of parameters. Then, in step S89, the text that is the name of the keyword and the type "discontinuity" and step S89
Data is retrieved by sending the parameter designated by 88 to the database engine unit 34, and step S
Display the results at 90.

<Screen display example> Next, in a more specific example,
An example of data search in the database system of this embodiment will be described using a display screen. FIG. 9 is a search keyword display screen 91 in the database system of this embodiment.
Is.

In FIG. 9, the keywords stored in the keyword dictionary 35 are displayed in the keyword list display section 92. In the keyword list display section 92, the parameter holding mark 93 shows that the keyword should have a parameter. Here, the keywords that should have parameters are "date", "continuity", and "disc" in FIG.
These are three types of keywords, "intuity".

In this example, the keyword "date of birth" is
The keyword is a “date” type keyword, and a parameter holding mark 93 is added to the “date of birth” line in the keyword display area 92. The keyword "age" is
The parameter holding mark 93 is attached with a keyword of "continuity" type. Here, "age"
4, the minimum value Min is "0", the maximum value Max is "150", and the step width Step is "1".
The keyword “post” is a keyword of the classification name “post” and is a “discontinuity” type keyword. In addition, the possible values in Fig. 4 are "Chairman", "Vice Chairman", "President", "Vice President", "Manager".
Assume that you have “section manager”, “section manager”, “others”, and “none”. This is also a keyword that should have a parameter because the keyword holding mark 93 is in the "Title" line of the keyword list table 92. The keywords "general affairs department", "human resources department", "sales department", "research department" are "norma"
Since it is an "l" type keyword and has no parameter, no parameter holding mark is added in the keyword list display portion 92.

When data is searched using the keyword "general affairs department" as a search key, "general affairs department" is designated with the mouse from the keyword list display portion 92 in FIG. 9 and the OK button 94 is clicked. As a result, the database engine unit 34 uses the “general affairs department” and “norma” as search keys.
Data of the "l" type is sent and a data search is performed.

When a search is performed using the keyword "date of birth" as a search key, the "date of birth" in the keyword list display area 92 in FIG. 9 is specified with the mouse and the OK button 94 is clicked. Since the keyword “date of birth” is a “date” type keyword, the search range designation screen 100 of FIG. 10 is displayed. In FIG.
Date and time specified in the minimum value display unit 101 and maximum value display unit 10
By clicking the OK button 103, the date and time specified in 2 is sent to the database engine unit 34 together with the keyword name "date of birth" and the type "date".
Data search is performed.

On the other hand, when "age" is selected in the keyword list display section 92 in FIG. 9, the search range designation screen 111 in FIG. 11 is displayed. In the search range designation screen 111, the minimum parameter value 114 and the maximum parameter value 115 are the minimum value Min and the maximum value Ma of the keyword “age” stored in the keyword dictionary 35.
x, and a numerical value other than this value is the minimum value 112 in the search range.
And the maximum value 113 cannot be specified. Further, in this embodiment, the minimum value and the maximum value can be designated by using the scroll bars 118 and 119, and the values are displayed on the minimum value display section 116 and the maximum value display section 117. At this time, the scroll bars 118 and 119 indicate the step width S of the keyword "age".
Scroll step by step (here, Step =
1). Also, the maximum value cannot be specified smaller than the minimum value.
From this, when the OK button 11A is clicked, the keyword name "age", the type "continuity", the minimum value and the maximum value are sent to the database engine unit 34, and the data search is performed.

When "Title" is selected in the keyword list display portion 92 in FIG. 9, the search parameter designation screen 121 in FIG. 12 is displayed. A list of parameters of the keyword “post” is displayed on the parameter display unit 122 in FIG. 12, and the parameter display unit used for the search is clicked by clicking the parameter used for the search with the mouse and clicking the Add button 124. 12
The parameter is displayed in 3. This operation is repeated when searching with multiple parameters. OK button 1
When 26 is clicked, the keyword name “post”, the type “discontinuity”, and the parameters displayed in the parameter display section 123 used for the search are sent to the database engine section 34, and the data search is performed thereby.

As described above, since "date of birth", "age", "position", etc., which must be conventionally defined as a keyword field, can be used as a keyword, the date can be set without defining the keyword field in advance. It is possible to search by, numerical value or classification. In the present embodiment, the keyword types are “normal” and “d”.
"ate", "continuity", "disconti"
However, the present invention is not limited to this, and it is also possible to have a voice, an image, or the like as additional information.

The present invention may be applied to a system composed of a plurality of devices or an apparatus composed of one device. Further, it goes without saying that the present invention can be applied to the case where it is achieved by supplying a program to a system or an apparatus.

[0040]

According to the data management method of the present invention, since it is possible to add accompanying information to a keyword and attach a variable or the like to the data as a keyword, it is possible to use a numerical value or the like without defining a keyword field in advance. The effect is that data can be searched.

[Brief description of drawings]

FIG. 1 is an external view of a hardware system of this embodiment.

FIG. 2 is a block diagram of a hardware system of this embodiment.

FIG. 3 is a configuration diagram of a database system according to the present embodiment.

FIG. 4 is a diagram showing a keyword structure in a keyword dictionary of the present embodiment.

FIG. 5 is a diagram showing a structure of keywords associated with data in the database engine unit of the present embodiment.

FIG. 6 is a flowchart showing a processing procedure for registering a keyword in the keyword dictionary of this embodiment.

FIG. 7 is a flowchart showing a processing procedure for adding a keyword to the data according to the present embodiment.

FIG. 8 is a flowchart showing a processing procedure of data search by a keyword according to the present embodiment.

FIG. 9 is a diagram showing a search key designation screen according to the present embodiment.

FIG. 10 is a diagram showing a search range designation screen according to the present embodiment.

FIG. 11 is a diagram showing a search range designation screen according to the present embodiment.

FIG. 12 is a diagram showing a search parameter designation screen according to the present embodiment.

[Explanation of symbols]

 11 mouse 12 keyboard 13 hard disk device (HD) 14 floppy disk device (FD) 15 CD-ROM drive 16 monitor 21 arithmetic processing unit (CPU) 22 internal storage memory 23 CRT controller 24 general-purpose input / output unit 31 control unit 32 GUI management unit 33 keyword management unit 34 database engine unit 35 keyword dictionary

Claims (16)

[Claims] 1. A data management method for managing data by using a keyword attached to the data, wherein when the data is registered, the corresponding keyword and accompanying information according to the attribute of the keyword are added and registered. A method of managing data, wherein the generated data is managed based on the corresponding keyword and accompanying information according to an attribute of the keyword. 2. The data management method according to claim 1, wherein the management of the data is a search, and the data is searched based on a keyword and accompanying information according to an attribute of the keyword. 3. The data management method according to claim 1, further comprising a step of inputting the accompanying information. 4. The method according to claim 3, further comprising a step of selecting a type of accompanying information based on the corresponding keyword and instructing input of accompanying information corresponding to the selected type. Data management method. 5. The method according to claim 3, further comprising a step of registering a keyword and associated information corresponding to an attribute in association with each other, and a step of notifying the associated information based on designation of the keyword. Described data management method. 6. The method according to claim 1, further comprising a step of notifying a list of keywords registered in advance.
The data management method described in any one of 1. 7. The data management method according to claim 6, wherein in the notification process, a list of keywords registered in advance is displayed so that it can be discriminated whether or not it has the accompanying information. 8. The data management according to claim 1, wherein the incidental information is set by a numerical value, a character, a voice, an image, etc., corresponding to a keyword attribute. Method. 9. A database system for managing data by a keyword attached to the data, wherein the data is registered in the database by adding a database, a corresponding keyword and accompanying information according to an attribute of the keyword. A database system comprising: a data registration unit; and a data management unit that manages the data registered in the database based on the corresponding keyword and accompanying information according to the attribute of the keyword. 10. The data management means includes search means for searching data registered in the database based on a keyword and associated information according to an attribute of the keyword. Database system. 11. The database system according to claim 9, further comprising an input means for inputting the accompanying information at the time of data registration or data search. 12. The method according to claim 11, further comprising: instruction means for selecting a type of accompanying information based on the corresponding keyword and for instructing input of accompanying information corresponding to the selected type. Database system. 13. A keyword registration means for registering a keyword and associated information corresponding to an attribute in association with each other, and a notifying means for notifying the associated information based on the designation of the keyword. 11. The database system according to 11 or 12. 14. The keyword registration means includes a keyword dictionary that stores a keyword name, a type of associated information, and associated information in association with each other.
Database system described. 15. The display device according to claim 9, further comprising display means for displaying a list of pre-registered keywords so that it can be discriminated whether or not it has the accompanying information. Database system. 16. The database system according to claim 9, wherein the accompanying information is set as a numerical value, a character, a voice, an image, etc., corresponding to the attribute of the keyword. .