ICALEPCS2019 - List of Authors (Strangolino, G.)

Paper	Title	Page
WEDPR01	Cumbia: Graphical Libraries and Formula Plugin to Combine and Display Data from Tango, EPICS and More	971
	G. Strangolino Elettra-Sincrotrone Trieste S.C.p.A., Basovizza, Italy
	Cumbia libraries offer the next generation core (C++) and graphical (Qt) software to write complete and lightweight applications that provide a unified user interface, regardless of the underlying engine (Tango, EPICS, WebSocket, …) With the new formula plugin, results can be manipulated and combined by JavaScript functions and displayed in the appropriate widget. Qt has a deep JavaScript integration that allows efficient introduction of program logic into the application. Using the Qt + QML technologies, apps can be designed for the desktop and mobile devices. Switching between the two targets is an immediate operation. A WebSocket based service* has been used to test Qt + QML mobile applications on portable devices. It makes it possible to connect to Tango and EPICS without their installation. A new tool called "la-cumparsita" lets non-programmers use the Qt designer to realize complete applications ready to communicate with the control system in use: Tango, EPICS or any other abstraction framework (e.g. WebSocket). These apps seamlessly integrate with the desktop. Most demanding users can integrate JavaScript functions and use them as data sources for the GUI elements. *The "canoned" service. It is part of the PWMA project (GPL3 LICENSE) and exposes a WebSocket interface.
	Slides WEDPR01 [2.933 MB]
DOI •	reference for this paper ※ https://doi.org/10.18429/JACoW-ICALEPCS2019-WEDPR01
About •	paper received ※ 30 September 2019 paper accepted ※ 09 October 2019 issue date ※ 30 August 2020
Export •	reference for this paper using ※ BibTeX, ※ LaTeX, ※ Text/Word, ※ RIS, ※ EndNote (xml)

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 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)

WEPHA097	Development of a Tango Interface for the Siemens-Based Control System of the Elettra Infrastructure Plants	1321
	P. Michelini, I. Ferigutti, F. Giacuzzo, M. Lonza, G. Scalamera, G. Strangolino, M. Trevi Elettra-Sincrotrone Trieste S.C.p.A., Basovizza, Italy
	The control system of the Elettra Sincrotrone Trieste infrastructure plants (cooling water, air conditioning, electricity, etc.) consists of several Siemens PLCs connected by an Ethernet network and a number of management stations running the Siemens Desigo software for high-level operation and monitoring, graphical display of the process variables, automatic alarm distribution and a wide range of different data analysis features. No external interface has been realized so far to connect Desigo to the Elettra and FERMI accelerator control systems based on Tango, making it difficult for the control room operators to monitor the conventional plant operation and parameters (temperature, humidity, water pressure, etc.), which are essential for the accelerator performance and reliability. This paper describes the development of a dedicated Desigo application to make selected process variables externally visible to a specific Tango device server, which then enables the use of all the tools provided by this software framework to implement graphical interfaces, alarms, archiving, etc. New proposals and developments to expand and improve the system are also discussed.
DOI •	reference for this paper ※ https://doi.org/10.18429/JACoW-ICALEPCS2019-WEPHA097
About •	paper received ※ 30 September 2019 paper accepted ※ 09 October 2019 issue date ※ 30 August 2020
Export •	reference for this paper using ※ BibTeX, ※ LaTeX, ※ Text/Word, ※ RIS, ※ EndNote (xml)

WEPHA148	Cumbia-Telegram-Bot: Use Cumbia and Telegram to Read, Monitor and Receive Alerts From the Control Systems	1441
	G. Strangolino Elettra-Sincrotrone Trieste S.C.p.A., Basovizza, Italy
	Telegram is a cloud-based mobile and desktop messaging app focused on security and speed. It is available for Android, iPhone/iPad, Windows, macOS, Linux and as a web application. The user signs in the cumbia-telegram bot to chat with a Tango or EPICS control system from everywhere. One can read and monitor values, as well as receive alerts when something special happens. Simple source names or their combination into formulas can be sent to the bot. It replies and notifies results. It is simple, fast, intuitive. A phone number to register with telegram and a client are the necessary ingredients. On the server side, cumbia-telegram provides the administrator with full control over the allocation of resources, the network load and the clients authorized to chat with the bot. Additionally, the access to the systems is read only. On the client side, the bot has been meticulously crafted to make interaction easy and fast: history, bookmarks and alias plugins pare texting down to the bone. Preferred and most frequent operations are accessible by simple taps on special command links. The bot relies on modules and plugins, that make the application extensible.
DOI •	reference for this paper ※ https://doi.org/10.18429/JACoW-ICALEPCS2019-WEPHA148
About •	paper received ※ 30 September 2019 paper accepted ※ 10 October 2019 issue date ※ 30 August 2020
Export •	reference for this paper using ※ BibTeX, ※ LaTeX, ※ Text/Word, ※ RIS, ※ EndNote (xml)

