A data collection conversion method and device for a heat treatment apparatus and a medium

Abstract

The application discloses a kind of collection data conversion method, equipment and medium for heat treatment equipment, it is related to industrial data processing technical field, including, original collection data section is matched with equipment point table data, process single data, field mapping record is generated, conversion rule snapshot is formed based on field mapping record, and process section boundary sequence is generated in combination with process step time boundary and state change position;Original collection data section is matched with process section boundary sequence in time intersection, the data section that straddles process section is split, and conversion data section sequence is generated, conversion processing record is generated according to the processing order recorded in conversion rule snapshot, and conversion result record is formed by conversion processing record.The application forms conversion rule snapshot based on field mapping record, and the reproducibility and consistency of data conversion process are guaranteed.

Description

Technical Field

[0001] This invention relates to the field of industrial data processing technology, and in particular to a method, device and medium for data acquisition and conversion for heat treatment equipment. Background Technology

[0002] In industrial heat treatment settings, equipment data acquisition and conversion are fundamental for production process monitoring, quality traceability, and process optimization. Conventional methods typically involve acquiring multi-source sensor data such as temperature, pressure, and flow rate at fixed acquisition cycles, converting the raw values ​​into standard engineering units through pre-defined mapping relationships, and then storing them in a database in chronological order. This approach, relying on stable communication protocols and standardized interfaces, has been widely adopted in industrial settings, supporting basic production data recording and report generation needs, and is characterized by low implementation costs and good system compatibility.

[0003] However, this type of conventional method has two limitations: First, data segmentation often relies on a single time window, making it difficult to accurately capture instantaneous changes during process state switching, resulting in data mixing across process segments; second, the conversion rules are usually statically configured, which cannot dynamically adapt to the differences in process parameters of different heat treatment batches, resulting in insufficient semantic consistency of the data. Summary of the Invention

[0004] In view of the aforementioned existing problems, the present invention is proposed.

[0005] Therefore, the present invention provides a data acquisition and conversion method for heat treatment equipment to solve the problems of cross-process data mixing caused by relying on a single time window and insufficient data semantic consistency caused by using static configuration rules in the prior art.

[0006] To solve the above-mentioned technical problems, the present invention provides the following technical solution: In a first aspect, the present invention provides a data acquisition and conversion method for heat treatment equipment, comprising: acquiring raw acquisition data, equipment list data, and process sheet data for the current heat treatment batch; generating a time range for the heat treatment batch based on the process step time; forming a field data column according to the equipment number, heat treatment batch number, and acquisition field; generating a field-level sampling interruption interval based on the acquisition cycle or adjacent acquisition time interval; and then segmenting the raw acquisition data into segments according to temporal continuity and state change location; matching the raw acquisition data segments with the equipment list data and process sheet data to generate a field mapping record; and forming a data column based on the field mapping record. A snapshot of the conversion rules is generated, and a process segment boundary sequence is generated by combining the time boundaries of the work steps and the location of state changes. The original data segments are matched with the process segment boundary sequences in terms of time intersection. Data segments that cross process segments are split to generate a sequence of converted data segments. Conversion processing records are generated according to the processing order recorded in the conversion rule snapshot, and conversion result records are formed from the conversion processing records. A playback index is generated based on the hierarchical relationship of the conversion result records. A playback task sequence is formed according to the playback request. The conversion result records are processed along the playback task sequence according to the playback type, and the processing results are associated with the conversion record number to generate the data conversion result.

[0007] As a preferred embodiment of the data acquisition and conversion method for heat treatment equipment described in this invention, the step of segmenting and generating original acquired data segments according to temporal continuity and state change positions includes the following steps: extracting the heat treatment batch number, step name, step sequence, step start time, step end time, and step duration from the process sheet data; filtering the data of the current heat treatment batch and merging it to generate a process sheet step data group; and generating the step start time and step end time based on the process sheet step data group, thereby generating the heat treatment batch time range; extracting the equipment number, heat treatment batch number, acquisition field, acquisition time, and acquisition sequence number from the original acquired data; filtering the data of the current heat treatment batch and aggregating it according to the equipment number and acquisition field to generate a field dataset; and then... The segment dataset is arranged according to the acquisition time and acquisition sequence number to generate field data columns. The acquisition period corresponding to the field data column is extracted from the equipment point table data, and the field-level sampling interruption interval is generated according to the acquisition period. The field-level sampling interruption interval is checked against the time range of the heat treatment operation batch. The acquisition sequence number, acquisition time, acquisition original value, equipment status and alarm status of adjacent original acquisition data are extracted from the field data column, and each segmentation position is generated. Then, the segmentation positions are merged according to their order to generate a segmentation position sequence. The field data column is segmented according to the segmentation position sequence. The original acquisition data between each segmentation position is assigned to the original acquisition data segment. Data segment numbers are generated according to the arrangement order, and the start time and end time are generated according to the acquisition time. Then, the data is checked against the time range of the heat treatment operation batch.

[0008] As a preferred embodiment of the data acquisition and conversion method for heat treatment equipment described in this invention, the step of forming a conversion rule snapshot based on field mapping records includes the following steps: According to the arrangement order of the original acquired data segments, data matching the original acquired data segments are selected from the equipment point table data and process sheet data respectively; the selected data is compared with the original acquired data segments in terms of units, and a correspondence is established between them to generate field mapping records; field interpretation rules and unit conversion rules are generated based on the field mapping records; time sequence arrangement rules and exception handling rules are generated based on the original acquired data segments; process segment attribution rules are generated based on the process sheet data; status marking rules are generated based on the original acquired data; and then the field interpretation rules, unit conversion rules, time sequence arrangement rules, exception handling rules, process segment attribution rules, and status marking rules are associated with the field mapping records to generate a conversion rule snapshot.

[0009] As a preferred embodiment of the data acquisition and conversion method for heat treatment equipment described in this invention, the step of generating a process segment boundary sequence by combining the time boundary of the process step and the position of state change includes the following steps: Based on the heat treatment batch number, process name, process sequence, process start time, and process end time in the process sheet process step data group, the start time and end time of the process step are checked sequentially, and the start time, end time, and corresponding unverified state of the same process step are associated to generate the process step time boundary; the original acquired data segments are arranged according to the equipment number, heat treatment batch number, and acquisition field, and adjacent original acquired data segments are compared sequentially. The original data, equipment status, and alarm status corresponding to each segment are collected and their corresponding collection times are associated with adjacent original data segments to generate the status change positions between each original data segment. The time boundaries of each step are arranged according to the step sequence and the status change positions located between the start and end times of the step. The position before the two adjacent positions is taken as the start time of the process segment and the position after the two adjacent positions is taken as the end time of the process segment. At the same time, they are associated with the step name, step sequence, and heat treatment batch number to generate a process segment number. This number is then checked against the time range of the heat treatment batch to form a process segment boundary sequence.

[0010] As a preferred embodiment of the data acquisition and conversion method for heat treatment equipment described in this invention, the steps for generating the converted data segment sequence are as follows: The process segment boundary sequence is read according to the heat treatment batch number, and arranged according to the process step sequence, process segment start time, and process segment number. The common boundary of adjacent process segments is assigned to the next process segment, and the end time of the last process segment is assigned to the last process segment, generating a process segment interval record. The original acquired data segment is compared with the process segment interval record under the same heat treatment batch in terms of time. The later start time is taken as the intersection start position, and the earlier end time is taken as the intersection start position. The intersection end position is used to associate the data segment number, process segment number, process segment boundary position, intersection start position, and intersection end position to generate a process segment intersection record. When an original data segment forms only one process segment intersection record, the original data segment is retained. When two or more process segment intersection records are formed, sub-data segments are generated according to the intersection start position and intersection end position. The data segment number of the original data segment is used as the parent data segment number of the sub-data segments. When no process segment intersection record is formed, the process segment number is set to null, the process segment ownership status is marked as pending verification, and the sequence of converted data segments is arranged.

[0011] As a preferred embodiment of the data acquisition and conversion method for heat treatment equipment described in this invention, the steps for forming a conversion result record from the conversion processing record are as follows: Read the conversion data segments sequentially according to the conversion data segment sequence. When the conversion data segment is an unsplit original acquisition data segment, read the conversion rule snapshot according to the data segment number. When the conversion data segment is a sub-data segment, read the conversion rule snapshot according to the parent data segment number. Read the process segment boundary according to the process segment number. Perform field interpretation processing, unit conversion processing, timing processing, exception handling, and process segment confirmation processing on the conversion data segment sequentially. When the process segment number is not empty, read the process segment boundary according to the process segment number and perform process segment matching. When the process segment number is empty and the process segment ownership status is pending verification... The process segment matching results are marked as pending verification. During the anomaly verification process, the status marking rules are read synchronously to mark the equipment status and alarm status. According to the order of field interpretation processing, unit conversion processing, time sequence processing, anomaly processing, and process segment confirmation processing, the data and verification status generated in each process are associated, and conversion processing records are generated according to the conversion data segment number and processing order. The conversion processing records are collected according to the conversion data segment number. Based on the collected conversion processing records, the collected fields, original values, collection units, collection time, collection sequence number, equipment status, alarm status, and process segment number are associated, and combined with the conversion data segment number, rule snapshot number, and process segment number to generate conversion record number and conversion result record.

[0012] As a preferred embodiment of the data acquisition and conversion method for heat treatment equipment described in this invention, the step of forming a playback task sequence based on playback requests includes the following steps: arranging the conversion result records and sequentially aggregating them according to the conversion data segment sequence, process segment boundary sequence, and heat treatment batch number to obtain corresponding conversion result records; establishing the correspondence between each conversion result record according to the aggregation order to generate a playback index; receiving playback requests and sequentially searching the playback index for conversion result records corresponding to the conversion data segment sequence, process segment boundary sequence, or heat treatment batch number to obtain conversion result records arranged in the playback index order; repeatedly verifying and checking the correspondence between the conversion result records arranged in the playback index order, and generating a playback task sequence according to the verified arrangement order.

