PRODUCTION MACHINE INFORMATION SYSTEM BASED ON TECHNOLOGY GROUP IN RELATIONAL DATABASE ENVIRONMENT

Ahmad Farhan, Yeni Sumantri, Purnomo Budi Santoso

Abstract


The world is entering industry 4.0. The digital enlarges to machine maintenance known as troubleshooting. Troubleshooting is a series of actions needed to deal with machine damage treatment. Problems that often occur in troubleshooting are that technicians are not in the location, the information is still in the form of printed books, the risk of books being lost, books slipping, and the location of books far from the location of machine failure. This research was to solve this problem by developing an application called Production Machine Troubleshooting Information System (SITMEP) in relational database environment. This system was developed by integrating several methods such as machine damage knowledge obtained from tacit sourced from mechanical technicians, experts in their fields and explicit knowledge sourced from machine manual books. GT is to combine knowledge with machine hierarchies and it supports systems for database and SQL. The tool used was MS Access with VBA.


Keywords


System Information, Maintenance, Group Technology, Knowledge Management, Database, Microsoft Access

Full Text:

PDF

References


F. Chiarello, L. Trivelli, A. Bonaccorsi, and G. Fantoni, “Extracting and mapping industry 4.0 technologies using wikipedia,” Comput. Ind., vol. 100, pp. 244–257, 2018.

V. Roblek, M. Meško, and A. Krapež, “A complex view of industry 4.0,” Sage Open, vol. 6, no. 2, p. 2158244016653987, 2016.

T. Borgi, A. Hidri, B. Neef, and M. S. Naceur, “Data analytics for predictive maintenance of industrial robots,” in 2017 International Conference on Advanced Systems and Electric Technologies (IC_ASET), 2017, pp. 412–417.

E. Rauch, C. Linder, and P. Dallasega, “Anthropocentric perspective of production before and within Industry 4.0,” Comput. Ind. Eng., vol. 139, p. 105644, 2020.

K. Henning, “Recommendations for implementing the strategic initiative INDUSTRIE 4.0,” 2013.

S. Wang, J. Wan, D. Li, and C. Zhang, “Implementing smart factory of industrie 4.0: an outlook,” Int. J. Distrib. Sens. networks, vol. 12, no. 1, p. 3159805, 2016.

L. S. Dalenogare, G. B. Benitez, N. F. Ayala, and A. G. Frank, “The expected contribution of Industry 4.0 technologies for industrial performance,” Int. J. Prod. Econ., vol. 204, pp. 383–394, 2018.

T. Stock, M. Obenaus, S. Kunz, and H. Kohl, “Industry 4.0 as enabler for a sustainable development: A qualitative assessment of its ecological and social potential,” Process Saf. Environ. Prot., vol. 118, pp. 254–267, 2018.

L. Xiao, S. Song, X. Chen, and D. W. Coit, “Joint optimization of production scheduling and machine group preventive maintenance,” Reliab. Eng. Syst. Saf., vol. 146, pp. 68–78, 2016.

D. J. Smith, “Power-by-the-hour: the role of technology in reshaping business strategy at Rolls-Royce,” Technol. Anal. Strateg. Manag., vol. 25, no. 8, pp. 987–1007, 2013.

A. A. Mendes and J. L. D. Ribeiro, “Establishment of a maintenance plan based on quantitative analysis in the context of RCM in a JIT production scenario,” Reliab. Eng. Syst. Saf., vol. 127, pp. 21–29, 2014.

A. R. Siregar, “Manajemen Pengetahuan: Perspektif Pustakawan,” PUSTAHA, vol. 1, no. 1, pp. 2–6, 2005.

P. Carrillo, H. Robinson, A. Al-Ghassani, and C. Anumba, “Knowledge management in UK construction: Strategies, resources and barriers,” Proj. Manag. J., vol. 35, no. 1, pp. 46–56, 2004.

S. S. Rao and A. Nayak, “ENTERPRISE ONTOLOGY MODEL FOR TACIT KNOWLEDGE EXTERNALIZATION IN SOCIO-TECHNICAL ENTERPRISES.,” Interdiscip. J. Information, Knowl. Manag., vol. 12, 2017.

E. A. Smith, “The role of tacit and explicit knowledge in the workplace,” J. Knowl. Manag., vol. 5, no. 4, pp. 311–321, 2001.

T. L. Johnson, S. R. Fletcher, W. Baker, and R. L. Charles, “How and why we need to capture tacit knowledge in manufacturing: Case studies of visual inspection,” Appl. Ergon., vol. 74, pp. 1–9, 2019.

J. L. Burbidge, The introduction of group technology. Halsted Press, 1975.

J. L. Neves and R. Bordawekar, “Demonstrating AI-enabled SQL Queries over Relational Data using a Cognitive Database,” Knowl. Discov. Data Min., 2018.

R. McFadyen, Relational databases and microsoft access. Ron McFadyen, 2016.

M. MacDonald, Access 2010: The missing manual. “ O’Reilly Media, Inc.,” 2010.

I. Sommerville, Software Engineering GE. Pearson Australia Pty Limited, 2016.


Refbacks

  • There are currently no refbacks.


Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.