JP2000107993A - Production management system, its recovery method, and recording medium having program therefor stored therein - Google Patents

Abstract

PROBLEM TO BE SOLVED: To easily and surely restore a broken piece of information and suppress the stop of a production facility or reduction in production capacity by restoring production information, when the production information is broken, on the basis of peculiar information, and restoring the peculiar information, when the peculiar information is broken, on the basis of the production information. SOLUTION: Even if the initially registered information of a memory device A is broken, the information necessary for progressing a process can be gained on the basis of the initially registered information stored in a memory device B without executing a recovery processing of performing an information collection from the actual article such as the product and producing machine in a production site, which requires much labor and time. Although the possibility of breaking the stored information is low in the memory device B since the access frequency is extremely low, the initially registered information of the information managed on the process progress management data file of the memory device A can be used as recovery source when the information of the memory device B is broken by any cause.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a production management system, a recovery method therefor, and a storage medium storing a program therefor, and more particularly to a storage means for storing important information related to manufacturing and an access to the storage means. The present invention relates to a production management system having a plurality of terminals, a recovery method thereof, and a storage medium storing the program.

[0002]

2. Description of the Related Art A schematic configuration of a process progress device (production management system) conventionally applied in a factory for producing mass-produced products such as electronic components and home electric appliances will be described with reference to FIG. As shown in FIG. 9, the conventional production management system includes a storage device (also referred to as a database) 100 in which all information related to production management (hereinafter referred to as production information) is stored.
An input processing terminal 1 that previously sets various fixed information related to production management in the storage device 100; and a reference processing terminal that refers to and extracts desired information such as a production progress status from the production information stored in the storage device 100. 2 and update processing terminals (also referred to as process terminals) 3a, 3b,... For setting various update information according to the progress of production.

[0003] The fixed information is, specifically, fixed production status information, such as a classification of a product to be produced, a type of production machine (production model), an input date, the number of inputs, and a work in process. Refers to process, quantity, etc. The update information is status information (variation information) that changes as needed in the production process, and refers to the latest information (log) in each production process.

Here, the update processing terminals 3a, 3b,...
Performs update (write) processing of the progress of processing in the storage device 100 for each processing step, and may reach several tens to several hundreds depending on the type of product and the production process.
Therefore, when accesses from the update processing terminals 3a, 3b,...
In addition to imposing an excessive load on the system, data in the storage device 100, particularly important information in production management such as a process in progress, a manufacturing model, and a version number, were erroneously erased or erroneously written and stored in the storage device 100. The probability of occurrence of a defect or breakage in a part of the production information becomes extremely high, causing a problem that production control is not normally controlled.

As described above, the product in-process, production model,
If important information such as the version number has been lost, recovery (recovery) processing, which requires a very large amount of time and effort, such as collecting information from actual products such as products and manufacturing machines at the production site, must be performed. Production had to be stopped during that time. In the conventional production management system, when the reference processing terminal 2 refers to the production information in the storage device 100, as shown in FIG. An index key (ID) is set for each item, and when searching for a reference item (e.g., model), a rearrangement process based on the ID is executed as needed to extract relevant information.

[0006]

As described above, in the conventional production management system, if the database is damaged, the production must be stopped for a long time for recovery processing. have. The following describes a conventional recovery processing method. The recovery method described below uses a function that is provided as standard in a commercially available operation system (OS) or the like. Mirroring function Double write processing at application level Periodic backup processing However, each of the above-mentioned recovery methods has the following problems.

The mirroring function is a method of generating exactly the same data in another storage area, and thus functions effectively against a hardware failure such as a disk for a storage device. If the unit is destroyed, the same destroyed information is generated on the mirror side, and there is a problem that data recovery cannot be substantially achieved.

Further, the method of writing data in the storage device to another disk at the application level (double write process) is a method of performing exactly the same process on two data files, so that the recovery process is actually performed. In the case of execution, there is no guarantee that the backup side has normal data, there is a problem that reliability is lacking, and the processing speed of the system is reduced by half.