[0013] As a preferred embodiment of the data acquisition and conversion method for heat treatment equipment described in this invention, the steps for associating the processing results with the conversion record number to generate data conversion results are as follows: First, read the conversion result records sequentially along the playback task sequence. When the playback type is result playback, arrange the conversion result records according to the order in the playback index, and verify the correspondence between the arranged conversion result records to obtain the conversion result records processed by result playback. Second, when the playback type is recalculation playback, reprocess the conversion result records according to the conversion data segment sequence and process segment boundary sequence, and verify the reprocessed conversion result records item by item with the conversion result records in the playback task sequence, retaining the consistent and inconsistent items. Third, when the playback type is restoration playback, reverse the processing order of the conversion result records. Fourth, when the playback type is process segment playback, heat treatment batch playback, or part batch number playback, collect the conversion result records according to the process segment boundary sequence or heat treatment batch number, and then associate the processing results of each playback type to generate data conversion results.

[0014] In a second aspect, the present invention provides a computer device including a memory and a processor, wherein the memory stores a computer program, wherein when the computer program is executed by the processor, it implements any step of the data acquisition and conversion method for heat treatment equipment as described in the first aspect of the present invention.

[0015] Thirdly, the present invention provides a computer-readable storage medium having a computer program stored thereon, wherein: when the computer program is executed by a processor, it implements any step of the data acquisition and conversion method for heat treatment equipment as described in the first aspect of the present invention.

[0016] The beneficial effects of this invention are as follows: by dividing the original collected data segments according to the continuity of time and the position of state change, the logical confusion of cross-state data is eliminated; by forming a snapshot of conversion rules based on field mapping records, the reproducibility and consistency of the data conversion process are guaranteed. Attached Figure Description

[0017] To more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings used in the following description of the embodiments will be briefly introduced. Obviously, the 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.

[0018] Figure 1 This is a flowchart of a data acquisition and conversion method for heat treatment equipment.

[0019] Figure 2 Generate a flowchart for the transformation rule snapshot.

[0020] Figure 3 Generate a flowchart to record the conversion results.

[0021] Figure 4 Generate a flowchart for the data transformation results.

[0022] Figure 5 A line graph showing the consistency rate of the snapshot conversion rules.

[0023] Figure 6 Heatmap for consistency rate of conversion processing actions. Detailed Implementation

[0024] To make the above-mentioned objects, features and advantages of the present invention more apparent and understandable, the specific embodiments of the present invention will be described in detail below with reference to the accompanying drawings.

[0025] Many specific details are set forth in the following description in order to provide a full understanding of the invention. However, the invention may also be practiced in other ways different from those described herein, and those skilled in the art can make similar extensions without departing from the spirit of the invention. Therefore, the invention is not limited to the specific embodiments disclosed below.

[0026] Secondly, the term "one embodiment" or "embodiment" as used herein refers to a specific feature, structure, or characteristic that may be included in at least one implementation of the present invention. The phrase "in one embodiment" appearing in different places in this specification does not necessarily refer to the same embodiment, nor is it a single or selective embodiment that is mutually exclusive with other embodiments.

[0027] Reference Figures 1-6This is one embodiment of the present invention, which provides a data conversion method for heat treatment equipment, including the following steps: S1. Collect the original acquisition data, equipment list data and process sheet data of the current heat treatment operation batch, generate the time range of the heat treatment operation batch according to the step time, form field data columns according to equipment number, heat treatment operation batch number and acquisition field, generate field-level sampling interruption interval based on acquisition cycle or adjacent acquisition time interval, and then divide the original acquisition data segments according to the time sequence continuity and the position of state change.

[0028] It receives raw data, equipment list data, and process sheet data for the current heat treatment batch and generates the time range for the heat treatment batch. Raw data includes equipment number, heat treatment batch number, acquisition time, acquisition sequence number, acquisition field, original acquisition value, acquisition unit, equipment status, and alarm status. Acquisition fields include heat treatment equipment working area temperature, workpiece temperature, carbon potential, atmosphere value, oil temperature, stirring status, fan status, heat treatment equipment operating door status, quenching medium status, power consumption, and fuel consumption. Equipment list data includes equipment number, acquisition field, field description, original unit, acquisition cycle, and field data type. Process sheet data includes heat treatment batch number, part batch number, material grade, process name, step name, step sequence, step start time, step end time, step duration, target temperature, target holding time, cooling method, and the corresponding recording unit for each acquisition field.

[0029] Process sheet data matching the current heat treatment batch number is selected from the process sheet data. These are then grouped according to the step sequence and step name to generate process sheet step data groups for the current heat treatment batch. Each process sheet step data group contains the heat treatment batch number, step name, step sequence, step start time, step end time, and step duration.

[0030] The time processing is performed on the process order step data groups for the current heat treatment batch. The start time, end time, and duration of each process order step data group are read one by one, and the start and end times of the step are generated based on the time fields carried by the process order step data group itself. If a process order step data group has both a start time and an end time, the start time is used as the start time, and the end time is used as the end time. If a process order step data group has a start time and a duration, but the end time is empty, the start time is used as the start time, and the start and durations are summed to obtain the end time. If a process order step data group has a step end time and a step duration, but a step start time is empty, then the step end time is used as the step termination time for that process order step data group. The difference between the step end time and the step duration is calculated to obtain the step start time for the process order step data group. If a process order step data group only has a step start time, then the step start time is used as the step start time for that process order step data group, and the step termination time is written to the process order step data group as pending verification. If a process order step data group only has a step end time, then the step end time is used as the step termination time for that process order step data group, and the step start time is written to the process order step data group as pending verification. If a process order step data group only has a step duration, or if the step start time, step end time, and step duration are all empty, then the step duration is written to the process order step data group as pending verification.

[0031] The start times of each process step data group are summarized to generate a process step start time summary result; the end times of each process step data group are also summarized to generate a process step end time summary result. If both the process step start time summary result and the process step end time summary result are not empty, the earliest process step start time and the latest process step end time in the process step start time summary result are extracted, and the earliest and latest process step end times are compared. If the earliest process step start time is not later than the latest process step end time, the earliest process step start time is taken as the start time of the current heat treatment batch, and the latest process step end time is taken as the end time of the current heat treatment batch. If the earliest process step start time is later than the latest process step end time, a process sheet time processing status of "heat treatment batch time abnormal and pending verification" is generated. If the summary result of the step start time is empty but the summary result of the step end time is not empty, then the original data collected that matches the current heat treatment batch number is extracted, and sorted from earliest to latest collection time. The collection time of the first original data in the sorted result is taken as the start time of the current heat treatment batch, and the latest step end time in the summary result of the step end time is taken as the end time of the current heat treatment batch. A process sheet time organization status of "step time pending verification" is generated. If the summary result of the step end time is empty but the summary result of the step start time is not empty, then the original data collected that matches the current heat treatment batch number is extracted, and sorted from earliest to latest collection time. The collection time of the last original data in the sorted result is taken as the end time of the current heat treatment batch, and the earliest step start time in the summary result of the step start time is taken as the start time of the current heat treatment batch. A process sheet time organization status of "step time pending verification" is generated. If both the summary results for the start and end times of a process step are empty, extract the original data collected that matches the current heat treatment batch number. Sort the data by collection time from earliest to latest. Use the collection time of the first original data entry after sorting as the start time of the current heat treatment batch, and the collection time of the last original data entry as the end time of the current heat treatment batch. Generate a process sheet time processing status indicating that the process step time is pending verification. Define the time range between the start and end times of the heat treatment batch as the heat treatment batch time range.

[0032] Extract records from the raw data collection that match the batch number of the current heat treatment operation. These records are then grouped according to equipment number and collection field, with records corresponding to the same equipment number, heat treatment batch number, and collection field grouped into the same field dataset. The field dataset is identified by the corresponding equipment number, heat treatment batch number, and collection field.

[0033] Each data collection record in the field dataset retains the collection time, collection sequence number, original collection value, collection unit, device status, and alarm status. The original data collection data in the field data column is arranged from earliest to latest according to the collection time; when multiple original data collection records have the same collection time, they are arranged from smallest to largest according to the collection sequence number, resulting in the field data column.

[0034] Extract device point table data where both the device number and the acquisition field match the field data column, and extract the acquisition period from the device point table data. When the acquisition period in the device point table data is not empty and is greater than zero, use three times the time length corresponding to the acquisition period as the field-level sampling interruption interval corresponding to the field data column.

[0035] It should be noted that the field-level sampling interruption judgment multiple is used to distinguish between normal acquisition fluctuations and continuous sampling interruptions. Based on the acquisition protocol, communication retry method, acquisition frequency, and normal acquisition delay of the heat treatment equipment, a corresponding sampling interruption judgment multiple is selected from two to five, and the selected multiple is pre-written into the equipment point table data. For equipment with a high acquisition frequency and relatively stable communication delay, a smaller sampling interruption judgment multiple is selected; for equipment with protocol retries, network jitter, or a low acquisition frequency, a larger multiple is selected. Value three is the preferred value, capable of accommodating single acquisition delays and situations where two consecutive expected sampling points fail to form records, while avoiding delays in identifying continuous sampling interruptions due to an excessively large multiple.

[0036] When the collection period is null, zero, or a non-time length, the collection time of two adjacent raw data points in the field data column is extracted sequentially. The difference between the collection time of the later raw data point and the collection time of the earlier raw data point is calculated to generate adjacent collection time intervals. Adjacent collection time intervals with the same time length are grouped into the same interval category. The number of adjacent collection time intervals corresponding to each interval category is counted, and the time length of the interval category with the most corresponding intervals is determined as the baseline sampling interval. When there is more than one interval category with the most corresponding intervals, the time length of the interval category with the earliest first occurrence of adjacent collection time intervals in the field data column is selected as the baseline sampling interval. The time length obtained by repeating the baseline sampling interval three times consecutively is used as the field-level sampling interruption interval.

[0037] Write the field-level sampling interruption interval into the corresponding field data column to ensure a one-to-one correspondence between the device number, heat treatment batch number, acquisition field, and field-level sampling interruption interval in the same field data column. Perform a time check between the field-level sampling interruption interval and the heat treatment batch time range. When the field-level sampling interruption interval is greater than zero and less than the heat treatment batch time range, write a valid sampling interruption interval status into the field data column. When the field-level sampling interruption interval is null, zero, or greater than or equal to the heat treatment batch time range, write a pending verification status into the field data column.

