JPH04268670A - Dictionary definition information retrieval system - Google Patents

Abstract

PURPOSE:To shorten the retrieval time by generating an intermediate table where definition information are organized for individual retrieval purposes and not directly accessing definition information but accessing the intermediate table at the time of retrieving registered definition information. CONSTITUTION:Various definition information 2 and 3 related to a structural data base and its system constitution are registered in a dictionary 1. A definition information extracting and editing device 4 outputs an intermediate table 6, where definition information are transposed for individual retrieval purposes, onto an auxiliary storage device 5. For example, when definition information 10 and 11 consist of records consisting of information (A,B,C) and (C,D), the definition information extracting and editing device 4 retrieves occurrences of definition information 11 for an occurrence C1 of definition information 10 to find the same occurrence and outputs it to the intermediate table. In response to a retrieval request related to contents of definition information 10 and 11, a definition information retrieving and editing device 7 retrieves only the intermediate 6 to perform editing and output.

Description

[Detailed description of the invention]

0001

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a method for searching definition information in a data dictionary system for database/data communication.

0002

[Prior Art] The conventional technology is a search for various definition information registered in a dictionary in a structural database system, as shown in Japanese Patent Laid-Open Nos. 62-34230 and 63-66646. When a request is made, the necessary information is retrieved directly from the dictionary according to a search route set in advance for each search purpose, displayed, and then edited.

0003

[Problems to be Solved by the Invention] In the above-mentioned prior art, no consideration was given to the demand for high-speed retrieval of definition information registered in a dictionary.

The object of the invention is to speed up searches by accessing intermediate tables instead of directly accessing dictionaries.

[0005]

[Means for Solving the Problem] The above purpose is to create definition information that, in a dictionary system in which definition information regarding a structural database and its system configuration is registered in advance, sorts the definition information according to search purpose and outputs it to an intermediate table. This can be achieved by a dictionary definition information retrieval system characterized by having an extraction/editing means and a definition information search/editing means for retrieving definition information from the intermediate table using arbitrary items and combinations of items.

[0006].

[Operation] According to the present invention, an intermediate table edited for each search purpose is generated from definition information registered in a dictionary using a definition information extraction/editing device, and a definition information search is performed in response to an arbitrary search request. Necessary information can be retrieved from corresponding items or combinations of items in this intermediate table using an editing device.

[0007]

DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of the present invention will be described below with reference to the drawings. In FIG. 1, the present invention has a data dictionary 1
Various definition information 2 and 3 related to the structural database and its system configuration are registered in , and a definition information extraction/editing device 4 outputs an intermediate table 6 in which the various definition information is rearranged according to the search purpose onto the auxiliary storage device 5. and a definition information search and edit device 7 that searches the intermediate table 6 in response to a search request from the terminal 8 and outputs the result to the terminal 8 or printer 9.

FIG. 2 explains the relationship between two pieces of definition information. FIG. 2 is a data structure diagram of two pieces of definition information 10 and 11, and shows that each of the definition information 10 and 11 is constituted by a record type having information A, B, C, and C, D. At this time, assuming that the realized values of definition information 10 and 11 are expressed as shown in FIG.
Search for the realization values of , find the same one, and create intermediate table 6
Output to.

[0009] Hereinafter, the actual values C2, C3, . . . of the definition information 10 will be explained.
Similar processing is also performed for the intermediate table 12 shown in FIG. 3 to generate the intermediate table diagram 12 shown in FIG.

Next, after the intermediate table shown in FIG. 12 is generated, in response to an arbitrary search request regarding definition information 10 and 11, the definition information search/edit device 7 searches only the intermediate table 6, and after editing, All you have to do is output it.

For example, regarding definition information 10 and 11, B
When it is necessary to establish the relationship between and D, the definition information search and edit device 7 searches the intermediate table 6 and outputs the result to the terminal 8 or printer 9 in the tabular format shown in FIG.

[0012] Furthermore, the definition information search and edit device 7 can output requests for the same relationship as above, changing the output order as shown in FIG. 6, depending on how conditions are given.

FIG. 6 is a diagram showing another embodiment of the present invention, in which an intermediate table 6 created from a data dictionary 1 is stored in an extended storage device 1 using a definition information extraction/editing device 4.
3 Output on top. Thereafter, in response to a search request from the terminal 5, the intermediate table 6 on the extended storage device 13 is searched. According to this method, the intermediate table 6 can be accessed at high speed, thereby improving processing performance.

[0014]

According to the present invention, by generating intermediate tables organized according to purpose from definition information in a dictionary, it is possible to respond to any search request.

[0015] Furthermore, by searching by items and combinations of items in the intermediate table, there is no need to generate programs for each search purpose. Furthermore, the search can be constrained to access intermediate tables organized in a format suitable for the search without directly accessing the dictionary.

[Brief explanation of the drawing]

[Figure 1] Configuration diagram of the present invention

[Figure 2] Data structure diagram of definition information in the dictionary

[
Figure 3: Diagram showing an intermediate table

[Figure 4] Diagram showing realized values in a dictionary of definition information having the structure shown in Figure 2.

[Figure 5] Diagram showing the results of the present invention

FIG. 6 is a configuration diagram showing another embodiment of the present invention.

[Explanation of symbols]

1...Dictionary, 2...Definition information extraction and editing device, 3...
Auxiliary storage device, 4... definition information search device, 5... terminal, 6...
Printer, 1-1, 1-2...definition information, 3-1...intermediate table.

Claims (2)

[Claims] Claim 1: In a dictionary system in which definition information regarding a structural database and its system configuration is registered in advance, a definition information extraction and editing device that once sorts the definition information according to search purpose and outputs it to an intermediate table; A dictionary definition information retrieval system characterized by having a definition information retrieval/editing device for retrieving definition information using arbitrary items and combinations of items from a table.
2. A dictionary definition information retrieval system comprising an extended storage device that creates the intermediate table according to claim 1 on an extended storage area.