A whole-process traceable environmental data collaborative verification method and system

Abstract

The application discloses a kind of full-process traceable environmental data collaborative verification method and system, first, establish the literature-row-column data model with literature digital object identifier (DOI) as the core of organization, support cell level agreement and revision operation;Second, before updating verification record, old record is completely archived to history table, export is generated in time axis order auditor list and hierarchical revision text;Then, based on literature identification dimension statistics verification progress, and in the form of unit in display terminal side cache, after server check integrity, batch write-in;Finally, generate the process parameter delivery table containing data column and auditor, audit time, detailed record and so on tracking column.The application effectively solves the problems of low efficiency, incomplete audit chain, unreliable weak network synchronization and non-standard delivery in the existing electrochemical water treatment literature parameter collaborative verification.

Description

Technical Field

[0001] This invention belongs to the interdisciplinary field of electrochemical water treatment and environmental information technology. It relates to a method and system for collaborative verification of literature information and experimental data related to electrochemical water treatment, electrocatalytic oxidation and electrochemical advanced reduction processes in the field of electrochemical water treatment. Specifically, it relates to a method and verification system for multi-person collaborative manual verification, audit tracking and data export of structured extraction results such as experimental parameters, electrode configuration and operating conditions in electrochemical water treatment literature. Background Technology

[0002] Electrochemical water treatment is an important technological pathway for degrading recalcitrant organic pollutants and achieving advanced oxidation treatment, encompassing various forms such as electrocatalytic oxidation, electro-Fenton oxidation, electro-reduction, electro-adsorption, electrocoagulation, and coupled processes. In scientific research and engineering practice, a large amount of experimental data has been published in journal articles and technical reports, involving key parameters such as electrode materials, electrode area, current density, electrolyte composition, target pollutants, degradation rate constant k, TOC / COD removal rate, specific energy consumption, and plate-and-frame / membrane electrode reactor configurations.

[0003] In recent years, researchers have begun to explore using large language models to extract these parameters in batches from portable documents and generate structured tables with DOI (Document Digital Object Identifier) ​​columns to accelerate the construction of electrochemical water treatment process parameter databases. However, large-scale automated extraction inevitably produces errors or ambiguities, necessitating high-quality manual verification before data entry.

[0004] Existing verification methods often rely on individual quality inspectors comparing the original text line by line, which is inefficient and difficult to support multi-person collaboration. When multiple auditors work on the same dataset, repeated modifications to the same cell cannot be fully recorded, breaking the audit chain. Exported deliverables lack standardized auditor information and revision notes, making it difficult to meet the requirements of traceability and reproducibility of scientific research data. In weak network environments such as laboratories or engineering sites, uploading cell by cell can easily lead to transmission failures and inconsistencies in data status.

[0005] In addition, existing general collaborative editing tools are not designed for the structural characteristics of electrochemical water treatment parameter tables: the same DOI often corresponds to multiple comparative experimental records (different current densities, different pollutant concentrations), and tasks and statistical progress need to be allocated according to the literature dimension; numerical fields (current density, removal rate, k value) need to maintain a calculable format when exported; revisions to fields such as electrode materials and process types need to retain a complete change chain for process engineers to review.

[0006] Therefore, there is an urgent need for a collaborative verification technology for experimental data in the field of electrochemical water treatment that supports multi-person collaboration, process auditability, reliable synchronization of the entire line, and can be connected to a process parameter library. Summary of the Invention

[0007] To address the issues of errors and ambiguities in experimental parameter tables extracted in batches from large language models during the construction of process parameter libraries for processes such as electrocatalytic oxidation, electro-Fenton, electrolysis, electroadsorption, and advanced electrochemical reduction, as well as the difficulties in tracing review history, data synchronization interruptions in weak network environments, and the lack of standardized audit information in exported deliverables during collaborative manual review, this invention provides a fully traceable environmental data collaborative verification method and system. The collaborative verification results can be used to support the construction of electrochemical water treatment process parameter libraries, quality review of model extraction results before their inclusion in the library, and traceable management of scientific research data.

