JP3085251B2 - Database device, search method therefor, and recording medium recording search program for searching database device by computer - Google Patents

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a database apparatus, a search method therefor, and a recording medium on which a search program for searching a database apparatus by a computer is recorded. The present invention relates to a planning database device that provides reference information, a search method thereof, and a recording medium that stores a search program for searching a database device by a computer.

[0002]

2. Description of the Related Art Conventionally, a planning database apparatus of this kind is used, for example, in Japanese Patent Application Laid-Open No. Hei 8-016663 to search for data required by a production planning system. The target search key needs to exist in one layer. Therefore, it is necessary to register all search keys required by the production planning system in the first hierarchy, and to maintain data so as to always correspond to the latest information at that time.

Conventionally, in this type of planning database apparatus, it is necessary to prepare data of a lower hierarchy in order to associate a search key and a higher hierarchy with a plurality of data groups required by the production planning system. Therefore, it is necessary to register data for a plurality of data groups required by the production plan creation system and to perform subsequent maintenance.

Conventionally, this kind of planning database device is:
When the production plan creation system requires data, if there is no data in the lower layer data group in the required data unit, the data is serviced by going to the upper layer data group to search for data. Was. Therefore, when a large amount of data is required, it is necessary to refer to data of a plurality of layers, and it takes time to acquire all the data.

[0005]

In the above-mentioned conventional planning database apparatus, data of a lower hierarchy must be maintained in order to acquire data of a higher hierarchy. There was a drawback that the required man-hours required for the modification were large and dedicated maintenance personnel were required.

In addition, data of a lower hierarchy must be created for a plurality of data groups required by the production plan creation system, and similarly, there is a drawback that the required man-hour is large.

Further, when the production planning system needs the data, the data in the lower hierarchy is searched, and if no data exists in the lower hierarchy, the data must be searched again in the upper hierarchy. There is a disadvantage that it takes time to acquire data.

SUMMARY OF THE INVENTION The present invention has been made to solve the above-mentioned drawbacks of the prior art, and has as its object to reduce the number of maintenance steps and the search time, and a search method and a database apparatus thereof. Is to provide a recording medium on which a search program for searching for a program by a computer is recorded.

[0009]

According to the present invention, there is provided a database apparatus comprising: a first search key group in which each of a plurality of data items to be serviced is a first search key;
Of multiple search targets corresponding to each of the search keys
And a service data creating means for creating predetermined service data from the database, wherein the database comprises: the first data group. And a second search key composed of a plurality of second search keys generated by grouping the first search keys based on predetermined characteristics.
, A second data group consisting of a plurality of second data as search targets corresponding to each of the second search keys, and a plurality of search targets for each of the first search keys. A third data group having the second search key as data, wherein the service data creating unit searches for the first data group corresponding to the first search key group And when the target search key to be output does not exist in the first search key group, searches the third data group with the first search key, and performs the second search from the third data group. Second search means for obtaining a key;
And a third search means for searching the second data group using a second search key obtained by the second search means.

Further, another database apparatus according to the present invention exists in the database and in a first search key group of the third data group and does not exist in a first search key group of the first data group. extraction means for extracting a fourth search keys, search the third data group from the fourth search searched key group and the third data group of the fourth to get the second search key acquisition means and a fifth retrieval means for retrieving said second data group in the second search key group acquired by said fourth search means, from said second data group by the fifth search means Service data creation means including: addition means for adding new data to the first data group based on the obtained data and the fourth search key group;
It is characterized by including.

A search method according to the present invention includes a first search key group using each of a plurality of data items to be serviced as a first search key, and a plurality of search operations corresponding to each of the first search keys. A first data group including target first data, and a plurality of second search keys generated by grouping the first search keys based on the first data group and predetermined characteristics. A second search key group,
Of multiple search targets corresponding to each of the search keys of
And a third data group having a second search key as a plurality of search target data for each of the first search keys. A search method, comprising: a first step of searching for the first data group corresponding to the first search key group; and a target search key to be output to the first search key group as a result of the search. A second step of retrieving the third data group with the first search key when there is no, and obtaining the second search key from the third data group; and the obtained second search A third step of retrieving the second data group by a key.

