Record management system and method to trace chemicals

Information

  • Patent Application
  • 20070175976
  • Publication Number
    20070175976
  • Date Filed
    February 01, 2007
    17 years ago
  • Date Published
    August 02, 2007
    16 years ago
Abstract
An operation for a chemical of indefinite form is managed so that operation record of the chemical is traceable. An IC tag (3) is attached to various containers (4a to 4c) each holding a chemical, and a chemical ID to identify the chemical held in each of the containers (4a to 4c) is stored in the IC tag (3). When an operation involving a mass change or a change of composition information is carried out, such as apportioning, mixing, reacting, and separating, while the containers (4a to 4c) serve as receivers of the chemical, a record management apparatus (1) newly generates a chemical ID, and a IC tag terminal (2) updates the chemical ID in the IC tag (3) to the new chemical ID. In addition, the record management apparatus (1) manages a correspondence between the chemical ID stored in the IC tag (3) (old chemical ID) and the chemical ID newly stored in the IC tag (3) (new chemical ID).
Description

BRIEF DESCRIPTION OF THE DRAWINGS


FIG. 1 is a schematic diagram showing a record management system to which one exemplary embodiment of the present invention is applied;



FIG. 2 is a schematic diagram of an IC tag terminal 2;



FIG. 3 is a flow diagram to explain an operation of the IC tag terminal 2 as shown in FIG. 2;



FIG. 4 illustrates an example of an entry form screen that accepts characteristic information of a chemical that is an object of an import operation;



FIG. 5 illustrates an example of an entry form screen that accepts characteristic information of a chemical that is the object of an apportioning operation;



FIG. 6 illustrates an example of an entry form screen that accepts characteristic information of a chemical that is the object of a mixing operation;



FIG. 7 illustrates an example of an entry form screen that accepts characteristic information of a chemical that is the object of a reacting operation;



FIG. 8A illustrates an example of an entry form screen that accepts characteristic information of a chemical after separation in an inputting side container, and FIG. 8B illustrates an example of an entry form screen that accepts characteristic information of a chemical inputted to a receiving side container;



FIG. 9 is a schematic diagram showing a record management apparatus 1;



FIG. 10 schematically illustrates registration contents of management information TL 141;



FIG. 11 schematically illustrates registration contents of mass update record TL 142;



FIG. 12 schematically illustrates registration contents of composition information TL 143;



FIG. 13 schematically illustrates registration contents of ID update record TL 144;



FIG. 14 is an illustration to explain a record update process of the record management apparatus 1;



FIG. 15 is an illustration to explain a record tracing process of the record management apparatus 1;



FIG. 16 schematically illustrates a tree view example of a tracing survey result;



FIG. 17 schematically illustrates a detailed display example of the tracing survey result;



FIG. 18 illustrates a hardware configuration of the record management apparatus 1;



FIG. 19 illustrates a general operation of the record management system in cases where a tank truck 4a feeds a drum 4b;



FIG. 20 is an illustration to explain a general operation of the record management system in cases where the chemical held in the drum 4b is mixed with the chemical held in a glass bottle 4c; and



FIG. 21 is an illustration to explain a general operation of the record management system in cases where a factory 4d is assumed as a container, a new chemical is generated using as materials the chemicals received from tank trucks 4a1 and 4a2, and the generated chemical is shipped by a tank truck 4a3.


