Section extraction device, section extraction method and program

Abstract

To provide a technique capable of efficiently associating an occupant transfer history with environmental information.SOLUTION: A section extraction device includes: a segment extraction part configured to extract a segment showing a section delimited by a change of a total amount of simultaneously occupied articles, as a section associating environmental information of an object, according to occupancy transfer data composed of an occupancy transfer history record showing a transfer history of an occupant of the object and realized by a non-fungible token, the occupancy transfer history record including a transfer date and transfer source identification information and transfer destination identification information; and an association part configured to associate environmental information of simultaneously occupied objects by each extracted segment. The segment extraction part is configured to: initialize a start date and an end date of the segment by each piece of the transfer destination identification information; thereafter retrieve an occupancy transfer history record including, as transfer source identification information or transfer destination identification information, identification information identical to the transfer destination identification information in a transfer date order; and extract the segment through updating the end date by the transfer date included by the retrieved occupancy transfer history record.SELECTED DRAWING: Figure 2

Description

Technical Field

[0001] The present disclosure relates to an interval extraction device, an interval extraction method, and a program.

Background Art

[0002] In recent years, in the supply chain field, the importance of sharing the transfer history of possession among stakeholders has been recognized for the purpose of ensuring traceability in case of defects in any articles such as goods and products (hereinafter, these are collectively referred to as "goods"). The transfer history of possession is, for example, what records, for each item, what moved, when, and from where to where (that is, what records, for each item, when each item transferred from which possessor to which possessor).

[0003] For example, as one of the prior arts, Patent Document 1 describes realizing a traceability system for resource objects by a blockchain composed of a plurality of nodes.

[0004] In addition, for purposes such as analysis and analysis at the time of occurrence of defects, cost reduction, and work efficiency improvement, efforts are also spreading to install IoT (Internet of Things) sensors in transport vehicles, warehouses, etc. and monitor information measured by these IoT sensors (hereinafter also referred to as environmental information). For example, in recent years, as the international momentum for decarbonization has increased, interest has been growing in efforts to visualize environmental information such as CO2 emissions measured by IoT sensors.

[0005] Therefore, in the future, it is expected that by associating the transfer history of possession for each item with the environmental information measured by IoT sensors, it will be possible to visualize detailed environmental information for each item in the supply chain of goods.

Prior Art Documents

Patent Documents

[0006]

Patent Document 1

Summary of the Invention

Problems to be Solved by the Invention

[0007] However, since there are a large number of occupant transfer histories in units of one product, if environmental information is simply associated with those occupant transfer histories, the amount of data will become enormous. For this reason, when visualizing detailed environmental information in units of one product, the visualization result becomes complicated, and as a result, for example, it may take a lot of time for analysis and investigation when a problem occurs.

[0008] The present disclosure has been made in view of the above points, and an object thereof is to provide a technique capable of efficiently associating an occupant transfer history with environmental information.

Means for Solving the Problems

[0009] An interval extraction device according to one aspect of the present disclosure is an occupancy transfer history record represented by non-fungible tokens on a blockchain, which represents the transfer history of the possessor of an object in a supply chain. The occupancy transfer data is composed of occupancy transfer history records including at least the transfer date and time of the object, transfer source identification information indicating the identification information of the transfer source of the object, and transfer destination identification information indicating the identification information of the transfer destination of the object. Based on the occupancy transfer data, a segment extraction unit extracts a segment representing an interval delimited by a change in the total amount of objects simultaneously occupied by the possessor as an interval for associating the environmental information of the object. For each segment extracted by the segment extraction unit, an association unit associates the environmental information of the objects simultaneously occupied by the possessor in the segment with the segment. The segment extraction unit initializes the start date and time and the end date and time of the segment for each transfer destination identification information, and then acquires occupancy transfer history records in which the same identification information as the transfer destination identification information is included as transfer source identification information or transfer destination identification information in chronological order of transfer date and time. By updating the end date and time with the transfer date and time included in the acquired occupancy transfer history records until a predetermined condition is satisfied, the interval from the start date and time to the end date and time is extracted as the segment corresponding to the transfer destination identification information.

Effect of the Invention

[0010] A technique capable of efficiently associating the possessor transfer history and the environmental information is provided.

Brief Description of the Drawings

[0011]

Figure 1

Figure 2

Figure 3

Figure 4

Figure 5

Figure 6

Figure 7

Figure 8

Figure 9

Figure 10

Figure 11

Figure 12

Figure 13

Mode for Carrying Out the Invention

[0012] Hereinafter, an embodiment of the present invention will be described.

[0013] <Occupier transfer history> The occupier transfer history is a record of when each product was transferred from which occupier to which occupier in units of one product. By recording the occupier transfer history, traceability regarding the logistics of products (hereinafter, also simply referred to as logistics traceability) is ensured.

[0014] Also, an occupier is a natural person, a juridical person, or a control and management target such as a space under their control and management that temporarily or non-temporarily controls and manages a product (thing) or a service (intangible). Hereinafter, as an example, it will be described that the occupier is a space that temporarily or non-temporarily controls and manages a product.

[0015] Specific examples of the possessor include, for example, transport vehicles such as trucks that can transport goods by means of a loading platform or the like, trains that can transport goods, warehouses and factories that can store goods, stores that sell goods, etc. Note that a single truck, a single train, a single warehouse, a single store, etc. may include multiple possessors. For example, when there are multiple rooms in a warehouse, each room may be regarded as one possessor, or a predetermined two or more rooms may be regarded as one possessor. Similarly, when there are multiple floors in a warehouse, each floor may be regarded as one possessor, or a predetermined two or more floors may be regarded as one possessor. The same applies to cases where a transport vehicle is equipped with multiple loading platforms or a train is composed of multiple vehicles.

[0016] Hereinafter, data representing the possessor transfer history will be referred to as a "possessor transfer history record", and table-form data composed of possessor transfer history records will be referred to as a "possessor transfer history table". A possessor transfer history record indicates when a certain product was transferred from which possessor to which possessor. A possessor transfer history record is represented, for example, in the following data format.

[0017] (Product individual ID, Transfer date and time, Transfer source ID, Transfer destination ID, Quantity of product) Here, the individual product ID is an identifier that uniquely identifies a product within the product's supply chain (e.g., a manufacturing-specific serial number, etc.). The transfer date and time is the date and time when the transfer of the product (including cases where the product is originally acquired through production, manufacturing, etc., and cases where the product is transferred through sales, disposal, exhaustion, etc.) occurs. The transfer source ID is an identifier that uniquely identifies the possessor of the transfer source. The transfer destination ID is an identifier that uniquely identifies the possessor of the transfer destination. The product quantity is information representing the size, quantity, weight, volume, number, etc. of the product. In the case where a product is originally acquired through production, manufacturing, etc., a certain predetermined identifier indicating that the product has been originally acquired is set for the transfer source ID. On the other hand, in the case where a product is transferred through sales, etc., a certain predetermined identifier indicating that the product has been transferred, etc. is set for the transfer destination ID. Hereinafter, it is assumed that the primary key in the possessor transfer history table is (individual product ID, transfer date and time).

[0018] As an example, FIG. 1 shows a case where a possessor transfer history record is realized by a non-fungible token (e.g., an ERC721 token, etc.) on a blockchain (Ethereum (registered trademark)). In the example shown in FIG. 1, a certain product (individual product ID: item1) is manufactured at a factory (possessor ID: 0x111), and a possessor transfer history record (individual product ID, transfer date and time, transfer source ID, transfer destination ID, product quantity) = (item1, 2022 / 1 / 1 12:00, 0x0, 0x111, 1) is generated and recorded in the distributed ledger of the blockchain (hereinafter also abbreviated as BC). In the example shown in FIG. 1, the identifier (address) indicating that the product has been originally acquired is set as 0x0 (an invalid address).

