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.


https://doi.org/10.18429/JACoW-ICALEPCS2019-WEPHA020
Title Pushing the Limits of Tango Archiving System using PostgreSQL and Time Series Databases
Authors
  • R. Bourtembourg, S. James, J.L. Pons, P.V. Verdier
    ESRF, Grenoble, France
  • G. Cuní, S. Rubio-Manriquepresenter
    ALBA-CELLS Synchrotron, Cerdanyola del Vallès, Spain
  • M. Di Carlo
    INAF - OAAB, Teramo, Italy
  • G.A. Fatkin, A.I. Senchenko, V. Sitnov
    NSU, Novosibirsk, Russia
  • G.A. Fatkin, A.I. Senchenko, V. Sitnov
    BINP SB RAS, Novosibirsk, Russia
  • L. Pivetta, C. Scafuri, G. Scalamera, G. Strangolino, L. Zambon
    Elettra-Sincrotrone Trieste S.C.p.A., Basovizza, Italy
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.
Footnotes & References https://timescale.com
Paper download WEPHA020.PDF [0.651 MB / 6 pages]
Poster download WEPHA020_POSTER.PDF [1.609 MB]
Export download ※ BibTeX LaTeXText/WordRISEndNote
Conference ICALEPCS2019
Series International Conference on Accelerator and Large Experimental Physics Control Systems (17th)
Location New York, NY, USA
Date 05-11 October 2019
Publisher JACoW Publishing, Geneva, Switzerland
Editorial Board Karen S. White (ORNL, Oak Ridge, TN, USA); Kevin A. Brown (BNL, Upton, NY, USA); Philip S. Dyer (BNL, Upton, NY, USA); Volker RW Schaa (GSI, Darmstadt, Germany)
Online ISBN 978-3-95450-209-7
Online ISSN 2226-0358
Received 30 September 2019
Accepted 02 November 2019
Issue Date 30 August 2020
DOI doi:10.18429/JACoW-ICALEPCS2019-WEPHA020
Pages 1116-1121
Copyright
Creative Commons CC logoPublished by JACoW Publishing under the terms of the Creative Commons Attribution 3.0 International license. Any further distribution of this work must maintain attribution to the author(s), the published article's title, publisher, and DOI.