JPH08263515A - Character string retrieving method having no object of retrieval - Google Patents

Abstract

PURPOSE: To enable retrieval with irreducible necessary storage capacity without having any object of retrieval by providing a correspondence table of items and character string constitution and a ciphering rule table for the respective items. CONSTITUTION: Basic items are classified in conformity to the item constitution of a character string to be retrieved (table 10). A group of item as respective item constitution elements is classified (table 11). The respective item constitution elements are ciphered in character strings to be retrieved, so the items and ciphers are made to correspond to each other (tables 20-2n). For retrieval, a basic item is selected and the item constitution corresponding to the selected basic item is determined. Then, items 2-(n) are selected and collated with the table 11 in the order of items corresponding to the items 2-(n) and when there is a corresponding item in the table 11, ciphers of the tables 20-2n are determined according to the constitution. A combined retrieval character string is generated according to the item constitution. The retrieval is completed with this generated character string.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to an item search in a database in which a character string structure to be searched is standardized. For example, the present invention relates to a search method using an item such as an integrated circuit, a resistor, or a capacitor used for circuit design, a mounting form, a resistance value, and a capacitance value.

[0002]

2. Description of the Related Art Conventionally, in a database environment, when a search is performed using this type of item, there is a 1: 1 correspondence table between each item and the search target character string (see FIG. 5). . In the search, the presence / absence of each item 1 to n is determined from the table 1, the item having the matched character string is flagged, and the character string corresponding to the destination of the flag of all the items is selected from the table 2.

[0003]

In the conventional search method described above, all tables are added each time the number of search targets increases, so the corresponding table holds items for all character strings. For this reason, there is a drawback in that hardware with a small storage capacity cannot operate.

[0004]

In order to solve the above-mentioned problems, the present invention does not hold the search target character string in the table. Only the character string structure and encryption rule patterns are made into a table, and a character string is created by combining items when searching.

According to the character string search method of the present invention, in a database environment, in order to realize a search by an item for a character string in which an item is encrypted, a correspondence relation table between the item and the character string structure and each An item encryption rule table is provided, a character string configuration corresponding to the input item is determined from these tables, and a character string is created according to the encryption rule of each item.

[0006]

Next, the present invention will be described with reference to the drawings.

FIG. 1 is a flow chart for explaining an embodiment of the present invention. 2 and 3 are block diagrams of the database in this embodiment.

First, the structure of the database will be described. Basic items are classified according to the item configuration of the search target character string (FIG. 2-Table 10). The item group which is each item component is classified (FIG. 2-Table 11).
Since each item constituent element is encrypted in the search target character string, the item and the encryption are associated with each other (Fig. 3-
Tables 20-2n).

A character string search is performed using the above database. The search selects basic items (FIG. 1-).
The item structure corresponding to the selected basic item is determined (FIG. 1-). Next, items 2 to n are selected (FIG. 1-). It collates with the table 11 in the order of items corresponding to items 2 to n (FIG. 1-). If the item corresponding to the table 11 exists, the encryption of the tables 20 to 2n is determined according to the item configuration of the table 10 (FIG. 1-). A combination search character string is created according to the item configuration (Fig. 1-). The search is completed with the created character string (Fig. 1-). As a result, even if the character string to be searched is not held, it is possible to search by making the combination of items into rules.

Next, the operation of this embodiment will be described with reference to a concrete example. When searching for the part name of the resistor, select the item such as material, resistance value,
Rated power and tolerance are four. The material is "carbon",
If you select "1KΩ" for resistance, "1/4" for rated power, and "± 5%" for tolerance, the presence or absence of each item will be determined.
Depending on the item configuration, the product name "RDM14B2E102JC
BK ”is created.

[0011]

As described above, according to the character string search method of the present invention which does not hold a search target, the search target is held by holding the correspondence table of items and character string configurations and the encryption rule table of each item. Even if it does not, the search can be realized with the minimum required storage capacity.

[Brief description of drawings]

FIG. 1 is a flow chart showing an embodiment of the present invention.

FIG. 2 is a data configuration diagram showing an embodiment of the present invention.

FIG. 3 is a data configuration diagram showing an embodiment of the present invention.

FIG. 4 is a data configuration diagram showing a product name search for resistors as one specific example of the present invention.

FIG. 5 is a data configuration diagram showing a conventional example.

Claims (2)

[Claims] 1. In a database environment, a correspondence table between an item and a character string configuration and an encryption rule table for each item are provided to realize a search by the item for a character string in which the item is encrypted. A character string search method that does not have a search target, characterized by determining a character string structure corresponding to an input item from these tables and creating a character string according to the encryption rule of each item. 2. The character string search method according to claim 1, wherein the character string is a product name of a circuit component, and the item is an electrical characteristic value.