[0008] The objective of this invention is achieved through the following technical solution:

[0009] A collaborative verification method for environmental data with full-process traceability includes the following steps:

[0010] Step 1: Establish a literature-row-column data model:

[0011] Receive collaborative verification requests for structured experimental parameter tables in the field of electrochemical water treatment, and establish a literature-row-column data model with the Digital Object Identifier (DOI) of the literature as the core of organization;

[0012] Step 2, Cell-level verification and revision validation:

[0013] When a user approves or modifies any cell, the modification value submitted by the user is forcibly verified against the original value of the cell. If the two are the same, the modification is rejected, ensuring that every valid modification can enter the audit chain.

[0014] Step 3: Generate archived and tracked records of multi-person verification history.

[0015] Before updating cell records, copy the old records completely to the verification history table; when exporting or displaying tracking information, merge historical and current events in ascending order of time to generate a list of auditors and hierarchical revision text sorted by audit order;

[0016] Step 4: Progress statistics for document dimensions:

[0017] Based on the document digital object identifier dimension, the total number of cells under each document and the number of cells that have met the verification conditions are counted to generate verification progress information for the administrator to keep track of the work progress of each reviewer;

[0018] Step 5: Complete batch synchronization for the entire row:

[0019] After the client completes the verification of all data columns in a row, it caches a row snapshot; during upload, it is encapsulated as a batch request, and the server writes it to the database all at once after verifying the row integrity.

[0020] Step 6, Engineered export with tracking columns:

[0021] Export a table file containing columns for electrochemical process data and fixed tracking columns.

[0022] A collaborative verification device for experimental data from electrochemical water treatment literature includes a data storage module, a verification execution module, a historical archiving module, a tracking generation module, a synchronous writing module, and a result export module, wherein:

[0023] The data storage module is used to store the experimental parameter dataset of electrochemical water treatment, literature row data, current verification record of cells and verification history;

[0024] The verification execution module is used to parse structured tables containing document digital object identifiers, receive cell-level agreement or revision operations, and perform validity checks on the revised values;

[0025] The historical archiving module is used to write old records into the verification history table before updating the current verification record;

[0026] The tracking and generation module is used to merge verification events according to the timeline and generate an ordered list of auditors, hierarchical revision texts and audit time information.

[0027] The synchronous writing module is used to receive batch synchronization requests for the entire row, verify row integrity, and trigger historical archiving before each cell is written.

[0028] The results export module is used to generate a delivery form file containing columns for electrochemical process data and tracking data.

[0029] A collaborative verification system for experimental data from electrochemical water treatment literature includes the aforementioned collaborative verification device, a literature data interface, a task allocation interface, and a display terminal, wherein:

[0030] The literature data interface is used to obtain the structured parameter table of electrochemical water treatment to be collaboratively verified from the literature database or experimental data management platform.

[0031] The task assignment interface is used to assign verification tasks to designated reviewers based on the document digital object identifier;

[0032] The display terminal is used to display a list of documents, a tabular frame-by-frame verification interface, verification progress, and exported results with tracking columns.

[0033] An electronic device includes one or more processors and a memory, wherein the memory is used to store one or more programs, and when the one or more programs are executed by one or more processors, the one or more processors enable the one or more processors to implement the above-mentioned fully traceable environmental data collaborative verification method.

[0034] A computer-readable storage medium having a computer program stored thereon, which, when executed by a processor, implements the aforementioned method for collaborative verification of environmental data with full-process traceability.

[0035] Compared with existing general table editing or simple comparison solutions, the present invention has the following advantages:

[0036] 1. Establish a complete audit chain for the entry of electrochemical water treatment parameters into the database, supporting full-process traceability for multiple revisions of the same cell;

[0037] 2. Based on the digital object identifier of documents, task allocation and progress quantification are realized to improve the efficiency of multi-person collaboration;

[0038] 3. Improve the reliability of data writing in weak network environments through a whole-line batch synchronization mechanism;

[0039] 4. Generate standardized deliverables containing tracking columns to meet the needs of scientific research data governance and process parameter library construction;

