JPH0594449A - Parts information management system - Google Patents

Abstract

PURPOSE:To use the correct content of necessary parts information as necessary by the user of a local device. CONSTITUTION:An inputting part 1 inputs input parts information 2, and a data base updating part 3 registers it in a host computer data base 4. A parts classification judging part 7 collates the parts classification code of the input parts information 2 to the parts classification code in a parts classification managing table 8, and outputs the matched input parts information 2. A parts judging part 5 collates the parts code of the input parts information 2 to the parts code in a parts managing table 6, and outputs matched update part information 9. A parts classification managing table updating part 13 sets the parts classification code of the parts information at the parts classification managing table 8, and a parts managing table updating part 12 sets the parts code of the parts information at the parts managing table 6. A local database updating part 10 registers the update parts information 9 in a local data base 11.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a parts information management system, and more particularly to a parts information management system constructed on a database distributed information processing system consisting of a host computer having a host computer database and a local device having a local database. ..

[0002]

2. Description of the Related Art Conventionally, in this type of component information management system, a component information transfer request input by an operator in a local device is sent to a host computer, and component information matching this component information transfer request is extracted from a host computer database. Then, the extracted part information is transferred to the local device and the local database is updated.

[0003]

In this conventional parts information management system, it is necessary to intervene the operator to update the local database. Therefore, even if new parts information is registered in the host computer database, Even if the existing part information is changed, the user of the local device will use the old local database unless the part information is retrieved to the local database, and the part information cannot be used in a timely manner. There was a flaw.

In view of the above points, an object of the present invention is to register (or update) the component information input (or changed) on the host computer side in the host computer database, and at the same time to register the component in the local database on the local device side. An object of the present invention is to provide a parts information management system that allows a user of a local device to use necessary parts information with correct contents when necessary by registering (or updating) information.

[0005]

A parts information management system according to the present invention is a parts information management system constructed on a database distributed information processing system comprising a host computer having a host computer database and a local device having a local database. In, an input unit for inputting the component information, a database updating unit for registering the inputted component information in the host computer database, a component management table for managing the component code of the component information previously registered in the local database, and an input A component determination unit that compares the component code of the generated component information with the component code in the component management table and outputs the component information having the matched component code, and the component classification of the component information registered in the local database in advance. Manage code A product classification management table, a component classification determination unit that outputs the component information having the matched component classification code by comparing the component classification code of the input component information with the component classification code in the component classification management table, A local database updating unit that registers the component information output from the component determining unit and the component classification determining unit in a local database; a component management table updating unit that sets the component code of the component information in the component management table; And a component classification management table updating unit that sets a component classification code in the component classification management table.

[0006]

In the parts information management system of the present invention, the input section inputs the parts information, the database updating section registers the entered parts information in the host computer database, and the parts management table is registered in the local database in advance. The part code of the part information is managed, and the part judgment part compares the part code of the input part information with the part code in the part management table and outputs the part information having the matched part code. Manages the part classification code of the part information that is registered in the local database in advance, and the part classification code in the part information entered by the part classification determination unit and the part classification code in the part classification management table are matched and matched. Outputs the component information that has the component classification code, and the local database updater The part information output from the classification determination part is registered in the local database, the part management table update part sets the part code of the part information in the part management table, and the part classification management table update part sets the part classification code of the part information to the part Set in the classification management table.

[0007]

DESCRIPTION OF THE PREFERRED EMBODIMENTS Next, the present invention will be described in detail with reference to the drawings.

FIG. 1 is a block diagram showing the configuration of a parts information management system according to an embodiment of the present invention. The component information management system of this embodiment is provided with a host computer 20.
The host computer 20 includes an input unit 1, input component information 2, a database updating unit 3, a host computer database 4, a component determining unit 5, and a component management table 6. The component classification determination unit 7, the component classification management table 8, the updated component information 9, the component management table updating unit 12, and the component classification management table updating unit 13 are provided.
It has a local database updating unit 10 and a local database 11.

Referring to FIG. 2, the format of the input part information 2 comprises a part code, a part classification code and a part attribute. The component attributes consist of product name, rating, external shape, reliability and the like.

Referring to FIG. 3, the entry format of the parts management table 6 consists of part codes.

Referring to FIG. 4, the entry format of the parts classification management table 8 consists of parts classification code.

Next, the operation of the component information management system of this embodiment constructed as described above will be described.

[0013] It is assumed that the local database 11 of the local device 30 has previously registered the component information frequently used by the user who uses the local device 30. Further, the component code and the component classification code of the component information registered in the local database 11 are the component management table updating unit 12 and the component classification management table updating unit 13.
Are registered in the parts management table 6 and the parts classification management table 8, respectively.

(1) First, the local database 11 is used as part information input to the host computer 20.
If the component code of the component information is not registered in the local database 11 and the component information having the same component classification code as the component classification code of the component information exists in the local database 11, that is, the component code of the input component information is the component management table 6 The operation when the component classification code of the component information that has not been registered and is registered in the component classification management table 8 will be described.