Further, in the method of periodically backing up data in the storage device, since only the data at the time of the backup process is stored,
It is not possible to restore up to the latest information immediately before the occurrence of data corruption, and there is a problem that the corrupted data is backed up. On the other hand, in the above-described production management system, when the process of referring to the production information from the reference processing terminal 2 is being executed, the information in the storage device 100 is to be rearranged by the ID. . Therefore, the process of writing the update information from the update processing terminal 3 which occurred at the same time is executed after the rearrangement process is completed, and the higher the frequency of access to the storage device 100, the longer the time required for the update process. Has the problem that it becomes longer.

[0010] The present invention solves the above-mentioned problems, and can easily and surely restore damaged information even when important information related to production management stored in a database is damaged. Production management that minimizes the impact on the production process and minimizes the stoppage of production equipment and the decline in production capacity, as well as the processing time even when access to the database is concentrated. It is an object of the present invention to provide a system, a recovery method thereof, and a storage medium storing the program.

[0011]

In order to achieve the above object, a production management system according to claim 1 stores production information relating to production of a product, and performs processing for each series of production steps of the product. First storage means for exchanging information;
A second storage unit that stores only fixed information specific to a production process of the product, out of the production information, and a case where the production information stored in the first storage unit is damaged.
The production information in the first storage is restored based on the fixed information stored in the second storage, and the unique information stored in the second storage is damaged. And a recovery control unit that recovers the unique information in the second storage unit based on the production information stored in the first storage unit.

According to a second aspect of the present invention, in the production management system according to the first aspect, of the production information stored in the first storage means, A third storage unit that stores only the change information that is changed as needed; and when the production information stored in the first storage unit is damaged, the third storage unit stores the information. The production information in the first storage unit is restored based on the fluctuation information.

According to a third aspect of the present invention, in the production management system according to the first or second aspect, the fixed information is stored in the first and second storage means in parallel with the production of the product. Information to be written in the first
When referring to the production information stored in the storage means, the fixed information stored in the second storage means is searched,
The production information stored in the first storage device is extracted and referred to based on the search result.

According to a fourth aspect of the present invention, there is provided a recovery method for a production management system, wherein information relating to production of a product is stored, and the first storage means is accessed for production processing, and only when reference is made to predetermined information. In a production management system having a second storage means to be accessed, prior to production of a product, storing fixed information unique to a production process of the product in the first and second storage means in parallel; If the fixed information stored in the first storage means is damaged due to the access, whether the access to the first storage means has been normally performed, and whether the abnormality of the access has occurred. A step of confirming whether or not the access target information is stored in the second storage means when it is confirmed; and a case where the access target information is stored in the second storage means. , On the basis of the fixed information stored in the second storage means, and a step of recovering the fixed information stored in the first storage unit, the second
When the fixed information stored in the storage means is damaged due to the access, a step of confirming whether or not reference access to the second storage means has been normally performed; and Restoring the fixed information stored in the second storage means based on the fixed information stored in the storage means.

Further, a storage medium storing a program for a recovery method of a production management system according to claim 5, wherein first storage means stores information relating to production of a product and is accessed for production processing; In a production management system having a second storage means accessed only when referring to predetermined information, prior to production of a product, fixed information unique to a production process of the product is stored in parallel in the first and second storage means. If the fixed information stored in the first storage means is damaged due to the access, whether the access to the first storage means has been performed normally, And when the abnormality of the access is confirmed, a process of confirming whether or not the information of the access target is stored in the second storage means; And recovering the fixed information stored in the first storage means based on the fixed information stored in the second storage means when the information of the elephant is stored. When the fixed information stored in the second storage means is damaged due to the access, processing for confirming whether or not reference access to the second storage means has been normally performed; and , Based on the fixed information stored in the first storage means,
And processing for restoring the fixed information stored in the storage means.

That is, according to the present invention, in addition to the storage device (first storage means) for storing all the production information which the conventional production management system has,
A second storage unit that stores only fixed information that is unique to the production process and is hardly affected by the manufacturing process; and a second storage unit that manages a log of variation information that is frequently changed in the manufacturing process among the production information. And a storage management system that can perform distributed management of information for each property and realize highly reliable recovery processing in software by using these three storage units. It is characterized by the following.

