A rosin refining process raw material traceability management method and system

Abstract

This invention relates to the field of industrial data management technology, specifically to a method and system for tracing the source of raw materials in rosin refining processes. The method includes the following steps: acquiring batch records, flow meter readings, splitting ratios, finished product batch numbers, and finished product output quantities; matching the input batch number with the output batch number; expanding the upstream batch connection relationship and calculating the allocation quantity; locating the raw material batch number; sorting the raw material batch numbers; and generating a set of identifiers representing the source of the finished product. In this invention, by verifying the input batch, output batch, and flow data, and combining the splitting ratio, step-by-step expansion, and path allocation calculations, the multi-level flow, multi-source mixing, and reflux relationships in the rosin refining process can be quantified, forming a continuous chain of association from finished product to raw material. Through batch aggregation, contribution comparison, and sorting identifiers, the actual impact of each source on the finished product can be clearly identified, improving the accuracy of source determination, the efficiency of anomaly tracking, and the reliability of quality analysis.

Description

Technical Field

[0001] This invention relates to the field of industrial data management technology, and in particular to a method and system for tracing and managing the raw materials used in rosin refining processes. Background Technology

[0002] The field of industrial data management technology mainly involves the collection, recording, storage, organization, and application of various types of data in industrial production processes. Its core aspects include recording raw material information, production process parameters, product quality inspection data, and supply chain flow data. By establishing unified data coding rules, batch identification rules, data recording formats, and data associations, it achieves systematic management of material and information flows in production activities. It employs methods such as barcode identification, batch numbering, ledger registration, electronic form entry, and database storage to manage the records of raw material warehousing, production input, and finished product associations. Traditional rosin refining raw material traceability management methods refer to the recording and tracking of the source and flow information of rosin raw materials throughout the entire process from procurement, warehousing, storage, processing, to finished product output. Addressing issues such as unclear raw material sources, mixed batches, and ambiguous processing relationships, traditional methods rely on supplier name registration, origin information recording, warehousing batch number labeling, manual completion of raw material requisition records, production input batch registration, processing procedure records, and finished product batch and raw material batch correspondence registration forms to record and trace the use of raw materials at each process.

[0003] Existing technologies primarily rely on manual registration, form filling, and post-event comparison in actual operation. The focus is on recording which process a batch of raw materials entered and which upstream batches a batch of finished products corresponded to. However, in continuous flow scenarios such as reactor transfers, distillation reflux, tank switching, and batch splitting, the recorded results are closer to static contact relationships, failing to present the true flow direction and quantity transfer process. Consequently, when the same intermediate batch has multiple destinations, only a rough correlation can be maintained, making it impossible to determine the actual proportion of each source in the finished product. Ledgers are created at various stages such as procurement, warehousing, requisition, processing, and discharging, resulting in discrepancies between field definitions and recording times. Manual reconciliation easily leads to issues such as numbering breaks, incomplete quantity connections, and misalignments between batches. If mixed batches, replenishment, or reflux occur within a certain period, subsequent investigations often only narrow down to a broad scope, making it difficult to pinpoint the specific source path. For example, if a batch of finished products corresponds to three batches of upstream materials, and one of these batches undergoes two transshipments, traditional registration methods can only prove that all three batches of materials participated in the processing, but cannot explain the extent of their respective contributions. When quality fluctuations occur, the determination of responsibility tends to remain at the level of needing to review all relevant batches, which not only expands the scope of sampling and isolation but also increases inventory freezes and production rhythm disruptions. Furthermore, when reviewing supplier quality differences, existing records are more suitable for checking whether a certain batch of raw materials was purchased, but are not conducive to assessing the impact of a particular batch of raw materials on the final product. As a result, the basis for procurement optimization is too coarse, anomaly analysis relies on experience-based inferences, and although data is retained, it is difficult to support refined accountability, refined release, and refined process correction. Summary of the Invention

[0004] To achieve the above objectives, the present invention adopts the following technical solution: a method for traceability management of raw materials in rosin refining process, comprising the following steps: S1: Obtain batch records and mass flow meter readings of rosin refining reactor equipment, distillation tower reflux pipeline unit, raw material storage tank feeding unit, match the feed batch number and discharge batch number, verify the readings, generate flow direction and flow volume identification batch connection relationship, and obtain process batch flow record set; S2: Based on the process batch flow record set, read the split ratio records of the rosin refining reactor equipment and the distillation tower reflux pipeline unit, normalize the split ratio and bind the flow volume to obtain the batch ratio flow relationship set; S3: Based on the batch ratio flow relationship set, read the finished product batch number and finished product output quantity of the finished product storage tank metering unit, expand the upstream batch connection relationship, calculate the allocation quantity, locate the raw material batch number of the raw material storage tank feeding unit, record the path allocation quantity, and obtain the finished product traceability path allocation table. S4: Based on the finished product traceability path allocation table, classify the raw material batch numbers, summarize the path allocation quantities, form a contribution record, and obtain the raw material source contribution list; S5: Based on the raw material source contribution list, read the preset contribution threshold, mark records below the contribution threshold, sort the remaining raw material batch numbers in descending order of contribution, associate the sorting results with the finished product batch number, and obtain the finished product source composition identifier set.

[0005] As a further embodiment of the present invention, the process batch flow record set includes flow direction identifier, flow quantity identifier, and time period correspondence; the batch proportion flow relationship set includes split proportion normalization value, proportion quantity binding relationship, and batch allocation weight structure; the finished product traceability path allocation table includes path level identifier, path allocation quantity record, and path association index; the raw material source contribution list includes raw material batch identifier, contribution quantity summary value, and source proportion result; the finished product source composition identifier set includes threshold marking result, contribution sorting sequence, and source composition label.

[0006] As a further aspect of the present invention, reading the preset contribution threshold includes determining the corresponding contribution threshold based on the summary result of the path allocation amount corresponding to the finished product batch number, wherein the contribution threshold is a preset ratio value of the summary result of the path allocation amount.

[0007] As a further aspect of the present invention, the marking of records below the contribution threshold includes recording raw material batch numbers with contribution amounts below the contribution threshold as low contribution records, and the sorting by contribution amount in descending order includes arranging raw material batch numbers not recorded as low contribution records in descending order according to their corresponding contribution amounts and associating them with finished product batch numbers.