In another search method according to the present invention, a first search key group using each of a plurality of data items to be serviced as a first search key, and a first search key group corresponding to each of the first search keys are provided. A first data group composed of a plurality of first data to be searched, and a plurality of second data generated by grouping the first search key based on the first data group and predetermined characteristics. A second search key group including a search key, a second data group including a plurality of second data to be searched corresponding to each of the second search keys, and each of the first search keys And a third data group having the second search key as a plurality of search target data for the database device, wherein the first search key group of the third data group And the said A first step of extracting a fourth search key group that does not exist in the first search key group of the data group, and searching the third data group with the fourth search key group to obtain the third data group A second step of obtaining the second search key from the second search key; a third step of searching the second data group with the second search key group obtained by the second search means; And a fourth step of adding new data to the first data group based on the data obtained from the second data group and the fourth search key group.

[0013] A recording medium according to the present invention includes a first search key group using each of a plurality of data items to be serviced as a first search key, and a plurality of searches corresponding to each of the first search keys. A first data group including target first data, and a plurality of second search keys generated by grouping the first search keys based on the first data group and predetermined characteristics. A second search key group,
Of multiple search targets corresponding to each of the search keys of
A database device including a database including a second data group consisting of the following data and a third data group having the second search key as a plurality of search target data for each of the first search keys. A search medium for storing a search program for searching by the computer, the program causing a computer to search for the first data group corresponding to the first search key group, and as a result of the search, When the target search key to be output does not exist in the search key group, the third data group is searched with the first search key, and the second search key is obtained from the third data group. A search program for causing a computer to search for a database device characterized by causing the second data group to be searched using the obtained second search key. Characterized in that the recording was.

In another recording medium according to the present invention, a first search key group using each of a plurality of data items to be serviced as a first search key, and a first search key group corresponding to each of the first search keys are provided. A first data group composed of a plurality of first data to be searched, and a plurality of second data generated by grouping the first search key based on the first data group and predetermined characteristics. A second search key group including a search key, a second data group including a plurality of second data to be searched corresponding to each of the second search keys, and each of the first search keys And a third data group having the second search key as a plurality of search target data with respect to a database device including a database. Grams to the computer present in the first search key group of the third group of data and the first
A fourth search key group that does not exist in the first search key group of the data group is extracted, the third data group is searched using the fourth search key group, and the second search key group is extracted from the third data group. A search key is obtained, the second data group is searched by the second search key group obtained by the second search means, and the data obtained from the searched second data group is compared with the fourth data. A search program for causing a computer to search for a database device characterized by adding new data to the first data group based on a search key group is recorded.

In short, according to the present invention, a plurality of data items can be searched only by providing a correspondence table between a search key and a group key and maintaining this table.
Maintenance man-hours can be reduced.

[0016]

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

FIG. 1 is a block diagram showing a first embodiment according to the present invention. Referring to the figure, the planning database device shown in the figure is a database 1 comprising three data groups A11, B12 and C13 to be described later.
And a data creation unit 12 including search units 21, 22, and 23 for searching data corresponding to each of the data groups A11, B12, and C13. Less than,
The data structure of this apparatus will be described by taking a manufacturing process of a ROM (Read Only Memory) as an example.

Referring to FIG. 2, FIG. 2A shows a data group A11, FIG. 2B shows a data group B12, and FIG. 2C shows a data group C13. . In other words, a planning database is composed of the data groups shown in FIGS. 2A to 2C.

Here, the data group A11 shown in FIG. 1A is used for performing a normal data service. The data group B12 shown in FIG.
Has a grouping key data structure in which the data group A11 is grouped based on specific characteristics. Furthermore, the data group C13 shown in FIG.
There is a correspondence between key items used for performing data service and grouping keys.