Here, since the fixed information stored in the second storage means is initial registration information written prior to the production of the product, damage is likely to occur depending on the progress of the manufacturing process. It has the property that there is no.
Further, since the variation information stored in the third storage means is information for indicating the progress of the manufacturing process in real time, it is always accessed from each process terminal (update processing terminal) and updated to the latest information. It has the property of being done.

Further, when referring to the production information stored in the first storage means, the narrowing target is the second storage means, so that the load on the first storage means is reduced. Things. Therefore, unlike the method using the mirroring function or the regular backup described above, even if the information stored in the first storage unit is damaged, the information destroyed in the second storage unit is not affected. This eliminates the problem that the processing speed of the system is reduced as in the double writing process.

Therefore, according to the production management system and the recovery method thereof of the present invention, when the fixed information among the production information stored in the first storage means is damaged, the second information is used.
If the fluctuation information out of the production information stored in the first storage means is damaged, the fluctuation information stored in the third storage means It is possible to restore the production information. Similarly, when the fixed information stored in the second storage unit is damaged, the damaged fixed information can be restored using the production information stored in the first storage unit.

Further, prior to the process of referring to the production information stored in the first storage means, the fixed information stored in the second storage means can be narrowed down and referred to, so that the first information can be referred to.
Since the load of the information rearrangement process in the storage means can be reduced, the time required for the process of writing variation information from each process terminal can be reduced. In addition, by incorporating the program related to the recovery processing into the library of the production management system, the recovery of the database (first storage unit) can be automatically executed in a software-like manner with a minimum system downtime. It can be easily applied to existing production management systems at low cost.

[0021]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS Hereinafter, a production management system according to the present invention will be described with reference to embodiments. A first embodiment of a production management system to which a recovery method according to the present invention is applied will be described with reference to the drawings. As shown in FIG. 1, the production management system of this embodiment
, Reference processing terminal 2, update processing terminal (process terminal) 3
, a, 3b,..., a storage device 10 (hereinafter, referred to as a storage device A) constituting the first storage device, and a storage device 20 (hereinafter, referred to as the storage device B) constituting the second storage device. )
And is configured.

The storage device A stores all information in the production management system as a process progress management data file. As shown in FIG. 2, the process progress management data file is mainly composed of initial registration information written before the start of production, and pass history information for each production process.

The initial registration information is fixed information indicating production status information unique to the production process, such as classification, production model, input date, input number, figure number, work-in-process, and edition number of the product to be produced. And information unique to the production. This initial registration information is characterized in that it is information that is extremely rarely accessed from other terminals except for the access from the input processing terminal at the time of initial registration.

On the other hand, the passing history information is variation information indicating status information that varies as needed in the production process, and is the latest information (passing log) such as the number of in-process processes and quantities that change as needed according to the progress of the production process. It is comprised including. This passage history information is accessed from each of the update processing terminals 3a, 3b, ... at any time according to the progress of the production process,
There is a feature that the information is written.

The storage device B stores and manages the initial registration information among the information managed on the process progress management data file. Here, the initial registration information is written simultaneously and in parallel when writing to the storage device A. That is, the process progress management data file containing all information related to production management and the initial registration information are stored in separate storage devices A and B, respectively.
Is stored and managed.

According to the production management system having such a configuration, the initial registration information stored in the storage device B is different from the storage device A frequently accessed from the update processing terminals 3a, 3b,. Without being subject to the update process,
Since the access frequency is low, there is almost no damage due to the nature of the information, and the initial registration information can be used as a recovery source of the storage device A.

Therefore, even if a part or most of the initial registration information in the storage device A is damaged, as described in the prior art, the information from the actual products such as products and manufacturing machines at the production site is obtained. The information necessary for performing the process progress processing based on the initial registration information stored in the storage device B can be acquired without performing the recovery processing that requires labor and time to perform collection. .

On the other hand, as for the storage device B, since the access frequency is extremely low, the possibility that the stored information is damaged is extremely low. However, if the information is damaged for any reason, the process of the storage device A is performed. Of the information managed on the progress management data file, the initial registration information can be used as a recovery source. That is, according to the present embodiment, as shown in FIG. 2, a bidirectional recovery structure between the storage device A and the storage device B can be realized, and the damaged information can be recovered simply and reliably. be able to.