[0019] After that, in the example shown in FIG. 1, an occupant transfer occurs to Track 1 (occupant ID: 0x222), and an occupant transfer history record (product individual ID, transfer date and time, transfer source ID, transfer destination ID, product quantity) = (item1, 2022 / 1 / 2 15:30, 0x111, 0x222, 1) is recorded in the BC. Similarly thereafter, an occupant transfer occurs to the warehouse (occupant ID: 0x333), and an occupant transfer history record (product individual ID, transfer date and time, transfer source ID, transfer destination ID, product quantity) = (item1, 2022 / 1 / 2 18:00, 0x222, 0x333, 1) is recorded in the BC. Similarly, thereafter, an occupant transfer occurs to Track 2 (occupant ID: 0x444), and an occupant transfer history record (product individual ID, transfer date and time, transfer source ID, transfer destination ID, product quantity) = (item1, 2022 / 1 / 3 13:00, 0x333, 0x444, 1) is recorded in the BC. Similarly, thereafter, an occupant transfer occurs to the store (occupant ID: 0x555), and an occupant transfer history record (product individual ID, transfer date and time, transfer source ID, transfer destination ID, product quantity) = (item1, 2022 / 1 / 4 9:00, 0x444, 0x555, 1) is recorded in the BC. Finally, the product (product individual ID: item1) is sold at the store (occupant ID: 0x555), and an occupant transfer history record (product individual ID, transfer date and time, transfer source ID, transfer destination ID, product quantity) = (item1, 2022 / 1 / 4 16:00, 0x555, 0x0, 1) is recorded in the BC. Note that in the example shown in FIG. 1, the identifier (address) indicating that the product has been sold is set to 0x0 (invalid address).

[0020] In this way, the occupant transfer history record ensures traceability (logistics traceability) in the entire logistics supply chain from the production and manufacturing of goods to distribution and sales. In the example shown in FIG. 1, a system for ensuring logistics traceability (logistics traceability system) is realized by blockchain, but this is just an example. Besides blockchain, for example, if the occupant transfer history can be stored for each product unit, logistics traceability may be ensured by a center-managed database system. The logistics traceability system applicable to this embodiment is not limited to a specific logistics traceability system, and any logistics traceability system can be applied as long as it can manage the occupant transfer history record after identifying the management target by means of an ID, barcode, RFID (Radio Frequency Identification) tag, etc.

[0021] <Environmental information> Environmental information refers to information measured by IoT sensors installed, etc., in a certain space (including the space temporarily or permanently dominated and managed by the occupant). In this embodiment, it is assumed that some environmental information is measured by IoT sensors within the space dominated and managed by at least some of the occupants on the logistics supply chain.

[0022] Specific examples of environmental information include, for example, GPS (Global Positioning System) information (that is, position information measured using radio waves received by a GPS receiver), temperature, humidity, electricity consumption, fuel consumption, CO2 emissions, etc.

[0023] Environmental information can be classified into point information type and quantity information type. Examples of environmental information of the point information type include, for example, GPS information, temperature, humidity, etc. On the other hand, examples of environmental information of the quantity information type include, for example, electricity consumption, fuel consumption, CO2 emissions, etc.

[0024] Regarding the environmental information of the point information type, even if there are multiple products in the measurement space of the IoT sensor, the environmental information of each product is the same (including cases where it can be regarded as the same). Also, the environmental information of the point information type is information with strong meaning for each point existing in time series, and the environmental information is not added or divided. On the other hand, in the case of the environmental information of the quantity information type, when there are multiple products in the measurement space of the IoT sensor, it is expected to obtain the environmental information for each product considering the total quantity and attributes of the products, etc. Specifically, for example, it is expected to obtain the power consumption, fuel consumption, CO2 emissions, etc. for each product by proportional calculation considering the total quantity and attributes of the products, etc.

[0025] Also, by associating the possessor transfer history with the environmental information, visualization of detailed environmental information for each product (that is, environmental information for each product for each possessor) on the logistics supply chain is expected. On the other hand, since there are a large number of possessor transfer histories for each product unit, there is a problem that the data volume becomes enormous when the possessor transfer history and the environmental information are simply associated.

[0026] Furthermore, when performing proportional calculation for the environmental information of the quantity information type, there is also a problem that the environmental information for each product unit becomes inaccurate with a simple proportional calculation. For example, considering CO2 emissions as environmental information, assume that a certain truck departs from a warehouse and delivers products to multiple bases. At this time, if the CO2 emissions during the delivery route are simply divided by the total quantity of products, the CO2 emissions of the products loaded and unloaded first will be calculated to be more than the actual amount, while the CO2 emissions of the products loaded and unloaded later will be calculated to be less than the actual amount.

[0027] Therefore, below, in order to solve the above two problems, an interval called "segment" is introduced, and a method (proposed method) is described that efficiently associates the possessor transfer history with the environmental information using the segment and enables calculation of more accurate environmental information for each product unit regarding the environmental information of the quantity information type.

[0028] In addition, if more accurate environmental information per product unit can be calculated for the environmental information of the quantity information type, for example, it becomes possible to more accurately calculate the CO2 emissions related to Scope 3 categories 4 and 9 (transportation, distribution) in the logistics supply chain defined by the Greenhouse Gas (GHG) protocol.

[0029] <Overview of the proposed method> ·Regarding the environmental information of the quantity information type Assume that an owner transfer history table composed of owner transfer history records for a certain period (for example, a predetermined period up to the current date and time, etc.) is given. Also, regarding the environmental information of the quantity information type, assume that the integrated value of the time-series environmental information for each owner is obtained. Hereinafter, as an example, assume that the environmental information of the quantity information type is CO2 emissions, and the integrated value of the time-series CO2 emissions for each owner (hereinafter also referred to as the integrated CO2 emissions) is obtained.

[0030] At this time, in this proposed method, the following processes (1-1) to (1-6) are executed.

[0031] (1-1) Segment extraction Based on the transfer date and time, etc. of the owner transfer history records stored in the owner transfer history table, segments for each owner are extracted. A segment is an interval delimited by the change in the total quantity of products simultaneously occupied by an owner. A segment becomes an interval associated with an owner. Here, the total quantity of products is the total of the product quantities of the products simultaneously occupied by the owner associated with that segment. This total quantity of products is used to allocate the environmental information of the quantity information type. Whether to use size, quantity, weight, volume, number, etc. as the product quantity is determined, for example, by the attributes and properties of the product. The specific method of segment extraction will be described later.

[0032] (1-2) Occupancy period extraction Based on the transfer source ID, transfer destination ID, etc. of the possessor transfer history records stored in the possessor transfer history table, the possession period for each product is extracted. The possession period refers to the period delimited by changes in the possessor who possesses the product. The possession period becomes the period associated with the product. Note that the specific method for extracting the possession period will be described later.

[0033] (1-3) CO2 Emission Calculation per Segment Calculate the CO2 emission per segment. For example, taking the start date and time of the segment as the "segment start date and time" and the end date and time as the "segment end date and time", for each segment, obtain the integrated CO2 emission at the date and time closest to the segment end date and time (hereinafter referred to as the first integrated CO2 emission) and the integrated CO2 emission at the date and time closest to the segment start date and time (hereinafter referred to as the second integrated CO2 emission). Then, calculate the value obtained by subtracting the second integrated CO2 emission from the first integrated CO2 emission as the CO2 emission per segment for the segment. However, this calculation method is just an example, and the calculation method of the CO2 emission per segment is not limited to this.

[0034] (1-4) CO2 Emission Calculation per Product Unit per Segment For example, for each segment, calculate the CO2 emission per product unit per segment for each product in the segment according to the formula: CO2 emission per product unit per segment = CO2 emission per segment × quantity of the product / (total quantity of products simultaneously possessed by the possessor in the segment).

[0035] (1-5) CO2 Emission Calculation per Product Unit per Possession Period For example, calculate the sum of the CO2 emissions per product unit per segment of the segments included between the segment with the segment start date and time closest to the start date and time of the possession period and the segment with the segment end date and time closest to the end date and time of the possession period, among the segments that are the same as the segment of the possessor of the possession period, as the CO2 emission per product unit per possession period of the possession period.

[0036] (1-6) Visualization Visualize the CO2 emissions per unit of goods for each occupancy period, the CO2 emissions per unit of goods for each segment, etc. (for example, display on a display or the like).

[0037] A specific example of calculating the CO2 emissions per segment and the CO2 emissions per unit of goods for each occupancy period will be described with reference to FIGS. 2 and 3. For example, as shown in FIG. 2, assume that the transportation route of truck 1 (occupant) on a certain day is as follows.

[0038] · Load goods A and B at warehouse a at 12:00, · Load goods C and D at warehouse b at 13:00, · Unload goods B, C, and D at store c at 14:00, · Unload goods A at store d at 15:00.

[0039] Also, assume that the quantity (weight) of goods A and B is 5 kg, and the quantity (weight) of goods C and D is 3 kg.

[0040] At this time, as shown in FIG. 3, the segments of truck 1 are "segment 1" from 12:00 to 13:00, "segment 2" from 13:00 to 14:00, and "segment 3" from 14:00 to 15:00. Also, the occupancy period of goods A related to truck 1 is from 12:00 to 15:00, the occupancy period of goods B related to truck 1 is from 12:00 to 14:00, the occupancy period of goods C related to truck 1 is from 13:00 to 14:00, and the occupancy period of goods D related to truck 1 is from 13:00 to 14:00.

