DOI QR코드

DOI QR Code

A Database Design for Remote Maintenance of Navigation and Communication Equipments in a Vessel

선박 항해통신장비 원격유지보수를 위한 데이터베이스 설계

  • Received : 2017.09.05
  • Accepted : 2017.10.24
  • Published : 2017.11.30

Abstract

The SOLAS ship should carry at least 83 different types of equipment based on the SFI group codes and each of which consists of several to dozens of components. During ship operation, it is necessary to ensure the normal operation of such equipment, and remote maintenance is highly demanded for immediate repair in the event of a equipment fault. This study proposes to find suitable classification system and to derive database structure for remote maintenance of navigation and communication equipment. As a result of this study, the classification system of equipment should be layered into equipment type, model, and component, and main table in the database consists of FMEA, service history, case data through Q&A, Preventive Maintenance. A database was constructed for 140 navigation and communication equipment models and 750 components. In order to evaluate the practical effects, service engineer evaluated the usefulness using the cloud app.

SOLAS 선박은 SFI group 코드 기준으로 적어도 83종의 장비를 탑재해야 하고, 각각의 장비는 다시 수 개에서 수십 개의 컴포넌트로 구성이 된다. 선박 운항 중에는 이러한 장비의 정상적인 운영이 보장되어야 하고, 문제 발생시 즉각적인 수리를 위하여 원격유지보수의 요구사항이 높다. 본 연구는 항해통신장비의 원격유지보수에 적합한 장비의 분류체계를 제시하고, 적절한 데이터베이스 구조를 도출하고자 했다. 연구 결과, 선박 항해통신장비의 원격유지보수를 위하여, 장비의 분류체계는 장비의 종류, 모델, 컴포넌트로 계층화되어야 하고, 고장모드와 영향분석, 질의응답, 수리이력, 상태정보와 예방정비 등의 테이블을 장비 모델 기준으로 구축하는 것이 효과적임을 알게 되었다. 140개의 항해통신장비 모델과 750개의 컴포넌트에 대하여 데이터베이스를 구축하였고, 실질적인 효과를 평가하기 위하여 선박장비 수리전문가가 클라우드 앱을 이용하여 검색 결과의 유용성을 평가하였다.

Keywords

References

  1. Y. M. Lee, K Y Lee, S H Bae, H Jang, J K Lee, "Defect Detection and Defect Classification System for Ship Engine using Multi-Channel Vibration Sensor," The KIPS Transactions. Part A, vol. 17A no.2, pp. 81-92, April 2010. https://doi.org/10.3745/KIPSTA.2010.17A.2.081
  2. K. S. Kwon, K. S. Kim, M. Y. Yoo, "Development for the Trouble Diagnosis Expert System of the Ship Propulsion Engine," Journal of the Society of Marine Engineering, vol. 14, no.3, pp. 195-201, Aug. 1990.
  3. H. G. Hwang, D W Park, J. I. Park, J. S. Lee, K. S. Rhyu, "A development of facility management system providing alarm function for fault effect and replacement of each component," Journal of the Korean Society of Marine Engineering, vol. 38, no. 4, pp. 456-462, May 2014. https://doi.org/10.5916/jkosme.2014.38.4.456
  4. H. Chen, T. Moan, H. Verhoeven, "Safety of dynamic positioning operations on mobile offshore drilling units," Reliability Engineering & System Safety, vol. 93, no. 7, pp 1072-1090, July 2008. https://doi.org/10.1016/j.ress.2007.04.003
  5. T. SHINODA, R. MIKASA, "Construction of Database for Ship Operation Trouble and Factor Analysis," The Journal of Japan Institute of Navigation. vol. 129, pp 141-147, Dec. 2013. https://doi.org/10.9749/jin.129.141
  6. H. G. Hwang, S. D. Lee, J. S. Lee, K. W. Jang, H. C. Park, "Design and Implementation of Shipboard Integrated Information System based on IEC 61162-450," Journal of the Korea Institute of Information and Communication Engineering, vol.21, no.7 pp.1466-1469, Sep. 2017.
  7. D. Lazecky, V. Kral, S. Rusek, R. Gono, "Software Solution Design for Application of Reliability Centered Maintenance in Preventive Maintenance Plan," 2017 18th International Scientific Conference on Electric Power Engineering (EPE) Electric Power Engineering (EPE), 2017 18th International Scientific Conference, pp. 1-4, 2017.5
  8. SMART-Navigation Project. SMART-Navigation Service [Internet]. Avaliable : http://www.smartnav.org/eng/html/SMART-Navigation/summary.php.
  9. A. Singh, K. Kumar, R. S. Virk, H. J. Kim, "Symbiotic Organisms Search Response to Distributed Database Queries," Asia-pacific Journal of Multimedia Services Convergent with Art, vol.6 no.11, pp. 595-619, Dec. 2016.
  10. C. Y. Kim, I. G. Lee, "Design and Implementation of NMEA2000 Protocol Application for Marine Monitoring System," Journal of the Korea Institute of Information and Communication Engineering, vol. 19, no. 2, pp. 317-322, Feb. 2015. https://doi.org/10.6109/jkiice.2015.19.2.317