Next, a recovery process applied to this embodiment will be described with reference to the drawings. In the first recovery process of this embodiment, a recovery program (recovery logic) for using the initial registration information stored in the storage device B as a recovery source of the storage device A in the production management system described above. Is realized by:

As shown in the flowchart of FIG. 3, first, an update process is performed on desired data stored in the storage device A (S11), and it is determined whether or not the update process has been normally performed (S11). S12). If it is determined that the update process is normal, the following process is performed (S13).

On the other hand, if the update processing is determined to be defective, it is determined that the corresponding data in the storage device A is damaged, and whether the corresponding data exists in the storage device B as the recovery source. Is determined (S14). If there is no corresponding data in the storage device B, an abnormal message is notified to the administrator (S15).

On the other hand, if the corresponding data exists in the storage device B, a recovery process of the fixed information is executed (S16), the damaged data in the storage device A is restored, and the storage device A is restored. Is updated.
The second recovery process of the present embodiment is realized by incorporating recovery logic for using the initial registration information stored in the storage device A as a recovery source of the storage device B in the production management system described above.

As shown in the flowchart of FIG. 4, first, reference processing is performed on desired data stored in the storage device B (S21), and it is determined whether or not the reference processing has been normally performed (S21). S22). If it is determined that the reference processing is normal, the following processing is executed (S23).

On the other hand, if the reference processing is determined to be defective, it is determined that the corresponding data in the storage device B has been damaged, and whether the corresponding data exists in the storage device A as the recovery source. Is determined (S24). If the corresponding data does not exist in the storage device A, an abnormal message is notified to the administrator (S25).

On the other hand, if the corresponding data exists in the storage device A, the reference information is restored (recovered) (S26), the damaged data in the storage device B is restored, and the storage device B is restored. Is referred to.
Next, reference processing applied to the present embodiment will be described with reference to the drawings. In the production management system according to the present embodiment, as shown in FIGS. 1 and 5, when the production information in the storage device A is referred to by the reference processing terminal 2, the arrangement of the reference items by the ID originally executed in the storage device A is performed. By executing the replacement process in the storage device B, the waiting time for writing the update information from the update processing terminal to the storage device A is reduced, and the processing speed of the system is improved.

That is, as shown in FIG. 5, data is managed in a distributed manner for each property, and a part of a plurality of reference IDs stored in advance in the storage device A is also set in the storage device B. Thus, the direct reference processing to the storage device A is prevented, and once the storage device B is narrowly referred to (for example, depending on the manufacturing model), the ID corresponding to the corresponding condition is extracted and the storage device A is extracted. Refer to the item.

Therefore, the reordering process of the reference items, which was conventionally performed in the storage device (corresponding to the storage device A) 100, can be performed in the storage device B. Therefore, the load of the reference process can be reduced for the storage device A where the access is concentrated, the speed of the process of writing the update information to the storage device A is increased, and the processing capability of the production management system is improved. be able to.

Next, a second embodiment of the production management system to which the recovery method according to the present invention is applied will be described with reference to the drawings. In addition, about the structure equivalent to the above-mentioned Example, the same code | symbol is attached | subjected and the description is abbreviate | omitted.
As shown in FIG. 6, the production management system of the present embodiment has a storage device 30 (hereinafter, referred to as a storage device C) constituting a third storage means in addition to the configuration of the first embodiment described above. It is configured.

The storage device C is one of the information managed on the process progress management data file stored in the storage device A.
The passage history information is stored and managed. Here, the passage history information is written simultaneously and in parallel when writing (updating) to the storage device A. That is, a process progress management data file including all information related to production management, and initial registration information and passage history information are stored in separate storage devices A, B, and C, respectively.
Is stored and managed.

According to the production management system having such a configuration, as shown in FIG. 7, the initial registration information stored in the storage device B can be used as a recovery source of the storage device A, and the storage device C can be used as a recovery source. Since the same information as the storage device A is written into the passage history information stored in the storage device A, the passage history information can be used as a recovery source of the storage device A for the passage history information.