[0040] 5. Effectively solves the problems of low efficiency, incomplete audit chain, unreliable synchronization due to weak network, and non-standard deliverables in the existing collaborative verification of parameters in electrochemical water treatment literature. Attached Figure Description

[0041] Figure 1 A schematic diagram of the overall architecture of the collaborative verification system for literature data on electrochemical water treatment;

[0042] Figure 2 Flowchart of the method for generating historical archives and tracking columns for multi-person verification;

[0043] Figure 3 Flowchart of the method for completing offline synchronization for the entire line;

[0044] Figure 4 A schematic diagram is exported for an electrochemical water treatment parameter table with tracking columns. Detailed Implementation

[0045] The technical solution of the present invention will be further described below with reference to the accompanying drawings, but it is not limited thereto. Any modifications or equivalent substitutions to the technical solution of the present invention that do not depart from the spirit and scope of the technical solution of the present invention should be covered within the protection scope of the present invention.

[0046] This invention provides a fully traceable collaborative verification method for environmental data: First, a document-row-column data model is established with the Digital Object Identifier (DOI) of the document as the organizational core, supporting cell-level agreement and revision operations; second, before updating the verification record, the old record is completely archived to a history table, and an ordered list of reviewers and hierarchical revision text are generated according to the timeline during export; next, the verification progress is statistically analyzed based on the document identifier dimension, and cached on the display terminal in whole rows, and then written in batches after the server verifies the integrity; finally, a process parameter delivery table containing data columns and tracking columns such as reviewers, review time, and detailed records is generated. Deploying the above functions in a collaborative verification device or system integrating a processor, memory, and data communication interface can connect to document databases, experimental data management platforms, and model extraction services, realizing the traceability, auditability, and reproducibility of the entire process of electrochemical water treatment parameter database entry, providing support for the construction of process parameter databases and scientific research data governance. The specific steps are as follows:

[0047] Step 1: Establish a literature-row-column data model:

[0048] Receive collaborative verification requests for structured experimental parameter tables in the field of electrochemical water treatment, and establish a literature-row-column data model with literature digital object identifiers as the core of organization.

[0049] In this step, the experimental parameter table for electrochemical water treatment is organized using digital object identifiers for the literature, supporting multiple lines of comparative experimental records corresponding to one literature. This model provides a foundation for allocating verification tasks by literature, tracking verification progress, and achieving line-wide synchronization.

[0050] In this step, the experimental parameter table must include at least the literature identification field and the electrochemical process field. The electrochemical process field includes at least one of the following: anode material, cathode material, anode area, cathode area, electrolyte, current density, cell voltage, target pollutant, initial pH, removal rate, degradation rate constant, or reactor type.

[0051] Step 2, Cell-level verification and revision validation:

[0052] The system receives user verification operations for the target cell, including approval and revision. When the verification operation is revision, the system verifies the revised value submitted by the user against the original value of the cell. If they are the same, the revision is rejected.

[0053] Step 3: Generate archived and tracked records of multi-person verification history.

[0054] like Figure 2As shown, before updating the current verification record of the target cell, if an old record exists, the old record is copied completely and written to the verification history table, and then the new record is written to or updated in the current verification record table. When exporting the verification results, all data columns of each logical row are traversed, and the verification events are merged in chronological order based on the verification history table and the current record table to generate an ordered list of auditors and hierarchical revision text arranged in the audit order (e.g., the first auditor changed the anode material from Pt to Ti / PtO2), and appended to the tracking column.

[0055] In this step, the ordered auditor list is generated as follows: the auditor identifier that first appears in the verification event of each cell is extracted according to the event timestamp, and arranged in chronological order, not alphabetically.

[0056] In this step, the hierarchical revision text is generated as follows: for each revision event, a formatted description containing the review order, column name, original value, and revised value is generated according to the event sequence.

[0057] Step 4: Progress statistics for document dimensions:

[0058] Based on the document digital object identifier dimension, the total number of cells under each document and the number of cells that have met the verification conditions are counted to generate verification progress information, which allows the administrator to keep track of the work progress of each reviewer.

[0059] In this step, the verification progress information is the percentage of progress corresponding to the ratio of the number of verified cells to the total number of cells under a certain document digital object identifier.

[0060] Step 5: Complete batch synchronization for the entire row:

[0061] like Figure 3 As shown, the client caches a snapshot of the row that has completed the verification of all data columns, on a whole-row basis. When an upload is triggered, multiple whole-row operations are encapsulated into a batch synchronization request and sent to the server. The server verifies the integrity of the whole row of data and then writes it to the database all at once.

[0062] In this step, when batch synchronization requests are processed on the server side, the cell verification and writing logic is called in a loop for each row, and historical archiving is performed before each write, which improves the reliability in weak network environments.

[0063] Step 6, Engineered export with tracking columns:

[0064] Export a table file containing electrochemical process data columns and fixed tracking columns. Numerical fields retain a calculable format to support the import of process parameter libraries and subsequent analysis. The fixed tracking columns include tracking columns such as auditor column, audit time column, and detailed record column. The audit time column takes the latest event time among all verification events in each cell and converts it to a preset time zone format.

[0065] Step 7, Device and System Deployment:

[0066] The aforementioned functional modules are modularized into a data storage module, a verification execution module, a historical archiving module, a tracking generation module, a synchronous writing module, and a result export module. These modules are deployed in a collaborative verification device, verification system, or electronic device that includes a processor and a memory, and work collaboratively with a display terminal through a document data interface.

[0067] This invention also provides a collaborative verification device for experimental data from electrochemical water treatment literature. The device includes a data storage module, a verification execution module, a historical archiving module, a tracking generation module, a synchronous writing module, and a result export module, wherein:

[0068] The data storage module is used to store the experimental parameter dataset of electrochemical water treatment, literature row data, current verification record of cells and verification history;

[0069] The verification execution module is used to parse structured tables containing document digital object identifiers, receive cell-level agreement or revision operations, and perform validity checks on the revised values;

[0070] The historical archiving module is used to write old records into the verification history table before updating the current verification record;

[0071] The tracking and generation module is used to merge verification events according to the timeline and generate an ordered list of auditors, hierarchical revision texts and audit time information.

[0072] The synchronous writing module is used to receive batch synchronization requests for the entire row, verify row integrity, and trigger historical archiving before each cell is written.

[0073] The results export module is used to generate a delivery form file containing columns for electrochemical process data and tracking data.

[0074] This invention also provides a collaborative verification system for experimental data from electrochemical water treatment literature. The system includes the aforementioned collaborative verification device, a literature data interface, a task allocation interface, and a display terminal, wherein:

[0075] The literature data interface is used to obtain the structured parameter table of electrochemical water treatment to be collaboratively verified from the literature database or experimental data management platform.

[0076] The task assignment interface is used to assign verification tasks to designated reviewers based on the document digital object identifier;

[0077] The display terminal is used to display a list of documents, a tabular frame-by-frame verification interface, verification progress, and exported results with tracking columns.

[0078] The present invention also provides an electronic device, the device including one or more processors and a memory, the memory being used to store one or more programs, which, when executed by one or more processors, enable the one or more processors to implement the above-described fully traceable environmental data collaborative verification method.

[0079] The present invention also provides a computer-readable storage medium having a computer program stored thereon, wherein the computer program, when executed by a processor, implements the above-described method for collaborative verification of environmental data with full traceability.

[0080] Example 1:

[0081] like Figure 1 As shown, this embodiment provides a collaborative verification system for experimental data from electrochemical water treatment literature. The system includes a client module on the display terminal side, an application service module deployed on a server, and a data storage module. The application service module includes a processor and a memory, and the memory stores the program that implements the method of the present invention. The data storage module can use a relational database and is stored in the server memory.

