Rancangan Sistem Informasi Berbasis Web Untuk Mengatasi Perbaikan Mesin Menggunakan Group Tecnologhy

  • Ahmad Farhan Universitas Brawijaya Malang
  • Yeni Sumantri Universitas Brawijaya Malang
  • Purnama Budi Santoso Universitas Brawijaya Malang
Abstract views: 595 , PDF downloads: 312
Keywords: Perawatan, Sistem Informasi, Group Technology

Abstract

Abstrak

Objektif. Dunia memasuki revolusi industri 4.0 yang ditandai dengan era digitalisasi. Digitalisasi juga merambah ke ilmu perawatan mesin, salah satunya adalah dalam hal troubleshooting (TS). TS adalah serangkaian tindakan yang diperlukan untuk menangani kerusakan yang terjadi pada mesin. Permasalahan yang sering timbul pada TS adalah: teknisi belum tentu ada dilokasi setiap saat, buku manual TS suatu mesin masih berupa buku cetak yang berisiko : buku hilang, buku keselip, dan letak buku jauh dari lokasi kerusakan mesin. Riset ini berusaha mengatasi permasalahan ini dengan cara mengembangkan aplikasi yang disebut Sistem Informasi Troubleshooting Mesin Produksi (SITMEP).

Metode. Metode penelitian untuk membuat SITMEP dikembangkan dengan cara mengintegrasikan beberapa ilmu seperti: Group Technology (GT) untuk membantu merancang arsitektur database SITMEP, database relasional untuk membangun sistem database SITMEP, dan bahasa Structured Query Language (SQL) untuk mempercepat pencarian cara TS yang tepat.

Hasil. Sebagai hasil penelitian adalah arsitekstur SITMEP dalam bentuk Entity Relation Diagram (ERD). Atas dasar ERD ini dapat dikembangkan menjadi sistem basis data SITMEP. Selanjutnya dikembangkan statmen SQL untuk mempermudah proses pencarian TS komponen yang rusak. Dengan menggunakan database management system (DBMS) dan Ms.Access 2016. Kesimpulan. SITMEP dapat di tempatkan di website perusahaan yang menggunakannya.

Aplikasi SITMEP diletakkan di web agar dapat diakses oleh siapa saja, kapan saja, dan dimana saja. Tools yang digunakan adalah Microsoft Acces beserta Visual Basic for Application (VBA) adapun langkah selanjutnya aplikasi dapat digunakan dan dikembangkan di banyak mesin industri.

Abstrack

Objective. The world entered the 4.0 industrial revolution marked by the era of digitalization. Digitalisation also extends to the science of machine maintenance, one of which is in terms of troubleshooting (TS). TS is a series of actions needed to deal with damage that occurs in the engine. Problems that often arise in the TS are: technicians are not necessarily in the location all the time, the TS manual of a machine is still a printed book at risk: books are missing, books are slipped, and the books are far from the location of damage to the machine. This research seeks to overcome this problem by developing an application called the Production Machine Troubleshooting Information System (SITMEP).

Methods. The research method to create SITMEP was developed by integrating a number of sciences such as: Group Technology (GT) to help design the SITMEP database architecture, relational databases to build a SITMEP database system, and Structured Query Language (SQL) language to speed up the search for the right TS method.

Results. As a result of the research is the architecture of SITMEP in the form of Entity Relations Diagram (ERD). On the basis of this ERD it can be developed into a SITMEP database system. Then the SQL statement was developed to simplify the process of finding TS damaged components. By using a database management system (DBMS) and Ms.Access 2016.

Conclusion. SITMEP can be placed on the website of the company that uses it. The SITMEP application is placed on the web so that it can be accessed by anyone, anytime, and anywhere. The tools used are Microsoft Access along with Visual Basic for Application (VBA). As for the next step, the application can be used and developed in many industrial machines.

Downloads

Download data is not yet available.

References

Alebrant Mendes, A. and Ribeiro, J. L. D. (2014). Establishment of a maintenance plan based on quantitative analysis in the context of RCM in a JIT production scenario. Reliability Engineering and System Safety, 127:21–29

Chiarello, F., Trivelli, L., Bonaccorsi, A., & Fantoni, G. (2018). Extracting and mapping industry 4.0 technologies using wikipedia. Computers in Industry, 100, 244-257.

Dalenogare, L. S., Benitez, G. B., Ayala, N. F., & Frank, A. G. (2018). The expected contribution of Industry 4.0 technologies for industrial performance. International Journal of Production Economics, 204, 383-394.

David J. Smith (2013) Power-by-the-hour: the role of technology in reshaping business strategy at Rolls-Royce, Technology Analysis & Strategic Management, 25:8, 987-1007

Ji-Bo Wang, Lu Liu, Jian-Jun Wang, Lin Li (2018. Makespan minimization scheduling

with ready times, group technology and shortening job processing times. Computer science theory, methods and tools the computer journal.

Kagermann, H., Wahlster, W., Helbig, J. (2013). Recommendations for implementing the strategic initiative Industrie 4.0: Securing the future of German manufacturing industry. Final report of the Industrie 4.0 Working Group. Acatech, Forschungsunion.

Keshavarz, T., Savelsbergh, M. and Salmasi, N. (2015) A branch-and-bound algorithm for the single machine sequencedependent group scheduling problem with earliness and tardiness penalties. Appl. Math. Model., 39, 6410–6424

Lantip Diat Prasojo (2014). Perancangan database sistem informasi manajemen pendidikan dengan dbms microsoft (acces dan sql server)

Lee, J., Bagheri, B., & Kao, H. A. (2015). A cyber-physical systems architecture for industry 4.0-based manufacturing systems. Manufacturing Letters, 3, 18-23.

Lei Xiao, Sanling Song, Xiaohui Chen1, David W. Coit. (2015). Joint optimization of production scheduling and machine group preventive maintenance. Reliability Engineering and System Safety.

M.A Liao, Y., Deschamps, F., Loures, E. D. F. R., & Ramos, L. F. P. (2017). Past, present and future of Industry 4.0-a systematic literature review and research agenda proposal. International journal of production research, 55(12), 3609-3629

Stock, T., Obenaus, M., Kunz, S., & Kohl, H. (2018). Industry 4.0 as enabler for a sustainable development: A qualitative assessment of its ecological and social potential. Process Safety and Environmental Protection, 118, 254-267

Wang, S., Wan, J., Li, D., & Zhang, C. (2016b). Implementing smart factory of industrie 4.0: an

outlook. International Journal of Distributed Sensor Networks, 12(1), 3159805

Wang, S., Wan, J., Zhang, D., Li, D., & Zhang, C. (2016a). Towards smart factory for industry 4.0: selforganized multi-agent system with big data based feedback and coordination. Computer Networks, 101, 158-168.

Yingjie Wang, Jianjun Liu, Xiang He, Bing Wang (2018). Design and realization of rock salt gas storage database management system based on SQL Server. Petroleum, 4:466–472

Published
2020-12-31

PlumX Metrics

How to Cite
Farhan, A., Sumantri, Y., & Santoso, P. B. (2020). Rancangan Sistem Informasi Berbasis Web Untuk Mengatasi Perbaikan Mesin Menggunakan Group Tecnologhy. JAMI: Jurnal Ahli Muda Indonesia, 1(2), 154-162. https://doi.org/10.46510/jami.v1i2.30