In the field of hydrogen energy testing, fuel cell tests generally have a long cycle, and the volume of raw data generated during the test process is enormous, usually with more than 300 columns of data, which accumulates into massive raw process test data in millisecond intervals.

Such data is usually stored as text files in the computers of equipment workstations, making it difficult to ensure its integrity and reliability. Therefore, test personnel face a huge workload and relatively low work efficiency when processing data and generating curve graphs.

Independently developed by Sunway Data, SW-LIMS (Laboratory Information Management System) integrates key functions such as collection, storage, retrieval and application of massive process test data. It can help laboratories automatically collect and store massive raw data generated during hydrogen energy testing, and also support big data query and screening, automatic curve graph generation and custom data analysis, which can significantly improve the work efficiency of test personnel and the comprehensive management level of laboratories.

Collection of Massive Process Test Data
According to the network access conditions of equipment and network security requirements, SW-LIMS can adapt to corresponding equipment network access and data collection solutions, which are mainly divided into three methods: direct equipment interface connection, software integration of instrument and equipment workstations, and workstation data file capture.

The SW-LIMS platform provides a dedicated equipment data collection software package, through which users can achieve multi-method data collection via collection configuration.

For instruments and equipment equipped with interfaces such as RS485, RS232, GPIB and RJ45, and in cases where network security requirements mandate direct connection between the LIMS server and the instruments, the equipment data collection module of the SW-LIMS server can send instruction messages through the communication protocols of the instruments and parse the data messages returned by them, realizing direct interface connection and data interaction with the instruments to acquire their data.

When instruments lack corresponding interfaces, the interfaces are occupied by workstations, or direct server connection is prohibited due to network security requirements, if the workstation software supports secondary development, the SW-LIMS server can be integrated with the equipment workstation software. The workstation software collects data and then uploads it to the SW-LIMS server, thus realizing equipment networking and data interaction.

If the workstation software of instruments does not provide open interfaces, data can be networked by capturing workstation data files, parsing them and uploading the parsed data to the SW-LIMS server.

SW-LIMS can identify the storage path of data files of instrument and equipment workstation software. By installing a data file collection service on the workstation, it can realize scheduled scanning of storage paths, parsing of data files and data upload.

After the operation of instruments and equipment, the workstation software generates data files in the storage path. The collection service parses the data files once detected and uploads the parsed instrument and equipment data to the SW-LIMS server.

Storage of Massive Process Test Data
The raw data of hydrogen energy testing is mainly used by R&D departments to trace and conduct in-depth analysis of test raw records, providing necessary test data support for the R&D process. In view of the need to ensure the integrity and non-loss of such data and the enormous data volume, the system adopts non-relational databases for data storage and management.

For such data, SW-LIMS stores the collected raw data in non-relational databases such as ClickHouse, MongoDB and InfluxDB, achieving low space occupancy and fast data extraction and calculation speed.

Retrieval of Massive Process Test Data
SW-LIMS is equipped with a powerful massive data retrieval function, which can support the query and display of a large amount of process test data from hydrogen energy testing. The system uses time-series databases for storage, realizing the proper storage of massive raw data and sampled data during the test process and their display on the page. The query page supports users to freely combine screening conditions for queries and also supports permission-managed data export. Users can apply for data export through an approval process based on screening results.

SW-LIMS provides retrieval methods such as fuzzy query, precise query and combined query, and supports keyword query function, which offers a fast query method allowing users to input any query keywords for quick search of all attributes involved in full-text retrieval.

Application of Massive Process Test Data
After the automatic collection and storage of raw equipment data, SW-LIMS can automatically screen, calculate and generate curves according to set rules, and automatically insert the screened, calculated data and generated curves into reports.

For the massive test data stored in time-series databases, the system supports data analysis based on screening logic and can automatically generate various graphs required for reports according to screening results.

Specifically for the hydrogen energy testing industry, SW-LIMS has realized the automatic drawing function of seven types of graphs, including LSV (Linear Sweep Voltammetry), CV (Cyclic Voltammetry), EIS (Electrochemical Impedance Spectroscopy), IV (Current-Voltage Characteristics), hydrogen modules, humidifiers and locking pressure. The system can automatically read data from files, generate graphs based on data sources and directly embed them into raw records and reports, thus saving test personnel's time in compiling report graphs.

Conclusion
The massive process test data management module of SW-LIMS can help hydrogen energy testing laboratories achieve efficient management and application of massive process test data through the collection, storage, retrieval and application of test process data, providing timely, complete, effective and traceable inspection and testing data support for the quality management of hydrogen energy laboratories. With the functions of this management module, SW-LIMS not only improves the work efficiency of hydrogen energy testing laboratories but also enhances the accuracy and reliability of data management, laying a solid technical foundation for the long-term development of laboratories.