JP4958566B2 - Database information storage and retrieval system - Google Patents

Description

  The present invention relates to a database information storage / retrieval system and method for eliminating omission of database retrieval.

  A database is a collection of information shared by a plurality of users. In general, a user narrows down information by searching in order to extract necessary information from the database. When searching for information from the database, the search results intended by the user may not be obtained. The reason is that the database handles complex information that does not have a significant amount of input for each item. It is possible that the format for storing information is not uniform. Complex information described here refers to information that is not limited in choices such as place names and dates, and format refers to the number, order, and format of items.

  For example, when two people store the same information, the number of input items and the keywords used to express information in each item may be different. When such information is narrowed down by searching with a keyword from the database, there is a possibility that information cannot be obtained from the stored information without omission depending on the keyword to be searched. That is, a search omission occurs.

As a method for avoiding such a problem that search omissions occur and improving the accuracy of information search and obtaining a search result intended by a user, a method of controlling information already accumulated in a database has been mainly used. For example, as described in Patent Document 1, it is disclosed to use feature words appearing in a document when searching for similar documents. The conventional search method as shown in Patent Document 1 is effective, and corrects the notation and format of information stored in the database, and controls the association between the stored information. Thus, the search accuracy can be improved.
JP 2003-16092 A

  However, the conventional technique as disclosed in the above-mentioned Patent Document 1 cannot deal with anything other than the assumed notation fluctuation (for example, a synonym creation method) and the format collapse (for example, how to assemble a sentence expression), In addition, there has been a problem that it is not possible to deal with information leakage when information is stored.

  It is an object of the present invention to provide a database information storage / retrieval system and method for eliminating omission of database retrieval.

