Designing Data-Intensive Application System for Production Plans Data Processing and Near Real-Time Analytics

In this work, benchmarking of production plan processing applications based on data storage and analytics solutions using open source technologies was performed. The functional and component architecture of a digital framework for processing production plan files is presented, with special attention to the performance analysis of data processing based on the measurement of processing time for each data volume and memory used. The proposed architecture of the application system consists of digital services, including the downloading data from hundreds of production plan files, processing these files, converting them into JSON objects and inserting SQL into an in-memory database for real-time queries, where they are analyzed using KPI -based methods. The proposed system allows processing and analyzing production plans almost in real time, which enables decision makers to check and monitor the status of production plans in real time and take the necessary actions on demand and on time. The proposed digital framework was tested on data collected from real production plans of a truck manufacturing company.