In FIG. 2A, a data group A11 is
Type A1 individually indicating the codes “KD-AAA” K1 and K2 of the type (ROM in this example) to be managed as key items, code A2 of the type group in which this type A1 is grouped, and work on type A1 A process code A3 indicating a process to be performed, an equipment code A4 indicating equipment used in the process corresponding to the process code A3, and an index time A5 indicating a time required for the process corresponding to the process code A3 in seconds [s]. And

In this example, the code "KD-AAA" K1
And K2, the process codes “1000” and “200”
A work process corresponding to “0” is performed. The equipment used at that time is the bonding apparatus indicated by the equipment code “BDG01” and the tester indicated by the equipment code “TST01”. The time required for the work process by the bonding apparatus indicated by the equipment code “BDG01” is “10”.
[S], the time required for the work process by the tester indicated by the equipment code “TST01” is “20” [s].

The data group B12 has a product group B2 obtained by grouping a plurality of product types B1 as key items.
Then, the product type group B2 stores the data “QFP64
P2.7 "L1, L2 and L3 and the process code B3" 1
000 "," 2000 "and" 2000 ". Then, the process codes B3 “1000”, “200”
The facility codes B4 corresponding to "0" and "2000" are "BDG01", "TST01", and "TST02", respectively. Equipment code B4 “BDG01”, “TST01”,
The index time corresponding to “TST02” is “4
0 "," 50 ", and" 60 ".

"QFP" stands for Quad Flat
Package, “64P” indicates 64 pins, and “2.7” indicates that the thickness of the package is 2.7 [mm].

The data group C13 includes “KD-B” of the product type C1.
BB "M1 and" KD-CCC "M2 as key items,
A type group C2 is formed by grouping the type C1.

The service data D14 is data when the type D1 has acquired data of "KD-BBB" N2, N3. Here, the data group A1 is searched for “KD-BBB”, but the data group A11 includes the type “KD-BBB”.
“BB” is not registered. Therefore, the data group C13
Is searched for the product type “KD-BBB” to obtain the product type group “QFP64P2.7”. Here, the data group B12 is searched using the acquired “QFP64P2.7”,
The three data of 1, L2 and L3 are acquired. When performing the service, the search key “KD-BBB” is set in the type D1, and the types D2, D4, and D5 have the data group B.
The data obtained from 12 is set. Thus, the service is performed.

Next, a processing procedure for creating the service data D14 of FIG. 2 from the database having the database structure shown in FIG. 2 will be described with reference to the flowchart of FIG. First, the data group A11 is searched for using "KD-BBB" as the search key K01 (step S1).

As a result of the search, if the type "KD-BBB" exists in the data group A11, the data service is performed (steps S2 to S8). However, here, the variety "KD
"-BBB" does not exist in the data group A11. Therefore, the data group C13 is searched using the search key K01 “KD-BBB” (steps S2 → S3), and the search key K0 is searched.
Then, “QFP64P2.7”, which is 2, is acquired (step S4).

The search key K02 "QFP64P
2.7 ”to retrieve the data group B12 (step S5),
A data item corresponding to "QFP64P2.7" is obtained (step S6). Then, new data is created from “KD-BBB” and the data item obtained by searching the data group B12 (step S7), and the data service is performed (step S7 → S8). "Data Service"
Means returning data search results.

A database device according to a second embodiment of the present invention is shown in the block diagram of FIG. In the figure, the same parts as those in FIG. 1 are indicated by the same reference numerals.

Referring to FIG. 1, a database device according to the present embodiment includes a database 101 including three data groups A11, B12, and C13, and a data group A11,
It is configured to include search units 121, 122, and 123 for searching data corresponding to B12 and C13, and a data creation unit 102 having a data updating unit 124 that writes the searched data to the data group A11.

