Patent ID: 7433757
Filing Date: 2008-10-07
Classification: G05B,G06Q

Abstract:
1. A substance management system that tabulates releasing and transferring amount of a substance included in a material handled by a business entity for each destination of the releasing and transferring of said substance, comprising a storage portion and a retrieval processing portion, wherein said storage portion stores: a plurality of material handling amount records, each of which is a set of relational information linking together the process in which said material is handled, said material, and the handling amount of said material; a plurality of substance handling amount records, which are result records obtained based on the handling amount of said material recorded in said plurality of material handling amount records and the content rate of a substance included in said material using said plurality of material handling amount records as the source record thereof, and each of which records is a set of relational information linking together the process in which said material is handled, the substance that said material includes, and the handling amount of said material; a first linkage information that defines the relationship between said material handling amount record and said substance handling amount record; a plurality of releasing and transferring amount records, which are result records obtained based on the handling amount of said substance recorded in said plurality of substance handling amount records and the releasing and transferring coefficient of the substance in the process, in which the material that include said substances is handled, for each destination of the releasing and transferring of said substance using said plurality of substance handling amount records as the source record thereof, and each of which records is a set of relational information linking together the process in which said material is handled, the substance that said material includes, and the releasing and transferring amount of said substance for each destination of the releasing and transferring of said substance; a second linkage information that defines the relationship between said substance handling amount record and said releasing and transferring amount record; a plurality of tabulation result records, which are result records obtained through tabulation over said plurality of releasing and transferring amount records using the same as the source record thereof, and each of which records is a set of relational information linking together said substance and the releasing and transferring amount of said substance for each destination of the releasing and transferring of said substance; and a third linkage information that defines the relationship between said releasing and transferring amount record and said tabulation result record, wherein said retrieval processing portion identifies: said plurality of releasing and transferring amount records by retrieving from said storage portion using said third linkage information when such a tabulation result record as is included in said plurality of tabulation result records is chosen, wherein said identified plurality of releasing and transferring amount records are the base of generating said chosen tabulation result record; said plurality of substance handling amount records by retrieving from said storage portion using said second linkage information when such a releasing and transferring amount record as is included in said plurality of releasing and transferring amount records is chosen, wherein said identified plurality of substance handling amount records are the base of generating said chosen releasing and transferring amount record; and said plurality of material handling amount records by retrieving from said storage portion using said first linkage information when such a substance handling amount record as is included in said plurality of substance handling amount records is chosen, wherein said identified plurality of material handling amount records are the base of generating said chosen substance handling amount record.