An Evaluation of Access Performance of STEP-based CAD Database

STEP 기반 CAD 데이터베이스의 액세스 성능 평가 실험

  • 김준환 (한국과학기술원 기계공학과) ;
  • 한순홍 (한국과학기술원 기계공학과)
  • Received : 2003.10.08
  • Accepted : 2004.05.15
  • Published : 2004.06.30


In shipbuilding area, data sharing is one of the crucial issues. Recently, for collaborative design, ship structural CAD systems adopt the database as its primary storage. Database is useful to deal with the large amount of design information among the heterogeneous design department and design stage. To make the database-based CAD system object-oriented database(OODB) and object-relational database(ORDB) can be used. It is important to select proper database because the CAD system performance mainly depends on access performance of database. In this research, using prototype CAD system from other research, access performance of OODB and ORDB form CAD system was evaluated. STEP application protocol was used as the database schema and experiment was made in query by property and query by region. The results give some idea of how to choose the database for CAD systems.


  1. 한순홍 (2001), 모델링 커널을 이용한 조선 전용-CAD의 개발방안, 조선학회지, 38(1), 94-99
  2. 이종갑, 김준호 (1991), 범용 CAD시스템을 기초로 한 조선 의장설계일관 시스템, 대한조선학회지, 29(3), 28-35
  3. Fedorowicz J. (1987), Database performance evaluation in an indexed file environment, ACM transaction on Database, 12,(1), 85-110
  4. Darmont J., Ammar A., Gourgand M. (1995), Performance evaluation for clustering Algorithms in Object-Oriented Database Systems, 6th International Conference, DEXA95, London
  5. Schkolnick M.,Tiberio P. (1985), Estimating the costof updates in a relational database, ACM transaction on Databafe, 10(2), 163-179
  6. Graefe G., (1993), Query evaluation techniques for large databases, ACM Computing Surveys, 25(2)
  7. 김성진, 이상호 (2002), 객체-관계형 데이터베이스 시스템을 위한 새로운 성능 평가 방법론, 한국 정보처리학회 논문지, 7(7)
  8. Kepmp J., Kowarschick W., Kiebling W, Hitzelberger R. (1995) Benchmarking OODB System for CAD, 6th International Conference, DEXA95, London September 4-8, 167-176
  9. Kim J.H., Han S. (2003), Encapsulation of geometric functions for a ship structural CAD which has a STEP database as the native storage, Computer-Aided Design, 35, Issue13, 1161-1170
  10. 김준환, 한순흥 (2002), STEP DB를 Native Stotage로 가지는 3차원 선체CAD에서 형상모델링커널과 데이터베이스간의 인터페이스, 한국CAD/CAM 학회 논문집, 7(4)
  11. 김준환, 한순홍 (2002), 상업용 CAD에서 STEP 기반 객체지향 데이터베이스 내부의 형상 인스턴스 검색 및 수정, 대한산업공학회지, 28(4)
  12. ISO TC184/SC4/WG3 N799, ISO/CD 10303-218 Product data representation and exchange - Application protocol - Part 218: Ship structures, 1999
  13. 손정모 외 (1999), 분산환경에서 표준모델(STEP)을 이용한 내용검색, 한국CAD/CAM 학회 논문집, 4(6), 285-294
  14. Krebs T., Luehrsen H. (1995), STEP databases as integration platform for concurrent engineering, Proc, 2nd International Conf. on Concurrent Engineering (Mclean, Virginia, August 23-25), Johnstown, PA: Concurrent Technologies Co., 131-142
  15. Loffredo D., Efficient Database Implementation of EXPRESS Information Models, RPI, Ph.D. Thesis 1998
  16. Sun J., Hardwick M., Building an integrated large scale STEP database for virtual enterprises, Proceedings of ASME DETC99/DFM, Sept. 1999, Las Vegas, USA
  17. Jacobsen K. (1997), Development of a ship modeling application using CAS. CADE, an object oriented software development environment, ICCAS
  18. GRAD Inc.,,