FIG. 5 shows an example of service data created by the database device shown in FIG. The data items of the data group A21 shown in the figure are the same as the data items of the data group A11 described above. That is, in the data group A21, the search key is the type A1, and has the type code A2, the process code A3, the facility code A4, and the index time A5.

In this data group A21, the type A1 is "KD
-AAA "O1, O2," KD-BBB "O3, O4
O5, “KD-CCC” data O6, O7, O8. “KD-AAA” is data that originally existed in the data group A11, and “KD-BBB” and “KD-C”
“CC” is data added in the current process.

Next, with reference to the flowchart of FIG. 6, a processing procedure for creating the data group A21 of FIG. 5 from the database having the database structure shown in FIG. 4 will be described.

First, the difference between the key item of the data group A11 and the key item of the data group C13 is extracted (step T).
1). In this case, “KD-BBB” and “KD-CC
C "is the difference data.

Thereafter, the data group C13 is searched using the search key K01 for the extracted difference data (step T2), and the search key K02 is obtained (step T3).
The search key K02 in this case is “QFP64
P2.7 ". With this search key K02, the data group B1
2 is searched (step T4). The search key in this case is “QFP64P2.7”, and the acquired data is all data using “QFP64P2.7” as the search key (step T5).

The difference retrieval key K01 and the data group B12
New data is created by combining the data items (step T6) and registered in the data group A11 (step T6).
7). New data is created because the data acquired from the data group C13 and the data group B12 needs to be in the form of service data.

The present invention is not limited to the above-described embodiment, and various modifications are possible. For example, the number of the data group A11 is not limited to one, and it goes without saying that the data group C13 can be shared even with two or more data groups.

The present invention is not limited to a planning database, but can be applied to a database that holds manufacturing data for production at a factory or the like.

By preparing a recording medium on which a program for realizing the processing of FIG. 3 or 6 described above is recorded and controlling a computer using the recording medium, the database apparatus of FIG. 1 or FIG. It is clear that a search similar to that described above can be performed. This recording medium contains
Various recording media can be used in addition to the semiconductor memory and the magnetic disk device not shown in FIG. 1 or FIG.

That is, the database apparatus of the present invention provides a first search key group using each of a plurality of service target data items as a first search key, and a plurality of search corresponding to each of the first search keys. The first of the first data of interest
(1 in FIG. 1) including a data group (11 in FIG. 1), and a service data creating unit (2 in FIG. 1) for searching the database and creating predetermined service data An apparatus, wherein the first data group and the first characteristic are determined based on a predetermined first characteristic.
And a second search key group including a plurality of second search keys generated by grouping the search keys, and a second search key group including a plurality of search target second data corresponding to each of the second search keys. (12 in FIG. 1) and a third data group (13 in FIG. 1) having the second search key as a plurality of search target data corresponding to each of the first search keys
The service data creation unit 2 includes: a first search unit (21 in FIG. 1) for searching the first data group corresponding to the first search key group; A second search unit that searches for the third data group with the first search key and obtains a second search key from the third data group when there is no target search key to be output; 2 of 2
3) and a third search unit (2 in FIG. 1) that searches for a second data group using the second search key acquired by the second search unit.
2).

Further, in the search method of the present invention, a first step (S1 in FIG. 3) of searching for data of the first data group with reference to the first search key group; A second step (S2 in FIG. 3) of retrieving an inspection key group to determine whether or not a first search key exists; and determining the third data group when the first search key does not exist. Search and
The third step of obtaining the second search key (S in FIG. 3)
3, S4) and a fourth step (S5, S6 in FIG. 3) of searching the second data group with the second search key.