In order to solve the above problems, the present invention adopts the following configuration.
In an information storage / retrieval system for databases that store information in line units ,
Information storage using a fixed format consisting of multiple items for information storage and retrieval and specifying the information, and keywords selected from the pull-down menu used for each item except the item indicating the information name Is an information storage / retrieval system that uses the same standard format for both
The standard format includes a first classification indicating that the item is directly input, a second classification indicating that a keyword is selected and input from a pull-down menu, and information on the standard format. In the case of the first classification, the item is added in the middle of accumulation and has a third classification indicating that a keyword is selected and input from the pull-down menu. In the case of the second classification, the keyword and the search condition in the next item are checked without checking whether the input information in the first classification item matches the search condition. Checks whether the keyword in the second classification item matches the search condition, and if it matches, searches for the keyword in the next item If there is no match, the next row is searched, and in the case of the third classification, whether or not data exists in the third classification item is checked, If the search condition does not exist, the search condition is matched with the keyword in the next item, and if it exists, whether the search keyword matches the keyword in the third classification item. A check is made, and if they match, the keyword in the next item and the search condition are checked for matching, and if they do not match, the next line is searched .

  According to the present invention, information is input according to a fixed format and a search is performed using the same format, so that no search omission occurs. In addition, even if the number of items is added later for the format used for information storage, no search omission occurs before and after the addition.

  A database information storage / retrieval system according to an embodiment of the present invention will be described below in detail with reference to FIGS. FIG. 1 is a block diagram showing the overall configuration of a database information storage / retrieval system according to an embodiment of the present invention. FIG. 2 is a diagram showing an example of the contents of an input database for storing information related to this embodiment. FIG. 3 is a diagram showing a GUI (Graphical User Interface) when information is stored according to the present embodiment. FIG. 4 is a diagram showing a configuration of the database according to the present embodiment.

  FIG. 5 is a diagram showing a GUI when performing a search related to the present embodiment. FIG. 6 is a flowchart showing a procedure for performing a search related to the present embodiment. FIG. 7 is a diagram showing the results of a search related to this embodiment.

  1, a database information storage / retrieval system 100 according to an embodiment of the present invention includes an input device 101, an output device 102, a CPU 103, a memory 104, a control unit 105, and a storage device 106. Has been.

  The information storage / retrieval system 100 provides a database use environment, and an input device 101 in the system 100 is used to operate the database application 200, and inputs characters on the GUI provided by the database application 200. Operate buttons and buttons. The output device 102 is used to display a GUI provided by the database application 200 in a database usage environment.

  In this system 100, the CPU 103 executes the database application 200 read into the memory 104. The memory 104 is used in the system 100 for the database application 200 to be read and executed by the CPU 103. In the system 100, the control unit 105 controls data transfer between the input device 101, the output device 102, the CPU 103, the memory 104, and the storage device 106.

  The storage device 106 stores the database application 200, the input format 300, and the database 400. Here, the database application 200 is an application that uses the input format 300 to narrow down data by accumulating and searching data in the database 400. The input format 300 is a format used when the database application 200 narrows down data by storing and retrieving data. The database 400 is a collection of data accumulated by the database application 200.

  The database user uses the database application 200 read from the storage device 106 onto the memory 104 and uses the input device 101 to check the GUI provided by the input format 300 read by the database application 200 on the output device 102. Enter.

  An example of the contents of the input format 300 is shown in FIG. In FIG. 2, the item is the name of the item (in the example of FIG. 2, the item is name, brewery, style, alcohol content, color), and the classification of the item is the item input method and the item is created It is a classification for classifying time. The keyword 302 used for the item is a keyword group used in a pull-down menu when inputting information on an item in the same column and the item of the classification 301 or when narrowing down data by search ( Specific examples of items and their classifications A, B, and C will be described later).

  The input format 300 is a matrix that holds “items and their classifications 301” in the first row and “keywords 302 used for items” in the second and subsequent rows. In this case, zero or one or more “keywords 302 to be used for the item” are suspended. In the example of FIG. 2, the first column is only “items and their classifications 301” and there is no “keyword 302 used for items” because this item is an item for which information is directly input when data is input. It is.

  “Item and its classification 301” and “keyword 302 used for the item” are prepared when the database is created. The classification in “Items and their classifications” is for determining the input method for storing information in the database and whether or not the items were prepared when the database was created. “A” is an item for which information is directly input, “Category B” is an item input by selecting information from a pull-down menu, and “Category C” is an item input by selecting information from a pull-down menu It indicates that the item has been added after database creation.

  “Items and their classifications 301” and “keywords 302 used for items” are prepared when creating a database. However, in practice, new required items are often found after starting to use information storage. When a new item is added after the use of information storage is started, the category of the item is “Category A” when information is directly input (instead of selectively inputting information from a pull-down menu). When inputting information by selecting information from the pull-down menu, “classification C” is used, and the data narrowing process in the search is different (the data narrowing in the search will be described later).

  Here, with respect to the input format shown in FIG. 2, the case of accumulation and search of information regarding beer is illustrated. The first line of the input format consists of the product name in the first column, the brewery in the second column, the beer style in the third column, the alcohol content in the fourth column, and the beer in the fifth column. Fill in the color. Further, classification A is entered in the first column of the first row, classification B in the second, third, fourth and fourth columns, and classification C in the fifth column. However, in the fifth column, the item is not created at the beginning of accumulation in the input format, but is an item that is provided for the first time when the item is input in the fourth row (at this stage, the classification C is entered). ). In addition, taking Shochu as another example of the input format, the first line of the input format is the product name of shochu in the first column, the prefecture of the brewery in the second column, the type of raw material in the third column, The alcohol content may be entered in the fourth column, and the sweetness may be entered in the fifth column.

  Therefore, the keyword corresponding to the item is entered in the second and subsequent rows, and the product name (eg, Kanagawa Lager) is directly entered in the second row and the first column, and the second row and the second column are entered. For example, Kanagawa Brewing is selectively input from the pull-down menu for each brewery, and lager and 6% are selected and input from the pull-down menu in the third and fourth columns of the second row. In this way, information on the product name is also accumulated in the third line, and then when the color of beer is selected from the pull-down menu at the stage of the fourth line, the color of the beer starts from the fourth line. Is stored, and classification C is entered in the first line.

  As will be described later, when searching, the same format as the input format (see FIG. 5 described later) is used, so there is no omission in searching. Here, when searching, in the prior art, for example, when searching for a desired book name, when specifying a publisher, a place that should be a space publisher may be entered as publisher space or space publication. It was assumed that even in such input, a method of searching for the same as the space publisher by referring to the thesaurus was adopted. In this embodiment, as will be described later, when searching, the same format as information storage is used, and an item (for example, publisher) is selected by a pull-down menu, so a synonym is referred to. No information is leaked and no information leakage occurs.

  In this manner, information is input by the input application 101 while the input format 300 is read by the database application 200 and the provided GUI is viewed. An example of the provided GUI is shown in FIG. The example of FIG. 3 is a database regarding beer. That is, FIG. 3 is an example of a GUI in which the application program 200 reads and provides the input format 300. In this example, 501 is an item for directly inputting information, 502 to 505 are items for inputting information by selecting information from a pull-down menu, and 506 is pressed after all information has been input. This is a button for accumulating information input to the database 400.

  More specifically, the item 501 “name” (for example, a product name may be used) directly inputs information. The items 502 to 505 of “brewery”, “style”, “degree of alcohol”, and “color” are input by selecting information from a pull-down menu.

  As shown in FIG. 4, the input information is stored in the database 400 in such a way that each data is one line and the keywords input for each item are arranged in a matrix. Each column is data input for each item, but information about each item is stored separately as an input format 300 and thus is not included in the database 400. Here, the “color” item 505 ′ is assumed to be an item newly added after the database is created (refer to FIG. 4, after inputting the data on the second row and before inputting the data on the third row). No data is input before the second line.

  Next, the search will be described. For narrowing down data by search, the database application 200 reads the input format 300 and inputs information with the input device 101 while viewing the provided GUI. An example of the provided GUI is shown in FIG. In the example shown in the figure, 501 is an item for directly inputting information, and therefore cannot be used so that it cannot be used to narrow down data by search. Items 502 to 505 are items for inputting information by selecting information from a pull-down menu, and 506 is used to search for data matching the conditions from the database 400 when pressed after all information has been input. It is a button.

  More specifically, since the “name” item 501 ″ is an item in which information is directly input at the time of inputting information, data is not narrowed down by search. This is to prevent omission of search by not narrowing down the data by searching, since the items for which information has been directly input may be blurred. The items 502 "to 505" of "brewery", "style", and "alcohol content" select information from a pull-down menu. After all items are entered, the search button 506 ″ is pressed to narrow down data by searching from the database 400.

  Next, the narrowing of data by search will be described with reference to the flowchart of FIG. In step 601, variables m and n are used in order to compare the data of m rows and n columns of the database 400 with search conditions, and m and n are set to 1 as initial values. In step 602, it is checked whether or not the nth column “item and its classification 301” exists in the input format 300 (in the example of FIGS. 2 and 4, there is no item and classification in the sixth column). . If it exists, the process proceeds to step 603; otherwise, the process proceeds to step 604. In step 603, the nth “item and its classification 301” of the input format 300 is inspected (the classification in the first column is checked (classification A) in the examples of FIGS. 2 and 4).

  In step 604, the m-th row data in the database 400 is stored as search results in the same manner as the database 400 as data that matches the search conditions (in the example of FIGS. 2 and 4, the search has been made up to the sixth column. It means that the condition of the line matches, so it accumulates). However, when m and n are 1, there is no data in the m-th row, so nothing is accumulated in the search result.

  In step 607, if the classification inspected in step 603 is classification A, 1 is added to the variable n, and the process returns to step 602. In step 605, if the classification inspected in step 604 is classification B, it is confirmed whether the data of m rows and n columns in the database 400 matches the search condition. If they match in step 607, 1 is added to variable n, and the flow returns to step 602. If they do not match at step 608, 1 is added to the variable m, n is set to 1, and the process proceeds to step 609 (the first column of the next row is searched).

  In step 606, if the classification inspected in step 603 is class C, it is checked whether or not data of m rows and n columns exists in the database 400. If there is, the process proceeds to step 605; Proceed to 607 (as shown in FIG. 4, in the case of category C, even when the keyword selected from the pull-down menu does not exist, there is a situation that it was not listed as an item when the database was created (example in FIG. 4 Since there is a possibility that the search condition is matched, the process proceeds to the next procedure assuming that the search condition is matched).

  In step 609, it is checked whether or not the m-th row data exists in the database. If there is, the flow proceeds to step 602 (goes to the first column of the next row), and if not, the flow proceeds to step 610. In step 610, the search result is displayed on the output device 102 on the database application 200 stored in step 604, and the process ends.

  An example of the result of narrowing down data by search is shown in FIG. The database application 200 displays on the output device 102. The items of the input format 300 are configured in such a manner that the narrowing result by the search is suspended. The example shown in FIG. 7 is the result of narrowing down the data by searching under the condition (AND condition) that the item “alcohol” is “5%” and “color” is “black”. Is assumed to be data stored in the database 400 before the item “color” is added, the information (keyword) of the item “color” does not exist, but does not exist (the database shown in FIG. 4). In order to prevent a search omission from occurring with respect to the “−” mark in the configuration, it is displayed as shown in FIG.

  As described above, according to the embodiment of the present invention, when information is stored in a database without taking a method of controlling information that has already been stored in order to avoid a search omission, It is a database information storage / retrieval system that facilitates the storage / retrieval of information by adopting a storage method with the search in mind. In the configuration of the present embodiment, the information is stored and searched in the database by inputting information according to a standard format and performing a search using the same format so as not to cause a search omission. To do. In addition, when information is stored, a search system is constructed so as not to cause a search omission even when the number of items to be input is added to the format to be used.

It is a block diagram which shows the whole structure in the information storage / retrieval system of the database which concerns on embodiment of this invention. It is a figure which shows the example of the content of the input database for the information storage regarding this embodiment. It is a figure which shows GUI at the time of implementing the information storage regarding this embodiment. It is a figure which shows the structure of the database which concerns on this embodiment. It is a figure which shows GUI at the time of implementing the search regarding this embodiment. It is a flowchart which shows the procedure which implements the search regarding this embodiment. It is a figure which shows the result of having implemented the search regarding this embodiment.

Explanation of symbols

101 Input device 102 Output device 103 CPU
104 Memory 105 Control Unit 106 Storage Device 200 Database Application 300 Input Format 400 Database

Claims (1)

In an information storage / retrieval system for databases that store information in line units ,
Using a fixed format consisting of multiple items for identifying and storing information and identifying information, and keywords selected from pull-down menus used for each item except for items indicating information names,
An information storage / retrieval system that uses the same fixed format for information storage and search ,
The standard format includes a first classification indicating that the item is directly input, a second classification indicating that a keyword is selected and input from a pull-down menu, and information on the standard format. a third classification with representative to enter by selecting a keyword from the drop-down menu a items added in the course of storage, was closed,
When searching in line units, in the case of the first classification, the keyword and search in the next item are performed without checking whether the input information in the first classification item matches the search condition. There line the match check of the conditions,
In the case of the second classification, it is checked whether or not the keyword in the second classification item and the search condition match, and if they match, the keyword and search condition match check in the next item is performed. If it doesn't match, search for the next line,
In the case of the third classification , it is checked whether or not data exists in the third classification item. If there is no data, the search condition is matched and the keyword and the search condition in the next item are matched. If there is a match, the keyword in the third classification item and the search condition are checked to see if they match. If there is a match, the keyword and search condition in the next item are checked. An information storage / retrieval system that performs a search for the next line if they do not match .

Images