[0041] Also, as shown in FIG. 2, assume that the result of calculating the CO2 emissions per segment is as follows.

[0042] CO2 emissions per segment for segment 1: 100 CO2 emissions per segment for segment 2: 100 CO2 emissions per segment for segment 3: 100 In the above case, the per - product CO2 emissions per segment for each product in Track 1 are calculated as follows.

[0043] Per - product CO2 emissions per segment for Product A in Segment 1: 100×5 / 10 Per - product CO2 emissions per segment for Product B in Segment 1: 100×5 / 10 Per - product CO2 emissions per segment for Product A in Segment 2: 100×5 / 16 Per - product CO2 emissions per segment for Product B in Segment 2: 100×5 / 16 Per - product CO2 emissions per segment for Product C in Segment 2: 100×3 / 16 Per - product CO2 emissions per segment for Product D in Segment 2: 100×3 / 16 Per - product CO2 emissions per segment for Product A in Segment 3: 100×5 / 5 Therefore, the per - product CO2 emissions per occupancy interval are calculated as follows.

[0044] Per - product CO2 emissions per occupancy interval for Product A in the occupancy interval of Track 1: 100×5 / 10 + 100×5 / 16 + 100×5 / 5 ≒ 181 Per - product CO2 emissions per occupancy interval for Product B in the occupancy interval of Track 1: 100×5 / 10 + 100×5 / 16 ≒ 81 Per - product CO2 emissions per occupancy interval for Product C in the occupancy interval of Track 1: 100×3 / 16 ≒ 19 Per - product CO2 emissions per occupancy interval for Product D in the occupancy interval of Track 1: 100×3 / 16 ≒ 19 Thus, the per - product CO2 emissions per segment and the per - product CO2 emissions per occupancy interval are obtained. Therefore, these can be visualized and used for purposes such as analysis during malfunction occurrence, cost reduction, and business efficiency improvement.

[0045] Also, at this time, since the CO2 emissions of each product are associated with the occupancy period and segment, the data volume can be significantly reduced compared to the case of simply associating the CO2 emissions with the occupant transfer history. Therefore, for example, it becomes possible to execute processes such as analysis and analysis at the time of failure in units of segments, and as a result, a significant reduction in processing time can be expected.

[0046] Furthermore, after obtaining the CO2 emissions for each product in units of segments and accumulating them, the CO2 emissions for each occupancy period can be calculated, so it becomes possible to calculate more accurate CO2 emissions compared to simple apportionment calculations.

[0047] Here, an example of the result of visualizing the CO2 emissions per product per segment and the CO2 emissions per product per occupancy period is shown in FIG. 4. In the example shown in FIG. 4, the CO2 emissions per product per occupancy period (CO2 emissions (kg-CO2)) of a certain product (product individual ID: item1) for each occupancy period and the information related thereto (product individual ID, occupant, occupancy period start date and time, occupancy period end date and time, total, etc.) are visualized on the display column 1000. Also, in the example shown in FIG. 4, the CO2 emissions per product per segment (CO2 emissions per product (kg-CO2)) of the product in a certain segment and the information related thereto (product individual ID, weight, occupant, segment start date and time, segment end date and time, segment CO2 emissions (kg-CO2), total amount of simultaneously occupied products (kg), total, etc.) are visualized on the display column 1100. Note that the display column 1100 may be displayed, for example, when a desired segment is selected by a user or the like on the display column 1000.

[0048] ·Regarding environmental information of the point information type It is assumed that an occupant transfer history table composed of occupant transfer history records for a certain period (for example, a predetermined period up to the current date and time, etc.) is given. Also, regarding the environmental information of the point information type, it is assumed that time-series environmental information for each occupant is obtained. Hereinafter, as an example, it is assumed that the environmental information of the point information type is GPS information, and time-series GPS information for each occupant is obtained.

[0049] At this time, in the proposed method, the following processes (2-1) to (2-3) are executed.

[0050] (2-1) Segment extraction This is the same as the above (1-1). That is, based on the transfer date and time of the occupant transfer history records stored in the occupant transfer history table, segments for each occupant are extracted. However, in the case of point information type, it is not necessary to allocate environmental information according to the total quantity of products. Therefore, as the quantity of products, for example, the number of products can be used. The specific method of segment extraction will be described later.

[0051] · Regarding the segmenting determination threshold For example, even when a plurality of products are simultaneously warehoused in a certain warehouse or a plurality of products are simultaneously shipped out from a certain warehouse, the transfer dates and times on the occupant transfer history records for these plurality of products do not necessarily become exactly the same. This is because, for example, the transfer date and time of the occupant transfer history record may be updated in the order in which the products are loaded and unloaded from the truck. Also, for example, when the occupant transfer history record is realized by non-fungible tokens of a blockchain, since the transactions for updating the occupant transfer history record are not necessarily recorded in the same block.

[0052] Therefore, if the segments are strictly delimited by the change in the total quantity of products, the segments may become too fine and may not become meaningful segments. Thus, for transfers related to the same occupant, even if the transfer dates and times are different, if the difference between them is less than a certain value, a threshold (hereinafter, this threshold will be referred to as the "segmenting determination threshold") is set so as to regard them as one segment. Thereby, it is possible to prevent the segments from becoming too fine. The segmenting determination threshold is set in advance to an appropriate value.

[0053] For example, as shown in FIG. 5, it is assumed that products A to D (each with a product quantity of "1 kg") are transferred in order from truck 1 to a certain occupant (such as a warehouse or a store) almost simultaneously. At this time, if the segments are strictly delimited by the change in the total quantity of products, as shown in the upper diagram of FIG. 5, segment 1 (total quantity of products "1 kg"), segment 2 (total quantity of products "2 kg"), segment 3 (total quantity of products "3 kg"), and segment 4 (total quantity of products "4 kg") are obtained in order. However, these are very fine segments and cannot be regarded as meaningful segments just because the processing volume becomes huge. Therefore, as shown in the lower diagram of FIG. 5, even if the total quantity of products held simultaneously changes, if the difference in transfer date and time is less than the segmenting determination threshold value, it is regarded as the same segment. Thereby, for example, when the segmenting determination threshold value is 3 minutes, as shown in the lower diagram of FIG. 5, products A to C transferred almost simultaneously can be treated as products held by the occupant simultaneously in segment 1 (total quantity of products "3 kg").

[0054] (2-2) Associate GPS information for each segment Associate each segment with GPS information. For example, regarding each segment, acquire the GPS information existing between the segment start date and time and the segment end date and time, and these acquired GPS information may be associated with the corresponding segment.

[0055] (2-3) Visualization Visualize the GPS information associated with each segment (for example, display it on a display or the like).

[0056] A specific example of associating GPS information for each segment will be described with reference to FIG. 6. For example, as shown in FIG. 6, it is assumed that the transportation route of truck 1 (occupant) on a certain day is as follows.

[0057] · Load 200 products at warehouse a at 12:00, · Load 200 products at warehouse b at 13:00, · Unload 300 products at store c at 14:00, ·Lower 100 items at store d at 15:00.

[0058] At this time, for the segments of truck 1, the period from 12:00 to 13:00 is "segment 1", the period from 13:00 to 14:00 is "segment 2", and the period from 14:00 to 15:00 is "segment 3".

[0059] Therefore, GPS information during the period from 12:00 to 13:00 is associated with segment 1. Similarly, GPS information during the period from 13:00 to 14:00 is associated with segment 2. Similarly, GPS information during the period from 14:00 to 15:00 is associated with segment 3.

[0060] As a result, an association can be obtained between each segment and GPS information. For this reason, these can be visualized and used for purposes such as analysis during malfunction occurrence, cost reduction, and business efficiency improvement.

[0061] Also, at this time, since GPS information is associated with segments, the data volume can be significantly reduced compared to the case of simply associating GPS information with the transfer history of the possessor. For this reason, for example, processing such as analysis during malfunction occurrence can be executed in units of segments, and as a result, a significant reduction in processing time can be expected.

[0062] Although specific examples of the visualization results of the GPS information associated with segments are omitted, for example, for each segment, the GPS information associated with that segment can be visualized (or only one or a plurality of representative GPS information among them can be visualized).

