JPH0756952A - Data extraction retrieval system - Google Patents

Abstract

PURPOSE:To improve the retrieval efficiency of a data base. CONSTITUTION:A retrieval file generation processing means 1 stores a record including a data content and a retrieval item in a data accumulation file 20 corresponding to the data content and stores a record having a synthesis retrieval item based on the retrieval item concerned in a retrieval file 10. An initial retrieval processing means 2 retrieves a record group for a first screen, which satisfies a retrieval request, from the retrieval file 10, extracts a retrieval result for the first screen from the data accumulation file 20 based on the retrieval and edits/displays the first screen. A retrieval work file generation processing means 3 operates in parallel to the initial retrieval processing means 2, retrieves all the record groups satisfying the retrieval requset from the retrieval file 10 and generates a retrieval work file 30 having the retrieval result for the whole screens based on the retrieval. A retrieval display processing means 4 edits/displays screens after the display of a second screen based on the retrieval work file 30.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a data extraction / retrieval method in a database retrieval system for retrieving a database consisting of a plurality of types of data storage files.

[0002]

2. Description of the Related Art Conventionally, in this type of data extraction / retrieval method, the following data extraction / retrieval process (records having data contents to be retrieved are stored in a database composed of plural types of data accumulation files). A process of searching and extracting from a file and editing / displaying the screen showing the search result) was performed. Note that different types of data storage files are created depending on the type of data content, and the records in each data storage file include the data content and the search item unique to that data storage file.

A search request having a search item specific to each data storage file as a search condition is issued to each of a plurality of types of data storage files. That is, a separate search request is issued for each type of data storage file.

Based on the search item (search condition) in the search request, a record group (record group satisfying the search request) having the data content of the search target is searched and extracted from the data storage file.

The extracted record group is edited for display, and a screen showing search results is displayed on the terminal.

Here, when a large number of data contents exist as search results and all the search results cannot be displayed on one screen, one of the following two methods has been taken. .

One-time operation by the operator (key operation, etc.)
Each time, one screen is searched, and one screen is edited and displayed based on the search.

All the searches are performed based on the search request, the search results are accumulated in the work file, and the data content for one screen is extracted from the work file for each operation of the operator etc. The minutes are edited and displayed.

[0009]

In the above-described conventional data extraction / retrieval method, a search is performed by a separate search request for each of a plurality of types of data storage files (this is because different data storage files are different). Even if the search conditions are the same), it is necessary to edit / display each search result for each type of data storage file, which causes a problem that the search efficiency of the database deteriorates.

Further, when a large number of data contents exist as search results for one search request and all the search results cannot be displayed at one time on one screen, one operation by an operator or the like. Since it is necessary to repeat the search, edit and display every time, and to create a work file for storing all the search results, there is a problem that the search efficiency (particularly, the search display efficiency) is deteriorated. That is, due to the former need, the response at the time of displaying each screen is delayed, and due to the latter need, it takes a long time to display the first screen.

The above problems increase the influence of the search efficiency (decrease in the search efficiency) due to the increase in the types of data storage files that make up the database, and increase the amount of information in the database and the combination of search conditions. It was an obstacle to diversification.

In view of the above points, an object of the present invention is to provide a "search file" consisting of only "integrated search items" for collectively managing search items in records in a plurality of types of data storage files with the same item. Is to provide a data extraction search method that improves the search efficiency of the database.

As conventional techniques for improving search efficiency, "JP-A-62-271178 (image information search method)" and "JP-A-63-68975 (screen information search method)" have been published. There is. However, these conventional techniques do not "improve the search efficiency of the database by using the search file" as in the present invention, and are different from the present invention in the point of view.

[0014]

A data extraction search method of the present invention is a database search system for searching a database consisting of a plurality of types of data storage files, and a search file for storing records consisting of only integrated search items. A data storage file that stores a record including a search item and data content, and a record that includes the data content to be stored in the database and that includes the data content and the search item extracted from the data content as the data content. Search file creation processing means for storing a record having an integrated search item based on the search item in the corresponding data storage file, and a record group for the first screen satisfying the search request from the search file. Search and extract the search results for the first screen based on the search. Initial search processing means for extracting a record group having data content groups from the data storage file to edit / display the first screen, and all records that operate in parallel with the initial search processing means and satisfy the search request A search work file is created by searching and extracting a group from the search file, and extracting a record group having a data content group that is a search result for all screens based on the search from the data storage file to create a search work file. It has a processing means and a search display processing means for editing / displaying the screen after the second screen is displayed based on the search work file created by the search work file creating means.