Therefore, even if the initial registration information or the passage history information of a part or most of the storage device A is damaged, as described in the prior art, the product and the manufacturing machine at the production site are damaged. Without performing a recovery process requiring time and effort, that is, collecting information from the actual device, based on the initial registration information stored in the storage device B and the passage history information stored in the storage device C. Information necessary for performing the process progress processing can be obtained.

Next, a recovery process applied to this embodiment will be described with reference to the drawings. The recovery process of the present embodiment uses the initial registration information stored in the storage device B in the above-described production management system and the passage history information stored in the storage device C as recovery sources of the storage device A. This is realized by incorporating the recovery logic.

As shown in the flowchart of FIG. 8, first, update processing is performed on desired data stored in the storage device A (S31), and it is determined whether or not the update processing has been normally performed (step S31). S32). If it is determined that the updating process is normal, the following process is executed (S33).

On the other hand, if the update processing is determined to be defective, it is determined that the corresponding data in the storage device A has been damaged, and the data corresponding to the storage device C as the first recovery source exists. (S3)
4). If the corresponding data exists in the storage device C, a recovery process of the fluctuation information is executed (S3).
5) The damaged data in the storage device A is restored, and the update process is executed on the storage device A again.

On the other hand, if the corresponding data does not exist in the storage device C, it is determined whether or not the corresponding data exists in the storage device B as the second recovery source (S3).
6). If the corresponding data exists in the storage device B, recovery processing of the fixed information is executed (S3).
7), the damaged data in the storage device A is restored, and the update process is executed on the storage device A again.

On the other hand, if the corresponding data does not exist in the storage device B, an abnormal message is notified to the administrator (S38). As described above, in the conventional production management system, when a failure occurs in the production information stored in the storage device, information is collected from actual products such as products and manufacturing machines at the production site, which is extremely complicated. Recovery process that requires complex processing, and therefore, until data file and data recovery is completed,
Although the production system had to be stopped, in the present invention, by incorporating the recovery logic into the production management system, data recovery can be automatically and automatically realized as necessary, The stoppage of the production system can be kept to a minimum, and a decrease in production efficiency can be suppressed as much as possible.

Incorporation of the recovery logic described above can be easily realized even in an existing production management system by storing the recovery method program of the present invention in a storage medium. Here, the storage medium generally refers to a portable medium such as a floppy disk, a CD-ROM, a memory card, a ROM chip, and the like, but a fixed storage device (hard disk) can also be removed from the system and transported. Such a hard disk can be included in the storage medium because the program may be provided by installing the program in advance. further,
When distributing a program via a network or a communication line, it goes without saying that the storage device of the distribution source is also included in the storage medium.

Therefore, the program stored in the above-described storage medium is loaded into a memory (including a virtual memory) of a hardware system in an executable form, and by executing the program, the recovery function and the reference function are executed. Contribute to the construction of a production management system that realizes In the above-described embodiment, the configuration in which the production information, the fixed information, and the variation information are stored in separate storage devices has been described, but the present invention is not limited to this embodiment. In other words, it goes without saying that a storage area may be divided into a plurality of storage areas and stored and managed in different areas in which information corruption does not affect each other.

[0049]

As described above, according to the production management system and the recovery method thereof of the present invention, when the fixed information out of the production information stored in the first storage means is damaged, the second information is obtained. With the fixed information stored in the storage means of
Further, when the fluctuation information out of the production information stored in the first storage means is damaged, the damaged production information can be restored using the fluctuation information stored in the third storage means. Similarly, when the fixed information stored in the second storage unit is damaged, the damaged fixed information can be restored using the production information stored in the first storage unit.

Further, prior to the process of referring to the production information stored in the first storage means, the fixed information stored in the second storage means is narrowed down and referred to, so that the first information is obtained.
Since the load of the information rearrangement process in the storage means can be reduced, the time required for the process of writing variation information from each process terminal can be reduced. In addition, by incorporating the program related to the recovery processing into the library of the production management system, the recovery of the database (first storage unit) can be automatically executed in a software-like manner with a minimum system downtime. It can be easily applied to existing production management systems at low cost.

[Brief description of the drawings]

