60 measurement systems in five locations

The Gist

The challenge

Facing intense price pressure, technological advances, and ever-shorter development and product lifecycles, Semikron needed to be able to archive quality data, trace material movement and delivery information throughout the production chain, and run multi-layered ad hoc analyses.

The solution

Exasol connects to five international Semikron locations and 60 measurement systems. Raw data from production systems is compiled, standardised, zipped, and made available for the central server in Germany, where it’s passed to the Exasol database and available at all times for queries and reports. The system at Semikron comprises 3+1 stand-alone computers (nodes), which are linked in a cluster and automatically distributed, allowing for optimal use of all hardware resources.

“With Exasol we are able to significantly optimise our business processes. Thanks to expanded data management and considerably faster data analysis, we can adjust to the high demands made by the market.”

Gerhard Zapf, Group Leader IT Applications, Semikron

Benefits

The benefits for Semikron

Evaluation times for standard analysis down from several days to a few hours

Uniform measurement and process data archive

Production and quality KPIs traced within prescribed storage periods

Ad hoc preventive analysis on measurement data at any time without information loss

Specialist departments can remain independent and create standard and ad hoc reports at the click of a button

Proof of production with all data available on one single component