A Study on the comparison between MS-SQL and ALTIBASE in EPCIS

EPCIS에서 MS-SQL과 ALTIBASE의 비교에 관한 연구

  • Dan, Da (Department of Industrial Engineering, INHA University) ;
  • Song, Young-Keun (Department of Industrial Engineering, INHA University) ;
  • Kwon, Dae-Woo (Department of Industrial Engineering, INHA University) ;
  • Lee, Doo-Yong (Department of Industrial Engineering, INHA University) ;
  • Li, Zhong-Shi (Department of Industrial & Management Engineering, NAMSEOUL University) ;
  • Lee, Chang-Ho (Department of Industrial Engineering, INHA University)
  • 단 단 (인하대학교 산업공학과) ;
  • 송영근 (인하대학교 산업공학과) ;
  • 권대우 (인하대학교 산업공학과) ;
  • 이두용 (인하대학교 산업공학과) ;
  • 이종석 (남서울대학교 산업경영공학과) ;
  • 이창호 (인하대학교 산업공학과)
  • Received : 2010.04.20
  • Accepted : 2010.06.08
  • Published : 2010.06.30

Abstract

EPC Information Services (EPCIS) is an EPCglobal standard designed to enable EPC-related data sharing within and across supply chain. The EPCIS standard defines standard interfaces to enable EPC-related data to be captured and subsequently to be queried using a set of service operations and an associated data model. There are two kinds of EPCIS data: event data and master data. Event data is created in the process of carrying out business processes. Traceability of goods across supply chain is based on event data. Therefore, each company must have an event data. This study compared he difference between MS-SQL(DRDBMS) and ALTIBASE(MMDBMS) for data storage. We compared the difference between two database management in many respects such as insert time and select time. We come to a conclusion that ALTIBASE is more efficient than MS-SQL.

Keywords

References

  1. Alexander Ilic, Thomas Andersen, Florian Michahelles, "EPCIS-based Supply Chain Visualization Tool", Business Processes & Applications, 2009.
  2. Alexander Ilic, Thomas Andersen, Florian Michahelles, "increasing Supply-Chain Visibility with Rule-Based RFID Data Analysis", IEEE Internet Computing, 2009.
  3. EPCglobal, "EPC Information Services (EPCIS) Version 1.0.1 Specification", EPCglobal, September 2007.
  4. EPCglobal, "The EPCglobal Architecture Framework Version 1.3", EPCglobal, September 2009.
  5. Seshadri, A. Silberschatz, and S. Sudarshan, "Distributed Multi-Level Recovery in Main-Memory Databases", Proc. of the International Conference on Parallel and Distributed Information Systems, 1996.
  6. Verisign, Inc., "The EPCglobal Network: Enhancing the Supply Chain", 2005.
  7. 안재명, 이종태, 오해석, (주)리테일테크 기술 연구소 공저, "EPCglobal Network 기반의 RFID 기술 및 활용",글로벌, 2007. 2.
  8. 이규웅, "고가용성을 위한 주기억장치 DBMS ALTIBASE의 이중화 관리 기법", 한국인터넷 정보학회, 6권, 1호, 2005, 2.
  9. 조용철, "RFID기반의 통합물류센터를 위한 효율적인 EPCIS Repository 구축에 관한 연구", 인하대학교 박사학위논문, 2009
  10. 조이현, "RFID 기반 물류환경에서의 실시간 데이터 처리를 위한 EPCIS의 설계 및 구현", 부산대학교 석사학위논문, 2007.