Downloads provided by UsageCounts
This project was completed in the scope of NextGen Archiver (NGA) for WinCC OA SCADA systems. The NGA is a new archiver for WinCC OA that uses a pluggable architecture to support multiple database technologies. This project was part of a wider effort to benchmark a range of database technologies to understand their limits in terms of functionality and performance in the context of CERN use cases. The benchmarking methodology involves producing realistic test data and performing write and read benchmarks on the database technologies under the test. The specific focus of this project was to perform ingestion benchmarking on TimescaleDB and PostgreSQL. We obtained an ingestion rate of 80K rows/second for TimescaleDB one-node and 150K rows/second for TimescaleDB two-node making them 2X and 3X higher than that of PostgreSQL which is around 40K rows/second. As the benchmark runs progressed we observed a considerable decline in the ingestion rate for PostgreSQL, but the ingest rate was stable for TimescaleDB. The work on the benchmarks will continue and focus on query performance and evaluation of different schema variants.
summer-student programme, CERN openlab
summer-student programme, CERN openlab
| selected citations These citations are derived from selected sources. This is an alternative to the "Influence" indicator, which also reflects the overall/total impact of an article in the research community at large, based on the underlying citation network (diachronically). | 0 | |
| popularity This indicator reflects the "current" impact/attention (the "hype") of an article in the research community at large, based on the underlying citation network. | Average | |
| influence This indicator reflects the overall/total impact of an article in the research community at large, based on the underlying citation network (diachronically). | Average | |
| impulse This indicator reflects the initial momentum of an article directly after its publication, based on the underlying citation network. | Average |
| views | 140 | |
| downloads | 8 |

Views provided by UsageCounts
Downloads provided by UsageCounts