Success Story Dillinger

VISUALIZATION OF MEASUREMENT DATA For years, the quality assurance department in the steel mill worked with a Java application that displayed the process data of the secondary metallurgy and also showed the associated measured values. The task was to deliver a new data basis and to implement the presentation. While the process data could be displayed well, the measured values presented some challenges. There were twelve measurement points per vacuum system and a total of over one-hundred- thousand treatments. The roughly 50GBs of measurement data was compressed, so that had to be interpolated for displaying. That said, holding the complete set of measurements in memory was not possible with the dashboard application. In addition, fetching data according to a selection is very limited in scope. Although it was possible to interpolate within the visualization, it was not possible to have the different graphs synchronized to the same starting and end point. After evaluating multiple approaches, the team at Dillinger decided to move the measurement data to a PostgreSQL database with Timescale. Instead of showing the graphs in the dashboard application, they called an Angular application that only sends one request to Timescale per treatment. OUTCOMES Scalefree supported the project at Dillinger with three consultants in the first phase of the project. This phase was characterized by the empowerment of the internal staff and project organization by the Scalefree consultants. In the second phase, Scalefree supported the team in a more strategic and advisory role. Dillinger integrated the two largest source systems for production data, the steel mill and rolling mill database, modeled the central business objects and generated ETL routes from models. They were able to provide the desired KPIs of the two subprojects on a fully historicized data basis with a loading frequency of under two hours on a single node system. Nicolas Fritz points out: “One of the most important goals was to enable the internal team to independently expand the warehouse. And I am proud to say that together with Scalefree we achieved this goal.”

Scalefree’s support ended at the beginning of 2020, and since then, Dillinger has

● Implemented several technical projects for research and development ● Established supply for myEService, a way for Dillinger’s customers to receive timely information about the production status of their orders. ● Connected further source systems, among others also with ActiveMQ ● Implemented numerous optimizations in their business logic ● Replicated a source system to relieve the productive system with user requests ● Installed two monitoring solutions: Nagios for current problems and Grafana with Prometheus for longterm

Made of Steel - Data Vault 2.0 at Dillinger | Scalefree International GmbH

10/13

Powered by