JP2002189756A - Method for generating list of retrieval result of relational database, retrieval device for relational database, and recording medium - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a system which is easy to read through without any awareness of hierarchy as a system which manages a series of volumes of materials (book, etc.), through a relational database(RDB). SOLUTION: An identification key item is specified among a plurality of items (field) included in the RDB and when retrieval from the RDB is performed, records having matching data by items as to the previously specified identification key item are detected from extracted records to extract a plurality of records as ones in the same series and generate series information, which is entered into a list of retrieval results while generated by having records replaced with a plurality of records included in the series.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a system for creating a list of relational database search results.

[0002]

[Prior Art] Books, CDs, CDs, such as library systems
-In a system that manages various materials such as media such as ROM, there are many cases where a series is composed of a plurality of volumes of materials.

[0003] In managing such materials, there is a merit that the browsability at the time of material search is improved by performing hierarchical management in which a series is set as an upper layer and each volume is managed as a lower layer.

[0004]

However, in order to implement such a hierarchical management in a library system, for example, a virtual series-level bibliography is first created, and then a holding unit (actual material) is created. The process of associating bibliographies had to be done manually.

[0005] Since such a task imposes a considerable burden on the library, it is rare that the library implements bibliographic hierarchy management. At present, it is only registered in the database.

The present invention has been made in view of such a problem, and determines data constituting a series from a plurality of data (records) retrieved from a relational database, and lists the data as data representing the series. An object of the present invention is to provide a system capable of managing data without being aware of the hierarchy by configuring display.

[0007]

In order to solve the above problems, the present invention provides a method for performing a search on a relational database and creating a list of extracted records as a search result. From a plurality of items included in the database, one or more items are specified as identification key items in advance, and when a search is performed on the relational database, the identification key items are extracted from the extracted records. A plurality of records are extracted as the same series by detecting a record in which data for each item matches, one series information is created for each extracted same series, and a plurality of records included in the same series are created. Alternatively, the created series information is configured to be listed in the list.

That is, in the present invention, one or more items are specified as identification key items in advance from a plurality of items (fields) included in the relational database, and a record in which the data of the specified identification key items match is specified. (Data) is extracted assuming that it is included in the same series. Then, series information corresponding to the same series including a plurality of records is created, and only the created series information, not all the records included in this series, is listed.

[0009] With this configuration, a plurality of records are compressed and listed as a series in the list of search results, so that material browsability similar to that in the case of performing hierarchical management of data can be realized. For this reason, the above-mentioned work for hierarchical management becomes unnecessary, and the burden on the administrator can be greatly reduced.

[0010] A plurality of identification key items are specified, and a conditional expression of the plurality of identification key items is specified. When a search is performed on a relational database, the above-mentioned identification key items specified in advance are added. By applying a designated conditional expression to extract records of the same series, it is possible to more flexibly set determination conditions of the same series.

[0011]

Embodiments of the present invention will be described below with reference to the drawings.

This embodiment is described by taking as an example bibliographic management in a library system.

FIG. 1 is a block diagram showing an example of the system configuration of the present invention.

Reference numeral 1 denotes a bibliographic database for storing bibliographs in the book management system, which is a relational database for storing bibliographic information of books stored by the library.

Reference numeral 2 denotes a search device, which is a bibliographic database 1
And a storage unit 21 for storing identification key items and conditional expressions, and also has a function of creating a list described later.

Reference numeral 3 denotes input means for instructing the search device 2 to input a search instruction, an identification key item, a conditional expression, and the like.

Reference numeral 4 denotes a display device 4 for displaying a list created by the search device 2.

The above example is a simple configuration example for explanation, and the present invention is not limited to this configuration. The search device 2 may be provided as a server, and a client terminal may be provided in place of the input device 2 and the display device 4, and input and display may be performed on the client terminal side. Further, the list created by the search device 2 may be printed and output by a printer instead of a display device (display).

Next, an example of bibliographic information managed in the bibliographic database will be described with reference to FIG.

This bibliographic information is provided corresponding to each book, and constitutes one record on the database. The bibliographic record has data for each item (field) such as a book title and an author name as shown in FIG. Some materials include items without data (for example, some materials have no subtitle).

FIG. 3 is a flowchart for explaining the operation of the search device 2 for creating a list of search results.

First, an identification key item and a conditional expression for identifying a series are set in the storage means 21 prior to the search based on an instruction from the operator using the input means 3 (step 101). This setting process is unnecessary if there is no need to change the identification key items and the conditional expressions that were performed earlier.

Next, the bibliographic database 1 is searched using search conditions (keywords, range designation, etc.) provided by the input means 3 (step 102).