[0063] [Example 1] Hereinafter, Example 1 of the present embodiment will be described. In Example 1, a case where the environmental information is the CO2 emission amount is assumed, and the environmental information management device 10 that executes the above-mentioned processes (1-1) to (1-6) will be described. However, the fact that the environmental information is the CO2 emission amount is just an example, and Example 1 described below is similarly applicable to environmental information of an amount information type other than the CO2 emission amount (for example, power consumption, fuel consumption, etc.).

[0064] <Hardware configuration example of the environmental information management device 10 in Example 1> A hardware configuration example of the environmental information management device 10 in Example 1 is shown in FIG. 7. As shown in FIG. 7, the environmental information management device 10 in Example 1 is realized by the hardware configuration of a general computer or computer system. For example, it includes an input device 101, a display device 102, an external I / F 103, a communication I / F 104, a RAM (Random Access Memory) 105, a ROM (Read Only Memory) 106, an auxiliary storage device 107, and a processor 108. Also, each of these hardware components is communicably connected via a bus 109.

[0065] The input device 101 is, for example, a keyboard, a mouse, a touch panel, a physical button, etc. The display device 102 is, for example, a display, a display panel, etc. Note that the environmental information management device 10 may not have at least one of the input device 101 and the display device 102.

[0066] The external I / F 103 is an interface with an external device such as a recording medium 103a. The environmental information management device 10 can read and write to the recording medium 103a via the external I / F 103. Examples of the recording medium 103a include a flexible disk, a CD (Compact Disc), a DVD (Digital Versatile Disk), an SD memory card (Secure Digital memory card), a USB (Universal Serial Bus) memory card, etc.

[0067] The communication I / F 104 is an interface for the environmental information management device 10 to connect to a communication network or the like. The RAM 105 is a volatile semiconductor memory (storage device) that temporarily holds programs and data. The ROM 106 is a non-volatile semiconductor memory (storage device) that can hold programs and data even when the power is turned off. The auxiliary storage device 107 is a storage device (storage device) such as an HDD (Hard Disk Drive), an SSD (Solid State Drive), or a flash memory. The processor 108 is an arithmetic device such as a CPU (Central Processing Unit).

[0068] The environmental information management device 10 in the first embodiment can realize various processes to be described later by having the hardware configuration shown in FIG. 7. Note that the hardware configuration shown in FIG. 7 is an example, and the hardware configuration of the environmental information management device 10 is not limited to this. For example, the environmental information management device 10 may have a plurality of auxiliary storage devices 107 and a plurality of processors 108, may not have a part of the illustrated hardware, or may have various hardware other than the illustrated hardware.

[0069] <Functional configuration example of the environmental information management device 10 in the first embodiment> A functional configuration example of the environmental information management device 10 in Embodiment 1 is shown in FIG. 8. As shown in FIG. 8, the environmental information management device 10 in Embodiment 1 includes a segment extraction unit 201, an occupancy period extraction unit 202, a CO2 emission amount calculation unit 203 for each segment, a CO2 emission amount calculation unit 204 for each segment per commodity unit, a CO2 emission amount calculation unit 205 for each occupancy period per commodity unit, and a visualization unit 206. Each of these units is realized, for example, by a process executed by one or more programs installed in the environmental information management device 10 on a processor 108 or the like. Further, the environmental information management device 10 in Embodiment 1 includes an occupant transfer history storage unit 301, an integrated CO2 emission amount storage unit 302, a CO2 emission amount storage unit 303 for each segment, and a CO2 emission amount storage unit 304 for each occupancy period per commodity unit. Each of these units is realized, for example, by a storage device such as an auxiliary storage device 107.

[0070] The segment extraction unit 201 executes the process of (1-1) above. That is, the segment extraction unit 201 extracts segments for each occupant based on the transfer date and time of the occupant transfer history records stored in the occupant transfer history table.

[0071] The occupancy period extraction unit 202 executes the process of (1-2) above. That is, the occupancy period extraction unit 202 extracts the occupancy period for each commodity based on the transfer source ID and transfer destination ID of the occupant transfer history records stored in the occupant transfer history table.

[0072] The CO2 emission amount calculation unit 203 for each segment executes the process of (1-3) above. That is, the CO2 emission amount calculation unit 203 for each segment calculates the CO2 emission amount for each segment. It can also be said that this associates the CO2 emission amount in each segment with the segment.

[0073] The CO2 emission amount calculation unit 204 for each segment per commodity unit executes the process of (1-4) above. That is, the CO2 emission amount calculation unit 204 for each segment per commodity unit calculates the CO2 emission amount for each segment per commodity unit.

[0074] The CO2 emissions calculation unit 205 per commodity unit for each occupancy period executes the above processes (1-5). That is, the CO2 emissions calculation unit 205 per commodity unit for each occupancy period calculates the CO2 emissions per commodity unit for each occupancy period.

[0075] The visualization unit 206 executes the above processes (1-6). That is, the visualization unit 206 visualizes the CO2 emissions per commodity unit for each occupancy period, the CO2 emissions per commodity unit for each segment, etc.

[0076] The occupant transfer history storage unit 301 stores an occupant transfer history table composed of given occupant transfer history records (for example, an occupant transfer history record in the period from T-ΔT to T, where the current date and time is T and a predetermined time width is ΔT). These occupant transfer history records are given, for example, from a logistics traceability system.

[0077] The integrated CO2 emissions storage unit 302 stores the integrated CO2 emissions per occupant (for example, the integrated CO2 emissions per occupant in the period from T-ΔT to T). The integrated CO2 emissions per occupant are given, for example, from an IoT infrastructure system that manages IoT sensors installed, etc., in spaces temporarily or permanently controlled and managed by each occupant.

[0078] However, for example, the time-series CO2 emissions per occupant may be given from an IoT infrastructure system or the like. In this case, the integrated CO2 emissions per occupant are calculated, for example, by an integrated CO2 emissions calculation unit (not shown) provided in the environmental information management device 10.

[0079] The per-segment CO2 emission memory unit 303 stores the segments extracted by the segment extraction unit 201, the per-segment CO2 emissions calculated by the per-segment CO2 emission calculation unit 203, and the like. Hereinafter, the data representing the per-segment CO2 emissions is referred to as "per-segment CO2 emission record", and the table-form data composed of per-segment CO2 emission records is referred to as "per-segment CO2 emission table". The per-segment CO2 emission record represents the CO2 emissions in a certain segment of a certain occupant and the total quantity of the products that the occupant possessed simultaneously in that segment. The per-segment CO2 emission record is represented, for example, in the following data format.

[0080] (Occupant ID, Segment start date and time, Segment end date and time, Segment CO2 emissions, Total segment product quantity) Here, the occupant ID is an identifier that uniquely identifies the occupant. The segment start date and time is the start date and time of the segment. The segment end date and time is the end date and time of the segment. The segment CO2 emissions are the CO2 emissions in the segment (that is, the per-segment CO2 emissions related to that segment). The total segment product quantity is the total quantity of the products that the occupant possesses simultaneously in the segment. Hereinafter, it is assumed that the primary key in the per-segment CO2 emission table is (Occupant ID, Segment start date and time).

[0081] The CO2 emission amount per commodity unit for each occupancy period storage unit 304 stores the occupancy periods extracted by the occupancy period extraction unit 202, the CO2 emission amount per commodity unit for each occupancy period calculated by the CO2 emission amount per commodity unit for each occupancy period calculation unit 205, and the like. Hereinafter, data representing the CO2 emission amount per commodity unit for each occupancy period is referred to as a "CO2 emission amount record per commodity unit for each occupancy period", and table-form data composed of CO2 emission amount records per commodity unit for each occupancy period is referred to as a "CO2 emission amount table per commodity unit for each occupancy period". The CO2 emission amount record per commodity unit for each occupancy period represents the CO2 emission amount of a certain commodity in a certain occupancy period and the amount of that commodity. The CO2 emission amount record per commodity unit for each occupancy period is represented, for example, in the following data format.

[0082] (Commodity individual ID, Occupier ID, Occupancy period start date and time, Occupancy period end date and time, CO2 emission amount per commodity unit, Commodity amount) Here, the commodity individual ID is an identifier that uniquely identifies a commodity in the supply chain of the commodity (for example, a manufacturing unique number, etc.). The occupier ID is an identifier that uniquely identifies the occupier. The occupancy period start date and time is the start date and time of the occupancy period. The occupancy period end date and time is the end date and time of the occupancy period. The CO2 emission amount per commodity unit is the CO2 emission amount of the commodity in the occupancy period (that is, the CO2 emission amount per commodity unit for each occupancy period regarding the commodity in that occupancy period). The commodity amount is information representing the size, amount, weight, volume, number, etc. of the commodity. Hereinafter, it is assumed that the primary key in the CO2 emission amount table per commodity unit for each occupancy period is (Commodity individual ID, Occupier ID, Occupancy period start date and time).

