MACHINERY MAINTENANCE DATABASE SYSTEM FOR LARGE ELECTRICAL EQUIPMENT TRANSPORTATION Articles
Article Sidebar
Main Article Content
Abstract
This research aims to develop a maintenance database system for machinery used in the transportation of large electrical equipment by utilizing system analysis and design, data flow analysis, and Google Appsheet. The database system is divided into four sections: a section for storing data within the machinery maintenance department, a section for work preparation to assign machinery and personnel, a section for storing inspection and maintenance data, and a section for data display. The developed database system was then implemented and compared with various operational times to verify its effectiveness in improving machinery inspection and
maintenance processes. The research findings indicate that the developed database system significantly supports maintenance work for machinery used in the transportation of large electrical equipment. This is evidenced by the average document retrieval time of 0.53 minutes, which represents a 66.88% reduction from the previous time. The average history screening time was 0.61 minutes, a 94.85% reduction from the previous time. The average evaluation time for maintenance work was 2.26 minutes, a 43.78% reduction from the previous time. When comparing the times before and after the implementation of the database system using a t-test, the results showed a statistically significant reduction in all measured times, as the t-test values were lower than the critical values, and the p-values were below the significance level in all cases. Additionally, the developed database system eliminates errors in searching, screening, evaluating, and storing data. It also generates reports, which are beneficial for decision-making in future work, providing clear and reliable reference data
Article Details
This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.
This article is published and copyrighted by the Science and Technology Journal. South East Bangkok College
References
A. Banerjee, E. Duflo, and N. Qian, "On the road: Access to transportation infrastructure and economic growth in China," Journal of Development Economics, vol. 145, pp. 102442, 2020.
P. Taetong and N. Bumrungkiat, "Database system for managing spare parts inventory and predicting order quantities using mathematical techniques: A case study of an industrial enterprise in Lopburi," Journal of Rajabhat Lampang University, vol. 11, no. 1, pp. 76-88, Jan.–Jun. 2022.
J. Phapwadee and A. Kaengphol, "Development of a database management program for recording maintenance data of computers and equipment: A case study of an electronics company," King Mongkut's University of Technology North Bangkok Journal of Academic Studies, vol. 30, no. 3, pp. 432-442, Jul.–Sep. 2020.
S. Phichai et al., "The inventory system for equipment at the Faculty of Science and Technology, Loei Rajabhat University," Journal of Applied Information Technology, vol. 9, no. 2, pp. 31-43, Jul.–Dec. 2023.
P. Poolsawat et al., "An application for recording health check-up data," Journal of Science, Engineering, and Technology, Loei Rajabhat University, vol. 3, no. 1, pp. 77-87, Jan.–Jun. 2023.
C. Buaprom and T. Phannikul, "Design and development of an application for a recycling waste collection business," Journal of Engineering and Innovation, vol. 16, no. 1, pp. 64-78, Jan.–Mar. 2023.
K. Chaiwaree et al., "Development of an application for collecting machinery inspection data in the manufacturing process: A case study of a cassava flour production and export company in Kalasin province," Journal of Engineering and Industrial Technology, Kalasin University, vol. 2, no. 3, pp. 37-48, May–Jun. 2024.
L. Pinciroli, P. Baraldi, and E. Zio, "Maintenance optimization in industry 4.0," Reliability Engineering & System Safety, vol. 234, pp. 109204, 2023.
I. Roda and M. Macchi, "Maintenance concepts evolution: A comparative review towards advanced maintenance conceptualization," Computers in Industry, vol. 133, pp. 103531, 2021.
T. Taipalus, "Database management system performance comparisons: A systematic literature review," Journal of Systems and Software, vol. 208, pp. 111872, 2024.
W. Meethom and N. Koohathongsumrit, "A decision support system for road freight transportation route selection with new fuzzy numbers," Foresight, vol. 22, no. 4, pp. 505-527, 2020.
N. Kooathongsamrit and W. Chanthakam, "Development of a decision support system for selecting road transportation routes with fuzzy multi-criteria decision-making methods," Thai Journal of Operational Research, vol. 10, no. 2, pp. 1-23, Jan.–Mar. 2022.
C. Evarist, V. M.G. Luvara, and N. Chileshe, "Perception on constraining factors impacting recruitment and selection practices of building contractors in Dar Es Salaam, Tanzania," International Journal of Construction Management, vol. 23, no. 12, pp. 2012-2023, 2023.
