JACoW logo

Joint Accelerator Conferences Website

The Joint Accelerator Conferences Website (JACoW) is an international collaboration that publishes the proceedings of accelerator conferences held around the world.

RIS citation export for WEPHA020: Pushing the Limits of Tango Archiving System using PostgreSQL and Time Series Databases

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  - database
KW  - controls
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  -