Claims
  • 1. A record management system that manages operation record for a chemical, comprising: an IC tag that is attached to each container for holding the chemical;an IC tag terminal that reads data from and writes data to the IC tag; anda record management apparatus that manages record information of the chemical; wherein:the IC tag terminal includes:a reading unit that reads from the IC tag a chemical ID for identifying the chemical held in the container to which the IC tag is attached;a terminal side accepting unit that accepts from an operator an operational description for the chemical;a terminal side sending unit that sends to the record management apparatus the chemical ID read by the reading unit and operation information including the operational description for the chemical accepted by the terminal side accepting unit;a terminal side receiving unit that receives a chemical ID from the record management apparatus; anda writing unit that writes to the IC tag the chemical ID received by the terminal side receiving unit;the record management apparatus includes:a mass update record storing unit that stores mass update record of each chemical having the chemical ID;a composition storing unit that stores composition information including a chemical ID of a chemical constituting each chemical having the chemical ID;a chemical ID correspondence storing unit that stores a correspondence between a new chemical ID and an old chemical ID;a management apparatus side receiving unit that receives the operation information from the IC tag terminal;an updating unit that updates at least one of the mass update record storing unit, the composition storing unit, and the chemical ID correspondence storing unit, according to the operation information received by the management apparatus side receiving unit; anda management apparatus side sending unit that sends to the IC tag terminal, as the chemical ID, the new chemical ID newly stored in the chemical ID correspondence information storing unit, if the chemical ID correspondence storing unit is updated by the updating unit, andwhen an operation type indicated by the operation information received by the management apparatus side receiving unit is either of “mixing” and “apportioning”, according to an input amount included in the operation information, the updating unit updates mass update record of mass of the chemical having an input side chemical ID included in the operation information, that is stored in the mass update record storing unit, with a receiving side chemical ID included in the operation information as the old chemical ID, and a chemical ID newly generated as the new chemical ID, stores in the chemical ID correspondence storing unit a correspondence between the new chemical ID and the old chemical ID, and stores in the mass update record storing unit the mass update record of the chemical having the new chemical ID, according to the mass update record of mass of the chemical having the old chemical ID included in the operation information, that is stored in the mass update record storing unit and the input amount included in the operation information.
  • 2. The record management system according to claim 1, wherein, when the operation type indicated by the operation information received by the management apparatus side receiving unit is “mixing”, the updating unit further generates composition information of the chemical having the new chemical ID, the composition information including the old chemical ID and the input side chemical ID, and stores the composition information in the composition storing unit.
  • 3. The record management system according to claim 1, wherein, when the operation type indicated by the operation information received by the management apparatus side receiving unit is “apportioning”, the updating unit further generates composition information of the chemical having the new chemical ID, the composition information including the old chemical ID, and stores the composition information in the composition storing unit.
  • 4. The record management system according to claim 1, wherein, when the operation type indicated by the operation information received by the management apparatus side receiving unit is “importing”, the updating unit sets a null code as the old chemical ID and a newly generated chemical ID as the new chemical ID, stores in the chemical ID correspondence storing unit a correspondence between the new chemical ID and the old chemical ID, stores, in the mass update record storing unit, mass update record of the chemical having the new chemical ID according to the mass included in the operation information, generates composition information, including the composition held in the operation information, as the composition information of the chemical having the new chemical ID, and stores the composition information in the composition storing unit.
  • 5. The record management system according to claim 2, wherein, when the operation type indicated by the operation information received by the management apparatus side receiving unit is “importing”, the updating unit sets a null code as the old chemical ID and a newly generated chemical ID as the new chemical ID, stores in the chemical ID correspondence storing unit a correspondence between the new chemical ID and the old chemical ID, stores, in the mass update record storing unit, mass update record of the chemical having the new chemical ID according to the mass included in the operation information, generates composition information, including the composition held in the operation information, as the composition information of the chemical having the new chemical ID, and stores the composition information in the composition storing unit.
  • 6. The record management system according to claim 3, wherein, when the operation type indicated by the operation information received by the management apparatus side receiving unit is “importing”, the updating unit sets a null code as the old chemical ID and a newly generated chemical ID as the new chemical ID, stores in the chemical ID correspondence storing unit a correspondence between the new chemical ID and the old chemical ID, stores, in the mass update record storing unit, mass update record of the chemical having the new chemical ID according to the mass included in the operation information, generates composition information, including the composition held in the operation information, as the composition information of the chemical having the new chemical ID, and stores the composition information in the composition storing unit.
  • 7. The record management system according to claim 1, wherein, when the operation type indicated by the operation information received by the management apparatus side receiving unit is “reacting”, the updating unit sets the receiving side chemical ID included in the operation information as the old chemical ID and a newly generated chemical ID as the new chemical ID, stores in the chemical ID correspondence storing unit a correspondence between the new chemical ID and the old chemical ID, stores, in the mass update record storing unit, mass update record of the chemical having the new chemical ID according to the mass included in the operation information, generates composition information, including the composition held in the operation information, as the composition information of the chemical having the new chemical ID, and stores the composition information in the composition storing unit.
  • 8. The record management system according to claim 2, wherein, when the operation type indicated by the operation information received by the management apparatus side receiving unit is “reacting”, the updating unit sets the receiving side chemical ID included in the operation information as the old chemical ID and a newly generated chemical ID as the new chemical ID, stores in the chemical ID correspondence storing unit a correspondence between the new chemical ID and the old chemical ID, stores in the mass update record storing unit, mass update record of the chemical having the new chemical ID according to the mass included in the operation information, generates composition information including the composition held in the operation information as the composition information of the chemical having the new chemical ID, and then stores the composition information in the composition storing unit.
  • 9. The record management system according to claim 3, wherein, when the operation type indicated by the operation information received by the management apparatus side receiving unit is “reacting”, the updating unit sets the receiving side chemical ID included in the operation information as the old chemical ID and a newly generated chemical ID as the new chemical ID, stores in the chemical ID correspondence storing unit a correspondence between the new chemical ID and the old chemical ID, stores, in the mass update record storing unit, mass update record of the chemical having the new chemical ID according to the mass included in the operation information, generates composition information, including the composition held in the operation information as the composition information of the chemical having the new chemical ID, and stores the composition information in the composition storing unit.
  • 10. The record management system according to claim 1, wherein, when the operation type indicated by the operation information received by the management apparatus side receiving unit is “separating”, the updating unit sets the input side chemical ID included in the operation information as the old chemical ID and a newly generated chemical ID as the new chemical ID, stores in the chemical ID correspondence storing unit a correspondence between the new chemical ID and the old chemical ID, stores, in the mass update record storing unit, mass update record of the chemical having the new chemical ID according to the mass included in the operation information, generates composition information including the composition held in the operation information as the composition information of the chemical having the new chemical ID, and stores the composition information in the composition storing unit, andthe updating unit sets the receiving side chemical ID included in the operation information as the old chemical ID and a newly generated chemical ID as the new chemical ID, stores in the chemical ID correspondence storing unit a correspondence between the new chemical ID and the old chemical ID, stores, in the mass update record storing unit, mass update record of the chemical having the new chemical ID according to the mass update record of the chemical having the old chemical ID included in the operation information, stored in the mass update record storing unit, and the input amount included in the operation information, and further generates composition information including the composition including the old chemical ID, as the composition information of the chemical having the new chemical ID, and stores the composition information in the composition storing unit.
  • 11. The record management system according to claim 2, wherein, when the operation type indicated by the operation information received by the management apparatus side receiving unit is “separating”, the updating unit sets the input side chemical ID, included in the operation information, as the old chemical ID and a newly generated chemical ID as the new chemical ID, stores in the chemical ID correspondence storing unit a correspondence between the new chemical ID and the old chemical ID, stores, in the mass update record storing unit, mass update record of the chemical having the new chemical ID according to the mass included in the operation information, generates composition information including the composition held in the operation information as the composition information of the chemical having the new chemical ID, and stores the composition information in the composition storing unit, andthe updating unit sets the receiving side chemical ID, included in the operation information, as the old chemical ID and a newly generated chemical ID as the new chemical ID, stores in the chemical ID correspondence storing unit a correspondence between the new chemical ID and the old chemical ID, stores, in the mass update record storing unit, mass update record of the chemical having the new chemical ID according to the mass update record of the chemical having the old chemical ID included in the operation information, stored in the mass update record storing unit, and the input amount included in the operation information, and further generates composition information including the composition including the old chemical ID, as the composition information of the chemical having the new chemical ID, and stores the composition information in the composition storing unit.
  • 12. The record management system according to claim 3, wherein, when the operation type indicated by the operation information received by the management apparatus side receiving unit is “separating”, the updating unit sets the input side chemical ID as the old chemical ID and a newly generated chemical ID, included in the operation information, as the new chemical ID, stores in the chemical ID correspondence storing unit a correspondence between the new chemical ID and the old chemical ID, stores, in the mass update record storing unit, mass update record of the chemical having the new chemical ID according to the mass included in the operation information, generates composition information including the composition held in the operation information as the composition information of the chemical having the new chemical ID, and stores the composition information in the composition storing unit, andthe updating unit sets the receiving side chemical ID as the old chemical ID, included in the operation information, and a newly generated chemical ID as the new chemical ID, stores in the chemical ID correspondence storing unit a correspondence between the new chemical ID and the old chemical ID, stores, in the mass update record storing unit, mass update record of the chemical having the new chemical ID according to the mass update record of the chemical having the old chemical ID included in the operation information, stored in the mass update record storing unit, and the input amount included in the operation information, and further generates composition information including the composition including the old chemical ID, as the composition information of the chemical having the new chemical ID, and stores the composition information in the composition storing unit.
  • 13. The record management system according to claim 1, wherein, the record management apparatus comprises:a management apparatus side accepting unit that accepts a tracing survey request with a designation of a chemical ID; anda tracing survey unit that traces and surveys an operation record for a chemical having the chemical ID designated in the tracing survey request, whereinthe tracing survey unit further comprises:a tree searching unit that retrieves, from the chemical ID correspondence storing unit, ID correspondence information having the designated chemical ID as the new chemical ID, and if the ID correspondence information is retrieved, by repeating processing to newly designate the old chemical ID of the retrieved ID correspondence information, and designating the chemical ID designated in the tracing survey request as an initial chemical ID, specifies each chemical ID positioned upstream of the chemical ID designated by the tracing survey request, in a tree indicating a transition of the chemical ID, and alsoretrieves, from the chemical ID correspondence storing unit, ID correspondence information having the designated chemical ID as the old chemical ID, and if the ID correspondence information is retrieved, by repeating processing to newly designate the new chemical ID of the retrieved ID correspondence information, and designating the chemical ID designated in the tracing survey request as an initial chemical ID, specifies each chemical ID positioned downstream of the chemical ID designated by the tracing survey request, in a tree indicating a transition of the chemical ID; anda result output unit that outputs a search result from the tree searching unit.
  • 14. The record management system according to claim 2, wherein, the record management apparatus comprises:a management apparatus side accepting unit that accepts a tracing survey request with a designation of a chemical ID; anda tracing survey unit that traces and surveys an operation record for a chemical having the chemical ID designated in the tracing survey request, whereinthe tracing survey unit further comprises:a tree searching unit that retrieves, from the chemical ID correspondence storing unit, ID correspondence information having the designated chemical ID as the new chemical ID, and if the ID correspondence information is retrieved, by repeating processing to newly designate the old chemical ID of the retrieved ID correspondence information, and designating the chemical ID designated in the tracing survey request as an initial chemical ID, specifies each chemical ID positioned upstream of the chemical ID designated by the tracing survey request, in a tree indicating a transition of the chemical ID, and alsoretrieves, from the chemical ID correspondence storing unit, ID correspondence information having the designated chemical ID as the old chemical ID, and if the ID correspondence information is retrieved, by repeating processing to newly designate the new chemical ID of the retrieved ID correspondence information, and designating the chemical ID designated in the tracing survey request as an initial chemical ID, specifies each chemical ID positioned downstream of the chemical ID designated by the tracing survey request, in a tree indicating a transition of the chemical ID; anda result output unit that outputs a search result from the tree searching unit.
  • 15. The record management system according to claim 3, wherein, the record management apparatus comprises:a management apparatus side accepting unit that accepts a tracing survey request with a designation of a chemical ID; anda tracing survey unit that traces and surveys an operation record for a chemical having the chemical ID designated in the tracing survey request, whereinthe tracing survey unit further comprises:a tree searching unit that retrieves, from the chemical ID correspondence storing unit, ID correspondence information having the designated chemical ID as the new chemical ID, and if the ID correspondence information is retrieved, by repeating processing to newly designate the old chemical ID of the retrieved ID correspondence information, and designating the chemical ID designated in the tracing survey request as an initial chemical ID, specifies each chemical ID positioned upstream of the chemical ID designated by the tracing survey request, in a tree indicating a transition of the chemical ID, and alsoretrieves, from the chemical ID correspondence storing unit, ID correspondence information having the designated chemical ID as the old chemical ID, and if the ID correspondence information is retrieved, by repeating processing to newly designate the new chemical ID of the retrieved ID correspondence information, and designating the chemical ID designated in the tracing survey request as an initial chemical ID, specifies each chemical ID positioned downstream of the chemical ID designated by the tracing survey request, in a tree indicating a transition of the chemical ID; anda result output unit that outputs a search result from the tree searching unit.
  • 16. A record management apparatus that manages an operation record for a chemical, comprising: a mass update record storing unit that stores a mass update record of each chemical having a chemical ID;a composition storing unit that stores composition information including a chemical ID of a chemical constituting each chemical having the chemical ID;a chemical ID correspondence storing unit that stores a correspondence between a new chemical ID and an old chemical ID;a receiving unit that receives operation information from an IC tag terminal;an updating unit that updates at least one of the mass update record storing unit, the composition storing unit, and the chemical ID correspondence storing unit, according to the operation information received by the receiving unit; anda sending unit that sends, to the IC tag terminal, as the chemical ID, the new chemical ID newly stored in the chemical ID correspondence information storing unit, if the chemical ID correspondence storing unit is updated by the updating unit; wherein,when an operation type indicated by the operation information received by the receiving unit is either of “mixing” and “apportioning”, according to an input amount included in the operation information, the updating unit updates mass update record, stored in the mass update record storing unit, of mass of the chemical having an input side chemical ID included in the operation information, sets a receiving side chemical ID included in the operation information as the old chemical ID, and a chemical ID newly generated is set as the new chemical ID, stores in the chemical ID correspondence storing unit a correspondence between the new chemical ID and the old chemical ID, and stores, in the mass update record storing unit, the mass update record of the chemical having the new chemical ID, according to the mass update record, stored in the mass update record storing unit, of the chemical having the old chemical ID included in the operation information, and the input amount included in the operation information.
  • 17. An operation record management method to trace a chemical according to a record management system including a record management apparatus that is provided with an IC tag attached to each container holding a chemical, an IC tag terminal that reads data from and writes data to the IC tag, a mass update record storing unit that stores a mass update record of each chemical having the chemical ID, a composition storing unit that stores composition information including a chemical ID of a chemical constituting each chemical having the chemical ID, a chemical ID correspondence storing unit that stores a correspondence between a new chemical ID and an old chemical ID, wherein, the IC tag terminal reads, from the IC tag, a chemical ID that identifies a chemical held in a container to which the IC tag is attached,the IC tag terminal accepts from an operator an operational description for the chemical,the IC tag terminal sends, to the record management apparatus, operation information including the chemical ID being read and the operational description for the chemical that has been accepted,the record management apparatus receives the operation information from the IC tag terminal,when an operation type indicated by the operation information being received is either of “mixing” and “apportioning”, the record management apparatus updates, according to an input amount included in the operation information, a mass update record, stored in the mass update record storing unit, of the chemical having an input side chemical ID included in the operation information, sets a receiving side chemical ID included in the operation information as an old chemical ID, and a chemical ID newly generated as a new chemical ID, stores in the chemical ID correspondence storing unit a correspondence between the new chemical ID and the old chemical ID, and additionally stores, in the mass update record storing unit, the mass update record of the chemical having the new chemical ID, according to the mass update record, stored in the mass update record storing unit, of the chemical having the old chemical ID included in the operation information, and the input amount included in the operation information,when the ID correspondence information storing unit is updated, the record management apparatus sends, to the IC tag terminal, as the chemical ID, the new chemical ID newly stored in the ID correspondence information storing unit,the IC tag terminal receives the chemical ID from the record management apparatus, andthe IC tag terminal writes the chemical ID being received to the IC tag.
  • 18. A computer readable program causing a computer to perform functions, the computer comprising, a mass update record storing unit that stores a mass update record of each chemical having a chemical ID;a composition storing unit that stores composition information including a chemical ID of a chemical constituting each chemical having the chemical ID;a chemical ID correspondence storing unit that stores a correspondence between a new chemical ID and an old chemical ID;a receiving unit that receives operation information from an IC tag terminal;an update unit that updates at least one of the mass update record storing unit, the composition storing unit, and the chemical ID correspondence storing unit, according to the operation information received by the receiving unit; anda sending unit that sends, to the IC tag terminal as the chemical ID, the new chemical ID newly stored in the ID correspondence storing unit, when the update unit updates the ID correspondence storing unit; wherein,when an operation type indicated by the operation information received by the receiving unit is either of “mixing” and “apportioning”, according to an input amount included in the operation information, the updating unit updates mass update record, stored in the mass update record storing unit, of the chemical having an input side chemical ID included in the operation information, sets a receiving side chemical ID included in the operation information as an old chemical ID, and a chemical ID newly generated as a new chemical ID, stores in the chemical ID correspondence storing unit a correspondence between the new chemical ID and the old chemical ID, and stores, in the mass update record storing unit, the mass update record of the chemical having the new chemical ID, according to the mass update record, stored in the mass update record storing unit, of the chemical having the old chemical ID included in the operation information, and the input amount included in the operation information.
Priority Claims (1)
Number Date Country Kind
2006-24664 Feb 2006 JP national