Abstract:
Background Pulsed auxiliary heating power supplies used in magnetic confinement fusion generate transient voltage and current waveforms. Recording these waveforms requires the storage engine to handle large batches of samples while preserving their binary representation. Waveform samples and acquisition metadata have different storage requirements: samples are written in large blocks, whereas metadata are updated less frequently and used to locate the corresponding records.
Purpose To design a lightweight embedded time-series storage engine for transient waveforms and evaluate its write time, process CPU utilization, read performance, and readback integrity against a SQLite baseline that stores one sample per row.
Methods The Qt-based design stores metadata in SQLite and waveform samples in memory-mapped binary files. Two alternating buffers stage waveform blocks for writing. An independent Python reference implementation of the storage core was benchmarked in a Linux container using historical voltage and current records. The five-million-sample workload was constructed by cyclically replaying an exported voltage sequence whose timestamps corresponded to a sampling rate of 40 MHz. The evaluation covered batch writes, periodic storage, byte-for-byte readback checks, and sequential and random reads.
Results For the five-million-sample workload, the mean application-level write time was 2593.20 ms for the per-sample SQLite table and 21.16 ms for the hybrid path. All tested binary64 sequences matched their input byte for byte after normal completion without a crash or power failure. When one million samples were submitted as a batch once per second, mean process CPU utilization across three runs was 50.59% for the SQLite baseline and 0.69% for the hybrid path. The evaluation also quantified CPU variability using standard deviations and characterized sequential and random reads using throughput and latency.
Conclusions Under the tested workloads and cache conditions, the hybrid storage path reduced application-level write time and process CPU utilization while preserving the tested waveform sequences through write and readback. These measurements characterize the Python reference implementation. The performance of the Qt prototype, timing during online closed-loop operation, and durability under crashes or power loss require separate validation.