Success Story Dillinger

Prior to shipping, every plate is submitted to inspection in accordance with the customer’s specifications. Non-destructive testing, such as surface inspection, geometrical and dimensional checks and ultrasonic inspection, is performed on the plate itself during the flow of production..

Unlike many manufacturing processes there is no “bill of materials” that describes how the final product is assembled from smaller components. Actually, it is the other way around. Steel plates are produced from a huge bucket of liquid iron, called “heat”, which is formed, cut, rolled and cut again until the plates are ready.

Figure 1: Overview of the steel production process at Dillinger

INITIAL SITUATION During the described process, Dillinger collects a vast amount of data from sensors and operational data sources. For example, data about orders and their parameters, basic data on products and intermediate products, chemical analysis results and measurement data is collected on a regular basis. This data is aggregated and stored in Dillinger’s technical data warehouse. However, that “warehouse” was never designed as a data warehouse as such but it is “historically grown” meaning researchers and technologists from different departments needed various evaluations and over twenty man-years, solutions were built, successfully fulfilling their requirements. The result is a conglomerate of over a hundred ETL applications based on a variety of technologies. The majority of the applications are written in Java but there are also ETL jobs in third-party ETL tools as well as database views based on replications of production data. The reporting methods included Java programmes and Visual Basic applications mainly.

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

3/13

Powered by