| 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
※ LaTeX
※ Text/Word
※ RIS
※ EndNote |
| 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 |
 Published 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. |
|
