Report Open Access
The objective of the project is to develop benchmarking tools for database technologies
(InfluxDB, Oracle and Apache Kudu) used by WinCC OA Archiver used in CERN control
systems. The goal of the project is to help in selecting the technology that will be used to
store history of signal value changes and alarms in hundreds of control systems at
CERN, including the ones in the accelerator complex and experiments.
Particularly we are more focused towards benchmarking InfluxDB vs Oracle database.
We are using/developing two tools namely ArchivePump and QueryBenchmark.
ArchivePump will measure the write speed of the database. QueryBenchmark tool will
measure read speed of the database.