Author: Scafuri, C.
Paper Title Page
WEPHA020 Pushing the Limits of Tango Archiving System using PostgreSQL and Time Series Databases 1116
 
  • R. Bourtembourg, S. James, J.L. Pons, P.V. Verdier
    ESRF, Grenoble, France
  • G. Cuní, S. Rubio-Manrique
    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
  
  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.
https://timescale.com 		 
poster icon Poster WEPHA020 [1.609 MB]  
DOI • reference for this paper ※ https://doi.org/10.18429/JACoW-ICALEPCS2019-WEPHA020  
About • paper received ※ 30 September 2019       paper accepted ※ 02 November 2019       issue date ※ 30 August 2020  
Export • reference for this paper using ※ BibTeX, ※ LaTeX, ※ Text/Word, ※ RIS, ※ EndNote (xml)