Rancangan Sistem Informasi Berbasis Web Untuk Mengatasi Perbaikan Mesin Menggunakan Group Tecnologhy
Abstract views: 411
,
PDF downloads: 150
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
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
Authors who publish with this journal agree to the following terms:
1. Copyright on any article is retained by the author(s).
2. The author grants the journal, right of first publication with the work simultaneously licensed under a Creative Commons Attribution License that allows others to share the work with an acknowledgment of the work’s authorship and initial publication in this journal.
3. Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal’s published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgment of its initial publication in this journal.
4. Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work.
5. The article and any associated published material is distributed under the Creative Commons Attribution-ShareAlike 4.0 International License