[0008] As a further aspect of the present invention, the specific steps of S1 are as follows: S101: Obtain batch feeding records, discharge batch numbers, feed batch numbers, and mass flow meter readings from the rosin refining reactor, distillation tower reflux pipeline unit, and raw material storage tank feeding unit. Sort the equipment timestamps within the same time period and match the feed batch number and discharge batch number according to the time overlap interval to form a time-aligned data sequence and obtain a batch time matching sequence. S102: Based on the batch time matching sequence, call the corresponding mass flow meter reading, perform flow difference calculation on the cumulative value of feed flow and cumulative value of discharge flow in the same paired batch, and use the preset flow error threshold as the judgment criterion to make a consistency judgment. The paired records that meet the judgment conditions are retained and a flow identifier is added to obtain the batch pair that passes the flow verification. S103: Based on the flow verification, extract the correspondence between the input batch number and the output batch number through the batch pair, and mark the flow direction field and the corresponding flow amount field for each pair of batch records. Through the combination of structured fields, a unified record structure set is formed to obtain the process batch flow record set.

[0009] As a further aspect of the present invention, the specific steps of S2 are as follows: S201: Based on the process batch flow record set, read the batch split ratio record in the rosin refining reactor equipment and the distillation tower reflux pipeline unit, collect the ratio data corresponding to the same discharge batch number, and perform grouping processing according to the batch number. Calculate the total ratio of each ratio item and perform normalization processing to form a unified scale ratio sequence, and obtain the batch ratio normalization sequence. S202: According to the batch ratio normalization sequence, call the corresponding flow volume data in the process batch flow record set, perform association mapping on the ratio item and flow volume under the same batch number, and restructure the mapping data to establish a correspondence between the ratio value and the flow volume, forming a set of ratio and flow volume combined data units, and obtain the ratio flow binding unit set. S203: Based on the proportional flow binding unit set, extract the relationship between batch number, proportional value and flow volume field, perform structural integration on the data units, and merge them according to batch number to form a data structure set including the correspondence between proportional parameters and flow volume parameters, and obtain the batch proportional flow relationship set.

[0010] As a further aspect of the present invention, the specific steps of S3 are as follows: S301: Based on the batch ratio flow relationship set, read the finished product batch number and finished product output quantity in the finished product storage tank metering unit, perform retrieval matching on the finished product batch number, call the corresponding batch ratio flow relationship to expand the upstream batch connection relationship, perform hierarchical division and sequence arrangement on the expansion result, form a multi-level batch node and association relationship structure, and obtain the batch connection hierarchical sequence. S302: Based on the batch connection hierarchy sequence, call the corresponding ratio parameter and flow rate parameter of the hierarchy node, perform allocation calculation for each level batch node, establish node association identifier according to the batch number, write the allocation quantity into the corresponding node to form a set of hierarchy nodes with numerical attributes, and obtain the hierarchy allocation quantity node set. S303: Perform batch number matching and allocation quantity update operations step by step according to the hierarchical allocation quantity node set until the raw material batch number in the raw material storage tank feeding unit is located, and perform path-level integration recording on the path node allocation quantity to form a record set including path structure and allocation quantity data, and obtain the finished product traceability path allocation table.

[0011] As a further aspect of the present invention, the specific steps of S4 are as follows: S401: For the finished product traceability path allocation table, classify and organize it according to the raw material batch number, perform retrieval and grouping on the raw material batch number in the path record, and aggregate the path data corresponding to the same number to form a data set structure divided by number, and obtain the raw material batch path aggregation set; S402: Based on the raw material batch path aggregation set, call the path corresponding allocation quantity data, perform summary calculation on the path allocation quantity under the same raw material batch number, and mark the calculation results with number association to form a data structure that corresponds to the raw material number and the allocation quantity value, and obtain the raw material allocation quantity summary table; S403: Extract the correspondence between raw material batch number and allocation quantity value according to the raw material allocation quantity summary table, perform integration processing on the association structure between the number and the allocation quantity, and generate a set of record entries according to the number to form a raw material source corresponding to the allocation quantity record structure, and obtain the raw material source contribution list.

[0012] As a further aspect of the present invention, the specific steps of S5 are as follows: S501: Based on the raw material source contribution list, read the set contribution threshold and perform numerical comparison item by item, determine the contribution amount corresponding to the raw material batch number, mark and separate records that do not meet the threshold conditions, form a data set structure with marked status distinction, and obtain the contribution threshold screening set. S502: Based on the contribution threshold filtering set, call the unmarked raw material batch number and corresponding contribution amount data, perform descending sorting on the records, and establish a mapping relationship between batch number and sorting position to form a data structure set with sequential identifier, and obtain the contribution sorting structure set; S503: Extract the correspondence between raw material batch number and sorting position according to the contribution sorting structure set, and integrate the sorting position correspondence with the finished product batch number by performing association identification. The associated data is structured and organized to form a data set including the correspondence between finished product number and source composition information, and the finished product source composition identifier set is obtained.

[0013] A traceability management system for raw materials in rosin refining processes includes: The feeding and flow acquisition module acquires batch feeding records, discharge batch numbers, infeed batch numbers, and mass flow meter readings from the rosin refining reactor, distillation tower reflux pipeline unit, and raw material storage tank feeding unit. It matches the infeed batch number with the discharge batch number within the same time period and writes the mass flow meter readings into a unified record structure after consistency verification. This forms a batch connection relationship with flow direction and flow volume identifiers, resulting in a process batch flow record set. The batch ratio construction module reads the batch split ratio records in the rosin refining reactor equipment and the distillation tower reflux pipeline unit based on the process batch flow record set, normalizes the split ratio corresponding to the same discharge batch number, and establishes a binding structure between the ratio and the flow relationship in combination with the corresponding flow volume to obtain the batch ratio flow relationship set. The path allocation and traceability module reads the finished product batch number and finished product output quantity in the finished product storage tank metering unit according to the batch ratio flow relationship set, expands the upstream batch connection relationship corresponding to the finished product batch number level by level, calculates the allocation quantity for each layer of batch connection relationship and establishes an association with the corresponding upstream batch number, and continuously executes batch number matching and allocation quantity update operations until the raw material batch number in the raw material storage tank feeding unit is located, and records the allocation quantity formed in the path at the path level to obtain the finished product traceability path allocation table. The source contribution summary module classifies and organizes the raw material batch number according to the finished product traceability path allocation table, summarizes and calculates the path allocation quantity corresponding to the same raw material batch number, and forms the contribution record of the corresponding raw material batch number to obtain the raw material source contribution list. The sorting and identification module reads the set contribution threshold according to the raw material source contribution list and performs numerical comparison item by item. Records below the contribution threshold are marked. The remaining raw material batch numbers are sorted in descending order according to their corresponding contribution amounts. The sorting results are associated with the finished product batch numbers to obtain the finished product source composition identification set.