In the host computer 20, the input component information 2 input from the input unit 1 is stored in the database updating unit 3
Is registered in the host computer database 4, and the component classification determining unit 7 collates the component classification code of the input component information 2 with the component classification code in the component classification management table 8. In this case, since the component classification codes match, the component classification determining unit 7 adds the component classification matching flag to the input component information 2 and outputs it to the component determining unit 5.

Next, the input component information 2 by the component determination unit 5
And the part code in the part management table 6 are collated. In this case, the component codes do not match, but since the component classification matching flag is attached to the input component information 2, the component determining unit 5 outputs the input component information 2 as the updated component information 9 to the local device 30. It Also,
The component code of the updated component information 9 is registered in the component management table 6 by the component management table updating unit 12.

In the local device 30, the local database update unit 10 registers the updated component information 9 in the local database 11.

(2) Next, as the component information input (or changed) to the host computer 20, the component code of the component information is already registered in the local database 11 and the same component classification code as the component information. When the component information having the classification code exists in the local database 11, that is, the component code of the inputted component information is registered in the component management table 6, and the component classification code of the inputted component information is the component classification management table 8
The operation when registered in is explained.

In the host computer 20, the input component information 2 input (or changed) from the input unit 1 is registered (or updated) in the host computer database 4 by the database updating unit 3 and by the component classification determining unit 7. The component classification code of the input component information 2 and the component classification code in the component classification management table 8 are collated. In this case, since the component classification codes match, the component classification determining unit 7 adds the component classification matching flag to the input component information 2 and outputs it to the component determining unit 5.

Next, the input component information 2 by the component determination unit 5
And the part code in the part management table 6 are collated. In this case, since the component codes match, the component determining unit 5 adds a component matching flag to the input component information 2 and updates the local device 30 as the updated component information 9.
Is output to. In this case, since the component code of the input component information 2 has already been registered in the component management table 6, the component management table 6 is not updated.

In the local device 30, the local database update unit 10 registers (or updates) the updated component information 9 in the local database 11.

(3) Next, the local database 11 is stored as the component information input to the host computer 20.
If the part code of the part information input to the is not registered and the part information having the same part classification code as the part classification code of the input part information does not exist in the local database 11, that is, The operation when the component code is not registered in the component management table 6 and the component classification code of the inputted component information is not registered in the component classification management table 8 will be described.

In the host computer 20, the input component information 2 input from the input unit 1 is stored in the database updating unit 3
Is registered in the host computer database 4, and the component classification determining unit 7 collates the component classification code of the input component information 2 with the component classification code in the component classification management table 8. In this case, since the component classification codes do not match, the input component information 2 is the component classification determining unit 7
No more output. As a result, the updated component information 9 is not output from the component determination unit 5, and the component management table 6 is not updated. In addition, the local database 11 is not updated in the local device 30.

In the description of the operation of the above embodiment, the operation when the component code is registered in the component management table 6 and the component classification code is not registered in the component classification management table 8 has not been described. This is because the registration of the code is premised on the registration of the part classification code, and is not expected in such a case.

[0025]

As described above, the present invention has the parts management table and the parts classification management table, and the parts code and parts classification code of the parts information registered in the host computer database and the parts code and parts of the parts management table. Check the part classification code in the classification management table, register (or update) the part information in the host computer database, and at the same time transfer the minimum necessary part information to the local device and register the part information in the local database (or By performing the (Update), the part information of the classification code used in the local device and the updated part information of the used part can be used in the local device side at the same time as being registered in the host computer database, and the necessary parts That you can use the right information when you need it There is a result.

Further, since the local database does not have the same large amount of information as the host computer database but has the minimum necessary component information that is normally used, there is an effect that resource saving can be realized.

[Brief description of drawings]

FIG. 1 is a block diagram showing a configuration of a parts information management system according to an embodiment of the present invention.

FIG. 2 is a diagram showing a format of input component information in FIG.

FIG. 3 is a diagram showing an entry format of a parts management table in FIG.

FIG. 4 is a diagram showing an entry format of a parts classification management table in FIG.

[Explanation of symbols]

 1 input part 2 input part information 3 database update part 4 host computer database 5 part determination part 6 part management table 7 part classification determination part 8 part classification management table 9 updated part information 10 local database update part 11 local database 12 part management table update Part 13 parts classification management table updating part 20 host computer 30 local device

Claims (1)

[Claims] 1. A parts information management system constructed on a database distributed information processing system comprising a host computer having a host computer database and a local device having a local database, and an input section for inputting parts information, A database updating unit for registering the registered component information in the host computer database, a component management table for managing the component code of the component information registered in the local database in advance, a component code of the inputted component information and the component management table The component judgment unit that outputs the component information that has the matched component code by comparing it with the component code of, and the component classification management table that manages the component classification code of the component information that is registered in the local database in advance. Of parts information A component classification code that collates the component classification code with the component classification code in the component classification management table and outputs component information having a matched component classification code; and a component classification determination unit and the component classification determination unit that outputs the information. A local database updating unit for registering the component information in the local database, a component management table updating unit for setting the component code of the component information in the component management table, and a component classification code for the component information in the component classification management table A parts information management system comprising: a parts classification management table updating unit.