[0083] <Example of the processing flow of the environmental information management device 10 in Embodiment 1> An example of the processing flow of the environmental information management device 10 in Embodiment 1 will be described with reference to FIG. 9. Steps S101 to S106 in FIG. 9 are repeatedly executed, for example, every predetermined time width.

[0084] The segment extraction unit 201 extracts segments for each occupant based on the transfer date and time, etc. of the occupant transfer history records stored in the occupant transfer history table (step S101). As a result, for example, segments in the data format of (occupant ID, segment start date and time, segment end date and time, total segment product quantity) are extracted. Hereinafter, the segment is assumed to be extracted as a per-segment CO2 emission record (occupant ID, segment start date and time, segment end date and time, segment CO2 emission, total segment product quantity) for each segment where the segment CO2 emission is not set. The details of the processing in this step will be described later.

[0085] Next, the occupancy period extraction unit 202 extracts the occupancy period for each product based on the transfer source ID, transfer destination ID, etc. of the occupant transfer history records stored in the occupant transfer history table (step S102). As a result, for example, occupancy periods in the data format of (product individual ID, occupant ID, occupancy period start date and time, occupancy period end date and time, product quantity) are extracted. Hereinafter, the occupancy period is assumed to be extracted as a per-occupancy-period product unit CO2 emission record (product individual ID, occupant ID, occupancy period start date and time, occupancy period end date and time, product unit CO2 emission, product quantity) for each occupancy period where the product unit CO2 emission is not set. The details of the processing in this step will be described later.

[0086] The following steps S103 to S105 are executed, for example, with respect to the segments and occupancy periods newly extracted in the above steps S101 to S102.

[0087] Next, the per-segment CO2 emission calculation unit 203 calculates the per-segment CO2 emissions (step S103). That is, the per-segment CO2 emission calculation unit 203 obtains, for each segment of each occupant, the cumulative CO2 emissions of the occupant at the time closest to the segment end time (the first cumulative CO2 emissions) and the cumulative CO2 emissions of the occupant at the time closest to the segment start time (the second cumulative CO2 emissions). Then, the per-segment CO2 emission calculation unit 203 calculates the value obtained by subtracting the second cumulative CO2 emissions from the first cumulative CO2 emissions as the segment CO2 emissions in the per-segment CO2 emissions record. Thereby, a per-segment CO2 emissions record (occupant ID, segment start time, segment end time, segment CO2 emissions, total segment product quantity) is obtained. Note that this can also be said to associate the CO2 emissions of each segment (i.e., segment CO2 emissions) with each segment.

[0088] Next, the per-segment per-product-unit CO2 emission calculation unit 204 calculates the per-segment per-product-unit CO2 emissions (step S104). That is, the per-segment per-product-unit CO2 emission calculation unit 204 calculates the per-segment per-product-unit CO2 emissions for each product occupied by the occupant in each segment, for example, by per-segment per-product-unit CO2 emissions = (segment CO2 emissions included in the per-segment CO2 emissions record) × (quantity of the product) / (total segment product quantity included in the per-segment CO2 emissions record).

[0089] Next, the per-occupation-interval per-product CO2 emission calculation unit 205 calculates the per-occupation-interval per-product CO2 emissions (step S105). That is, the per-occupation-interval per-product CO2 emission calculation unit 205 calculates, for example, the sum of the per-segment per-product CO2 emissions of the segments included between the segment with the closest segment start date and time before the start date and time of the occupation interval and having the same occupant ID as the occupant ID of the occupation interval and the segment with the closest segment end date and time after the end date and time of the occupation interval as the per-occupation-interval per-product CO2 emissions of the occupation interval. Thereby, a per-occupation-interval per-product CO2 emission record (product individual ID, occupant ID, occupation interval start date and time, occupation interval end date and time, per-product CO2 emissions, quantity of products) is obtained.

[0090] Then, the visualization unit 206 visualizes (for example, displays on a display or the like) the per-occupation-interval per-product CO2 emissions, the per-segment per-product CO2 emissions, etc. (step S106). That is, the visualization unit 206 displays, for example, at least one of the display columns 1000 and 1100 as shown in FIG. 4 on the display device 102.

[0091] <Example of segment extraction process in Embodiment 1> The segment extraction process by the segment extraction unit 201 can be implemented as follows.

[0092] An occupant ID non-duplication list is obtained with the transfer destination ID of the occupant transfer history record stored in the occupant transfer history table as the occupant ID. Next, the segment extraction unit 201 acquires, for each occupant ID included in the obtained list, the occupant transfer history records in which the occupant ID is the transfer source ID or the transfer destination ID in chronological order of transfer date and time. The following process is performed on the occupant transfer history records in chronological order of transfer date and time.

[0093] The most recent segment end date and time and the total quantity of products at that time are obtained from the most recent processing result (when this process is started for the first time and there is no most recent one, the date and time is a sufficiently old date and time, the total quantity of products is 0, etc., and appropriate initialization is performed). At this time, as the next segment to be generated, · The start date and time is the end date and time of the most recent segment. · The end date and time is the transfer date and time of the record being sequentially processed. · The total quantity of goods is the quantity of goods increased (when the current possessor is the transfer destination) or decreased (when the current possessor is the transfer source) for the records being sequentially processed. (In the case where there are multiple records with the same date and time, the increase or decrease process is repeated for all applicable records.) This is what should be done.

[0094] However, in this implementation method, if there are multiple possessor transfer history records within a few seconds or minutes, there is a high possibility that fine-grained segments with relatively short time intervals will occur according to the multiple possessor transfer history records. A more appropriate processing method for avoiding the occurrence of such fine-grained segments can also be considered.

[0095] One of the avoidance methods is to round the record date and time at an appropriate level and then perform the processing. For example, when there are records of "12:00:00" and "12:00:15", if the seconds are truncated for processing, these two records will be regarded as having the same date and time, so segments less than one minute will not occur.

[0096] As another avoidance method, a segmentation determination threshold is set, and for possessor transfer histories less than this segmentation determination threshold, they are connected as one segment. An example of the segment extraction process by this method will be described in detail below.

[0097] An example of the segment extraction process in step S101 of FIG. 9 will be described with reference to FIG. 10.

[0098] The segment extraction unit 201 obtains a non-duplicate list of possessor IDs by using the transfer destination ID of the possessor transfer history record stored in the possessor transfer history table as the possessor ID (step S201).

[0099] Next, the segment extraction unit 201 repeats steps S211 to S214 for each owner ID included in the list obtained in step S201 (step S202). Hereinafter, steps S211 to S214 for a certain owner ID will be described.

[0100] The segment extraction unit 201 acquires owner transfer history records in which the owner ID is the transfer source ID or the transfer destination ID in chronological order of transfer date and time (step S211). However, at this time, the segment extraction unit 201 acquires owner transfer history records including a transfer date and time after the maximum value of the segment start date and time of the CO2 emission amount record per segment stored in the CO2 emission amount table per segment. This is to start segment extraction from where the segment extraction process was continued when it was executed last time. Note that the maximum value of the date and time means the latest date and time.

[0101] The segment extraction unit 201 sets initial values for the temporary segment start date and time, the temporary segment end date and time, and the total quantity of temporary segment products (step S212). The segment extraction unit 201 sets initial values as follows for the temporary segment start date and time, the temporary segment end date and time, and the total quantity of temporary segment products. Note that the temporary segment start date and time, the temporary segment end date and time, and the total quantity of temporary segment products are all temporary variables used for segment extraction.

[0102] Temporary segment start date and time: Set the maximum value of the segment start date and time of the CO2 emission amount record per segment in which the owner ID is included among the CO2 emission amount records per segment stored in the CO2 emission amount table per segment. However, if there is no CO2 emission amount record per segment in which the owner ID is included, set NULL (null value).

[0103] Temporary segment end date and time: Set NULL.

[0104] Temporary segment total product volume: For each CO2 emission record segment containing the said possessor ID, set the segment total product volume of the CO2 emission record segment that takes the maximum segment start date and time. However, if there is no CO2 emission record segment containing the said possessor ID, set it to 0.

[0105] The segment extraction unit 201 repeats steps S221 to S223 for the said possessor transfer history record in the order in which the possessor transfer history record was obtained in step S211 above (step S213). Hereinafter, steps S221 to S223 for a certain possessor transfer history record will be described.