Further, another database apparatus according to the present invention includes a plurality of second search keys generated by grouping the first search keys based on the first data group and a predetermined first characteristic. A second search key group, a second data group (112 in FIG. 4) including a plurality of search target second data corresponding to each of the second search keys, and the first search key And a third data group (113 in FIG. 4) having the second search key as a plurality of search target data for each of the service data creation units 2.
Means for extracting a fourth search key group that exists in the first search key group of the third data group but does not exist in the first search key group of the first data group (121 in FIG. 4); The third
The second search means (123 in FIG. 4) for searching the data group of No. by the fourth search key and obtaining the second search key from the third data group, and the second check means A third search unit (122 in FIG. 4) for searching the second data group with the second search key group; data from the second data group acquired by the third search unit; Means for adding new data from the search key No. 4 to the first data group (FIG. 4)
124).

Another search method according to the present invention is the third search method.
A first step (T1 in FIG. 6) of extracting a fourth search key group that exists in the first search key group of the data group and does not exist in the first search key of the first data group. A second step (T2 and T3 in FIG. 6) of searching the third data group with the fourth search key group and obtaining a second search key from the third data group; A third search for searching the second data group with the second search key group obtained in the step
(T4, T5 in FIG. 6), the data from the second data group acquired in the third step, and the fourth
The step (T7 in FIG. 6) of adding new data in the first data group from the search key is performed.

As described above, for an item that does not need to have detailed data, a plurality of data items can be searched only by maintaining a correspondence table between a search key and a group key. Therefore, the number of maintenance steps can be reduced.

When data grouped according to the present invention is used, it is necessary to search not only a normal table but also a grouped table, which takes a long processing time. However, by expanding the data grouped in advance into a normal table, the search time can be reduced, and the processing can be speeded up.

The present invention can further take the following aspects in connection with the description of the claims.

(1) The database apparatus according to claim 1 or 2, wherein the first data group includes data on a kind, a process, equipment, and time required in a semiconductor manufacturing plant.

(2) The retrieval method according to (3) or (4), wherein the first data group includes data on a kind, a process, equipment, and a time required in a semiconductor manufacturing plant.

(3) The recording medium according to (5) or (6), wherein the first data group includes data on a kind, a process, equipment, and a time required in a semiconductor manufacturing plant.

[0050]

As described above, according to the present invention, a plurality of data items can be searched by providing a correspondence table between search keys and group keys, and by maintaining this table, the number of maintenance steps can be reduced. There is.

[Brief description of the drawings]

FIG. 1 is a block diagram illustrating a configuration of a database device according to a first embodiment of the present invention.

FIGS. 2A to 2C are diagrams illustrating examples of data groups of a database in FIG. 1, and FIG. 2D is a diagram illustrating an example of data serviced by the database device in FIG.

FIG. 3 is a flowchart illustrating an operation of a data creation unit in FIG. 1;

FIG. 4 is a block diagram illustrating a configuration of a database device according to a second embodiment of the present invention.

FIG. 5 is a diagram illustrating an example of data serviced by the database device of FIG. 4;

FIG. 6 is a flowchart showing an operation of a data creation unit in FIG. 5;

[Explanation of symbols]

 1,101 database 2,102 data creation unit 21,22,23,121,122,123 search unit 124 data update unit A11, B12, C13 data group

──────────────────────────────────────────────────の Continued on the front page (58) Field surveyed (Int.Cl. ⁷ , DB name) G06F 17/30 JICST file (JOIS)

Claims (6)

