ALPLA 的工业 4.0

阿尔普拉

ALPLA是包装解决方案领域的全球领导者，为可口可乐、联合利华以及食品、饮料、化妆品和清洁行业的其他品牌生产高品质包装。 ALPLA 在 46 个国家的 181 个地点拥有 20,900 名员工。

随着生产机械复杂性的增加，每个工厂对训练有素的专家的需求也在增加。这带来了以下挑战：

1. 每个工厂的人员成本更高
2. 更难在每个地点招聘有经验的人才
3. 人员流动成本更高
4. 经验不足的操作员以次优方式运行机器，影响资源消耗和整体设备效率 (OEE)。

切换到 Crate 物联网数据平台：快 250 倍...

在了解了 Crate 物联网数据平台后，他们决定将项目迁移到 Crate。 Crate 物联网数据平台由 CrateDB 提供支持，专为 ALPLA 等物联网工作负载而构建，它之所以具有吸引力，原因如下：

1. SQL：轻松将数据和代码从 SQL Server 迁移到 Crate IoT Data Platform
2. 分布式：在廉价服务器的弹性集群上轻松且经济地扩展
3. 动态模式：允许 ALPLA 将所有 900 个不同的传感器读数组合到一个表中，以便于维护和更快地查询
4. 实时性能：缓存在内存中的列索引使 Crate IoT Data Platform 执行仪表板查询的速度比 SQL Server 快 250 倍（以毫秒为单位，而不是几分钟）。

• 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.

• 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