[0014] Compared with the prior art, the advantages and positive effects of the present invention are as follows: In this invention, by verifying the corresponding data of the feed batch, discharge batch, and flow rate, and combining the calculation of splitting ratio, step-by-step expansion, and path allocation, the multi-level circulation, multi-source mixing, and reflux relationship in the rosin refining process can be quantitatively presented, forming a continuous chain of correlation from finished product to raw material. After the raw material batch summary, contribution comparison, and sorting identification, the actual impact of each source on the finished product can be clearly identified, improving the accuracy of source determination, the efficiency of anomaly tracking, and the reliability of quality analysis. Attached Figure Description

[0015] To more clearly illustrate the technical solutions in the embodiments of the present invention, the accompanying drawings used in the description of the embodiments will be briefly introduced below. Obviously, the accompanying drawings described below are only some embodiments of the present invention. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0016] Figure 1 This is a schematic diagram of the steps of the present invention; Figure 2 This is a detailed schematic diagram of S1 of the present invention; Figure 3 This is a detailed schematic diagram of S2 of the present invention; Figure 4 This is a detailed schematic diagram of S3 of the present invention; Figure 5 This is a detailed schematic diagram of S4 of the present invention; Figure 6 This is a detailed schematic diagram of S5 of the present invention; Figure 7 This is a system module diagram of the present invention. Detailed Implementation

[0017] The technical solution of the present invention will now be described with reference to the accompanying drawings.

[0018] To make the technical problems, technical solutions and advantages of the present invention clearer, a detailed description will be given below in conjunction with the accompanying drawings and specific embodiments.

[0019] Please see Figure 1 This invention provides a method for sourcing and managing raw materials for rosin refining processes, comprising the following steps: S1: Obtain batch feeding records, discharge batch numbers, feed batch numbers, and mass flow meter readings from the rosin refining reactor, distillation tower reflux pipeline unit, and raw material storage tank feeding unit. Match the feed batch numbers and discharge batch numbers within the same time period, and write the mass flow meter readings into a unified record structure after consistency verification. This forms a batch connection relationship with flow direction and flow volume identifiers, resulting in a process batch flow record set. S2: Based on the process batch flow record set, read the batch splitting ratio records in the rosin refining reactor equipment and the distillation tower reflux pipeline unit, normalize the splitting ratio corresponding to the same discharge batch number, and establish a binding structure between the ratio and the flow relationship in combination with the corresponding flow volume to obtain the batch ratio flow relationship set. S3: Based on the batch ratio flow relationship set, read the finished product batch number and finished product output quantity in the finished product storage tank metering unit, expand the upstream batch connection relationship corresponding to the finished product batch number level by level, calculate the allocation quantity for each layer of batch connection relationship and establish an association with the corresponding upstream batch number, continuously execute batch number matching and allocation quantity update operations until the raw material batch number in the raw material storage tank feeding unit is located, and record the allocation quantity formed in the path at the path level to obtain the finished product traceability path allocation table; S4: For the finished product traceability path allocation table, classify and organize according to the raw material batch number, summarize and calculate the path allocation quantity corresponding to the same raw material batch number, and form the contribution record of the corresponding raw material batch number to obtain the raw material source contribution list. S5: Based on the raw material source contribution list, read the set contribution threshold and perform numerical comparison item by item. Mark the records that are below the contribution threshold. Sort the remaining raw material batch numbers in descending order according to their corresponding contribution amounts. Associate the sorting results with the finished product batch numbers to obtain the finished product source identification set.

[0020] The process batch flow record set includes flow direction identifier, flow quantity identifier, and time period correspondence; the batch proportion flow relationship set includes split proportion normalization value, proportion quantity binding relationship, and batch allocation weight structure; the finished product traceability path allocation table includes path level identifier, path allocation quantity record, and path association index; the raw material source contribution list includes raw material batch identifier, contribution quantity summary value, and source proportion result; the finished product source composition identifier set includes threshold marking result, contribution sorting sequence, and source composition label.

[0021] Please see Figure 2 The specific steps of S1 are as follows: S101: Obtain batch feeding records, discharge batch numbers, feed batch numbers, and mass flow meter readings from the rosin refining reactor, distillation tower reflux pipeline unit, and raw material storage tank feeding unit. Sort the equipment timestamps within the same time period and match the feed batch number and discharge batch number according to the time overlap interval to form a time-aligned data sequence and obtain a batch time matching sequence. Four types of fields were extracted from batch records generated within the same production day from the rosin refining reactor, distillation column reflux pipeline, and raw material storage tank: the time of material feeding, raw material batch number, discharge batch number, and instantaneous mass flow meter reading. Before reading, null values ​​were removed; records with missing timestamps were directly excluded. Records with inconsistent batch numbers were standardized to a fixed format: batch number prefix plus date plus serial number. Then, all records were rearranged chronologically, placing the start and end times of material feeding from the raw material storage tank and the reactor feeding start and end times on the same timeline, establishing an initial correspondence for records with an overlap of at least 30 seconds. The same processing was then applied to the reactor discharge time and the distillation column reflux feeding time. During the implementation, one batch of rosin raw material, batch number 24042001, was selected. It entered the reactor between 09:00 and 09:18, with a cumulative input of 1180 kg. The corresponding batch number discharged from the reactor was 24042001A, which entered the reflux line between 09:16 and 09:36. The overlap time between the two records was 120 seconds, meeting the pairing condition. In the example, the rosin maintained a flowable dynamic under heating, with a common softening or melting range of approximately 75℃ to 150℃. The relative density was commonly between 1.03 and 1.09. A value of 1.034, calculated at 120℃, can be used as a reference for subsequent flow rate conversion.

