Crate.io > Case Studies > Industry 4.0 at ALPLA: Enhancing Factory Efficiency with IoT

Industry 4.0 at ALPLA: Enhancing Factory Efficiency with IoT

Crate.io Logo
 Industry 4.0 at ALPLA: Enhancing Factory Efficiency with IoT - IoT ONE Case Study
Technology Category
  • Analytics & Modeling - Machine Learning
  • Infrastructure as a Service (IaaS) - Cloud Computing
Applicable Industries
  • Equipment & Machinery
  • Packaging
Applicable Functions
  • Human Resources
  • Maintenance
Use Cases
  • Personnel Tracking & Monitoring
  • Real-Time Location System (RTLS)
Services
  • Testing & Certification
The Challenge
ALPLA, a global leader in packaging solutions, faced several challenges as the complexity of their production machinery increased. The need for highly trained specialists in each factory led to higher personnel costs, difficulties in recruiting experienced talent at each location, and costly personnel turnover. Furthermore, less experienced operators running the machines sub-optimally impacted resource consumption and overall equipment effectiveness (OEE). ALPLA also faced the challenge of monitoring visual inspection systems in every line of their plants, which was almost impossible to do manually. In 2016, ALPLA decided to use data from the 900 different types of embedded sensors in each factory to address these issues. However, their initial choice of SQL Server as the data store for the sensor data proved inadequate, as it was unable to cope with their data requirements.
The Customer
About The Customer
ALPLA is a world leader in the area of packaging solutions, producing high-quality packaging for renowned brands such as Coca-Cola and Unilever, as well as other brands in the food, drinks, cosmetics, and cleaning industries. The company employs 20,900 employees at 181 locations across 46 countries. As a global leader, ALPLA is committed to innovation and efficiency in its operations, and is constantly seeking ways to improve its production processes and reduce costs. The company's move to leverage IoT technology to enhance its factory efficiency is a testament to its forward-thinking approach and commitment to operational excellence.
The Solution
ALPLA switched to CrateDB, a solution perfectly suited for IoT workloads. CrateDB offered several advantages including easy migration of data and code from SQL Server, a dynamic schema that allowed ALPLA to combine all their 900 different sensor readings into a single table for easier maintenance and faster querying, and easy and economical scaling on elastic clusters of inexpensive servers. Most importantly, CrateDB's real-time performance, enabled by columnar indexes cached in memory, allowed the solution to execute dashboard queries 250x faster than SQL Server. ALPLA integrated sensor data from multiple factories and production lines into a central 'mission control', staffed by experts who monitored production via interactive dashboards. These centralized experts could give direction to less experienced, lower-cost factory workers, thereby improving efficiency.
Operational Impact
  • The switch to CrateDB and the establishment of a centralized mission control led to significant improvements in ALPLA's operations. The company was able to lower personnel costs by requiring fewer experts at each factory location. The centralized mission control enabled immediate insight and control over production processes, replacing next-day quality reporting with real-time monitoring. This also allowed for cross-plant analysis, providing new insights that could be used to further improve operations. Overall, the solution improved ALPLA's overall equipment effectiveness (OEE), leading to more efficient and cost-effective operations.
Quantitative Benefit
  • Real-time performance of CrateDB enabled dashboard queries to execute 250x faster than SQL Server
  • Data from 900 different types of embedded sensors in each factory was combined into a single table for easier maintenance and faster querying
  • Centralized mission control allowed for continuous 24x7 monitoring of production efficiency

Case Study missing?

Start adding your own!

Register with your work email and create a new case study profile for your business.

Add New Record

Related Case Studies.

Contact us

Let's talk!
* Required
* Required
* Required
* Invalid email address
By submitting this form, you agree that IoT ONE may contact you with insights and marketing messaging.
No thanks, I don't want to receive any marketing emails from IoT ONE.
Submit

Thank you for your message!
We will contact you soon.