The data extraction / retrieval method of the present invention is a database retrieval system for retrieving a database consisting of a plurality of types of data storage files, and a retrieval file for storing records consisting of integrated retrieval items and retrieval items. The data storage file that stores records including data contents, a record that receives the data contents to be stored in the database, and includes the data contents and a search item extracted from the data contents, and the data corresponding to the data contents. Search file creation processing means for storing a record having an integrated search item stored in a storage file and having an integrated search item based on the search item, and a record group satisfying the search request is searched and extracted from the search file and based on the search A record that has a data content group that can be a search result By extracting the group from the data storage file and a retrieval processing unit for editing and displaying a screen showing the search results.

[0016]

The present invention will be described in detail with reference to the drawings.

FIG. 1 is a block diagram showing the configuration of an embodiment of the data extraction / retrieval method of the present invention (the data extraction / retrieval method of this embodiment corresponds to the invention described in claim 1).

The data extraction / retrieval method of this embodiment comprises a retrieval file creation processing means 1, an initial retrieval processing means 2, a retrieval work file preparation processing means 3, and a retrieval display processing means 4.
A search file 10, a plurality of types of data storage files 20, a search work file 30, and a terminal 40. In the data extraction / retrieval method of this embodiment, a database relating to newspapers is searched (the data accumulation file 20 is "article").
Related to "security information" and "photographs").

FIG. 2 is a diagram for explaining specific processing (processing from issuance of a search request to display of search results) of the data extraction search method of this embodiment.

FIG. 3 is a diagram showing a specific example of a record in the search file 10 in the data extraction search method of this embodiment.

The search file 10 is an integrated search item based on a search item (key item serving as a search condition) in a record in the data storage file 20 (the search items in the records in all the data storage files 20 are the same item). Records including only key items for collectively managing) are stored for all records in the all-data storage file 20. The number of records in the search file 10 is the same as the number of all records in the total data storage file 20, but since the data contents (article body text, stock price information, etc.) are not included, the amount of information in the search file 10 does not become excessive. (Therefore, the increase of the file capacity due to the new search file 10 is not serious).

The record in the search file 10 shown in FIG. 3 has the registration date, registration time, and
It has a genre and article number.

FIGS. 4A and 4B are diagrams showing specific examples of records in the data storage file 20 in the data extraction / retrieval method of this embodiment.

The data storage file 20 is created for each type of data content such as "article", "stock information", and "photograph", and the data content (article text, stock price information, etc.) is recorded in the record in each data storage file 20. ) And a search item peculiar to the data storage file 20 (the record in the data storage file 20 also includes a “display item” necessary for editing / displaying the screen).

The records in the data storage file 20 (data storage file 20 relating to "article" whose article body is data content) shown in FIG. 4A are searched items such as article number, genre (article type). Of major categories),
It has a genre (small category of article type), a registration date, a registration time, and the like. Further, the record in the data storage file 20 (the data storage file 20 relating to “stock information” whose stock price information is the data content) shown in FIG. 4B has article numbers, industry classifications (of the type of company) as search items. Large classification), registration date, registration time, type code (small classification of company type), etc. Although the structure of the search item group in both records is different, the search file 10
These records are managed collectively by the same integrated search item group. For example, the integrated search item "genre" in the record in the search file 10 shown in FIG.
Corresponds to the two search items “genre” and “genre” in the record in the data storage file 20 shown in FIG. 4A, and 2 in the record in the data storage file 20 shown in FIG. 4B. Corresponds to one search item "industry classification" and "type code".

Next, the operation of the data extraction / retrieval method of the present embodiment thus constructed will be described.

As a premise of the data extraction search process, the search file creation processing means 1 creates the search file 10 and various data storage files 20.

That is, the search file creation processing means 1
Inputs various data contents to be stored in the database, extracts a search item group from the data contents, and stores a record including the data contents and the search item group in the data storage file 20 corresponding to the data contents. Register with.
Further, the search file creation processing means 1 generates an integrated search item group based on the search item group (for example, FIG. 4).
The search items "genre" and "genre" in (a) are integrated into the integrated search item "genre", and the result is shown in FIG.
The integrated search item group having the arrangement as shown in FIG. 3 is generated together with other search items therein, and a record including only the integrated search item group is registered in the search file 10.

Search file creation processing means 1 as described above
Assuming that the search file 10 and the various data storage files 20 have been created by the processing of FIG. The process shown in 2 is performed.

First, when the initial search processing means 2 receives a search request, a record satisfying the search request (a record having an integrated search item corresponding to the search condition in the search request) is searched from the search file 10 for the first screen. Just search and extract.

Further, the initial search processing means 2 extracts the record groups in the data storage file 20 corresponding to the record groups in the search file 10 extracted as described above, and the data content group in these record groups. First having
The screen is edited / displayed on the terminal 40.

