The Joint Accelerator Conferences Website (JACoW) is an international collaboration that publishes the proceedings of accelerator conferences held around the world.
@InProceedings{bourtembourg:icalepcs2019-wepha020,
author = {R. Bourtembourg and G. Cuní and M. Di Carlo and G.A. Fatkin and S. James and L. Pivetta and J.L. Pons and S. Rubio-Manrique and C. Scafuri and G. Scalamera and A.I. Senchenko and V. Sitnov and G. Strangolino and P.V. Verdier and L. Zambon},
% author = {R. Bourtembourg and G. Cuní and M. Di Carlo and G.A. Fatkin and S. James and L. Pivetta and others},
% author = {R. Bourtembourg and others},
title = {{Pushing the Limits of Tango Archiving System using PostgreSQL and Time Series Databases}},
booktitle = {Proc. ICALEPCS'19},
pages = {1116--1121},
paper = {WEPHA020},
language = {english},
keywords = {TANGO, database, controls, SRF, distributed},
venue = {New York, NY, USA},
series = {International Conference on Accelerator and Large Experimental Physics Control Systems},
number = {17},
publisher = {JACoW Publishing, Geneva, Switzerland},
month = {08},
year = {2020},
issn = {2226-0358},
isbn = {978-3-95450-209-7},
doi = {10.18429/JACoW-ICALEPCS2019-WEPHA020},
url = {https://jacow.org/icalepcs2019/papers/wepha020.pdf},
note = {https://doi.org/10.18429/JACoW-ICALEPCS2019-WEPHA020},
abstract = {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.},
}