[0106] When the temporary segment start date and time is NULL, the segment extraction unit 201 sets the transfer date and time of the said possessor transfer history record as the temporary segment start date and time (step S221). Note that if the temporary segment start date and time is not NULL, this step is not executed.

[0107] The segment extraction unit 201 determines segment confirmation according to whether the difference between the transfer date and time of the said possessor transfer history record and the temporary segment end date and time is less than the segmentation determination threshold (step S222). Specifically, the segment extraction unit 201 executes the following (3-1) or (3-2).

[0108] (3-1) When the temporary segment end date and time is NULL, or when the difference between the transfer date and time of the said possessor transfer history record and the temporary segment end date and time is less than the segmentation determination threshold In this case, the segment extraction unit 201 executes (3-1-1) to (3-1-2).

[0109] (3-1-1) The segment extraction unit 201 sets the transfer date and time of the said possessor transfer history record as the temporary segment end date and time.

[0110] (3-1-2) If the owner transfer history record is the last record regarding the owner ID in step S213 above, the segment extraction unit 201 executes the following (3-1-2-1) to (3-1-2-3). On the other hand, if the owner transfer history record is not the last record regarding the owner ID in step S213 above, the process proceeds to step S223.

[0111] (3-1-2-1) The segment extraction unit 201 increases or decreases the provisional segment total quantity according to whether the owner ID matches the transfer source ID of the owner transfer history record. That is, when the owner ID matches the transfer source ID, the segment extraction unit 201 subtracts the quantity of goods in the owner transfer history record from the provisional segment total quantity. On the other hand, when the owner ID does not match the transfer source ID (that is, when the owner ID matches the transfer destination ID of the owner transfer history record), the segment extraction unit 201 adds the quantity of goods in the owner transfer history record to the provisional segment total quantity.

[0112] (3-1-2-2) The segment extraction unit 201 determines the segment of the owner ID using the current provisional segment start date and time, provisional segment end date and time, and provisional segment total quantity. That is, the segment extraction unit 201 determines the segment of the owner ID (owner ID, segment start date and time, segment end date and time, segment total quantity) with the current provisional segment start date and time as the segment start date and time, the current provisional segment end date and time as the segment end date and time, and the current provisional segment total quantity as the segment total quantity.

[0113] (3-1-2-3) The segment extraction unit 201 stores the information of the segments determined in (3-1-2-2) above in the per-segment CO2 emission table as per-segment CO2 emission records. That is, the segment extraction unit 201 stores the information of the segments determined in (3-1-2-2) above (owner ID, segment start date and time, segment end date and time, and total segment product quantity) in the per-segment CO2 emission table as per-segment CO2 emission records. At this time, if a per-segment CO2 emission record with a matching primary key already exists in the per-segment CO2 emission table, the segment extraction unit 201 updates the existing per-segment CO2 emission record; otherwise, it inserts the per-segment CO2 emission record into the per-segment CO2 emission table. Then, the segment extraction unit 201 proceeds to step S214.

[0114] (3-2) When it is other than the above (3-1) In this case, the segment extraction unit 201 executes the following (3-2-1) to (3-2-4).

[0115] (3-2-1) The segment extraction unit 201 sets the transfer date and time of the owner transfer history record as the temporary segment end date and time.

[0116] (3-2-2) The segment extraction unit 201 determines the segment of the owner ID using the current temporary segment start date and time, temporary segment end date and time, and temporary segment product total quantity. That is, the segment extraction unit 201 determines the segment of the owner ID (owner ID, segment start date and time, segment end date and time, segment product total quantity) with the current temporary segment start date and time as the segment start date and time, the current temporary segment end date and time as the segment end date and time, and the current temporary segment product total quantity as the segment product total quantity.

[0117] (3-2-3) The segment extraction unit 201 stores the information of the segments determined in the above (3-2-2) in the per-segment CO2 emission table as per-segment CO2 emission records. That is, the segment extraction unit 201 stores the information of the segments determined in the above (3-2-2) (owner ID, segment start date and time, segment end date and time, and total segment product quantity) in the per-segment CO2 emission table as per-segment CO2 emission records. At this time, if a per-segment CO2 emission record with a matching primary key already exists in the per-segment CO2 emission table, the segment extraction unit 201 updates the existing per-segment CO2 emission record; otherwise, it inserts the per-segment CO2 emission record into the per-segment CO2 emission table.

[0118] (3-2-4) The segment extraction unit 201 sets the temporary segment end date and time to the temporary segment start date and time.

[0119] The segment extraction unit 201 increases or decreases the temporary segment product quantity according to whether the owner ID matches the transfer source ID of the owner transfer history record (step S223). That is, when the owner ID matches the transfer source ID, the segment extraction unit 201 subtracts the product quantity of the owner transfer history record from the temporary segment product quantity. On the other hand, when the owner ID does not match the transfer source ID (that is, when the owner ID matches the transfer destination ID of the owner transfer history record), the segment extraction unit 201 adds the product quantity of the owner transfer history record to the temporary segment product quantity.

[0120] After the above step S223 is executed, if there is a next owner transfer history record regarding the owner ID, it returns to the above step S221, and the repeated processing of steps S221 to S222 is executed for the next owner transfer history record. On the other hand, if there is no next owner transfer history record regarding the owner ID, step S214 is executed.

[0121] The segment extraction unit 201 sets values for the provisional segment start date / time and the provisional segment end date / time, and determines the final segment in the current segment extraction process (step S214). Specifically, the segment extraction unit 201 executes the following (4-1) to (4-3).

[0122] (4-1) The segment extraction unit 201 sets the provisional segment start date / time and the provisional segment end date / time as follows.

[0123] Provisional segment start date / time: Set the current provisional segment end date / time.

[0124] Provisional segment end date / time: Set a date / time after the current provisional segment end date / time, for example, the system date / time at the time of execution of the current segment extraction process.

[0125] (4-2) The segment extraction unit 201 determines the final segment of the relevant possessor ID in the current segment extraction process using the current provisional segment start date / time, the provisional segment end date / time, and the total quantity of provisional segment products. That is, the segment extraction unit 201 determines the final segment (possessor ID, segment start date / time, segment end date / time, total quantity of segment products) of the relevant possessor ID in the current segment extraction process with the current provisional segment start date / time as the segment start date / time, the current provisional segment end date / time as the segment end date / time, and the current total quantity of provisional segment products as the total quantity of segment products.

[0126] (4-3) The segment extraction unit 201 stores the information of the final segment determined in (4-2) above in the per-segment CO2 emission quantity table as a per-segment CO2 emission quantity record. That is, the segment extraction unit 201 stores the information of the final segment (possessor ID, segment start date / time, segment end date / time, and total quantity of segment products) determined in (4-2) above in the per-segment CO2 emission quantity table as a per-segment CO2 emission quantity record.

[0127] If the next occupant ID exists in the list obtained in step S201 above, the process returns to step S211, and the repetitive process of steps S211 to S214 is executed for the next occupant ID. On the other hand, if the next occupant ID does not exist in the list obtained in step S201 above, the segment extraction process ends.

[0128] In the above segment extraction process, the transfer date and time of the occupant transfer history record is set as the segment start date and time. However, for example, the transfer date and time of the occupant transfer history record immediately following the occupant transfer history record may be set as the segment start date and time, or the date and time between the transfer date and time of the occupant transfer history record and the transfer date and time of the occupant transfer history record related to the occupant transfer history record may be set as the segment start date and time. Also, at this time, the date and time set as the segment end date and time may be appropriately changed according to the segment start date and time, or a part of the segment extraction process may be appropriately changed.

[0129] <Example of Occupancy Period Extraction Process in Embodiment 1> The example of the occupancy period extraction process in step S102 of FIG. 9 will be described with reference to FIG. 11.

[0130] The occupancy period extraction unit 202 obtains a list without duplication of product individual IDs from the occupant transfer history records stored in the occupant transfer history table (step S301).

[0131] Next, the occupancy period extraction unit 202 repeats steps S311 to S313 and step S314 or step S315 for each product individual ID included in the list obtained in step S301 above (step S302). Hereinafter, steps S311 to S313 and step S314 or step S315 for a certain product individual ID will be described.

[0132] The occupancy period extraction unit 202 acquires the occupant transfer history records including the individual product ID in the order of transfer date and time (step S311). However, at this time, the occupancy period extraction unit 202 acquires the occupant transfer history records including the transfer date and time after the maximum value of the occupancy period start date and time of the product unit CO2 emission amount records per occupancy period stored in the product unit CO2 emission amount table per occupancy period. When there are no product unit CO2 emission amount records per occupancy period stored in the product unit CO2 emission amount table per occupancy period, the occupancy period extraction unit 202 acquires all the occupant transfer history records including the individual product ID in the order of transfer date and time.