Further, when receiving the search request, the initial search processing means 2 passes the search request to the search work file creation processing means 3.

Upon receipt of the search request from the initial search processing means 2, the search work file creation processing means 3 searches and extracts all the record groups satisfying the search request from the search file 10, and the extracted search file 10 The record group corresponding to the record group of
A search work file 30 is created which is extracted from 0 and has those record groups as search results. Here, the processing of the search work file creation processing means 3 is performed in parallel with the processing of the initial search processing means 2 (thus, the first
The search work file 30 is created while the process for displaying the screen is being performed).

The search / display processing means 4 is triggered by the operation of the operator who indicates the "next screen request", and the search work file 3 is displayed.
Based on the search result stored in 0, display processing of all screens after the second screen is displayed (new screens after the second screen and first screens after the screens after the second screen are displayed. Is displayed again on the terminal 40.

The invention according to claim 2 can be realized even if the process relating to the creation of the search work file 30 is not performed in the above process. FIG. 5 is a block diagram showing the configuration of an embodiment of the data extraction / retrieval method of the invention according to the second aspect.

The data extraction retrieval system of the embodiment shown in FIG. 5 has the same components as the retrieval file creation processing means 1, the retrieval file 10, the data storage file 20 and the terminal 40 in FIG. It has a search processing means 5 for searching, editing and displaying for displaying one screen and screens after the second screen.

The retrieval processing means 5 retrieves and extracts a record group satisfying the retrieval request from the retrieval file 10 and retrieves a record group having a data content group as a retrieval result from the various data storage files 20 based on the retrieval. The extracted screen is edited and displayed on the terminal 40 to show the search result. At this time, if a large number of data contents exist as search results for one search request and all the search results cannot be displayed at one time on one screen, based on the operation of the operator, Search, edit, and display each screen.

[0038]

As described above, the present invention uses a search file that stores a record having an integrated search item that collectively manages search items in records in a plurality of types of data storage files as the same item. By doing
This has the effect of improving the search efficiency for the database.

Further, the search, edit, and display processes for displaying the first screen and the process for creating the search work file for storing all the search results are operated in parallel to search for one search request. As a result, even if a large number of data contents exist and all the search results cannot be displayed at one time on one screen, the search display efficiency is not significantly deteriorated and the search efficiency for the database is improved. The effect is that you can.

[Brief description of drawings]

FIG. 1 is a block diagram showing the configuration of an embodiment of a data extraction / retrieval method of the present invention.

FIG. 2 is a diagram for explaining a specific process of the data extraction / retrieval method shown in FIG.

FIG. 3 is a diagram showing a specific example of a record in a search file in FIG.

FIG. 4 is a diagram showing a specific example of a record in a data storage file in FIG.

FIG. 5 is a block diagram showing the configuration of another embodiment of the data extraction / retrieval method of the present invention.

[Explanation of symbols]

 1 Search File Creation Processing Means 2 Initial Search Processing Means 3 Search Work File Creation Processing Means 4 Search Display Processing Means 5 Search Processing Means 10 Search Files 20 Data Storage Files 30 Search Work Files 40 Terminals

Claims (2)

[Claims] 1. A database search system for searching a database composed of a plurality of types of data storage files, and a search file storing records including only integrated search items and a record including search items and data contents. The data storage file and the data content to be stored in the database are received, and a record including the data content and a search item extracted from the data content is stored in the data storage file corresponding to the data content and the search is performed. Search file creation processing means for storing a record having an integrated search item based on an item in the search file, and a record group for the first screen satisfying the search request is searched and extracted from the search file, and based on the search A record that has a data content group that is the search result for the first screen Initial search processing means for extracting from the data storage file to edit / display the first screen, and operating in parallel with the initial search processing means to search all the record groups satisfying the search request from the search file. Search work file creation processing means for creating a search work file by extracting from the data storage file a record group having a data content group that is a search result for all screens based on the search, A data extraction search method comprising: a search / display processing unit that edits / displays screens after the second screen is displayed based on the search work file created by the file creating unit. 2. A database search system for searching a database composed of a plurality of types of data storage files, and a search file storing records including only integrated search items and a record including search items and data contents. The data storage file and the data content to be stored in the database are received, and a record including the data content and a search item extracted from the data content is stored in the data storage file corresponding to the data content and the search is performed. Search file creation processing means for storing a record having an integrated search item based on an item in the search file, and a record group satisfying the search request is searched and extracted from the search file, and data which is a search result based on the search A record group having a content group is stored in the data storage file Data extracting search method characterized by having a search processing means for extracting and editing and display of a screen showing search results from.