FIG. 1 is a schematic configuration diagram showing a first embodiment of a production management system according to the present invention.

FIG. 2 is a conceptual diagram illustrating a recovery process of production information in the present embodiment.

FIG. 3 is a flowchart (part 1) illustrating a recovery process applied to the embodiment;

FIG. 4 is a flowchart (part 2) illustrating a recovery process applied to the embodiment;

FIG. 5 is a conceptual diagram illustrating a process of referring to production information in the embodiment.

FIG. 6 is a schematic configuration diagram showing a second embodiment of the production management system according to the present invention.

FIG. 7 is a conceptual diagram showing a recovery process of production information in the present embodiment.

FIG. 8 is a flowchart illustrating a recovery process applied to the present embodiment.

FIG. 9 is a diagram showing a schematic configuration of a conventional production management system.

FIG. 10 is a conceptual diagram showing a conventional production information reference process.

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 1 Input processing terminal 2 Reference processing terminal 3, 3a, 3b Update processing terminal 10 Storage device A 20 Storage device B 30 Storage device C 100 Storage device

Continued on front page F term (reference) 3C042 RJ13 5B049 BB07 CC21 DD05 EE05 EE53 EE59 FF09 GG04 GG07 5H215 AA06 BB09 BB11 CC03 CC07 CX04 GG01 GG09 HH03 KK03

Claims (5)

[Claims] A first storage unit for storing production information relating to the production of a product and exchanging processing information for each of a series of production processes of the product; and a production process of the product among the production information. A second storage unit that stores only unique fixed information; and, if the production information stored in the first storage unit is damaged, the fixed information stored in the second storage unit. And restores the production information in the first storage means, and if the unique information stored in the second storage means is damaged, stores the information in the first storage means A recovery control unit that recovers the unique information in the second storage unit based on the obtained production information. 2. The production management system according to claim 1, wherein, among the production information stored in the first storage means,
A third storage unit that stores only change information that is changed at any time according to the production progress status of the product; and when the production information stored in the first storage unit is damaged, A production management system, wherein the production information in the first storage unit is restored based on the fluctuation information stored in the third storage unit. 3. The production management system according to claim 1, wherein said fixed information is stored in said first information before said product is produced.
And information that is written in parallel to the second storage means. Upon reference to the production information stored in the first storage means, the fixed information stored in the second storage means is searched, A production management system, wherein the production information stored in the first storage device is extracted and referred to based on the search result. 4. A first storage means for storing information related to production of a product and accessed for production processing;
In a production management system having a second storage means accessed only when referring to predetermined information, prior to production of a product, fixed information unique to a production process of the product is stored in parallel in the first and second storage means. If the fixed information stored in the first storage means is damaged by the access, whether or not the access to the first storage means has been normally performed; And when the abnormality of the access is confirmed, a step of confirming whether or not the information of the access target is stored in the second storage means, and the information of the access target is stored in the second storage means. Restoring the fixed information stored in the first storage means based on the fixed information stored in the second storage means, if the stored fixed information is stored in the second storage means. Stored in the storage means When the fixed information is damaged due to the access, a step of confirming whether or not the reference access to the second storage means has been normally performed; and a step of storing the information in the first storage means. Restoring the fixed information stored in the second storage means based on the fixed information. 5. A first storage means for storing information relating to the production of a product and accessed for production processing;
In a production management system having a second storage means accessed only when referring to predetermined information, prior to production of a product, fixed information unique to a production process of the product is stored in parallel in the first and second storage means. If the fixed information stored in the first storage means is damaged by the access, whether the access to the first storage means has been performed normally, And when the abnormality of the access is confirmed, a process of confirming whether or not the information of the access target is stored in the second storage unit, and the information of the access target is stored in the second storage unit. And if the stored fixed information is stored, executing a process of restoring the fixed information stored in the first storage means based on the fixed information stored in the second storage means. Stored in storage means When the obtained fixed information is damaged due to the access, processing for confirming whether or not reference access to the second storage means has been normally performed; and storing the fixed information in the first storage means. A storage medium storing a program for executing a process of restoring the fixed information stored in the second storage unit based on the fixed information thus obtained.