[0022] S102: Based on the batch time matching sequence, call the corresponding mass flow meter reading, perform flow difference calculation on the cumulative value of feed flow and cumulative value of discharge flow in the same paired batch, and use the preset flow error threshold as the judgment criterion to make a consistency judgment. The paired records that meet the judgment conditions are retained and a flow identifier is added to obtain the batch pair that passes the flow verification. Based on the aforementioned time-pairing results, retrieve the continuous reading sequence of the corresponding mass flow meter, and summarize the cumulative infeed and cumulative outfeed amounts for the same paired batch at 1-second sampling intervals. Before accumulation, delete any sudden jumps in readings. The judgment rule is that if the difference between two adjacent seconds exceeds eight times the average of the previous 10 seconds, any exceeding this value is supplemented by the average of the nearest adjacent values. Then, incorporate the zero-flow readings during the pump shutdown phase into the cumulative sequence to avoid shortening the total amount due to discontinuities between segments. The threshold setting is determined through three sets of on-site verification data. The nominal accuracy of mass flow meters is typically ±0.1 percentage points of the reading, and the volumetric flow rate accuracy is typically ±0.22 percentage points. In this embodiment, after merging the additional deviations caused by pipeline stagnation and valve switching, the flow error threshold is set at ±0.5 percentage points. For example, batch 24042001 has a cumulative infeed of 1180 kg and a cumulative outfeed of 1176 kg, with an absolute difference of 4 kg. The converted deviation is approximately 0.34 percentage points, which falls within the threshold. Therefore, this pairing is retained and a flow rate verification pass mark is added. Another batch has an infeed of 1260 kg and an outfeed of 1248 kg, with a deviation of approximately 0.95 percentage points. It is directly rejected and will not be included in subsequent records.

[0023] Table 1 Quality Verification Test Data Table

[0024] As shown in Table 1, the 0.5 percentage point threshold retains records with deviations between 0.31 and 0.34 percentage points, and removes records with deviations between 0.56 and 0.95 percentage points. Subsequently, only the cumulative amount and batch number of the passed items are referenced.

[0025] S103: Based on the flow verification, extract the correspondence between the input batch number and the output batch number through batch pair, and mark the flow direction field and the corresponding flow amount field for each pair of batch records. Through the combination of structured fields, a unified record structure set is formed to obtain the process batch flow record set. For paired records that have passed flow verification, three core data items are extracted: raw material batch number, discharge batch number, and cumulative turnover. The turnover direction is written as a fixed text, uniformly formatted as raw material storage tank to reactor, reactor to distillation column reflux line, and distillation column reflux line to subsequent batches. During processing, the original second-level readings are no longer retained; only the verified batch correspondence and cumulative volume are preserved, generating continuously transferable data entries. In this example, batch 24042001 corresponds to reactor discharge batch 24042001A, with a turnover of the aforementioned passed value of 1176 kg; batch 24042003 corresponds to reactor discharge batch 24042003A, with a turnover of 977 kg. If the same raw material batch is pumped into the same reactor in two separate batches, they are first merged into a single source record according to time sequence, and then written into the source list under the same discharge batch to avoid repeated expansion during subsequent proportional processing. The processed single record can be written as follows: Source batch 24042001, Destination batch 24042001A, direction field is raw material to reactor, and flow rate field is 1176 kg. After this processing, subsequent steps can directly retrieve its upstream source by destination batch, without having to look back at the original collection log.

[0026] Please see Figure 3 The specific steps of S2 are as follows: S201: Based on the process batch flow record set, read the batch split ratio record in the rosin refining reactor equipment and the distillation tower reflux pipeline unit, collect the ratio data corresponding to the same discharge batch number, and perform group processing according to the batch number. Calculate the total ratio of each ratio item and perform normalization processing to form a unified scale ratio sequence and obtain the batch ratio normalization sequence. Continue reading the splitting ratio records corresponding to the same batch of output from the aforementioned flow records. The reading objects are limited to the splitting ledgers generated by the rosin refining reactor and the distillation tower reflux pipeline. Before reading, check the registration time of the ratio record, requiring that the interval with the end time of the output batch does not exceed 20 minutes. Records exceeding this time are discarded as invalid. The ratio values ​​written in the three forms of percentage, fraction, and decimal are uniformly converted to decimal form and then grouped according to the same batch of output. In the example, the output batch 24042001A has three registered values ​​for the finished product direction, reflux direction, and loss correction direction during distillation splitting, which are written as 58, 35, and 7 respectively. First, rewrite them as 0.58, 0.35, and 0.07, and then sum the three values, resulting in 1.00, which does not need to be adjusted again. If another batch is registered as 60, 36, and 6, and the sum is 1.02, then divide each value by 1.02 to obtain 0.5882, 0.3529, and 0.0589. After the proportions are normalized, the results are then bound to the original batch number and saved. This numerical adjustment uses all proportion items within the same batch; retaining only the first two items is not allowed, otherwise the subsequent total allocation will be disconnected from the previous flow.

[0027] S202: According to the batch ratio normalization sequence, call the corresponding flow volume data in the process batch flow record set, perform association mapping on the ratio item and flow volume under the same batch number, and restructure the mapping data to establish a correspondence between the ratio value and the flow volume, forming a set of ratio and flow volume combined data units, and obtain the ratio flow binding unit set. The normalized proportional sequence is used to access the flow rate field from the preceding record. Each proportional item under the same batch number is multiplied by its corresponding flow rate to form a group of proportional and flow rate data. Before multiplication, the order of the proportional items is checked to ensure consistency with the flow direction name. If the flow direction name is missing, it is sorted by registration time and aligned with the pipeline destination order. In the example, the total flow rate of batch 24042001A is 1176 kg. After normalization, the three proportional items are 0.58, 0.35, and 0.07, respectively. The finished product direction should be 682.08 kg. After direct proportional allocation, the results are 682.08 kg, 411.60 kg, and 82.32 kg. The total flow rate of batch 24042003A is 977 kg. If the corresponding proportional items are 0.62, 0.30, and 0.08, the results after allocation are 605.74 kg, 293.10 kg, and 78.16 kg. The resulting data units are written with four items: batch number, flow name, proportion value, and corresponding flow volume. If the same batch is subsequently split a second time, the original data is not rewritten. Instead, new proportion flow data is attached to the new destination batch, thus ensuring that each level of record can be traced back to the actual flow volume of the previous level.

