Adding Value by Combining Business and Sensor Data: An Industry 4.0 Use Case

Abstract: Industry 4.0 and the Internet of Things are recent developments that have lead to the creation of new kinds of manufacturing data. Linking this new kind of sensor data to traditional business information is crucial for enterprises to take advantage of the data's full potential. In this paper, we present a demo which allows experiencing this data integration, both vertically between technical and business contexts and horizontally along the value chain. The tool simulates a manufacturing company, continuously producing both business and sensor data, and supports issuing ad-hoc queries that answer specific questions related to the business. In order to adapt to different environments, users can configure sensor characteristics to their needs.

• The paper demonstrates a novel data integration approach that synchronizes high-frequency sensor streams with traditional business data in Industry 4.0 environments.
• It utilizes a single-page application built with Scala and the Play framework and leverages an in-memory columnar database for real-time query processing.
• The simulation tool enables users to conduct SQL-based queries to analyze time-based sensor events and production metrics, informing smart manufacturing decisions.

Combining Business and Sensor Data for Industry 4.0

Introduction

The integration of business and sensor data within Industry 4.0 environments exemplifies a significant challenge and opportunity for contemporary manufacturing enterprises. As sensor technologies continue to mature, they generate massive streams of data, potentially revealing insightful correlations with conventional business data. The paper under review examines this data convergence challenge, introducing a demonstration tool to simulate and analyze data integration in an industrial setting.

Data Integration Challenges

The necessity for data integration arises from the divergence in the characteristics of business data (e.g., sales orders and inventory levels) and sensor data (e.g., temperature and vibration metrics). Vertical integration is emphasized, where the diverse formats and real-time characteristics of IoT data are synchronized with business data pipelines. Horizontal integration, in contrast, involves organizing consistent, homogeneous business data throughout the enterprise value chain. The complexities are compounded given that IoT data—from sources like injection molding machines producing terabytes daily—demands a discrete handling approach compared to business data.

System Architecture and Implementation

The developed system is constructed using the Play framework and Scala, manifesting as a single page application empowered by an in-memory columnar database for real-time data processing and querying. This architecture is designed to simulate a comprehensive manufacturing environment with both sensor and business data streams being readily configurable.

Figure 1: Entity Relationship Diagram in Crow's Foot Notation for the Business Data.

The central component of the simulation is the Entity Relationship Diagram, reflecting real-world Enterprise Resource Planning (ERP) systems, thereby enhancing the real-world applicability of the demo. It facilitates vertical integration through time-based correlations of sensor and business data, anchoring sensor events to specific production timelines.

Functional Capabilities and User Interaction

The tool's primary offering is in its simulation and querying capabilities within a synthetically generated industrial environment. Users can manipulate sensor configurations and issue SQL-based ad-hoc queries, exploring how sensor data impacts business processes and decision-making.

Figure 2: Screenshot a Selected Part of the Demo Application.

Illustrative queries, such as determining average temperatures on specific machines, showcase the system's potential to provide meaningful insights into operational efficiencies and product quality, thereby supporting strategic and operational decisions.

Conclusion

The implementation of this demo application contributes a practical perspective to the broader discourse on Industry 4.0 data integration strategies. By emulating real-world scenarios and offering a modifiable platform for experimentation, it stands to propel further scholarly and practical exploration in this domain. Anticipated future developments may extend functionality to integrate additional sensor types, further enhancing real-time analytics capabilities and application scalability for diverse industrial settings. This paper underscores the transformative potential of data integration, laying the groundwork for future advancements in smart manufacturing processes.