Paper

Title

Page

Cumbia: Graphical Libraries and Formula Plugin to Combine and Display Data from Tango, EPICS and More

971

G. Strangolino
Elettra-Sincrotrone Trieste S.C.p.A., Basovizza, Italy

Cumbia libraries offer the next generation core (C++) and graphical (Qt) software to write complete and lightweight applications that provide a unified user interface, regardless of the underlying engine (Tango, EPICS, WebSocket, …) With the new formula plugin, results can be manipulated and combined by JavaScript functions and displayed in the appropriate widget. Qt has a deep JavaScript integration that allows efficient introduction of program logic into the application. Using the Qt + QML technologies, apps can be designed for the desktop and mobile devices. Switching between the two targets is an immediate operation. A WebSocket based service* has been used to test Qt + QML mobile applications on portable devices. It makes it possible to connect to Tango and EPICS without their installation. A new tool called "la-cumparsita" lets non-programmers use the Qt designer to realize complete applications ready to communicate with the control system in use: Tango, EPICS or any other abstraction framework (e.g. WebSocket). These apps seamlessly integrate with the desktop. Most demanding users can integrate JavaScript functions and use them as data sources for the GUI elements.
*The "canoned" service. It is part of the PWMA project (GPL3 LICENSE) and exposes a WebSocket interface.

Slides WEDPR01 [2.933 MB]

DOI •

reference for this paper ※ https://doi.org/10.18429/JACoW-ICALEPCS2019-WEDPR01

About •

paper received ※ 30 September 2019 paper accepted ※ 09 October 2019 issue date ※ 30 August 2020

Export •

reference for this paper using ※ BibTeX, ※ LaTeX, ※ Text/Word, ※ RIS, ※ EndNote (xml)

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 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)

WEPHA097

Development of a Tango Interface for the Siemens-Based Control System of the Elettra Infrastructure Plants

1321

P. Michelini, I. Ferigutti, F. Giacuzzo, M. Lonza, G. Scalamera, G. Strangolino, M. Trevi
Elettra-Sincrotrone Trieste S.C.p.A., Basovizza, Italy

The control system of the Elettra Sincrotrone Trieste infrastructure plants (cooling water, air conditioning, electricity, etc.) consists of several Siemens PLCs connected by an Ethernet network and a number of management stations running the Siemens Desigo software for high-level operation and monitoring, graphical display of the process variables, automatic alarm distribution and a wide range of different data analysis features. No external interface has been realized so far to connect Desigo to the Elettra and FERMI accelerator control systems based on Tango, making it difficult for the control room operators to monitor the conventional plant operation and parameters (temperature, humidity, water pressure, etc.), which are essential for the accelerator performance and reliability. This paper describes the development of a dedicated Desigo application to make selected process variables externally visible to a specific Tango device server, which then enables the use of all the tools provided by this software framework to implement graphical interfaces, alarms, archiving, etc. New proposals and developments to expand and improve the system are also discussed.

DOI •

reference for this paper ※ https://doi.org/10.18429/JACoW-ICALEPCS2019-WEPHA097

About •

paper received ※ 30 September 2019 paper accepted ※ 09 October 2019 issue date ※ 30 August 2020

Export •

reference for this paper using ※ BibTeX, ※ LaTeX, ※ Text/Word, ※ RIS, ※ EndNote (xml)

WEPHA148

Cumbia-Telegram-Bot: Use Cumbia and Telegram to Read, Monitor and Receive Alerts From the Control Systems

1441

G. Strangolino
Elettra-Sincrotrone Trieste S.C.p.A., Basovizza, Italy

Telegram is a cloud-based mobile and desktop messaging app focused on security and speed. It is available for Android, iPhone/iPad, Windows, macOS, Linux and as a web application. The user signs in the cumbia-telegram bot to chat with a Tango or EPICS control system from everywhere. One can read and monitor values, as well as receive alerts when something special happens. Simple source names or their combination into formulas can be sent to the bot. It replies and notifies results. It is simple, fast, intuitive. A phone number to register with telegram and a client are the necessary ingredients. On the server side, cumbia-telegram provides the administrator with full control over the allocation of resources, the network load and the clients authorized to chat with the bot. Additionally, the access to the systems is read only. On the client side, the bot has been meticulously crafted to make interaction easy and fast: history, bookmarks and alias plugins pare texting down to the bone. Preferred and most frequent operations are accessible by simple taps on special command links. The bot relies on modules and plugins, that make the application extensible.

DOI •

reference for this paper ※ https://doi.org/10.18429/JACoW-ICALEPCS2019-WEPHA148

About •

paper received ※ 30 September 2019 paper accepted ※ 10 October 2019 issue date ※ 30 August 2020

Export •

reference for this paper using ※ BibTeX, ※ LaTeX, ※ Text/Word, ※ RIS, ※ EndNote (xml)