[0038] The original data acquisition segments are generated based on the field data columns, field-level sampling interruption intervals, and the time range of heat treatment batches. The field data columns are extracted one by one, and according to the order of the original data acquisition in the field data columns, the acquisition sequence number, acquisition time, equipment status, and alarm status of adjacent two original data acquisitions are extracted sequentially. The acquisition sequence number of the subsequent original data acquisition is checked for continuity with that of the preceding original data acquisition; when a skip number exists between the acquisition sequence numbers of the subsequent and preceding original data acquisitions, the position between the preceding and subsequent original data acquisitions is used as the sequence number splitting position. When the field data column is written with the sampling interruption interval valid status, the difference between the acquisition time of the subsequent and preceding original data acquisitions is calculated to obtain the current adjacent acquisition time interval; when the current adjacent acquisition time interval is greater than the field-level sampling interruption interval, the position between the two original data acquisitions is used as the time splitting position. When the field data column is written with the sampling interruption interval pending verification status, the sampling interruption interval pending verification status is written to the corresponding original data acquisition segment.

[0039] The device status and alarm status of two adjacent raw data sets are compared. When the data field corresponding to the data column is the status of the heat treatment equipment's operating door, stirring status, fan status, or quenching medium status, the original values ​​of two adjacent raw data sets are compared. If the original values ​​of the two raw data sets are different, the position between the two raw data sets is used as the data field status segmentation position. If the device status of two adjacent raw data sets is different, the position between the two raw data sets is used as the device status segmentation position; if the alarm status of two adjacent raw data sets is different, the position between the two raw data sets is used as the alarm status segmentation position. The segmentation positions are arranged according to their order in the data column. Segmentation positions with the same sequence number, time segmentation position, device status segmentation position, and alarm status segmentation position are merged to generate a segmentation position sequence corresponding to the data column.

[0040] The first original data in the field data column is used as the starting point of the first original data segment. The field data column is then segmented sequentially according to the segmentation position sequence. The original data before each segmentation position is used as the ending point of the current original data segment. The original data after each segmentation position is used as the starting point of the next original data segment. The last original data in the field data column is used as the ending point of the last original data segment.

[0041] Data segment numbers are generated according to the order of the original data segments in the field data columns. The acquisition time of the first piece of original data in each segment is extracted as the start time, and the acquisition time of the last piece of original data is extracted as the end time. The acquisition sequence number, original value, acquisition unit, equipment status, and alarm status of each piece of original data within a segment are summarized to generate acquisition sequence number range, acquisition original value set, acquisition unit set, equipment status set, and alarm status set. The data segment number, equipment number, heat treatment batch number, acquisition field, start time, end time, heat treatment batch time range, acquisition sequence number range, acquisition original value set, acquisition unit set, equipment status set, alarm status set, field-level sampling interruption interval, field-level sampling interruption interval, and segmentation position type are written into the corresponding original data segment. When the start time is earlier than the start time of the heat treatment batch or the end time is later than the end time of the heat treatment batch, a "heat treatment batch time out of bounds, pending verification" status is written into the corresponding original data segment.

[0042] S2. Match the original collected data segments with the equipment point table data and process sheet data to generate field mapping records. Based on the field mapping records, form a conversion rule snapshot and combine the process step time boundary and state change location to generate the process segment boundary sequence.

[0043] Following the original data segment arrangement order, extract the data segment number, equipment number, heat treatment batch number, acquisition field, start time, end time, acquisition sequence number range, acquisition unit set, field-level sampling interruption interval, sampling interruption interval, and segmentation position type set one by one. Based on the equipment number and acquisition field, extract the field description, original unit, acquisition cycle, and field data type from the equipment point table data; based on the heat treatment batch number and acquisition field, extract the record unit of the acquisition field from the process sheet data.

[0044] For units that appear repeatedly in the collection unit set, merge them and arrange them according to their first occurrence position in the original collection data segment to generate the actual unit sequence of the data segment. When there is only one type of collection unit in the actual unit sequence of the data segment, the collection unit is used as the original unit of the data segment; when there are multiple types of collection units in the actual unit sequence of the data segment, compare adjacent collection units in the order of the original collection data in the original collection data segment, determine the adjacent position where the collection unit changes as the unit change position, and divide the original collection data segment into unit data intervals according to the unit change position; take the collection unit corresponding to each unit data interval as the interval original unit, and associate the start position, end position, interval original unit and their arrangement order of the unit data interval to generate unit interval records; when the collection unit set is empty, extract the original units in the equipment point table data as the original units of the data segment, and check the names of the original units of the data segment with the original units in the equipment point table data. If they match, retain the original units of the data segment; if they do not match, retain both the original units of the data segment and the original units in the equipment point table data.

[0045] The record units corresponding to the data acquisition fields extracted from the process sheet data are merged, and duplicate data acquisition field record units are retained only once. If only one type of data acquisition field record unit exists after merging, the data acquisition field record unit is used as the target unit; if no data acquisition field record unit exists after merging, the field mapping record is marked as missing target unit pending verification; if multiple data acquisition field record units exist after merging, the process step name, process step order, and data acquisition field record unit are arranged in ascending order to generate a process step target unit sequence.

[0046] Extract the data segment number and acquisition field one by one according to the original data segment arrangement order. Concatenate the data segment number and acquisition field corresponding to the same original data segment in the extraction order to generate a field mapping record number. Establish a correspondence between the field mapping record number and the corresponding data segment number, equipment number, heat treatment batch number, acquisition field, field description, field data type, original unit of data segment, original unit in equipment point table data, target unit, and process step target unit sequence to obtain the field mapping record.

[0047] It should be noted that the field mapping record number is a number used to uniquely identify the field correspondence between the original acquired data segment and the equipment point table data and process sheet data.

[0048] Field interpretation rules are generated based on the collected fields, field descriptions, and field data types. When both the field description and field data type are not empty, a correspondence is established between the collected fields and their corresponding field descriptions and data types, generating field interpretation content. When either the field description or the field data type is empty, the extracted collected fields, field descriptions, and field data types are retained, and a field interpretation pending verification status is generated. The field interpretation content and field interpretation pending verification status are then grouped according to the field mapping record number to obtain the field interpretation rules.

[0049] Unit conversion rules are generated based on the original units of the data segment, the original units and target units in the equipment point table data, and the target unit sequence of the process step. When the original units of the data segment are inconsistent with the original units in the equipment point table data, the generated status is "Inconsistent Original Units". When the original units of the data segment are consistent with the target units, unit conversion content is generated that maintains the original acquired value and the acquired unit unchanged. When the original units of the data segment are inconsistent with the target units, it is verified whether the original units of the data segment come from the current original acquired data segment, and whether the target units come from process sheet data with the same acquisition field as the current original acquired data segment. Based on the verification results, a physical quantity verification result is generated. When both the original units and target units of the data segment establish a correspondence with the same acquisition field and corresponding field description, the physical quantity verification result is determined to be the same physical quantity; otherwise, the physical quantity verification result is determined to be a different physical quantity. When the physical quantity verification results are for the same physical quantity, compare the unit names of the original unit and the target unit in the data segment. The portion that is identical and located at the end of the unit name is considered the common unit. The text or symbols that differ before the common unit are used as the order of magnitude representation, and an order of magnitude identification result is generated. If the order of magnitude representations of the original and target units in the data segment can be identified, the corresponding order of magnitude representation and its multiplier relationship are written into the order of magnitude identification result. If no common unit is formed or the multiplier relationship corresponding to the order of magnitude representation cannot be determined, the order of magnitude identification result is marked as pending verification, and the original data acquisition value and unit remain unchanged. When the physical quantity verification results are for different physical quantities, the unit conversion is marked as pending verification, and the original data acquisition value and unit remain unchanged.

[0050] The conversion rules are determined based on the original and target units of the data segment. When the two units only have a multiple relationship, the original value is converted according to the corresponding multiple to obtain the multiple conversion relationship (for example, if the original unit of the data segment is kilopascal and the target unit is pascal, the multiple value of 1,000 and the conversion direction from kilopascal to pascal are written into the multiple conversion relationship, and the original value is multiplied by 1,000 during unit conversion). When the two units are temperature units with different starting points on the temperature scale, the temperature offset corresponding to the original unit is eliminated first, then the multiple conversion is performed, and finally the offset conversion relationship of the target unit is obtained (for example, if the original unit of the data segment is Fahrenheit and the target unit is Celsius, the temperature offset of 32 corresponding to the original unit, the multiple value of 5 / 9, and the conversion order of eliminating the temperature offset before performing the multiple conversion are written into the offset conversion relationship, and the original value is subtracted by 32 and then multiplied by 5 / 9 during unit conversion). If the conversion rules between the original and target units cannot be determined, the unit conversion is marked as pending verification, and the original value and the acquisition unit remain unchanged.

[0051] When the target unit sequence of a work step is not empty, extract the work step name, work step order, and corresponding record unit of the acquisition field one by one according to the work step order. Verify the original unit of the data segment against the corresponding record unit of the acquisition field for each work step, and generate the unit conversion content for each work step based on the unit conversion relationship between the original unit of the data segment and the corresponding record unit of the acquisition field. Verify the original unit of the data segment against the corresponding record unit of the acquisition field for the current work step; if they match, generate unit conversion content that keeps the original acquisition value and acquisition unit unchanged; if they do not match but a multiple conversion relationship or an offset conversion relationship can be determined, generate the unit conversion content for the current work step according to the corresponding multiple conversion relationship or offset conversion relationship. Collect the original unit of the data segment, target unit, work step target unit sequence, multiple conversion relationship, offset conversion relationship, conversion order, unit conversion content, and the generated verification status according to the field mapping record number to obtain the unit conversion rules.

[0052] Based on the data segment number in the field mapping record, the original acquired data is selected from the raw acquired data where the equipment number, heat treatment batch number, and acquired field are consistent with the field mapping record, and the acquisition time falls between the start and end times of the corresponding raw acquired data segment. The data is then arranged from earliest to latest acquisition time, and if the acquisition times are the same, they are arranged from smallest to largest acquisition sequence number, generating a data segment acquisition record sequence. The acquisition sequence number and acquisition time of two adjacent raw acquired data points in the data segment acquisition record sequence are extracted sequentially. The continuity of the acquisition sequence number of the subsequent raw acquired data point is checked against the acquisition sequence number of the preceding raw acquired data point, and the difference between the acquisition time of the subsequent raw acquired data point and the acquisition time of the preceding raw acquired data point is calculated to obtain the adjacent acquisition time interval. The arrangement order of the raw acquired data, the results of the acquisition sequence number continuity check, the adjacent acquisition time interval, the field-level sampling interruption interval, and the sampling interruption interval are aggregated according to the data segment number to obtain the time sequence arrangement rules.