[0028] S203: Based on the proportional flow binding unit set, extract the relationship between batch number, proportional value and flow volume field, perform structural integration on the data unit, and merge according to batch number to form a data structure set including the correspondence between proportional parameter and flow volume parameter, and obtain the batch proportional flow relationship set; The proportional values ​​and corresponding turnover volumes are reorganized into expandable related records. When writing, the batch number is used as the primary index, and the proportional value and turnover volume are used as parallel fields, merging sequentially according to the destination relationship. In this example, batch 24042001A is organized into three expandable records: the first is written as destination finished product batch 24042001P, proportional 0.58, corresponding quantity 682.08 kg; the second is written as destination return batch 24042001R, proportional 0.35, corresponding quantity 411.60 kg; and the third is written as loss correction item 0.07, corresponding quantity 82.32 kg. The loss correction item is not further expanded but is retained in the same batch relationship set to avoid missing items when verifying the total quantity later. If two duplicate source records appear in the same destination batch after merging, they are summarized again by destination batch plus source batch. For example, if the two records are 120 kg and 35 kg respectively, they are merged and written as 155 kg. After the process is completed, each record in the batch ratio flow relationship set retains four items: upstream batch, downstream batch, ratio value, and corresponding quantity. When expanding the connection later, the source chain can be directly traced back through the downstream batch.

[0029] Please see Figure 4 The specific steps of S3 are as follows: S301: Based on the batch ratio flow relationship set, read the finished product batch number and finished product output quantity in the finished product storage tank metering unit, perform retrieval matching on the finished product batch number, call the corresponding batch ratio flow relationship to expand the upstream batch connection relationship, perform hierarchical division and sequence arrangement on the expansion result, form a multi-level batch node and association relationship structure, and obtain the batch connection hierarchical sequence. The finished product storage tank metering data is retrieved from the batch ratio flow relationship. First, the corresponding finished product output is retrieved by the finished product batch number. Then, the connection relationship is expanded upstream level by level, starting from the aforementioned finished product batch. Before expansion, it is checked whether the finished product storage tank metering time period is consistent with the drum or canning time period, with a deviation allowed of 10 minutes; those exceeding this are not included in this path. In the example, the output of finished product batch 24042001P in the finished product storage tank metering ledger is 680 kg, which is only 2.08 kg different from the 682.08 kg allocated to the aforementioned batch 24042001A, with a difference of approximately 0.31 percentage points. The expansion continues using this batch relationship. The expansion order is arranged in four levels: finished product batch, distillation tower diversion batch, reactor discharge batch, and raw material feeding batch. Within the same level, they are further sorted by time sequence. If a finished product batch corresponds to two upstream diversion records, the two records are first linked side by side to the second level, and then each is connected to its respective upstream source. In the processed sequence, each node is written with a level number, current batch number, upstream batch number, and associated quantity field, which can be directly read in the next step of layer-by-layer calculation.

[0030] S302: Based on the batch connection hierarchical sequence, call the corresponding proportional parameters and flow parameters of the hierarchical nodes, perform allocation calculation for each level batch node, establish node association identifier according to the batch number, write the allocation quantity into the corresponding node to form a set of hierarchical nodes with numerical attributes, and obtain the hierarchical allocation quantity node set. The proportional values ​​and corresponding flow rates are called layer by layer in the hierarchical sequence, and the allocation amount for each node is written. The starting point is the actual output of the finished product tank, and the theoretical flow rate is no longer directly taken; then, the calculation is pushed back upwards according to the proportion of the node in the previous level. In the example, the actual output of finished product batch 24042001P is 680 kg, and the proportion of the previous level reactor discharge batch 24042001A in the finished product direction is 0.58. Therefore, the associated allocation amount of batch 24042001A is 680 kg. Then, the total flow rate of 24042001A, which was input from raw material batch 24042001 and verified, is 1176 kg. Since there is only one raw material batch corresponding to the discharge batch in the current example, all 680 kg in this layer are still linked to raw material batch 24042001. If, in another example, there are two raw material batches that account for 0.72 and 0.28 of the output batch 24042005A respectively, and 500 kg of finished product have already been allocated, then when pushing upwards, 360 kg and 140 kg will be obtained respectively. When writing to a node, the node association identifier is registered synchronously. The syntax is to take the current batch number plus the level number to avoid confusion of the same batch in different finished product paths.

[0031] S303: Based on the hierarchical allocation node set, perform batch number matching and allocation update operations level by level until the raw material batch number in the raw material storage tank feeding unit is located, and perform path-level integration recording on the path node allocation to form a record set including path structure and allocation data, and obtain the finished product traceability path allocation table. The process involves sequentially matching batch numbers upwards along the hierarchical nodes with allocated quantities. When a batch from the raw material storage tank is matched, the upward matching stops, and all traversed nodes are written as a single path record. Path records are stored using sequential fields and are not broken down into independent segments. In this example, the complete path corresponding to finished product batch 24042001P can be written as: finished product batch 24042001P, distilled and split into batch 24042001A, traced back to raw material batch 24042001, with a path allocation of 680 kg. If another path originates from finished product batch 24042005P, distilled and split into batch 24042005A, and then mixed in the reactor with batch 24042005M, with upstream sources of raw material batches 24041911 and 24041912 respectively, the corresponding allocation quantities are written as two independent paths of 360 kg and 140 kg. During the data processing, the total distribution quantities along the same batch of finished products must be consistent with the metering output of the finished product storage tanks. The allowable error remains ±0.5 percentage points. If this error exceeds the allowable margin, previous proportional registration or flow verification records must be reviewed. The resulting table entries should simultaneously express the path structure and the actual distribution quantities received by that path.

[0032] Please see Figure 5 The specific steps of S4 are as follows: S401: For the finished product traceability path allocation table, classify and organize according to the raw material batch number, perform retrieval and grouping on the raw material batch number in the path record, and aggregate the path data corresponding to the same number to form a data set structure divided by number, and obtain the raw material batch path aggregation set; The finished product traceability path records are reclassified according to the raw material batch number, and records of the same raw material batch in different finished product paths are grouped into the same group. Before grouping, the raw material batch number is checked for duplicate or supplementary codes. If records with the same date and number but different source warehouses are found, the warehouse number is added before grouping. In the example, raw material batch 24042001 appears in two paths, finished product batch 24042001P and finished product batch 24042006P. The former has an allocation of 680 kg, and the latter has an allocation of 120 kg. Therefore, the two paths are merged into the same raw material number group for storage. Raw material batch 24041911 corresponds to only one path and is kept in a separate group. All path fields are retained in the group, and no direct summation or overwriting is performed to avoid the need to check the distribution of this raw material in each finished product later. After sorting, each number group contains at least four items: raw material batch number, finished product batch number, complete upstream to downstream path string, and path allocation quantity. When summarizing later, all path allocation quantities in the group can be read directly.

