Web-based Data Integration System Implementation for Reliability Improvement of a Product

제품의 신뢰성 향상를 위한 웹 기반 데이터 통합 시스템 구축에 관한 연구

  • 경태원 (경희대학교 일반대학원 산업공학과) ;
  • 김상국 (경희대학교 테크노공학대학)
  • Published : 2005.12.31

Abstract

This study proposes an integrated monitoring system for data reliability improvement in a steel manufacturing industry. The data obtained from existing steel manufacturing process is not micro data which is gathered at the occurring point, but average value (macro data) which is gathered from the occurring point to ending point. This kind of macro data is not only difficult for a detailed analysis for an error causing factor, but it might cause a fatal influence as well on the quality of produced goods even if the error is within an error tolerance. And during the process of steel production, thousands of data is produced in a second, thus requiring database plan to manage abundant amount of data. Therefore, the following proposed system is capable of collecting as well as analyzing all the data generated from the process of product production. And the system was able to raise the efficiency of the database server by planning the database to handle large capacity data. Also, by applying web-based technology, inquiries and analysis of data with no limit on time and space was possible with PC connected to the intranet. Hence, the system was able to work on effective quality improvement of manufactured products, plus able to raise the reliability of the product. Also, accumulated data from long period of time was used for fundamental material for new controlling model, operation technology, and new product development.

본 연구는 철강제조 분야에서 제품 생산 중 발생하는 모든 데이터를 실시간으로 수집하여 데이터베이스화하고, 웹 기반 시스템을 구축함으로써 시간과 장소의 제약 없이 필요 데이터를 조회, 분석할 수 있는 시스템 개발에 대한 연구이다. 본 시스템의 구축 결과, 실시간으로 데이터의 조회 및 분석이 가능하게 됨으로써 생산 제품에 대한 보다 효율적인 품질개선 활동이 가능하게 되었고, 제품의 신뢰도를 높일 수 있게 되었다. 또한 장기간 누적된 데이터를 데이터베이스화하고 그것을 통계적으로 분석 가능하게 함으로써 새로운 제어모델의 개발과 조업기술의 개발이 보다 용이하게 되었고, 신제품 개발의 기초자료로도 활용할 수 있게 되었다.

Keywords

References

  1. 기초철강지식, 한국철강신문, 2002
  2. 김재영 역, 철강편람 1: 압연기초. 강판편, 일본철강협회, 세화출판사, 1990
  3. 이화식, 대용량 데이터베시스 솔루션, 대청, 1999
  4. Alapati, Expert Oracle9i Database Administration, Apress, 2003
  5. Azim, H. and G. Bahador, 'A Practical Reliability and Maintainability Data Collection and Processing Software', Computers ind. Engng, Vol. 33, 1997
  6. Bill, H., 'The B2B Standards War', EAI Journal, October 2000
  7. Burleson, D. K., Physical Database Design Using Oracle, CRC Pr I Llc, 2004
  8. Hsu, C.-C. and S.-L. Hwang, 'A Study of Interface Design Improvement in an Engineering Data Management System on the world wide web', Computers & Industrial Engineering, Vol. 47, 2004
  9. Comer, D. E. Internetworking with TCP/IP, Vol.3: Client-Server Programming and Applications, Linux/Posix Sockets, Prentice-Hall, 2000
  10. Daryl, P., 'Internet Scenario: The Infrastructure for e-Business', Gartner SYMPOSIUM ITxpo 2000, 16-20 October 2000
  11. David, S. L., 'B2B Process Integrationm' EAI Journal, Oct. 2000
  12. Davies, Microsoft Windows Serwer 2003 TCP/IP Protocols and Services Technical Reference, Microsoft, 2000
  13. EAI Journal, July/August 1993
  14. Fox, A. M., J. E. Cooling and N. S. Cooling, 'Integrated Design Approach for Real-time Embedded Systems', lEE Proc-Softw., Vol. 146, No. 2, April 1999
  15. Gallardo, D., Java Oracle Database Development, Prentice Hall Ptr, 2002
  16. Heinckiens, P. M., Building Scalable Database Applications: Object-Oriented Design, Architectures, and Implementations, Addison-Wesley, 1998
  17. Jolitz, L. G., TCP/IP Networking Protocol, Independent Pub Group, 2001
  18. Kwak, Y.-S. and S.-H. Lee, 'Multimedia Database System', The Jour. Of Industrial Sciences, Vol. 7, 1992
  19. Ladshman, Oracle 9i PL/SQL: Developer's Guide, Apress, 2003
  20. Riccardi, Database Management: with Web Site Development Applications, Addison Wesley, 2002
  21. Roy, S., Application Integration: Rethinking the Structure of Business Automation Gartner SYMPOSIUM Itxpro2000, 16-20 October 2000
  22. Stevens, W. R., Advanced Programming in the UNIX(R) Environment, Addison-Wesley, 1992