[0053] Anomaly handling rules are generated based on the data segment acquisition record sequence, the set of segmentation position types, the field-level sampling interruption interval, and the sampling interruption interval. When the acquisition sequence numbers of two adjacent raw acquisition data are not consecutive, the difference between the acquisition sequence numbers of the two raw acquisition data is first calculated to obtain the number and range of missing acquisition sequence numbers. Combining the acquisition time of the two raw acquisition data, the missing positions corresponding to each missing acquisition sequence number are determined according to the relationship of acquisition sequence number changes. The difference between the acquisition sequence numbers of the two raw acquisition data is used as the basis for dividing the time interval. The theoretical time interval corresponding to adjacent acquisition sequence numbers is calculated, and the missing positions corresponding to each missing acquisition sequence number are determined sequentially according to the difference between the missing acquisition sequence number and the acquisition sequence number of the previous raw acquisition data. Subsequently, missing position records are generated one by one, and missing handling content without adding replacement acquisition values ​​is formed for each missing position. When the time interval between adjacent acquisitions is greater than the field-level sampling interruption interval, the acquisition time of the previous raw acquisition data is extracted as the communication interruption start time, and the acquisition time of the next raw acquisition data is extracted as the communication interruption end time, generating a communication interruption record. When there are more than one original data entry with the same equipment number, heat treatment batch number, acquisition field, acquisition time, and acquisition sequence number, the first original data entry appearing in the data segment acquisition record sequence is selected as the original data to be converted. The remaining original data entries are considered duplicate data that are not converted, and the original acquisition value, acquisition unit, equipment status, and alarm status of each duplicate data entry are retained. When there are more than one original data entry with the same equipment number, heat treatment batch number, acquisition field, acquisition time, and acquisition sequence number, the original acquisition value, acquisition unit, equipment status, and alarm status of each original data entry are checked sequentially. Original data entries with non-empty original acquisition values ​​and acquisition units, equipment status that does not indicate sensor abnormality, and alarm status that does not indicate an alarm accompanying the current acquisition record are prioritized as the original data to be converted. When there are more than one original data entry with non-empty original acquisition values ​​and acquisition units, equipment status that does not indicate sensor abnormality, and alarm status that does not indicate an alarm accompanying the current acquisition record, the first original data entry appearing in the data segment acquisition record sequence is selected as the original data to be converted. If there is no original data where both the original value and the acquisition unit are not empty, the device status does not indicate sensor abnormality, and the alarm status does not indicate that the current acquisition record is accompanied by an alarm, then the original data where both the original value and the acquisition unit are not empty will be prioritized for conversion. If there is more than one original data where both the original value and the acquisition unit are not empty, or if the original value or acquisition unit of each original data is empty, then the first original data appearing in the data segment acquisition record sequence will be selected for conversion. The remaining original data will be treated as duplicate data that is not converted, and the original value, acquisition unit, device status, and alarm status of each duplicate data will be retained. If there is a unit conversion pending verification status in the unit conversion rule, the original value will be combined with the corresponding acquisition unit, the reason for pending verification will be marked, and unit abnormality handling content will be generated. When the device status directly indicates a sensor malfunction, the corresponding device status information is first extracted and matched with the associated raw data. The corresponding raw data and the malfunction status identifier are retained to form a device status malfunction record. When the alarm status indicates that the current data acquisition record is accompanied by an alarm, the alarm status information is obtained and associated with the corresponding raw data. The corresponding raw data and the alarm content are retained to form an alarm accompanying record. The unit's malfunction handling content, device status malfunction records, and alarm accompanying records are associated and collected according to the data segment number to generate an malfunction record set. Missing location records, communication interruption records, duplicate data processing results, and the malfunction record set are uniformly collected according to the data segment number to obtain malfunction handling rules.

[0054] Extract the step name, step sequence, step start time, step end time, and process sheet time processing status from the process sheet step data group according to the heat treatment operation batch number. If both the step start time and end time have been generated, establish the correspondence between the step name, step start time, and step end time according to the step sequence to obtain the step time interval; if either the step start time or step end time has not been generated, retain the already generated times and mark the step time as requiring further verification. Group each step time interval, process sheet time processing status, and step time pending verification status according to the heat treatment operation batch number and step sequence to obtain the process segment affiliation rules.

[0055] The system iterates through the data segment acquisition record sequence, sequentially traversing the device status and alarm status. It extracts the device status and acquisition time corresponding to the current raw acquisition data and the previous raw acquisition data. When the device status of two adjacent raw acquisition data is the same, the current device status and corresponding acquisition time are continuously merged to form a device status record. When the device status is different, the device status before the change, the device status after the change, the acquisition time of the previous raw acquisition data, and the acquisition time of the next raw acquisition data are associated to generate a device status change record. The system then extracts the alarm status and acquisition time corresponding to the current raw acquisition data and the previous raw acquisition data. When the alarm status of two adjacent raw acquisition data is the same, the current alarm status and corresponding acquisition time are continuously merged to form an alarm status record. When the alarm status is different, the alarm status before the change, the alarm status after the change, the acquisition time of the previous raw acquisition data, and the acquisition time of the next raw acquisition data are associated to generate an alarm status change record. Finally, the device status record, alarm status record, device status change record, and alarm status change record generated during the traversal process are summarized to obtain the status marker information for the corresponding data segment. The equipment status, alarm status, equipment status change records, and alarm status change records are collected according to the data segment number to obtain the status marking rules.

[0056] The generation time of each rule is used as the snapshot generation time. The field mapping record number, data segment number, and snapshot generation time are concatenated in order to generate a rule snapshot number. The rule snapshot number is then associated with the field mapping record number, data segment number, equipment number, heat treatment batch number, acquired field, field interpretation rule, unit conversion rule, time sequence arrangement rule, anomaly handling rule, process segment affiliation rule, status marking rule, and each status to be verified to obtain the conversion rule snapshot.

[0057] When both the start and end times of a work step have been generated, and the start time is earlier than the end time, the batch number, step name, sequence, start time, and source of start time are summarized into a step start boundary record. Similarly, the batch number, step name, sequence, end time, and source of end time are summarized into a step end boundary record. The start and end boundary records for the same work step are then associated to generate the time boundary for the current step. If either the start or end time of a work step has a pending verification status, a correspondence is established between this status and the already generated start or end boundary records.

[0058] The original data segments were collected according to the equipment number, heat treatment batch number, and acquisition field, and then arranged from earliest to latest according to the start time to obtain a sequence of original data segments ordered by time. Extract two adjacent raw data segments sequentially. When the segmentation location type set corresponding to the latter raw data segment has a segmentation location for the acquisition field status, equipment status, or alarm status, filter the raw data from the raw data that has the same equipment number, heat treatment batch number, and acquisition field as the former raw data segment, and whose acquisition time is between the start and end times of the former raw data segment. Arrange the raw data in ascending order of acquisition time. If the acquisition times are the same, arrange them in ascending order of acquisition sequence number. Extract the last raw data after arrangement to obtain the end acquisition record of the previous segment. Filter the raw data from the raw data that has the same equipment number, heat treatment batch number, and acquisition field as the latter raw data segment, and whose acquisition time is between the start and end times of the latter raw data segment. Arrange the raw data in ascending order of acquisition time. If the acquisition times are the same, arrange them in ascending order of acquisition sequence number. Extract the first raw data after arrangement to obtain the start acquisition record of the subsequent segment. The acquisition time of the initial acquisition record in the latter segment is used as the state boundary time; the acquisition time of the final acquisition record in the former segment is used as the start time of the state change candidate interval; and the acquisition time of the initial acquisition record in the latter segment is used as the end time of the state change candidate interval. The state boundary time represents the sampling time at which the state change is confirmed by the original acquisition data, not the actual time when the state changes. The actual time when the state changes is located within the state change candidate interval. The corresponding state extraction object is determined according to the segmentation location type, where the state value of the acquisition field is the original value in the original acquisition data corresponding to the state of the heat treatment equipment operating door, stirring state, fan state, or quenching medium state. When the segmentation location type is a data acquisition field status segmentation location, the data acquisition field status value in the preceding end data acquisition record is extracted as the pre-change state, and the data acquisition field status value in the following start data acquisition record is extracted as the post-change state. When the segmentation location type is a device status segmentation location, the device status value in the preceding end data acquisition record is extracted as the pre-change state, and the device status value in the following start data acquisition record is extracted as the post-change state. When the segmentation location type is an alarm status segmentation location, the alarm status value in the preceding end data acquisition record is extracted as the pre-change state, and the alarm status value in the following start data acquisition record is extracted as the post-change state. A correspondence is established between the state boundary time, segmentation location type, pre-change state, post-change state, data acquisition field, preceding data segment number, and following data segment number to obtain the state boundary record.

[0059] Extract the start and end boundary records of each step sequentially. Then, filter the state boundary records to ensure their state boundary times are neither earlier than the start time nor earlier than the end time of the current step. If the state boundary time equals the start time of the current step, the corresponding state boundary record is added to the current step. If the state boundary time equals the end time of the current step, the corresponding state boundary record is not added to the current step. If the end time of the current step is the same as the start time of the next step, the corresponding state boundary record is added to the next step. Arrange the start boundary records, filtered state boundary records, and end boundary records of the current step according to their boundary times from earliest to latest. If more than one boundary record corresponds to the same boundary time, merge the start time source, end time source, data acquisition field status segmentation position, device status segmentation position, and alarm status segmentation position corresponding to the same boundary time to generate a boundary source set. Establish a correspondence between the arranged boundary times and the corresponding boundary source set to obtain the boundary time sequence of the current step.

[0060] Extract adjacent boundary times from the boundary time sequence sequentially, taking the preceding boundary time as the process segment start time and the following boundary time as the process segment end time. Concatenate the heat treatment batch number, process step sequence, and time interval arrangement according to the process step sequence and the arrangement order of time intervals within the same process step to generate a process segment number, and use the process step name as the process segment name. Based on the process segment start time and process segment end time, filter the original acquired data segments whose start time is earlier than the process segment end time and whose end time is no earlier than the process segment start time, extract the corresponding data segment numbers, and arrange them according to the start time of the original acquired data segments to generate a corresponding data segment number sequence. Establish a correspondence between the process segment number, process segment name, heat treatment batch number, process step sequence, process segment start time, process segment end time, start boundary source set, end boundary source set, corresponding data segment number sequence, and heat treatment batch time range to obtain the process segment boundary.