[0033] S402: Based on the raw material batch path aggregation set, call the path corresponding allocation quantity data, perform summary calculation on the path allocation quantity under the same raw material batch number, and mark the calculation results with number association to form a data structure that corresponds to the raw material number and the allocation quantity value, and obtain the raw material allocation quantity summary table; On the raw material batch path aggregation results, the allocation quantity of the same path number is summarized. The allocation quantities of all paths under the same raw material batch are added together one by one, and the raw material batch number is appended to the result. In the example, the allocation quantities of raw material batch 24042001 in two paths are 680 kg and 120 kg respectively, and the total is 800 kg; the allocation quantity of raw material batch 24041911 in one path is 360 kg, and the total is still recorded as 360 kg; the total value of raw material batch 24041912 is 140 kg. If the same raw material batch appears in more than three paths, all paths are included in the accumulation; it is not allowed to retain only the first two high-value paths. To avoid statistical omissions, the total amount is accumulated and then compared with the actual amount of raw material fed into the front end. For example, if the amount of raw material batch 24042001 that has passed the previous verification is 1176 kg, and the total amount currently allocated to each finished product is 800 kg, then the remaining 376 kg can still be retrieved in the finished products that have not yet left the warehouse, the batches in process of return, or the loss correction items. However, this step only records the cumulative value of the finished product path that has been formed.

[0034] S403: Extract the correspondence between raw material batch number and allocation quantity value based on the raw material allocation quantity summary table, perform integration processing on the association structure between the number and the allocation quantity, and generate a set of record entries according to the number to form a record structure of allocation quantity corresponding to raw material source, and obtain the raw material source contribution list; The summarized raw material batch numbers and cumulative allocation quantities are organized into source record entries. Each entry retains only one raw material batch and its corresponding cumulative quantity, listed in ascending order of raw material batch number. In this example, records can be generated as follows: raw material batch 24041911, corresponding allocation quantity 360 kg; raw material batch 24041912, corresponding allocation quantity 140 kg; raw material batch 24042001, corresponding allocation quantity 800 kg. If multiple sources need to be viewed for the same finished product, they are not merged into a finished product perspective in this step, but are kept as a separate column for the raw material perspective, providing input for threshold determination and sorting in the next step. To ensure context continuity, the number of finished product batches in which the source raw material has appeared is simultaneously noted in the output of this step. For example, raw material batch 24042001 is associated with 2 finished product batches, and raw material batch 24041911 is associated with 1 finished product batch. After this organization, subsequent filtering can be based on cumulative allocation quantity or by the range of associated finished products to assist in verifying the completeness of the records.

[0035] Please see Figure 6 The specific steps of S5 are as follows: S501: Based on the raw material source contribution list, read the set contribution threshold and perform numerical comparison item by item. Determine the contribution amount corresponding to the raw material batch number. Mark and separate records that do not meet the threshold conditions to form a data set structure with marked status distinction, and obtain the contribution threshold screening set. The contribution threshold is read from the raw material source records and compared one by one. Records with a contribution below the threshold are marked for removal, while those with a contribution above or equal to the threshold are marked for retention. The threshold is not given directly based on experience, but is determined based on the results of checking the finished product proportions of three consecutive production batches. In the example, the raw material contribution threshold is set to 2.0 percentage points of the total finished product batch. Three experimental values ​​were used in the setting process: 1.0, 2.0, and 3.0 percentage points. The corresponding number of valid source entries after verification were 9, 6, and 4, respectively. Among them, 1.0 percentage points introduce too many scattered paths, and 3.0 percentage points will lose the stable small proportion of return sources. Therefore, 2.0 percentage points is used. Table 2 lists the experimental data. Taking the total amount of finished product batch 24042005P as an example of 500 kg, the threshold is converted to 10 kg. Raw material batch 24041911 contributes 360 kg, and raw material batch 24041912 contributes 140 kg. Both are retained. If a raw material batch only contributes 6 kg, it is marked as below the threshold and transferred to the separation record.

[0036] Table 2. Results of Contribution Threshold Test

[0037] Referring to Table 2, the number of retained entries and the number of missing entries corresponding to 2.0 percentage points are in a balanced state, so in the embodiment, it is written as a contribution threshold into the subsequent sorting process.

[0038] S502: Based on the contribution threshold filter set, call the unmarked raw material batch number and corresponding contribution amount data, perform descending sorting on the records, and establish a mapping relationship between batch number and sorting position to form a set of data structures with sequential identifiers, thus obtaining the contribution sorting structure set; For raw material records not marked as low contribution, sort them from largest to smallest contribution and assign a sorting position to each record. If two records have the same contribution before sorting, first compare the quantity of the corresponding finished product batch; the record with the larger quantity of related finished product batches is ranked higher. If they are still the same, then compare the earliest feeding time of the raw material batches; the record with the earlier time is ranked higher. In this example, in the source corresponding to finished product batch 24042005P, raw material batch 24041911 contributes 360 kg, and raw material batch 24041912 contributes 140 kg; therefore, their sorting positions are recorded as 1 and 2, respectively. If another finished product batch has raw material batch 24042001 contributing 800 kg, raw material batch 24042003 contributing 220 kg, and raw material batch 24042004 contributing 16 kg, and the threshold, after conversion by 2.0 percentage points, is 14 kg, then all three records are retained, and their sorting positions are written as 1, 2, and 3. After sorting, the original contribution value is not rewritten; only the order field is added to facilitate the next step of directly attaching the source composition result to the finished product batch number.

