The Joint Accelerator Conferences Website (JACoW) is an international collaboration that publishes the proceedings of accelerator conferences held around the world.
TY - CONF AU - Bourtembourg, R. AU - Cuní, G. AU - Di Carlo, M. AU - Fatkin, G.A. AU - James, S. AU - Pivetta, L. AU - Pons, J.L. AU - Rubio-Manrique, S. AU - Scafuri, C. AU - Scalamera, G. AU - Senchenko, A.I. AU - Sitnov, V. AU - Strangolino, G. AU - Verdier, P.V. AU - Zambon, L. ED - White, Karen S. ED - Brown, Kevin A. ED - Dyer, Philip S. ED - Schaa, Volker RW TI - Pushing the Limits of Tango Archiving System using PostgreSQL and Time Series Databases J2 - Proc. of ICALEPCS2019, New York, NY, USA, 05-11 October 2019 CY - New York, NY, USA T2 - International Conference on Accelerator and Large Experimental Physics Control Systems T3 - 17 LA - english AB - The Tango HDB++ project is a high performance event-driven archiving system which stores data with micro-second resolution timestamps, using archivers written in C++. HDB++ supports MySQL/MariaDB and Apache Cassandra backends and has been recently extended to support PostgreSQL and TimescaleDB*, a time-series PostgreSQL extension. The PostgreSQL backend has enabled efficient multi-dimensional data storage in a relational database. Time series databases are ideal for archiving and can take advantage of the fact that data inserted do not change. TimescaleDB has pushed the performance of HDB++ to new limits. The paper will present the benchmarking tools that have been developed to compare the performance of different backends and the extension of HDB++ to support TimescaleDB for insertion and extraction. A comparison of the different supported back-ends will be presented. PB - JACoW Publishing CP - Geneva, Switzerland SP - 1116 EP - 1121 KW - TANGO KW - database KW - controls KW - SRF KW - distributed DA - 2020/08 PY - 2020 SN - 2226-0358 SN - 978-3-95450-209-7 DO - doi:10.18429/JACoW-ICALEPCS2019-WEPHA020 UR - https://jacow.org/icalepcs2019/papers/wepha020.pdf ER -