[0061] The process segment boundaries for the same heat treatment batch are arranged according to the work step sequence and the start time of each process segment. The start and end times of each process segment, as well as the start and end times of the heat treatment batch, are then checked sequentially. When the time intervals corresponding to adjacent process segments overlap, the boundaries of the adjacent process segments are retained and marked as overlapping processes awaiting verification. When the start time of a process segment is earlier than the start time of the heat treatment batch, or the end time of a process segment is later than the end time of the heat treatment batch, the corresponding process segment boundaries are retained and marked as boundary out of bounds awaiting verification. When the start time of a process segment is equal to or later than the end time of the process segment, the generation of process segment boundaries corresponding to that time interval is stopped, and the process segment is marked as pending verification. The generated process segment boundaries are then arranged according to the work step sequence, process segment start time, and process segment number to obtain the process segment boundary sequence for the current heat treatment batch.

[0062] To verify the effectiveness of the transformation rule snapshot in ensuring the reproducibility and consistency of the historical data transformation process when subsequent rules change, Figure 5 Five transformation rule change percentages were set: 0%, 10%, 20%, 40%, and 60%. Each percentage used 40,000 transformation result records, and statistics were performed using a 95% confidence interval. When reading the transformation rule snapshot, the consistency rate of the complete processing chain corresponding to each transformation rule change percentage was 100%. When the transformation rule change percentage increased to 60%, the consistency rate of the complete processing chain when reading the current rule and when reading only the unit transformation rule decreased to 12.32% and 22.85%, respectively, indicating that the transformation rule snapshot can prevent subsequent rule changes from affecting the original transformation results.

[0063] S3. Perform time intersection matching on the original acquired data segment and the process segment boundary sequence, split the data segment that crosses the process segment, generate the transformed data segment sequence, generate the transformation processing record according to the processing order recorded in the transformation rule snapshot, and form the transformation result record from the transformation processing record.

[0064] Establish the correspondence between the original acquired data segments and the process segment boundaries, and generate a sequence of transformed data segments. Read the process segment boundary sequence according to the heat treatment batch number, and arrange them according to the process step sequence, process segment start time, and process segment number. The position of each process segment boundary in the process segment boundary sequence is taken as the process segment boundary position. Except for the last process segment of the current heat treatment batch, the half-open interval containing the process segment start time but excluding the process segment end time is taken as the time interval of the process segment; the closed interval containing the process segment start time and end time is taken as the time interval of the last process segment of the current heat treatment batch. When adjacent process segments share a boundary, the common boundary is assigned to the next process segment. Establish a correspondence between the process segment number, process segment name, process step sequence, process segment start time, process segment end time, process segment boundary position, and boundary verification status according to the arrangement order, forming a process segment interval record.

[0065] Following the original data acquisition segment arrangement order, the data segment number, equipment number, heat treatment batch number, acquisition field, start time, end time, acquisition sequence range, and original data within the segment are read one by one. The corresponding conversion rule snapshot is then located based on the data segment number. The start and end times of the original data acquisition segment are compared with the start and end times of the records for each process segment interval under the same heat treatment batch. If the start time of the original data acquisition segment is earlier than the process segment end time, and the end time of the original data acquisition segment is not earlier than the process segment start time, the start and end positions of the overlapping portion of the two time intervals are determined, forming a process segment intersection record. The later of the start time of the original data acquisition segment and the start time of the process segment is taken as the intersection start position, and the earlier of the end time of the original data acquisition segment and the end time of the process segment is taken as the intersection end position. Using the data segment number and process segment number as a joint index, the process segment boundary position, intersection start position and intersection end position are written into the corresponding process segment intersection record to generate a mapping relationship between the data segment number and the process segment number, thereby establishing the correspondence between the data segment number, process segment number, process segment boundary position, intersection start position and intersection end position.

[0066] When an original data segment forms only one process segment intersection record, the original data segment number is retained and the corresponding process segment number is written into the transformed data segment. When an original data segment forms two or more process segment intersection records, the process segment intersection records are arranged from earliest to latest according to the intersection start position, and then the original data within the segment is arranged from earliest to latest according to the acquisition time. If the acquisition times are the same, the original data within the segment is arranged in ascending order of acquisition sequence number. For each process segment intersection record, the original data acquired between the current intersection start position and the intersection end position is summarized into the current sub-data segment; when the acquisition time is equal to the common boundary of adjacent process segments, the original data is summarized into the sub-data segment corresponding to the next process segment intersection record; when the current process segment is the last process segment of the heat treatment batch, the original data acquired when the acquisition time is equal to the intersection end position is summarized into the last sub-data segment corresponding to the current process segment intersection record. According to the arrangement order of the sub-data segments in the original data segment, the original data segment number, process segment number, and arrangement sequence number are connected sequentially to form the sub-data segment number, and the original data segment number is used as the parent data segment number. The start time, end time, and acquisition sequence range of the sub-data segment are formed based on the first and last original data collected in the sub-data segment.

[0067] When no process segment intersection record is formed in the original acquired data segment, all original acquired data within the segment is retained, and the process segment number is set to null. The start time and end time of the original acquired data segment are compared with the time range of the process segment boundary sequence. The corresponding reason is written based on the comparison result: if the segment is outside the time range of the heat treatment batch, within the gap between adjacent process segments, or if the process segment boundary is missing. The process segment's attribution status is marked as pending verification. The original acquired data segments (not split), the formed sub-data segments, the corresponding rule snapshot number, the process segment number, and the process segment attribution status are sorted according to the heat treatment batch number, equipment number, acquired fields, start time, and acquired sequence number range to generate a transformed data segment sequence.

[0068] According to the conversion rule snapshot, the following steps are executed sequentially: field interpretation, unit conversion, timing sequence adjustment, anomaly handling, and process segment confirmation. The sequence of converted data segments is read one by one, and the corresponding conversion rule snapshot is retrieved based on the data segment number or parent data segment number. The corresponding process segment boundary is then retrieved based on the process segment number. Following the field interpretation rules, unit conversion rules, timing sequence adjustment rules, anomaly handling rules, and process segment attribution rules recorded in the conversion rule snapshot, the following steps are executed sequentially: field interpretation processing, unit conversion processing, timing sequence adjustment processing, anomaly handling, and process segment confirmation processing. During anomaly handling, the status marking rules are simultaneously read to mark the equipment status and alarm status.

[0069] The processing order is as follows: field interpretation, unit conversion, timing sequence adjustment, exception handling, and process segment confirmation. After each processing action is completed, the converted data segment number, corresponding processing action name, and processing order are concatenated in order to generate a processing record number. The processing record number, processing action name, pre-processing data, post-processing data, converted data segment number, rule snapshot number, process segment boundary location, processing order, and processing status are stored in a related manner. A record structure is built using the processing record number as an index to generate the corresponding conversion processing record.

[0070] When performing field interpretation, the field interpretation rules are read, and the names of the collected fields in the transformed data segment are compared with those in the field interpretation rules. During field interpretation, the collected fields in the transformed data segment are read, and the rule-specific collected fields, field descriptions, and field data types corresponding to the current transformed data segment are extracted from the field interpretation rules. The names of the collected fields and rule-specific collected fields are compared; if the names match, the field descriptions and field data types are checked for emptiness. If both the field description and field data type are not empty, the collected fields, field descriptions, and field data types are established according to the same data location to obtain the field interpretation result; if the field description is empty, the collected fields and field data types are retained, and the corresponding data location is marked as missing field description; if the field data type is empty, the collected fields and field descriptions are retained, and the corresponding data location is marked as missing field data type; if both the field description and field data type are empty, the collected fields are retained, and the corresponding data location is marked as missing field description and missing field data type.

[0071] When the names of the collected fields differ from those of the fields collected according to the rules, the collected fields in the transformed data segment are retained, and the collected fields, the fields collected according to the rules, and the data locations of the currently collected fields are associated. Following the order of the original collected data in the transformed data segment, the field explanation results, missing field descriptions, missing field data types, and differences in field names corresponding to each data location are collected to obtain the field explanation processing results. The collected fields, field descriptions, field data types, and data locations in the field explanation processing results are associated to generate a field explanation processing record.

[0072] When performing unit conversion processing, the processed data in the field interpretation processing record is used as the pre-processing data for unit conversion. Based on the work step sequence corresponding to the converted data segment, the corresponding unit conversion content is searched from the unit conversion rules. If no corresponding target unit is found, the unit conversion content corresponding to the original unit and target unit of the data segment is used. If the acquisition unit is consistent with the original unit of the data segment and the unit conversion content keeps the original acquisition value and acquisition unit unchanged, the original acquisition value and acquisition unit are retained. If the unit conversion content has a multiple conversion relationship, the original acquisition value is converted according to the multiple conversion relationship to obtain the converted value. If the unit conversion content has an offset conversion relationship, the temperature offset corresponding to the original unit of the data segment is eliminated first, and then the multiple conversion is performed according to the conversion order recorded in the offset conversion relationship to obtain the converted value. If the acquisition unit is inconsistent with the original unit of the data segment, or if the unit conversion content has a unit conversion pending verification status, the original acquisition value and acquisition unit are retained, and the reason for pending verification is associated with the data location. Collect the unit conversion results for each data location. If there are no unit differences and no unit conversions pending verification, the unit conversion is confirmed to be complete. If there are unit differences or unit conversions pending verification, a unit conversion processing record is generated, and the corresponding verification information is recorded.

[0073] During time-series data processing, the processed data in the unit conversion processing record is used as the pre-processing data. This data is arranged from earliest to latest collection time, and if collection times are the same, it is arranged from smallest to largest collection sequence number, forming the processed data. The collection sequence numbers of adjacent original data in the processed data are compared sequentially to generate results with consecutive sequences, missing sequences, duplicate sequences, or sequence rollback. The difference between the collection times of adjacent original data is calculated to obtain the adjacent collection time interval. When the sampling interruption interval is valid, the adjacent collection time interval is compared with the field-level sampling interruption interval. If the adjacent collection time interval is greater than the field-level sampling interruption interval, a time interruption result is generated. When the sampling interruption interval is in a pending verification state, the reason for the pending verification is associated with the corresponding original data. The results of the collection sequence number comparison and the collection time comparison are collected to form a time series processing completion status or a time series processing pending verification status. The data before time series processing, the data after time series processing, the collection sequence number comparison results, the collection time comparison results, the time series processing completion status or the time series processing pending verification status are associated with the transformed data segment number, the rule snapshot number, the third processing order after the second processing order and the corresponding processing record number, and a time series processing record is generated.