From the records extracted by the search, a process of extracting a plurality of applicable records as the same series is performed by using the identification key items and the conditional expressions stored in the storage means 21 (step 103).

For the same extracted record, series information to be displayed is created in place of the record information, and
In the list of search results, the created series information is replaced with each record information included in the series, and the list is output, and the created list is output (step 104).

The above processing will be further described with reference to FIGS. 4 and 5 using specific examples of bibliographic data.

First, at step 101
For fixed key items and conditional expressions, the first key (item)
Two keys set as publisher and logical formula as AND
(FIG. 4A). This setting ensures that the titles are the same.
And the publisher is the same, it is a series
It is to be considered. The series names are the same here.
The series name is not registered as a fixed key item.
Unrecognized bibliography can be recognized as a series
This is because

Next, in step 102, the bibliographic database 1 is searched to extract bibliographic data (records) whose title (item) includes the character string "History of Japan" (FIG. 4 (b) )). In this example, 10 pieces of bibliographic data are extracted.

In step 103, items recorded as series identification key items are extracted (FIG. 5).
(A)). Further, since AND is specified as a conditional expression, the same book title and publisher are used as one series (FIG. 5B).

In this example, the search results 1 to 7 are recognized as the same series because the title is "History of Japan" and the publisher is "Fuji Publishing".

In step 104, information on the same series is displayed in a display area for one bibliographic data (record) (FIG. 5C). In this example, a symbol (star) indicating that the data is compressed and displayed as a series is displayed together with the title and publisher data used as the identification key items as the series information.

The present invention is not limited to the embodiment of the library system described above, but can be applied to general data managed by a relational database.

[0033]

As described above, according to the present invention, a plurality of records can be specified in advance as identification key information and a conditional expression for recognizing a plurality of records as the same series in a relational database search result list creation process. For example, for the data of the same series, the information of the series can be displayed collectively. That is, it is possible to improve the viewability of the list of search results without performing the work of registering data in the database in consideration of the hierarchy in advance as in the related art.

[Brief description of the drawings]

FIG. 1 is a block diagram showing a configuration of an embodiment of the present invention.

FIG. 2 is a diagram showing an example of bibliographic data according to the embodiment of the present invention.

FIG. 3 is a flowchart illustrating a process of creating a search result list according to the embodiment of the present invention.

FIG. 4 is a diagram (part 1) illustrating a specific example of creating a search result list in the embodiment of the present invention.

FIG. 5 is a diagram (part 2) illustrating a specific example of creating a search result list in the embodiment of the present invention.

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 1 Bibliographic database 2 Search device 21 Storage device 3 Input device 4 Output device

Continued on the front page (72) Inventor Eiko Fujiyama 2081-27 Tahara, Mashiki-machi, Kamimashiki-gun, Kumamoto F-term in Fujitsu Minami-Kyushu System Engineering Co., Ltd. 5B075 NK04 PQ02 PQ46 QT06 UU11

Claims (4)

[Claims] 1. A method of performing a search on a relational database to create a list of extracted records, wherein one or more items are identified in advance from a plurality of items included in the relational database by an identification key. When a search is performed on the relational database, a plurality of records in the same series are detected by detecting a record in which data for each item matches with the previously specified identification key item from the extracted records. Extracting one series information for each of the extracted same series, and listing the created series information in the list in place of a plurality of records included in the same series. To create a search result list for relational databases. 2. A method for designating a plurality of identification key items and specifying a conditional expression of the plurality of identification key items. When a relational database is searched, the identification key items specified in advance are added to the identification key items. 2. The method according to claim 1, wherein records of the same series are extracted by applying a designated conditional expression. 3. A search device for performing a search on a relational database and creating a list of extracted records, wherein one or a plurality of items designated in advance from a plurality of items included in the relational database. An identification key item storage means for storing an identification key item; a search means for executing a search on a relational database; and all the identifications stored in the identification key item storage means among the records extracted by the search means. The same series extracting means for extracting a plurality of records as the same series by detecting a record having the same data for each item of the key item, and creating one series information for each same series extracted by the same series extracting means And, to multiple records included in the same series, Ete search apparatus relational database, characterized in that it comprises a list creation means for posted series information said created the list. 4. A computer-readable recording medium which records a program for performing a process of searching a relational database and creating a list of extracted records as a search result by a computer, wherein the relational database includes: A process of designating one or more items as identification key items in advance from a plurality of items included in the database; and performing a search on a relational database and executing a search on the relational database. A process of extracting a plurality of records as the same series by detecting a record in which data for each item matches with respect to the identification key item, and creating one series information for each of the extracted same series; The created record is replaced with multiple records contained in A computer-readable recording medium having recorded thereon a program for executing processing for posting release information in the list.