[0082] The administrator uploads a spreadsheet file containing experimental parameters for electrochemical water treatment via a display terminal. The first line of the file contains column names, including a Document Digital Object Identifier (DOI) column and process field columns, such as: process type, anode material, cathode material, electrolyte, initial pH, and current density (mA / cm²). 2 ), target pollutant, degradation rate constant k (min) -1 The system parses the file, writes the data into the dataset table and row data table, and counts the number of duplicate documents. (This includes parameters such as TOC removal rate (%) and reactor type.)

[0083] The administrator assigns DOIs 1 to 5 to reviewer A and DOIs 6 to 10 to reviewer B via the task assignment interface, and the task information is written to the task assignment table. After reviewer A logs in, the terminal only displays the assigned documents and their verification progress. Clicking on DOI-001 enters the verification interface; this document contains two lines of comparative experiments (e.g., 10 mA / cm²). 2 With 20 mA / cm 2 (Phenol degradation), a total of 2 rows × N columns of cells need to be verified.

[0084] Auditor A revised the first cell, "Anode Material," changing the original value "Pt" to "Ti / IrO2." The verification execution module received the request, confirmed the revised value was different from the original, and, since there was no previous record for that cell, directly wrote it into the current verification record table, recording the operation type, original value, revised value, auditor, and timestamp.

[0085] Several days later, auditor B reviewed DOI-001 and changed the same cell from "Ti / IrO2" to "Ti-IrO2". The history archiving module first copied auditor A's record completely to the verification history table, and then wrote B's new record.

[0086] like Figure 2 As shown, during export, the tracking generation module merges two events in the first row, "Anode Material," generating: an auditor column "A,B"; an audit time column showing the latest event time (converted to UTC+8); and a detailed record stating "Changed anode material from Pt to Ti / IrO2; the second auditor (B) changed anode material from Ti / IrO2 to Ti-IrO2." If all columns in a row are in agreement and there are no modifications, the detailed record displays "Confirmed."

[0087] The results export module generates an Excel delivery file containing process data columns and tracking columns. Numerical columns such as current density, removal rate, and k-value are set to numerical format for easy subsequent process regression analysis.

[0088] like Figure 4 As shown, in addition to the electrochemical process data columns such as DOI, anode material, current density, and removal rate, there are additional tracking columns such as auditor, audit time, and detailed records, which display audit information of multiple people revising the same field successively.

[0089] Example 2:

[0090] like Figure 3 As shown, in a weak or offline network environment, the auditor completes cell-by-cell verification of 10 lines of electrochemical experimental data on the display terminal. The local index database caches 10 "line complete" snapshots. After the network is restored, the batch synchronization engine encapsulates batch requests and sends them to the server. The synchronous write module verifies the integrity of each line, confirming that all cells in each line have been verified. Before each cell is written, historical archiving is performed, completing the write in one go without intermediate state conflicts.

[0091] Example 3:

[0092] like Figure 1 As shown, the collaborative verification device includes a processor, a memory, and a data communication interface interconnected via a data bus or network. When the processor executes the program in the memory, the data storage module, verification execution module, history archiving module, trace generation module, synchronous writing module, and result export module work together. The device can be deployed as a verification server or workstation in an electrochemical water treatment laboratory or an environmental protection enterprise's R&D data platform.

[0093] Example 4:

[0094] An electronic device includes a processor and a memory, wherein a computer program is stored in the memory, and the program, when executed by the processor, implements the method of Embodiment 1.

[0095] Example 5:

[0096] A computer-readable storage medium having a computer program stored thereon, which, when executed by a processor, implements the method of Embodiment 1.

Claims

