Data acquisition for digitisation in the paraffin candle production process

  • Giedrius Blažiūnas Kauno kolegija Higher Education Institution
Keywords: digitisation, data acquisition, Python, Streamlit, MSSQL


By utilising digital technology, digitisation helps businesses streamline procedures, increase efficiency and cut costs. Moreover, it enables businesses to gather knowledge and make data-driven choices that enhance product quality, customers’ satisfaction, and market competitiveness. Data acquisition, which permits the collection and analysis of real-time data from equipment and processes, is a crucial component of the digitalisation of industrial automation. Predictive maintenance may, therefore, be utilised to decrease downtime, enhance quality control, and optimise operations. The paraffin candle production process is being discussed, and its key variables are being identified for the purpose of digitisation. The study proposes data collection and processing methods from a candle production line and uses an IoT-enabled controller to collect and analyse data. The PLC software that reads, processes, and saves data in a SQL database on a remote PC is then built based on these techniques. An MSSQL database is used to store information on process variables, including temperatures, cycle times, and downtimes, for the different candle production stages, including the paraffin preparation tank, extruder, and conveyor for cutting candles. The database acts as a storage location for the gathered information, which can then be utilised to analyse and improve the manufacturing process. Python and the open-source package Streamlit were used to provide a user-friendly interface for operators. The interface allows the user to select historical data for each item of equipment by time and relevant variables, and it shows the filtered data in an understandable graphical style. This allows the operator to evaluate the production process, spot trends, and optimise it. With the use of support and assistance technologies, the data may be used for decision-making in future.


Download data is not yet available.


Doyle F, Cosgrove J. (2019). Steps towards digitisation of manufacturing in an SME environment. Procedia Manufacturing, Volume 38, p. 540-547, ISSN 2351-9789.
Fusko M., Buckova M., Mar Krajcovic M., Svitek R., (2019). The strategy for implementation of the digitisation in factories, Transportation Research Procedia, Volume 40, p. 1045-1052, ISSN 2352-1465.
Klimecka-Tatar D., Ingaldi M., (2022). Digitization of processes in manufacturing SMEs - value stream mapping and OEE analysis, Procedia Computer Science, Volume 200, p. 660-668, ISSN 1877-0509.
Sudhoff M., Leineweber S., Linsinger M., Niemeyer J. F., Kuhlenkötter B., (2020). Objective data acquisition as the basis of digitisation in manual assembly systems, Procedia CIRP, Volume 93, p. 1176-1181, ISSN 2212-8271.
Paulus-Rohmer D., Schatton H., Bauernhansl T., (2016). Ecosystems, Strategy and Business odels in the age of Digitization - How the Manufacturing Industry is Going to Change its Logic, Procedia CIRP, Volume 57, p. 8-13, ISSN 2212-8271.
Siedler C., Sadaune S., Tafvizi Zavareh M., Eigner M., Zink K. J, Aurich J. C., (2019). Categorizing and selecting digitisation technologies for their implementation within different product lifecycle phases, Procedia CIRP, Volume 79, p. 274-279, ISSN 2212-8271.
Vernim S., Moritz Krauel M., Gunther Reinhart G., (2021). Identification of digitisation trends and use cases in assembly, Procedia CIRP, Volume 97, p.136-141, ISSN 2212-8271.
Jelena Milisavljevic-Syed J., Thames J.L., Schaefer D., (2020) The Digitization of Design and Manufacturing: A State-of-the-Art Report on the Transition from Strategic Vision to Implementation in Industry, Procedia CIRP, Volume 93, p. 575-580, ISSN 2212-8271.
Böhner J., Scholz M., Franke J., Sauer A., (2018). Integrating digitisation technologies into resource efficiency driven industrial learning environments, Procedia Manufacturing, Volume 23, p. 39-44, ISSN 2351-9789.
“Industry 4.0: Fourth Industrial Revolution Guide To Industrie 4.0”. 2020. I-SCOOP.
Joppen R., Tekaat J.L., Dr.-Ing. Kühn A., (2019). Identification and Structuring of Benefits and Expenses for Evaluating the Profitability of Investments in Digitization within Production, Procedia Manufacturing, Volume 33, p. 248-255, ISSN 2351-9789.
How to Cite
Blažiūnas, G. (2023). Data acquisition for digitisation in the paraffin candle production process. Mokslo Taikomieji Tyrimai Lietuvos Kolegijose, 1(19), 221-227.