[0074] When performing exception handling, the processed data in the time sequence processing record is used as the pre-processing data in the exception handling. The acquisition sequence number of the two adjacent original acquisition data points with missing sequence number results is compared with the acquisition sequence number of the missing position record; if they match, the missing acquisition sequence number is retained. The acquisition time of the two adjacent original acquisition data points with time interruption results is compared with the communication interruption start time and communication interruption end time of the communication interruption record. When the acquisition time of the original acquisition data before the interruption in the time interruption result matches the communication interruption start time, and the acquisition time of the original acquisition data after the interruption matches the communication interruption end time, the original acquisition data on both sides of the interruption are retained, and no interpolation is performed. The original acquisition data corresponding to the candidate result with duplicate sequence number is compared with the duplicate data processing result. When the equipment number, heat treatment batch number, acquisition field, acquisition time, and acquisition sequence number are all the same, the original acquisition data with the earliest order is used as the original acquisition data participating in the conversion, and the remaining original acquisition data are considered duplicate data not participating in the conversion. The unit conversion process maintains the original collected values ​​and units for the data to be verified. When the equipment status matches the equipment status anomaly record, it is associated with the corresponding original collected data. When the alarm status matches the alarm accompanying record, it is associated with the corresponding original collected data. Equipment status retention records, equipment status change records, alarm status retention records, and alarm status change records are associated according to the status marking rules. The original collected data involved in the conversion, duplicate data not involved in the conversion, missing collection sequence numbers, communication interruption records, equipment status anomaly records, and alarm accompanying records are collected according to the chronological order of the processing records to generate a post-anomaly processing data sequence. Anomaly processing completion information is recorded when all verification results are consistent; otherwise, anomaly processing pending verification information is recorded. A correspondence is established between the pre-processing data, post-processing data sequence, anomaly processing completion information, or anomaly processing pending verification information and the conversion data segment number, rule snapshot number, fourth processing order, and corresponding processing record number to generate anomaly processing records.

[0075] When performing process segment confirmation processing, the data sequence after anomaly handling is used as the pre-processing data for process segment confirmation processing. The acquisition time is compared one by one with the process segment start time and process segment end time. Except for the last process segment of the current heat treatment batch, if the acquisition time is not earlier than the process segment start time and is earlier than the process segment end time, a relationship is established between the process segment number, process segment name, and process segment boundary position and the corresponding data position. Within the last process segment of the current heat treatment batch, if the acquisition time is not earlier than the process segment start time and not later than the process segment end time, a relationship is established between the process segment number, process segment name, and process segment boundary position and the corresponding data position. If the acquisition time is not within any process segment time interval, or if the process segment boundary is in a boundary crossing verification state or a process segment time overlap verification state, the corresponding data position is associated with the verification reason. The established data positions, corresponding process segment numbers, process segment names, process segment boundary positions, and associated verification reasons are summarized and correlated with the pre-processing data, the fifth processing sequence, and the corresponding processing record number to generate a process segment confirmation processing record.

[0076] The processing chain is generated by categorizing data into processing records based on their segment numbers, including field interpretation records, unit conversion records, time sequence processing records, anomaly processing records, and process segment confirmation records. These records are then arranged in order from first to fifth processing sequence to form a processing chain sequence queue. The processed data of the previous conversion record in the processing chain sequence queue is compared with the pre-processed data of the next conversion record, with each item checked for acquisition time, acquisition sequence number, data location, value, unit, equipment status, and alarm status. If all items match, consecutive adjacent processing actions are performed; if inconsistencies exist, the processing sequence, preceding and following record numbers, content of the difference, and location of the difference are correlated. The correlation results are arranged in order from first to fifth processing sequence to generate a processing chain verification record. Finally, following the arrangement order of the process segment confirmation records, the processed value, processed unit, acquisition time, acquisition sequence number, conversion marker, and process segment number corresponding to each data location are read sequentially. When there are no anomalies in the corresponding conversion process, the processed values ​​are arranged according to the collection time and collection sequence number to generate a standard value sequence. When the participation in conversion indicates that the corresponding original collected data did not participate in the conversion, the original position of the original collected data that did not participate in the conversion in the anomaly processing record, the position after time sequence processing, and the correspondence between the two are retained, and the original collected data that did not participate in the conversion are not included in the standard value sequence.

[0077] The field interpretation processing record, unit conversion processing record, time sequence processing record, exception handling record, and process section confirmation processing record are checked sequentially. If none of the five conversion processing records contain content awaiting verification, the conversion is complete. If any conversion processing record contains content awaiting verification, the processing action name, the reason for verification, and the corresponding data location are collected to form a conversion verification list. The standard value sequence, target unit, conversion completion time, and conversion completion status or conversion verification status are associated to generate a standard value field. When a unit conversion processing record has a unit conversion verification status, a time sequence processing record has a sampling interruption interval verification status, or a process section confirmation processing record contains content with a process section affiliation status awaiting verification, the conversion verification status is marked as pending confirmation and written to the standard value field. When generating the data conversion result, the pending confirmation status in the standard value field is read, and the corresponding data conversion result is marked as pending confirmation. Before the pending confirmation status is eliminated, the corresponding data conversion result is only used for verification and not as a process traceability result. Read the processing record number, transformation data segment number, parent data segment number, rule snapshot number, process segment number, process segment boundary position, data position before processing, and data position after processing for each transformation process in the processing order. Identify the same original data by acquisition time and acquisition sequence number, and connect the data positions of the original data in the five processing actions in sequence to generate a data lineage record.

[0078] Based on the pre-processing data, post-processing data, original location, time-series organized location, and conversion participation markers of the anomaly handling records, the following are collected: duplicate data not involved in conversion, missing acquisition sequence numbers, communication interruption records, unit conversion data awaiting verification, equipment status anomaly records, and alarm-related records. The pre-processing data and post-processing data of the anomaly handling records corresponding to the original location and post-processing data location are compared one by one. If there are differences between the pre-processing data and post-processing data of the anomaly handling records, or if the conversion participation marker has changed, the data is arranged from last to first according to the post-processing data location to obtain the restoration order. If the pre-processing data and post-processing data of the anomaly handling records are consistent and the conversion participation marker has not changed, the corresponding original location, post-processing data location, and conversion participation marker are retained. The restoration order, pre-processing data, post-processing data, original location, post-processing data location, and conversion participation markers of the anomaly handling records are associated to generate restoration fields.

[0079] The system sequentially compares the pre-processing and post-processing data of each conversion record, verifying the collected fields, original values, converted values, collection units, processed units, conversion markers, equipment status, alarm status, and process section number according to the original and post-processing data locations. If any item changes, the system associates the action name, pre-change content, post-change content, difference location, and processing status to generate an action difference record. If none of the items change, the system associates the action name, original location, post-processing data location, and processing status to generate an action retention record. The action difference records and action retention records are then arranged according to the processing order and post-processing data location to generate a difference field.

[0080] Based on the batch number of the heat treatment operation, the part batch numbers in the process sheet data are collected, and identical part batch numbers are merged to generate a part batch number collection result. When there is only one part batch number in the part batch number collection result, a correspondence is established between the part batch number and the converted data segment; when the part batch number collection result is empty, the part batch number is recorded as missing; when there are still multiple different part batch numbers in the part batch number collection result, they are arranged according to the order of appearance of each part batch number in the process sheet data, and the arrangement results where the part batch number cannot be uniquely determined are marked as pending verification.

[0081] The conversion record number is generated by concatenating the equipment number, heat treatment batch number, part batch number, acquisition field, conversion data segment number, parent data segment number, rule snapshot number, process segment number, and result generation time in that order. This conversion record number is then associated with the standard value field, lineage field, restoration field, difference field, processing chain verification record, and conversion completion status or conversion pending verification status to generate a conversion result record.

[0082] To verify the consistency guarantee provided by the transformation rule snapshot for each transformation processing action, and to determine the specific processing steps that may be affected by rule changes, Figure 6 The figure illustrates the consistency rates of field interpretation processing, unit conversion processing, timing organization processing, anomaly handling, and process segment confirmation processing under different recalculation methods. The figure uses each conversion processing action as a horizontal comparison object and different conversion rule change conditions or recalculation methods as a vertical comparison object, reflecting the degree to which each processing action is affected by rule changes through consistency rate differences. When reading the current rule, inconsistencies are prone to occur in the field interpretation processing, anomaly handling, and process segment confirmation processing stages; reading only the unit conversion rule can only guarantee partial unit conversion results; when reading a complete conversion rule snapshot, all five conversion processing actions maintain a high degree of consistency.

[0083] S4. Generate a playback index based on the hierarchical relationship of the conversion result records, form a playback task sequence according to the playback request, process the conversion result records according to the playback type along the playback task sequence, and associate the processing results with the conversion record number to generate data conversion results.

[0084] The conversion result records are arranged in ascending order of generation time. If the generation times are the same, they are arranged by conversion record number. The conversion record number, conversion data segment number, parent data segment number, equipment number, heat treatment batch number, part batch number, acquisition field, process segment number, standard value field, lineage field, restoration field, difference field, and processing chain verification record are read one by one. The storage locations of the standard value field, lineage field, restoration field, difference field, and processing chain verification record within the conversion result record are determined. A correspondence is established between the conversion record number and the storage locations of the standard value field, lineage field, restoration field, difference field, and processing chain verification record, forming record index nodes. Record index node numbers are generated according to the order in which the record index nodes are formed.

[0085] Record index nodes are aggregated according to the conversion data segment number. Record index nodes corresponding to the same conversion data segment number are arranged according to the acquisition field and conversion record number. The conversion data segment number and parent data segment number are then associated item by item with each record index node number in the record index node number sequence and each conversion record number in the conversion record number sequence, forming a data segment index node. Data segment index nodes are also aggregated according to the process segment number. A correspondence is established between the data segment index node number sequence, conversion record number sequence, and process segment boundary position corresponding to the same process segment number, forming a process segment index node. When the process segment number is empty or the process segment's status is pending verification, the corresponding data segment index node number is aggregated as a process segment pending verification index node. Finally, process segment index nodes, process segment pending verification index nodes, and data segment index nodes are aggregated according to the heat treatment batch number. The heat treatment batch number, heat treatment batch time range, process segment index node number sequence, process segment pending verification index node number sequence, data segment index node number sequence, and record index node number sequence are then associated item by item, forming a heat treatment batch index node. When the part batch number has a unique value, heat treatment operation batch index nodes are collected according to the part batch number. The part batch number, the heat treatment operation batch index node number sequence, and the conversion record number sequence are associated item by item to form a batch index node. When the part batch number is missing or the part batch number is in a pending verification state, no corresponding batch index node is generated. The record index node, data segment index node, process segment index node, process segment pending verification index node, heat treatment operation batch index node, and batch index node are associated according to the correspondence between the conversion record numbers to form a playback index.

