JCOP FWWG, 1 October 2024
NextGen Archiver
Present:
Sergey Shkarovskiy, Piero Giorgio Verdini, Georgios Leventis, Piotr Golonka (chair), Rafal Kulaga (presenter), Luis GC, Luis Miguens Fernandez, Martin Zemko, Peter Bond, Geraldine Thomas, Antonin Kveton (presenter), Pavel Fiala, Clara Gaspar, Ivan Shvetsov, Mateusz Lechman, Adrien Ledeul, Vazquez, Cristina, Wassef, Paris Moschovakos, Mariusz Suder, Fernando Varela, Raul Jimenez Estupinan, Lukasz Goralczyk, Soham Biswas
Welcome to Martin, new member of the NGA Team!
After Rafal's and Antonin's presentation, the following points were discussed:
- LukaszG: clarify what does it mean "support Oracle as long as necessary". Is there any internal date for moving away from Oracle in the long term? If , e.g. SCADA AppSvc would not ever like to move out of Oracle, will it be possible to keep supporting the systems that are archiving to Oracle
- Fernando responded: as long as we may rely on ITDBs service there is no need to move away from Oracle, unless there would be some other dependencies e.g. on the ETM side
- Rafal clarified that the concept of NGA was to separate BE and FE, hence such dependency on ETM is effectively prevented and it will be up to CERN to support the Oracle backend
- Paris (ATLAS): ATLAS starts a prototype of storing some (non-WinCCOA) DCS data into TimescaleDB and would be very much interested in getting advises from the CERN NGA Team, and draw from their experience.
- Rafal ressponded he will be happy to help. One should avoid overlap with the NGA's TimescaleDB though, and for the WinCC OA data it is the NGA that should be used. Happy to share experience with schema design for the other part, etc.
- Paris: would it be possible to "offload" (migrate) existing data from Oracle to TimescaleDB
- Rafal explained that this has already been discussed internally, and even though the amount of data is not small, it is certainly *reasonable* with the computing/storage we have available these days. Actually, an internal tool for such transfer has already been developed by Rafal - it was used to extract real data from the SCADAR database and transfer to TimescaleDB to measure how effective the data compression features of timescaledb are.
- Rafal added that even though the details of a contract between CERN and TimescaleDB are not known at the moment, employing TimescaleDB to ambitous CERN use cases would be very interesting for the TimescaleDB company as well as IT/DB (with positive impact on the contract / collaborarion / etc), hence the projects such as the one of ATLAS would be very interesting.
Others:
- Mariusz: Patch P014 released by ETM last week; will be repackaged with the brand-new implementation of CtrlRDBAccess and made available for testing before the end of this week. P014 seems to contain some fixes for OPC-UA and S7 drivers, as well as some minor fixes for the RDB Archiver.
- Mariusz finalizing the release of NGTrending - should be available close to the end of this week
- will be presented at the next JCOP FWWG
- Piotr: new core will be released alongside NGTrending (because NGTrending needs its new features).
- FwConfigs support for Delayed Alarms
- Technical Preview of mechanism for UX theming
- possible topic for the JCOP FWWG in 4-6 weeks
- Piotr: Next FWWG in 2 weeks on the topic of the web dashboarding tools in WinCC OA
There are minutes attached to this event.
Show them.