[0039] S503: Extract the correspondence between raw material batch number and sorting position based on the contribution ranking structure set, and integrate the sorting position correspondence with the finished product batch number by performing association identification. The associated data is structured and organized to form a data set including the correspondence between finished product number and source composition information, and the finished product source composition identification set is obtained. The sorting position is bound to the finished product batch number and organized into a finished product source composition record. Each record must specify at least four items: finished product batch number, raw material batch number, contribution amount, and sorting position, and output them together according to the same finished product batch. In the example, the source composition of finished product batch 24042005P can be organized as follows: sorting position 1 corresponds to raw material batch 24041911, with a contribution amount of 360 kg; sorting position 2 corresponds to raw material batch 24041912, with a contribution amount of 140 kg. If finished product batch 24042001P is traced only to raw material batch 24042001 and has a contribution amount of 680 kg, it is written as sorting position 1. If there are low contribution sources in the same finished product batch that are filtered out by a threshold, they are written into a separate low contribution separation record and are not included in this composition identifier set. At this point, the preceding flow verification result of 1176 kg, the proportional flow result of 682.08 kg, the actual output of finished product of 680 kg, and the source contribution of 680 kg are linked together in the same traceability chain to form a set of identifiers for the source of finished products that can be directly verified.

[0040] Please see Figure 7 A rosin refining process raw material traceability management system, comprising: The feeding and flow acquisition module acquires batch feeding records, discharge batch numbers, infeed batch numbers, and mass flow meter readings from the rosin refining reactor, distillation tower reflux pipeline unit, and raw material storage tank feeding unit. It matches the infeed batch number with the discharge batch number within the same time period and writes the mass flow meter readings into a unified record structure after consistency verification. This forms a batch connection relationship with flow direction and flow volume identifiers, resulting in a process batch flow record set. The batch ratio construction module is based on the process batch flow record set. It reads the batch split ratio records in the rosin refining reactor equipment and the distillation tower reflux pipeline unit, normalizes the split ratio corresponding to the same discharge batch number, and establishes a binding structure between the ratio and the flow relationship in combination with the corresponding flow volume to obtain the batch ratio flow relationship set. The path allocation and traceability module reads the finished product batch number and finished product output quantity from the finished product storage tank metering unit based on the batch ratio flow relationship set. It expands the upstream batch connection relationship corresponding to the finished product batch number level by level, calculates the allocation quantity for each level of batch connection relationship and establishes an association with the corresponding upstream batch number. It continuously executes batch number matching and allocation quantity update operations until it locates the raw material batch number in the raw material storage tank feeding unit, and records the allocation quantity formed in the path at the path level to obtain the finished product traceability path allocation table. The source contribution summary module categorizes and organizes the raw material batch number according to the finished product traceability path allocation table, summarizes and calculates the path allocation quantity corresponding to the same raw material batch number, and forms the contribution record of the corresponding raw material batch number, thus obtaining the raw material source contribution list. The sorting and identification module reads the set contribution threshold from the raw material source contribution list and performs numerical comparisons item by item. Records below the contribution threshold are marked. The remaining raw material batch numbers are sorted in descending order according to their corresponding contribution amounts. The sorting results are then associated with the finished product batch numbers to obtain the finished product source composition identification set.

[0041] The above description is merely a specific embodiment of the present invention, but the scope of protection of the present invention is not limited thereto. Any variations or substitutions that can be easily conceived by those skilled in the art within the technical scope disclosed in the present invention should be included within the scope of protection of the present invention. Therefore, the scope of protection of the present invention should be determined by the scope of the claims.

Claims

1. A method for traceability management of raw materials in rosin refining process, characterized in that, Includes the following steps: S1: Obtain batch records and mass flow meter readings of rosin refining reactor equipment, distillation tower reflux pipeline unit, raw material storage tank feeding unit, match the feed batch number and discharge batch number, verify the readings, generate flow direction and flow volume identification batch connection relationship, and obtain process batch flow record set; S2: Based on the process batch flow record set, read the split ratio records of the rosin refining reactor equipment and the distillation tower reflux pipeline unit, normalize the split ratio and bind the flow volume to obtain the batch ratio flow relationship set; S3: Based on the batch ratio flow relationship set, read the finished product batch number and finished product output quantity of the finished product storage tank metering unit, expand the upstream batch connection relationship, calculate the allocation quantity, locate the raw material batch number of the raw material storage tank feeding unit, record the path allocation quantity, and obtain the finished product traceability path allocation table. S4: Based on the finished product traceability path allocation table, classify the raw material batch numbers, summarize the path allocation quantities, form contribution records, and obtain the raw material source contribution list; S5: Based on the raw material source contribution list, read the preset contribution threshold, mark records below the contribution threshold, sort the remaining raw material batch numbers in descending order of contribution, associate the sorting results with the finished product batch number, and obtain the finished product source composition identifier set.

2. The method for traceability management of raw materials in the rosin refining process according to claim 1, characterized in that, The process batch flow record set includes flow direction identifier, flow quantity identifier, and time period correspondence; the batch ratio flow relationship set includes split ratio normalization value, ratio quantity binding relationship, and batch allocation weight structure. The finished product traceability path allocation table includes path level identifiers, path allocation quantity records, and path association indexes; the raw material source contribution list includes raw material batch identifiers, contribution quantity summary values, and source proportion results; the finished product source composition identifier set includes threshold marking results, contribution sorting sequences, and source composition labels.

3. The method for traceability management of raw materials in the rosin refining process according to claim 1, characterized in that: The process of reading the preset contribution threshold includes determining the corresponding contribution threshold based on the summary result of the path allocation amount corresponding to the finished product batch number. The contribution threshold is a preset ratio value of the summary result of the path allocation amount.

4. The method for traceability management of raw materials in the rosin refining process according to claim 1, characterized in that: The marking of records below the contribution threshold includes recording raw material batch numbers with contribution amounts below the contribution threshold as low contribution records, and the sorting by contribution amount in descending order includes arranging raw material batch numbers not recorded as low contribution records in descending order of their corresponding contribution amounts and associating them with finished product batch numbers.

5. The method for traceability management of raw materials in the rosin refining process according to claim 1, characterized in that, The specific steps of S1 are as follows: S101: Obtain batch feeding records, discharge batch numbers, feed batch numbers, and mass flow meter readings from the rosin refining reactor, distillation tower reflux pipeline unit, and raw material storage tank feeding unit. Sort the equipment timestamps within the same time period and match the feed batch number with the discharge batch number according to the time overlap interval to form a time-aligned data sequence and obtain a batch time matching sequence. S102: Based on the batch time matching sequence, call the corresponding mass flow meter reading, perform flow difference calculation on the cumulative value of feed flow and cumulative value of discharge flow in the same paired batch, and use the preset flow error threshold as the judgment criterion to make a consistency judgment. The paired records that meet the judgment conditions are retained and a flow identifier is added to obtain the batch pair that passes the flow verification. S103: Based on the flow verification, extract the correspondence between the input batch number and the output batch number through the batch pair, and mark the flow direction field and the corresponding flow amount field for each pair of batch records. Through the combination of structured fields, a unified record structure set is formed to obtain the process batch flow record set.