1. A full-process traceable environmental data collaborative verification method, characterized in that The method includes the following steps: Step 1: Establish a literature-row-column data model: Receive collaborative verification requests for structured experimental parameter tables in the field of electrochemical water treatment, and establish a literature-row-column data model with literature digital object identifiers as the core of organization; Step 2, Cell-level verification and revision validation: When a user approves or modifies any cell, the modification value submitted by the user is forcibly verified against the original value of the cell. If the two are the same, the modification is rejected, ensuring that every valid modification can enter the audit chain. Step 3: Generate archived and tracked records of multi-person verification history. Before updating cell records, copy the old records completely to the verification history table; when exporting or displaying tracking information, merge historical and current events in ascending order of time to generate a list of auditors and hierarchical revision text sorted by audit order; Step 4: Progress statistics for document dimensions: Based on the document digital object identifier dimension, the total number of cells under each document and the number of cells that have met the verification conditions are counted to generate verification progress information for the administrator to keep track of the work progress of each reviewer; Step 5: Complete batch synchronization for the entire row: After the client completes the verification of all data columns in a row, it caches a row snapshot; during upload, it is encapsulated as a batch request, and the server writes it to the database all at once after verifying the row integrity. Step 6, Engineered export with tracking columns: Export a table file containing columns for electrochemical process data and fixed tracking columns.

2. The method for collaborative verification of environmental data with full-process traceability according to claim 1, characterized in that... In step 1, the experimental parameter table includes at least a literature identification field and an electrochemical process field. The electrochemical process field includes at least one of the following: anode material, cathode material, anode area, cathode area, electrolyte, current density, cell voltage, target pollutant, initial pH, removal rate, degradation rate constant, or reactor type.

3. The method for collaborative verification of environmental data with full-process traceability according to claim 1, characterized in that... In step 3, the orderly auditor list is generated by extracting the auditor identifier that first appears in the verification event of each cell according to the event timestamp, and arranging them in chronological order, not alphabetically; the hierarchical revision text is generated by generating a formatted description containing the audit order, column name, original value and revised value for each revision event according to the event order.

4. The method for collaborative verification of environmental data with full-process traceability according to claim 1, characterized in that... In step 4, the verification progress information is the percentage of progress corresponding to the ratio of the number of verified cells to the total number of cells under a certain document digital object identifier.

5. The method for collaborative verification of environmental data with full-process traceability according to claim 1, characterized in that... In step 5, when the batch synchronization request is processed on the server, the cell verification and writing logic is called in a loop for each row, and the historical archive is executed before each write, which improves the reliability of weak network environment.

6. The method for collaborative verification of environmental data with full-process traceability according to claim 1, characterized in that... In step 6, the fixed tracking column includes an auditor column, an audit time column, and a detailed record column; the audit time column takes the latest event time among all verification events in each cell and converts it to a preset time zone format.

7. A collaborative verification device for electrochemical water treatment literature experimental data implementing the method of any one of claims 1-6, characterized in that... The device includes a data storage module, a verification execution module, a history archiving module, a trace generation module, a synchronous writing module, and a result export module, wherein: The data storage module is used to store the experimental parameter dataset of electrochemical water treatment, literature row data, current verification record of cells and verification history; The verification execution module is used to parse structured tables containing document digital object identifiers, receive cell-level agreement or revision operations, and perform validity checks on the revised values; The historical archiving module is used to write old records into the verification history table before updating the current verification record; The tracking and generation module is used to merge verification events according to the timeline and generate an ordered list of auditors, hierarchical revision texts and audit time information. The synchronous writing module is used to receive batch synchronization requests for the entire row, verify row integrity, and trigger historical archiving before each cell is written. The results export module is used to generate a delivery form file containing columns for electrochemical process data and tracking data.

8. A collaborative verification system for experimental data from electrochemical water treatment literature, characterized in that... The system includes the collaborative verification device as described in claim 7, a document data interface, a task allocation interface, and a display terminal, wherein: The literature data interface is used to obtain the structured parameter table of electrochemical water treatment to be collaboratively verified from the literature database or experimental data management platform. The task assignment interface is used to assign verification tasks to designated reviewers based on the document digital object identifier; The display terminal is used to display a list of documents, a tabular frame-by-frame verification interface, verification progress, and exported results with tracking columns.

9. An electronic device comprising one or more processors and a memory, wherein the memory is used to store one or more programs, characterized in that... When one or more programs are executed by one or more processors, the one or more processors implement the above-described method for collaborative verification of environmental data with full traceability.

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 fully traceable environmental data collaborative verification method according to any one of claims 1-6.

Images