[0133] The occupancy period extraction unit 202 sets initial values for the temporary occupancy period start date and time and the temporary occupant ID (step S312). The occupancy period extraction unit 202 sets the initial values as follows for the temporary occupancy period start date and time and the temporary occupant ID, for example. Note that both the temporary occupancy period start date and time and the temporary occupant ID are temporary variables used for occupancy period extraction.

[0134] Temporary occupancy period start date and time: Set the transfer date and time of the occupant transfer history record first acquired in step S311 above.

[0135] Temporary occupant ID: Set the transfer destination ID of the occupant transfer history record first acquired in step S311 above.

[0136] The occupancy period extraction unit 202 determines whether there are two or more occupant transfer history records acquired in step S311 above (step S313).

[0137] When there are not two or more occupant transfer history records acquired in step S311 above (that is, when there is only one occupant transfer history record acquired in step S311 above), the occupancy period extraction unit 202 performs occupancy period determination (step S314). That is, the occupancy period extraction unit 202 executes the following (5-1) to (5-2).

[0138] (5-1) The occupancy period extraction unit 202 determines the occupancy period of the individual product ID using the provisional occupancy start date and time and the provisional occupant ID. That is, the occupancy period extraction unit 202 determines the occupancy period (individual product ID, occupant ID, occupancy start date and time, occupancy end date and time, product quantity) of the individual product ID with the current provisional occupant ID as the occupant ID, the current provisional occupancy start date and time as the occupancy start date and time, and NULL as the occupancy end date and time. However, for the product quantity in the occupancy period, the product quantity included in the occupant transfer history record is set.

[0139] (5-2) The occupancy period extraction unit 202 stores the information on the occupancy period determined in the above (5-1) in the per-occupancy-period per-product unit CO2 emission record table as a per-occupancy-period per-product unit CO2 emission record. That is, the occupancy period extraction unit 202 stores the information on the occupancy period determined in the above (5-1) (individual product ID, occupant ID, occupancy start date and time, occupancy end date and time, and product quantity) in the per-occupancy-period per-product unit CO2 emission record table as a per-occupancy-period per-product unit CO2 emission record. At this time, if a per-occupancy-period per-product unit CO2 emission record with a matching primary key already exists in the per-occupancy-period per-product unit CO2 emission record table, the existing per-occupancy-period per-product unit CO2 emission record is updated; otherwise, the per-occupancy-period per-product unit CO2 emission record is inserted into the per-occupancy-period per-product unit CO2 emission record table.

[0140] However, when the occupant ID included in the occupancy period is an identifier indicating that the product has been originally acquired (produced, manufactured, etc.), or an identifier indicating that the transfer (occupant transfer) of the product or the like has been completed due to sales, disposal, exhaustion, etc., the above (5-2) is not executed. For example, in the example shown in FIG. 1, when the occupant ID is "0x0", the above (5-2) is not executed assuming that the product has been produced, manufactured, etc., or the transfer (occupant transfer) of the product has been completed.

[0141] On the other hand, when there are two or more occupant transfer history records obtained in step S311 described above, the occupancy period extraction unit 202 repeats step S321 in order from the second occupant transfer history record (step S321). Hereinafter, step S321 regarding a certain occupant transfer history record will be described.

[0142] The occupancy period extraction unit 202 determines the occupancy period or sets it as an error according to whether the temporary occupant ID matches the transfer source ID of the occupant transfer history record (step S321). That is, the occupancy period extraction unit 202 executes the following (6-1) or (6-2).

[0143] (6-1) When the temporary occupant ID matches the transfer source ID of the occupant transfer history record In this case, the occupancy period extraction unit 202 executes the following (6-1-1) to (6-1-3).

[0144] (6-1-1) The occupancy period extraction unit 202 determines the occupancy period of the individual product ID using the temporary occupancy period start date and time and the temporary occupant ID. That is, the occupancy period extraction unit 202 sets the current temporary occupant ID as the occupant ID, the current temporary occupancy period start date and time as the occupancy period start date and time, and the transfer date and time of the occupant transfer history record as the occupancy period end date and time, and determines the occupancy period of the individual product ID (individual product ID, occupant ID, occupancy period start date and time, occupancy period end date and time, product quantity). However, the product quantity in the occupancy period is set to the product quantity included in the occupant transfer history record.

[0145] (6-1-2) The occupancy period extraction unit 202 stores the information on the occupancy period determined in the above (6-1-1) in the per-occupancy-period per-product unit CO2 emission amount table as a per-occupancy-period per-product unit CO2 emission amount record. That is, the occupancy period extraction unit 202 stores the information on the occupancy period determined in the above (6-1-1) (product individual ID, occupant ID, occupancy period start date and time, occupancy period end date and time, and product quantity) in the per-occupancy-period per-product unit CO2 emission amount table as a per-occupancy-period per-product unit CO2 emission amount record. At this time, if a per-occupancy-period per-product unit CO2 emission amount record with a matching primary key already exists in the per-occupancy-period per-product unit CO2 emission amount table, the occupancy period extraction unit 202 updates the existing per-occupancy-period per-product unit CO2 emission amount record; otherwise, it inserts the per-occupancy-period per-product unit CO2 emission amount record into the per-occupancy-period per-product unit CO2 emission amount table.

[0146] However, when the occupant ID included in the occupancy period is an identifier indicating that the product has been acquired originally (produced, manufactured, etc.), or when it is an identifier indicating that the transfer (transfer of the occupant) of the product, etc. has been completed due to sale, disposal, exhaustion, etc., the above (6-1-2) is not executed. For example, in the example shown in FIG. 1, when the occupant ID is "0x0", the above (6-1-2) is not executed on the assumption that the product has been produced, manufactured, etc., or the transfer (transfer of the occupant) of the product has been completed.

[0147] (6-1-3) The occupancy period extraction unit 202 sets the provisional occupancy period start date and time and the provisional occupant ID as follows.

[0148] Provisional occupancy period start date and time: Set the transfer date and time of the occupancy transfer history record.

[0149] Provisional occupant ID: Set the transfer destination ID of the occupancy transfer history record.

[0150] (6-2) When the provisional occupant ID does not match the transfer source ID of the occupancy transfer history record In this case, the occupancy period extraction unit 202 outputs an error as an exception and terminates the occupancy period extraction process.

[0151] [Example 2] Hereinafter, Example 2 of the present embodiment will be described. In Example 2, assuming that the environmental information is GPS information, the environmental information management device 10 that executes the above processes (2-1) to (2-3) will be described. However, the fact that the environmental information is GPS information is just an example, and Example 2 described below is similarly applicable to environmental information of point information types other than GPS information (for example, temperature, humidity, etc.).

[0152] [Example of the hardware configuration of the environmental information management device 10 in Example 2]< It may be the same as the environmental information management device 10 in Example 1. Therefore, hereinafter, the hardware configuration of the environmental information management device 10 in Example 2 is assumed to be the same as that in Example 1, and the description thereof will be omitted.

[0153] [Example of the functional configuration of the environmental information management device 10 in Example 2]< An example of the functional configuration of the environmental information management device 10 in Example 2 is shown in FIG. 12. As shown in FIG. 12, the environmental information management device 10 in Example 2 includes a segment extraction unit 201, a GPS information association unit 207 for each segment, and a visualization unit 206. Each of these units is realized, for example, by a process executed by one or more programs installed in the environmental information management device 10 on a processor 108 or the like. Further, the environmental information management device 10 in Example 2 includes an occupant transfer history storage unit 301, a GPS information storage unit 305, and a GPS information storage unit 306 for each segment. Each of these units is realized, for example, by a storage device such as an auxiliary storage device 107.

[0154] The segment extraction unit 201 executes the process of (2-1) above. That is, the segment extraction unit 201 extracts segments for each occupant based on the transfer date and time of the occupant transfer history records stored in the occupant transfer history table. However, since it is not necessary to allocate environmental information by the total amount of products in the point information type, the process for obtaining the information necessary for allocation is not required during segment extraction.

[0155] The GPS information association unit 207 for each segment executes the above process (2-2). That is, for example, the GPS information association unit 207 for each segment acquires the GPS information existing between the segment start date and time and the segment end date and time for each segment, and associates the acquired GPS information with the segment.