(57) [Claims] 1. A first search key group using each of a plurality of data items to be serviced as a first search key, and a plurality of first search objects corresponding to each of the first search keys. And a service data creating means for creating predetermined service data from the database, wherein the database comprises the first data group. And a second search key group including a plurality of second search keys generated by grouping the first search keys based on predetermined characteristics, and a plurality of searches corresponding to each of the second search keys. A second data group consisting of second data to be processed, and a third data group having the second search key as a plurality of search target data for each of the first search keys. The service data creation means includes: first search means for searching for the first data group corresponding to the first search key group; and a target search key to be output to the first search key group. When no data exists, the third data group is converted to the first data group.
A second search unit that retrieves the second search key from the third data group by searching with the search key, and the second data group based on the second search key that is acquired by the second search unit And a third search means for searching for a database. 2. Extracting the database and a fourth search key group that is present in the first search key group of the third data group and is not present in the first search key group of the first data group. Extraction means; fourth search means for searching the third data group with the fourth search key group to obtain the second search key from the third data group; and the fourth search means Fifth search means for searching the second data group with the second search key group obtained by the second search key group, data obtained from the second data group by the fifth search means, and the fourth search key Group based on the first
2. The database apparatus according to claim 1, further comprising: service data creating means including adding means for adding new data to the data group. 3. A first search key group using each of a plurality of data items to be serviced as a first search key, and a plurality of first search objects corresponding to each of the first search keys. And a second search key consisting of a plurality of second search keys generated by grouping the first search keys based on the first data group and predetermined characteristics. Group, a second data group consisting of a plurality of second data as search targets corresponding to each of the second search keys, and a plurality of search target data for each of the first search keys. Third with second search key
A search method for a database device including a database including a first data group, wherein a first step of searching for the first data group corresponding to the first search key group; When the target search key to be output does not exist in the one search key group, the third data group is searched with the first search key, and the second search key is obtained from the third data group. A retrieval method, comprising: a second step; and a third step of retrieving the second data group using the acquired second retrieval key. 4. A first search key group using each of a plurality of data items to be serviced as a first search key, and a first search target group corresponding to each of the first search keys. And a second search key consisting of a plurality of second search keys generated by grouping the first search keys based on the first data group and predetermined characteristics. Group, a second data group consisting of a plurality of second data as search targets corresponding to each of the second search keys, and a plurality of search target data for each of the first search keys. Third with second search key
A search method for a database device including a database including a data group of the first data group and a first search key group of the first data group. A first step of extracting a fourth search key group that is not performed, and a second step of searching the third data group with the fourth search key group and acquiring the second search key from the third data group. Step 2, a third step of searching the second data group with the second search key group obtained by the second search means, and data obtained from the searched second data group. A fourth step of adding new data to the first data group based on the fourth search key group. 5. A first search key group using each of a plurality of data items to be serviced as a first search key, and a plurality of first search objects corresponding to each of the first search keys. And a second search key consisting of a plurality of second search keys generated by grouping the first search keys based on the first data group and predetermined characteristics. Group, a second data group consisting of a plurality of second data as search targets corresponding to each of the second search keys, and a plurality of search target data for each of the first search keys. Third with second search key
A storage medium storing a search program for a computer to search a database device including a database including a first data group and a first data group corresponding to the first search key group. When a target search key to be output does not exist in the first search key group as a result of the search, the third data group is searched using the first search key. Recording a search program for searching a database device by a computer, characterized by causing the second search key to be obtained from a group and searching the second data group by the obtained second search key. Recording medium characterized by the above-mentioned. 6. A first search key group using each of a plurality of data items to be serviced as a first search key, and a plurality of first search objects corresponding to each of the first search keys. And a second search key consisting of a plurality of second search keys generated by grouping the first search keys based on the first data group and predetermined characteristics. Group, a second data group consisting of a plurality of second data as search targets corresponding to each of the second search keys, and a plurality of search target data for each of the first search keys. Third with second search key
A storage medium storing a search program for searching for a database device including a database including a data group of the third data group by a computer, wherein the program is stored in a first search key group of the third data group. And extracting a fourth search key group that does not exist in the first search key group of the first data group, searching the third data group with the fourth search key group, and extracting the third data group. To retrieve the second search key, retrieve the second data group with the second retrieval key group acquired by the second retrieval means, and retrieve the data acquired from the retrieved second data group. A search program for searching a database device by a computer, wherein new data is added to the first data group on the basis of and the fourth search key group. Recording medium characterized by recording a ram.