Handbuch Industrie 4.0: Recht, Technik, Gesellschaft

Abstract

This paper proposes an user friendly Graphical User Interface (GUI) for data collection, maintaining databases and automated report generation processes. In recent years, the use of database has become more prevalent in almost every industry. However, the lack of technical knowledge in handling databases is common among most of the end users. More importantly, key data collection is a critical task while handling huge database research. This system makes the data collection process very simple by enabling the authorized users to update the database with Django Authentication System and also reduces the administrator’s load of frequently updating the database. Data generation includes tasks such as searching, focusing, monitoring, selecting, extracting, and capturing data. The proposed reporting software is more sophisticated and efficient in the reporting process than spreadsheets, from data entry to display. This application uses HTML and CSS in the user interface, JavaScript for interactivity, Microsoft’s MySQL for backend and Django web-framework for processing. With the combination of the above mentioned tools, the proposed system is successful in collecting, storing, manipulating and generating customized reports based on the user’s request. It is intelligent enough and has flexible methods to fetch data using dynamic SQL queries in generating reports with multiple parameters.