[0086] The system receives playback requests with a playback request number, playback type, and search criteria. Playback types include result playback, recalculation playback, restoration playback, process segment playback, heat treatment batch playback, or part batch number playback. Process segment playback, heat treatment batch playback, and part batch number playback are collectively referred to as range playback. Range playback is used to determine the playback range based on the process segment number, heat treatment batch number, or part batch number, and to collect conversion result records within the playback range based on the playback index. Search criteria are one of the following: conversion record number, conversion data segment number, process segment number, heat treatment batch number, or part batch number. When the playback type is process segment playback, the search criteria are the process segment number; when the playback type is heat treatment batch playback, the search criteria are the heat treatment batch number; and when the playback type is part batch number playback, the search criteria are the part batch number. When the search condition is a conversion record number, the corresponding conversion record index item is associated with the conversion record number, and the record index node number is associated based on the record index node identifier in the conversion record index item. When the search condition is a conversion data segment number, the data segment index node is associated with the conversion data segment number, and then the record index node number is associated based on the sequence of record index node numbers associated with the data segment index node. When the search condition is a process segment number, the process segment index node is associated with the process segment number, then the data segment index node is associated based on the sequence of data segment index node numbers associated with the process segment index node, and finally the record index node number is associated based on the sequence of record index node numbers associated with the data segment index node. When the search condition is the heat treatment batch number, the heat treatment batch index node is associated with the heat treatment batch number. Then, the data segment index node is associated with the process segment index node number sequence, the process segment verification index node number sequence, and the data segment index node number sequence associated with the heat treatment batch index node. Finally, the record index node number is associated with the record index node number associated with the data segment index node. When the search condition is the part batch number, the batch index node is associated with the part batch number. Then, the heat treatment batch index node is associated with the heat treatment batch index node number sequence associated with the batch index node. Finally, the process segment index node, data segment index node, and record index node are associated in sequence.

[0087] It should be noted that the conversion record index item is an index structure in the playback index used to directly locate the record index node based on the conversion record number, including the conversion record number and the record index node number.

[0088] Record index node numbers are arranged according to their order in the playback index. When the same record index node number appears repeatedly, the first occurrence is retained. Each record index node number is sequentially associated with its corresponding conversion record number, and these conversion record numbers are combined according to their order to form a conversion record number sequence. When the playback type is result playback, process segment playback, heat treatment batch playback, or part batch number playback, the storage locations of the standard value field, lineage field, restoration field, difference field, and processing chain are checked against the record index nodes. If all storage locations are identifiable and consistent with the record index node association, the conversion record number, record index node number, and each storage location are associated, forming part of the playback task record. If any storage location is unidentifiable or the association is inconsistent, the conversion record number, abnormal storage location, abnormal type, and verification result are associated, forming part of the playback record to be verified. When the playback type is recalculation playback, the storage locations of the standard value field, lineage field, restoration field, difference field, and processing chain are checked according to the record index node. The lineage field is read according to the lineage field storage location, and the data segment number, parent data segment number, rule snapshot number, process segment number, and process segment boundary position are checked. When the storage location and all contents in the lineage field can be determined and the correspondence between them is consistent, the conversion record number, record index node number, each storage location, and the content of the lineage field are established as the components of the playback task record. When any storage location cannot be determined, the content of the lineage field is missing, or the correspondence is inconsistent, the conversion record number, abnormal content, abnormal location, and verification result are established as the components of the playback record to be verified. When the playback type is restoration playback, the storage locations of the standard value field, lineage field, restoration field, difference field, and processing chain are checked according to the record index node. Then, the data segment number, parent data segment number, rule snapshot number, process segment number, and process segment boundary position are checked according to the lineage field. The restoration field is then read according to its storage location, and the data before processing, data after processing, original position, post-processing data position, conversion markers, and restoration order are checked. If all items in the restoration field can be determined and the restoration order corresponds to the original position, a correspondence is established between the conversion record number, record index node number, restoration field storage location, and restoration field content, which becomes part of the playback task record. If any restoration field content cannot be determined, the restoration order is missing, or the correspondence is inconsistent, a correspondence is established between the conversion record number, abnormal content, abnormal position, and verification result, which becomes part of the playback record to be verified.

[0089] When all verification items corresponding to the conversion record number have been verified, a correspondence is established between the playback request number, playback type, conversion record number, record index node number, standard value field storage location, lineage field storage location, restoration field storage location, difference field storage location, processing chain verification record storage location, and executable task status, generating a playback task record. If any verification item has an item awaiting verification, a correspondence is established between the playback request number, playback type, conversion record number, storage location of completed verifications, item awaiting verification, verification result, and awaiting verification task status, generating a playback awaiting verification record. Playback task records and playback awaiting verification records are arranged in the order of the conversion record number sequence to generate a playback task sequence. When the task status is executable, the corresponding playback task record continues to be processed. When the task status is awaiting verification, processing of the playback task corresponding to the conversion record number stops, and the playback awaiting verification record is output; no corresponding formal playback result is generated. Other playback task records with executable task status continue to be processed.

[0090] The system sequentially reads the playback task records in the playback task sequence and retrieves the corresponding conversion result records based on the playback type. When the playback type is result playback, it reads the standard value field based on the storage location of the standard value field, the lineage field based on the storage location of the lineage field, the restoration field based on the storage location of the restoration field, the difference field based on the storage location of the difference field, and the processing chain verification record based on the storage location of the processing chain verification record. The processed values ​​in the standard value sequence are arranged from earliest to latest according to the collection time. If the collection time is the same, they are arranged according to the collection sequence number and the original position. Then, the processed values, processed units, conversion participation markers, process section numbers, lineage relationships, restoration content, action difference content, and processing chain verification results are associated according to the conversion record number to generate result playback data. When the playback type is recalculation playback, the original collected data segment is extracted based on the data segment number or parent data segment number of the lineage field, the transformation rule snapshot is extracted based on the rule snapshot number, and the process segment boundary is extracted based on the process segment number and the process segment boundary position. Field interpretation processing, unit conversion processing, time sequence processing, exception handling and process segment confirmation processing are performed in sequence to generate a recalculated value sequence.

[0091] According to the original location, acquisition time, and acquisition sequence number, the processed values ​​in the recalculated value sequence are compared with the processed values ​​in the standard value field; the processed units in the recalculated value sequence are compared with the processed units in the standard value field; the conversion participation markers in the recalculated value sequence are compared with the conversion participation markers in the standard value field; and the process segment number in the recalculated value sequence is compared with the process segment number in the standard value field. If all comparison results are consistent, the recalculated value position, standard value position, and consistency comparison result are associated to generate recalculated consistent data; if any comparison result is inconsistent, the original location where the inconsistency occurred is used as the basis for further analysis. The system sets the data location, collection time, and collection sequence number. It then filters action difference records with the same data position from the difference field and compares the pre-processing data and post-processing data of the recalculation process with the pre-change and post-change content of the difference field records in the following processing order: field interpretation processing, unit conversion processing, time sequence processing, anomaly processing, and process section confirmation processing. The system identifies the first action with inconsistent comparison results as the action that caused the difference. It then associates the action name, difference position, pre-processing and post-processing data of the recalculation process, pre-change and post-change content of the difference field, and processing status to generate recalculation difference data.

[0092] When the playback type is restoration playback, the system reads the pre-processing data, post-processing data, original position, post-processing data position, and conversion participation flag of the exception handling record in reverse order according to the restoration field. The post-processing data and pre-processing data of the exception handling record are compared item by item. If differences exist, the post-processing data is replaced with the pre-processing data, and the data arrangement is restored according to the original position of the exception handling record. When the conversion participation flag is "not participating in conversion," the corresponding duplicate data is restored to the original acquisition data sequence according to the original position of the exception handling record. If a missing acquisition sequence number is not replaced with a replacement acquisition value, the missing acquisition sequence number and missing position are retained. If no interpolation is performed at the communication interruption position, the communication interruption start time, communication interruption end time, and original acquisition data on both sides of the interruption are retained. After restoration, the acquisition time, acquisition sequence number, acquisition value, acquisition unit, device status, and alarm status are arranged according to the original position of the exception handling record to generate a restoration data segment.

[0093] When the playback type is process segment playback, heat treatment batch playback, or part batch number playback, the playback data, recalculated consistency data, recalculated difference data, and restored data segments are collected according to the process segment number, heat treatment batch number, or part batch number, and arranged in the order of the record index nodes in the playback index. After playback is completed, the playback request number, playback type, conversion record number, processed value in the standard value sequence, processed unit, conversion participation marker, process segment number, processing status, lineage field, restored field, recalculated consistency data, recalculated difference data, difference location, playback record to be verified, reason to be verified, and final reliable status are associated to generate the data conversion result. If the storage location of the field corresponding to the replay type cannot be read, the final trusted state is marked as unplayable; if there is a replay record to be verified, the content to be verified in the replay record to be verified is extracted as the reason for verification, and the final trusted state is marked as to be verified; if the recalculated difference data is not empty, the final trusted state is marked as recalculated inconsistent; if there is no replay record to be verified, the storage location of the field corresponding to the replay type can be read, and the recalculated difference data is empty, the final trusted state is marked as official.

[0094] This embodiment also provides a computer device applicable to the data acquisition and conversion method for heat treatment equipment, comprising: a memory and a processor; the memory is used to store computer-executable instructions, and the processor is used to execute the computer-executable instructions to implement the data acquisition and conversion method for heat treatment equipment as proposed in the above embodiment.

[0095] The computer device can be a terminal, comprising a processor, memory, communication interface, display screen, and input devices connected via a system bus. The processor provides computing and control capabilities. The memory includes non-volatile storage media and internal memory. The non-volatile storage media stores the operating system and computer programs. The internal memory provides an environment for the operation of the operating system and computer programs stored in the non-volatile storage media. The communication interface is used for wired or wireless communication with external terminals; wireless communication can be achieved through Wi-Fi, carrier networks, NFC (Near Field Communication), or other technologies. The display screen can be an LCD screen or an e-ink screen. The input devices can be a touch layer covering the display screen, buttons, a trackball, or a touchpad on the computer device's casing, or an external keyboard, touchpad, or mouse.