[0156] The visualization unit 206 executes the above process (2-3). That is, the visualization unit 206 visualizes the GPS information associated with each segment for each segment.

[0157] The possessor transfer history storage unit 301 stores a possessor transfer history table composed of given possessor transfer history records (for example, possessor transfer history records in the period from T - ΔT to T, where the current date and time is T and a predetermined time width is ΔT). These possessor transfer history records are given, for example, from a logistics traceability system.

[0158] The GPS information storage unit 305 stores time-series GPS information for each possessor (for example, time-series GPS information for each possessor in the period from T - ΔT to T). The time-series GPS information for each possessor is given, for example, from an IoT infrastructure system that manages IoT sensors (such as in-vehicle GPS receivers for trucks, etc.) installed in the space temporarily or non-temporarily dominated and managed by each possessor.

[0159] The per-segment GPS information storage unit 306 stores the segments extracted by the segment extraction unit 201 and the per-segment GPS information, which is information associating segments with GPS information by the per-segment GPS information association unit 207. Hereinafter, the data representing the per-segment GPS information is referred to as a "per-segment GPS information record", and the table-form data composed of per-segment GPS information records is referred to as a "per-segment GPS information table". The per-segment GPS information record represents the time-series GPS information associated with a certain segment of a certain owner. The per-segment GPS information record is represented, for example, in the following data format.

[0160] (Owner ID, Segment start date and time, Segment end date and time, Segment GPS information) Here, the owner ID is an identifier that uniquely identifies the owner. The segment start date and time is the start date and time of the segment. The segment end date and time is the end date and time of the segment. The segment GPS information is the time-series GPS information associated with the segment. Hereinafter, it is assumed that the primary key in the per-segment GPS information table is (owner ID, segment start date and time).

[0161] <Example of the processing flow of the environmental information management device 10 in Embodiment 2> An example of the processing flow of the environmental information management device 10 in Embodiment 2 will be described with reference to FIG. 13. Steps S401 to S403 in FIG. 13 are repeatedly executed, for example, every predetermined time width.

[0162] The segment extraction unit 201 extracts the segments for each owner based on the transfer date and time, etc. of the owner transfer history records stored in the owner transfer history table (step S401). As a result, for example, segments in the data format of (owner ID, segment start date and time, segment end date and time) are extracted. Hereinafter, it is assumed that the segments are extracted as per-segment GPS information records with the segment GPS information not set. The details of the processing of this step will be described later.

[0163] The following step S402 is executed, for example, with respect to the segment newly extracted in step S401 above.

[0164] For each segment, the segment-by-segment GPS information association unit 207 acquires the GPS information existing between the segment start date / time and the segment end date / time, and associates these acquired GPS information with the segment as segment GPS information (step S402). Thereby, a segment-by-segment GPS information record (owner ID, segment start date / time, segment end date / time, segment GPS information) is obtained.

[0165] Then, the visualization unit 206 visualizes (for example, displays on a display or the like) the GPS information associated with each segment for each segment (step S403). Note that the visualization unit 206 may visualize, for example, the GPS information associated with a segment designated by the user, or may visualize the GPS information associated with each segment of the owner designated by the user.

[0166] <Example of segment extraction process in Example 2> In the segment extraction process in step S401 of FIG. 13, the process for obtaining the information necessary for the allocation of environmental information is unnecessary. Specifically, in the segment extraction process in Example 2, the following (a) and (b) are unnecessary, which is different from Example 1.

[0167] (a) "Temporary segment total product quantity" and "Segment total product quantity" (b) The process of step S223 Except for the above (a) and (b), if "Segment-by-segment CO2 emission record" is replaced with "Segment-by-segment GPS information record", "Segment-by-segment CO2 emission table" is replaced with "Segment-by-segment GPS information table", and "CO2 emission" is replaced with "GPS information" respectively, it is the same as Example 1.

[0168] <Summary> As described above, the environmental information management device 10 according to the present embodiment introduces an interval called a segment delimited by a change in the total amount of products simultaneously occupied by the occupier, and manages environmental information obtained in the product logistics supply chain or values calculated from such environmental information for each of these segments. Thereby, in the environmental information management device 10 according to the present embodiment, it becomes possible to efficiently associate the occupier transfer history and the environmental information in the logistics supply chain. For this reason, regardless of whether the environmental information is of the quantity information type or the point information type, for example, when associating the occupier transfer history and the environmental information for purposes such as analysis and investigation at the time of occurrence of a defect, cost reduction, and business efficiency improvement, it becomes possible to significantly reduce the amount of data. Further, when the environmental information is of the quantity information type, when calculating the environmental information for each product, it becomes possible to calculate more accurate environmental information as compared with simple proportional calculation.

[0169] The present invention is not limited to the above-described specifically disclosed embodiments, and various modifications, changes, combinations with known technologies, etc. are possible without departing from the scope of the claims.

Explanation of Reference Numerals

[0170] 10 Environmental information management device 101 Input device 102 Display device 103 External I / F 103a Recording medium 104 Communication I / F 105 RAM 106 ROM 107 Auxiliary storage device 108 Processor 109 Bus 201 Segment extraction unit 202 Occupancy interval extraction unit 203 CO2 emission amount calculation unit for each segment 204 CO2 emission amount calculation unit per product unit for each segment 205 CO2 emission amount calculation unit per product unit for each occupancy interval 206 Visualization unit GPS Information Association Section for Each 207 Segments Occupant Transfer History Memory Section 301 Accumulated CO2 Emission Memory Section 302 CO2 Emission Memory Section for Each Segment 303 CO2 Emission Memory Section per Commodity Unit for Each Occupied Interval 304 GPS Information Memory Section 305 GPS Information Memory Section for Each Segment 306

Claims

1. A transfer history record of the transfer of possession of an object in a supply chain, realized by an irreplaceable token of a blockchain, the transfer history record of possession consisting of a transfer date and time of the object, transfer source identification information indicating identification information of a transfer source of the object, and transfer destination identification information indicating identification information of a transfer destination of the object, and based on possession transfer data composed of the transfer history record of possession including at least the above, a segment extraction unit that extracts a segment representing a section delimited by a change in the total amount of objects simultaneously possessed by the possessor as a section for associating environmental information of the object; For each segment extracted by the segment extraction unit, an association unit that associates environmental information of the objects simultaneously possessed by the possessor in the segment with the segment; having; The segment extraction unit is as follows: For each transfer destination identification information, after initializing the start date and time and the end date and time of the segment, acquisition of possession transfer history records in which identification information identical to the transfer destination identification information is included as transfer source identification information or transfer destination identification information is performed in chronological order of transfer date, and the end date and time is updated with the transfer date included in the acquired possession transfer history records until a predetermined condition is satisfied, whereby a section from the start date and time to the end date and time is extracted as the segment corresponding to the transfer destination identification information. An interval extraction device.

2. The interval extraction device according to claim 1, further comprising a visualization unit that visualizes the segment and the environmental information associated with the segment.

3. The environmental information is point information measured by a sensor with each point representing the entire space in the supply chain where the object exists; The association unit is as follows: When a time series of the environmental information is given, for each segment extracted by the segment extraction unit, the time series of the environmental information included in the section represented by the segment among the given time series of the environmental information is associated with the segment. The interval extraction device according to claim 1 or 2.

4. Represents the transfer history of the possessor of an object in a supply chain, and is a transfer of possession history record realized by an irreplaceable token of a blockchain. The transfer of possession data is composed of transfer of possession history records that at least include the transfer date and time of the object, transfer source identification information indicating the identification information of the transfer source of the object, and transfer destination identification information indicating the identification information of the transfer destination of the object. As an interval for associating the environmental information of the object, a segment extraction procedure for extracting a segment representing an interval delimited by a change in the total amount of objects simultaneously possessed by the possessor is performed. For each segment extracted by the segment extraction procedure, an association procedure for associating the environmental information of the objects simultaneously possessed by the possessor in the segment with the segment is performed. The computer executes the procedures. The segment extraction procedure is as follows: For each transfer destination identification information, after initializing the start date and time and the end date and time of the segment, possession transfer history records in which the same identification information as the transfer destination identification information is included as transfer source identification information or transfer destination identification information are acquired in chronological order of transfer date and time, and the end date and time are updated with the transfer date and time included in the acquired possession transfer history records until a predetermined condition is satisfied. By doing so, the interval from the start date and time to the end date and time is extracted as the segment corresponding to the transfer destination identification information. This is an interval extraction method. **Claim 5** A program for causing a computer to function as the interval extraction device according to claim 1 or 2.

Images