6. The method for traceability management of raw materials in the rosin refining process according to claim 1, characterized in that, The specific steps of S2 are as follows: S201: Based on the process batch flow record set, read the batch split ratio record in the rosin refining reactor equipment and the distillation tower reflux pipeline unit, collect the ratio data corresponding to the same discharge batch number, and perform grouping processing according to the batch number. Calculate the total ratio of each ratio item and perform normalization processing to form a unified scale ratio sequence, and obtain the batch ratio normalization sequence. S202: According to the batch ratio normalization sequence, call the corresponding flow volume data in the process batch flow record set, perform association mapping on the ratio item and flow volume under the same batch number, and restructure the mapping data to establish a correspondence between the ratio value and the flow volume, forming a set of ratio and flow volume combined data units, and obtain the ratio flow binding unit set. S203: Based on the proportional flow binding unit set, extract the relationship between batch number, proportional value and flow volume field, perform structural integration on the data units, and merge them according to batch number to form a data structure set including the correspondence between proportional parameters and flow volume parameters, and obtain the batch proportional flow relationship set.

7. The method for traceability management of raw materials in the rosin refining process according to claim 1, characterized in that, The specific steps for S3 are as follows: S301: Based on the batch ratio flow relationship set, read the finished product batch number and finished product output quantity in the finished product storage tank metering unit, perform retrieval matching on the finished product batch number, call the corresponding batch ratio flow relationship to expand the upstream batch connection relationship, perform hierarchical division and sequence arrangement on the expansion result, form a multi-level batch node and association relationship structure, and obtain the batch connection hierarchical sequence. S302: Based on the batch connection hierarchy sequence, call the corresponding ratio parameter and flow rate parameter of the hierarchy node, perform allocation calculation for each level batch node, establish node association identifier according to the batch number, write the allocation quantity into the corresponding node to form a set of hierarchy nodes with numerical attributes, and obtain the hierarchy allocation quantity node set. S303: Perform batch number matching and allocation quantity update operations step by step according to the hierarchical allocation quantity node set until the raw material batch number in the raw material storage tank feeding unit is located, and perform path-level integration recording on the path node allocation quantity to form a record set including path structure and allocation quantity data, and obtain the finished product traceability path allocation table.

8. The method for traceability management of raw materials in the rosin refining process according to claim 1, characterized in that, The specific steps of S4 are as follows: S401: For the finished product traceability path allocation table, classify and organize it according to the raw material batch number, perform retrieval and grouping on the raw material batch number in the path record, and aggregate the path data corresponding to the same number to form a data set structure divided by number, and obtain the raw material batch path aggregation set; S402: Based on the raw material batch path aggregation set, call the path corresponding allocation quantity data, perform summary calculation on the path allocation quantity under the same raw material batch number, and mark the calculation results with number association to form a data structure that corresponds to the raw material number and the allocation quantity value, and obtain the raw material allocation quantity summary table; S403: Extract the correspondence between raw material batch number and allocation quantity value according to the raw material allocation quantity summary table, perform integration processing on the association structure between the number and the allocation quantity, and generate a set of record entries according to the number to form a raw material source corresponding to the allocation quantity record structure, and obtain the raw material source contribution list.

9. The method for traceability management of raw materials in the rosin refining process according to claim 1, characterized in that, The specific steps of S5 are as follows: S501: Based on the raw material source contribution list, read the set contribution threshold and perform numerical comparison item by item, determine the contribution amount corresponding to the raw material batch number, mark and separate records that do not meet the threshold conditions, form a data set structure with marked status distinction, and obtain the contribution threshold screening set. S502: Based on the contribution threshold filtering set, call the unmarked raw material batch number and corresponding contribution amount data, perform descending sorting on the records, and establish a mapping relationship between batch number and sorting position to form a data structure set with sequential identifier, and obtain the contribution sorting structure set; S503: Extract the correspondence between raw material batch number and sorting position according to the contribution sorting structure set, and integrate the sorting position correspondence with the finished product batch number by performing association identification. The associated data is structured and organized to form a data set including the correspondence between finished product number and source composition information, and the finished product source composition identifier set is obtained.

10. A traceability management system for raw materials in rosin refining process, characterized in that, The system is used to implement the rosin refining process raw material traceability management method according to any one of claims 1-9, the system comprising: The feeding and flow acquisition module acquires batch feeding records, discharge batch numbers, infeed batch numbers, and mass flow meter readings from the rosin refining reactor, distillation tower reflux pipeline unit, and raw material storage tank feeding unit. It matches the infeed batch number with the discharge batch number within the same time period and performs consistency verification on the mass flow meter readings before writing them into a unified record structure. This forms a batch connection relationship with flow direction and flow volume identifiers, resulting in a process batch flow record set. The batch ratio construction module reads the batch split ratio records in the rosin refining reactor equipment and the distillation tower reflux pipeline unit based on the process batch flow record set, normalizes the split ratio corresponding to the same discharge batch number, and establishes a binding structure between the ratio and the flow relationship in combination with the corresponding flow volume to obtain the batch ratio flow relationship set. The path allocation and traceability module reads the finished product batch number and finished product output quantity in the finished product storage tank metering unit according to the batch ratio flow relationship set, expands the upstream batch connection relationship corresponding to the finished product batch number level by level, calculates the allocation quantity for each layer of batch connection relationship and establishes an association with the corresponding upstream batch number, and continuously executes batch number matching and allocation quantity update operations until the raw material batch number in the raw material storage tank feeding unit is located, and records the allocation quantity formed in the path at the path level to obtain the finished product traceability path allocation table. The source contribution summary module classifies and organizes the raw material batch number according to the finished product traceability path allocation table, summarizes and calculates the path allocation quantity corresponding to the same raw material batch number, and forms the contribution record of the corresponding raw material batch number to obtain the raw material source contribution list. The sorting and identification module reads the set contribution threshold according to the raw material source contribution list and performs numerical comparison item by item. Records below the contribution threshold are marked. The remaining raw material batch numbers are sorted in descending order according to their corresponding contribution amounts. The sorting results are associated with the finished product batch numbers to obtain the finished product source composition identification set.

Images