[0096] This embodiment also provides a storage medium storing a computer program, which, when executed by a processor, implements the data acquisition and conversion method for heat treatment equipment as proposed in the above embodiments. The storage medium can be implemented by any type of volatile or non-volatile storage device or a combination thereof, such as Static Random Access Memory (SRAM), Electrically Erasable Programmable Read-Only Memory (EEPROM), Erasable Programmable Read Only Memory (EPROM), Programmable Red-Only Memory (PROM), Read-Only Memory (ROM), magnetic storage, flash memory, magnetic disk, or optical disk.

[0097] In summary, this invention eliminates logical confusion across state data by dividing the original collected data segments according to temporal continuity and state change location; and ensures the reproducibility and consistency of the data conversion process by forming a conversion rule snapshot based on field mapping records.

[0098] It should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention and are not intended to limit it. Although the present invention has been described in detail with reference to preferred embodiments, those skilled in the art should understand that modifications or equivalent substitutions can be made to the technical solutions of the present invention without departing from the spirit and scope of the technical solutions of the present invention, and all such modifications or substitutions should be covered within the scope of the claims of the present invention.

Claims

1. A method for acquiring and converting data for heat treatment equipment, characterized in that, include: Collect the original acquisition data, equipment list data and process sheet data of the current heat treatment operation batch, generate the time range of the heat treatment operation batch according to the step time, form field data columns according to equipment number, heat treatment operation batch number and acquisition field, generate field-level sampling interruption interval based on acquisition cycle or adjacent acquisition time interval, and then divide the original acquisition data segments according to the time sequence continuity and the position of state change. The original collected data segments are matched with the equipment point table data and process sheet data to generate field mapping records. Based on the field mapping records, a conversion rule snapshot is formed, and a process segment boundary sequence is generated by combining the process step time boundary and the state change location. The original data segments and process segment boundary sequences are matched for time intersection. Data segments that cross process segments are split to generate a sequence of transformed data segments. Transformation processing records are generated according to the processing order recorded in the transformation rule snapshot, and transformation result records are formed from the transformation processing records. A playback index is generated based on the hierarchical relationship of the conversion result records. A playback task sequence is formed according to the playback request. The conversion result records are processed along the playback task sequence according to the playback type. The processing results are associated with the conversion record number to generate the data conversion result.

2. The data acquisition and conversion method for heat treatment equipment as described in claim 1, characterized in that, The process of dividing the data into original segments based on temporal continuity and state change locations is as follows: Extract the heat treatment batch number, step name, step sequence, step start time, step end time, and step duration from the process sheet data. Filter the data of the current heat treatment batch and merge them to generate process sheet step data groups. Then, generate the step start time and step end time based on the process sheet step data groups, and finally generate the time range of the heat treatment batch. Extract the equipment number, heat treatment batch number, acquisition field, acquisition time and acquisition sequence number from the original acquisition data. Filter the data of the current heat treatment batch and aggregate it according to the equipment number and acquisition field to generate a field dataset. Arrange the field dataset according to the acquisition time and acquisition sequence number to generate field data columns. Extract the acquisition period corresponding to the field data column from the equipment point table data and generate the field-level sampling interruption interval according to the acquisition period. The field-level sampling interruption interval is checked against the time range of the heat treatment operation batch. The acquisition sequence number, acquisition time, acquisition original value, equipment status and alarm status of adjacent original acquisition data are extracted from the field data column, and each segmentation position is generated. Then, the segmentation position sequence is generated by merging the segments in the order of their respective segments. The data columns of the segmentation field are segmented according to the segmentation position sequence. The original data collected between each segmentation position is classified into the original data segment. Data segment numbers are generated according to the arrangement order. Start time and end time are generated according to the collection time. Then, they are checked against the time range of the heat treatment operation batch.

3. The data acquisition and conversion method for heat treatment equipment as described in claim 1, characterized in that, The steps for creating a snapshot of transformation rules based on field mapping records are as follows: According to the arrangement order of the original data collection segments, data that matches the original data collection segments are selected from the equipment point table data and process sheet data respectively. The selected data is then checked against the original data collection segments in terms of units, and a corresponding relationship is established between the selected data collection segments and the original data collection segments to generate field mapping records. Generate field interpretation rules and unit conversion rules based on field mapping records, and generate time sequence processing rules and anomaly handling rules based on raw collected data segments; Based on the process sheet data, process segment attribution rules are generated, and based on the original collected data, status marking rules are generated. Then, the field interpretation rules, unit conversion rules, time sequence arrangement rules, exception handling rules, process segment attribution rules, and status marking rules are associated with the field mapping records to generate a conversion rule snapshot.

4. The data acquisition and conversion method for heat treatment equipment as described in claim 2, characterized in that, The steps for generating the process segment boundary sequence by combining the time boundary of the work step and the location of state changes are as follows: Based on the heat treatment batch number, step name, step sequence, step start time, and step end time in the process sheet step data group, the step start time and step end time are checked sequentially, and the step start time, step end time, and corresponding verification status of the same step are associated to generate step time boundaries. The original data acquisition segments are arranged according to the equipment number, heat treatment batch number and acquisition field. The acquisition original value, equipment status and alarm status corresponding to adjacent original data acquisition segments are compared in turn. The acquisition time corresponding to the change is associated with the adjacent original data acquisition segments to generate the status change position between each original data acquisition segment. Arrange the time boundaries of each process step according to the process step sequence and the position of the state change between the start and end times of the process step. Take the position before the two adjacent positions as the start time of the process segment and the position after the two adjacent positions as the end time of the process segment. At the same time, associate it with the process step name, process step sequence and heat treatment batch number to generate a process segment number. Then check it with the time range of the heat treatment batch to form a process segment boundary sequence.

5. The data acquisition and conversion method for heat treatment equipment as described in claim 4, characterized in that, The steps for generating the transformed data segment sequence are as follows: Read the process segment boundary sequence according to the heat treatment batch number, and arrange them according to the process step sequence, process segment start time and process segment number. Assign the common boundary of adjacent process segments to the next process segment, and assign the end time of the last process segment to the last process segment to generate process segment interval records. The original data segment is compared with the process segment interval records under the same heat treatment batch. The later start time is taken as the intersection start position and the earlier end time is taken as the intersection end position. The data segment number, process segment number, process segment boundary position, intersection start position and intersection end position are associated to generate process segment intersection records. When an original data segment forms only one process segment intersection record, the original data segment is retained. When two or more process segment intersection records are formed, sub-data segments are generated according to the start and end positions of the intersection. The data segment number of the original data segment is used as the parent data segment number of the sub-data segments. When no process segment intersection record is formed, the process segment number is set to null, the process segment ownership status is marked as pending verification, and the sequence of converted data segments is arranged.

6. The data acquisition and conversion method for heat treatment equipment as described in claim 5, characterized in that, The steps for generating a conversion result record from the conversion processing record are as follows: Read the transformed data segments sequentially according to the transformed data segment sequence. When the transformed data segment is an unsplit original acquired data segment, read the transformation rule snapshot according to the data segment number. When the transformed data segment is a sub-data segment, read the transformation rule snapshot according to the parent data segment number. Read the process segment boundary according to the process segment number, and perform field interpretation processing, unit conversion processing, time sequence processing, exception handling and process segment confirmation processing on the transformed data segment in sequence. When the process segment number is not empty, read the process segment boundary according to the process segment number and perform process segment matching. When the process segment number is empty and the process segment ownership status is pending verification, mark the process segment matching result as pending verification. During the anomaly verification process, the status marking rules are read synchronously to mark the device status and alarm status; Following the sequence of field interpretation processing, unit conversion processing, time sequence processing, exception handling, and process segment confirmation processing, the data generated and the verification status in each process are associated, and conversion processing records are generated according to the converted data segment number and processing order. The conversion processing records are then collected according to the converted data segment number. Based on the collected conversion processing records, the collected fields, original values, collection units, collection time, collection sequence number, equipment status, alarm status, and process segment number are associated, and combined with the conversion data segment number, rule snapshot number, and process segment number to generate conversion record number and conversion result record.

7. The data acquisition and conversion method for heat treatment equipment as described in claim 1 or 6, characterized in that, The steps for forming a replay task sequence based on the replay request are as follows: The conversion result records are arranged and then collected level by level according to the conversion data segment sequence, process segment boundary sequence and heat treatment batch number to obtain the corresponding conversion result records in sequence. Then, the correspondence between each conversion result record is established according to the collection order to generate a playback index. Upon receiving a playback request, the system sequentially searches the playback index for the conversion result records corresponding to the converted data segment sequence, process segment boundary sequence, or heat treatment batch number, obtaining the conversion result records arranged in the order of the playback index. Repeatedly check and verify the correspondence of the conversion result records arranged in the playback index order, and generate a playback task sequence according to the verified arrangement order.

8. The data acquisition and conversion method for heat treatment equipment as described in claim 7, characterized in that, The steps for associating the processing result with the conversion record number to generate the data conversion result are as follows: Read the conversion result records sequentially along the playback task sequence. When the playback type is result playback, arrange the conversion result records according to the order in the playback index, and check the correspondence of the arranged conversion result records to obtain the conversion result records processed by result playback. When the playback type is recalculation playback, the conversion result records are reprocessed according to the conversion data segment sequence and process segment boundary sequence. The reprocessed conversion result records are checked item by item against the conversion result records in the playback task sequence, and the items that match and those that do not match are retained. When the playback type is restore playback, the processing is performed in reverse order according to the processing order of the conversion result records; When the playback type is process segment playback, heat treatment operation batch playback, or part batch number playback, the conversion results are collected and recorded according to the process segment boundary sequence or heat treatment operation batch number. Then, the processing results of each playback type are associated to generate data conversion results.

9. A computer device comprising a memory and a processor, wherein the memory stores a computer program, characterized in that, When the processor executes the computer program, it implements the steps of the data acquisition and conversion method for heat treatment equipment as described in any one of claims 1 to 8.

10. A computer-readable storage medium having a computer program stored thereon, characterized in that, When the computer program is executed by the processor, it implements the steps of the data acquisition and conversion method for heat treatment equipment as described in any one of claims 1 to 8.

Images