Journal of KIISE (정보과학회 논문지)

Korean Institute of Information Scientists and Engineers (한국정보과학회)
권호 표지
DOI QR코드

DOI QR Code

A Design of Metadata Registry Database based on Object-Relational Transformation Methodology

객체-관계 변환 방법론 기반 메타데이터 레지스트리 데이터베이스 설계

  • 차수영 (고려대학교 컴퓨터.전파통신공학과) ;
  • 이석훈 (고려대학교 컴퓨터.전파통신공학과) ;
  • 정동원 (군산대학교 통계컴퓨터과학과) ;
  • 백두권 (고려대학교 컴퓨터.전파통신공학과)
  • Received : 2015.05.15
  • Accepted : 2015.06.29
  • Published : 2015.09.15
⟨ Previous Next ⟩

Abstract

The ISO/IEC 11179 Metadata registry (MDR) is an international standard that was developed to register and share metadata. ISO/IEC 11179 represents an MDR as a metamodel that is an object model. However, it is difficult to develop an MDR based on ISO/IEC 11179 because the standard has no clear criteria to transform the metamodel into a database. In this paper, we suggest the design of an MDR data model that is based on object-relational transformation methodology (ORTM) for the MDR implementation. Hence, we classify the transformation methods of ORTM according to the corresponding relationships. After classification, we propose modeling rules by defining the standard use of the transformation. This paper builds the relational database tables as an implementation result of an MDR data model. Through experiments and evaluation, we verify the proposed modeling rules and evaluate the suitability of the created table structures. As the result, the proposed method shows that the table structures preserve classes and relationships of the standard metamodel well.

ISO/IEC 11179 메타데이터 레지스트리(Metadata Registry, MDR)는 메타데이터의 등록 및 공유를 위해 개발된 국제표준이다. ISO/IEC 11179는 MDR을 객체 모델인 메타모델로 표현한다. 하지만 ISO/IEC 11179는 메타모델을 데이터베이스로 구축하기 위한 명확한 기준이 없으므로 표준 기반의 MDR 개발이 어려운 문제점이 있다. 이 논문은 MDR 구현을 위해 객체-관계 변환 방법론 기반의 MDR 데이터 모델을 설계한다. 이를 위해 연구된 객체-관계 변환 방법론의 변환 기법들을 관계성에 기준하여 분류하고, 이 변환 기법들의 사용 기준을 정의함으로 모델링 규칙을 제안한다. 이 논문은 MDR 데이터 모델에 대한 구현 결과로 관계형 데이터베이스 테이블을 구축한다. 실험 및 평가를 통하여 제안하는 모델링 규칙을 검증하고 구축된 테이블 구조의 적합성을 평가한다. 평가 결과로 제안 기법에 의해 구축된 테이블 구조는 표준 메타모델의 클래스와 관계성을 잘 보존함을 보인다.

Keywords

Acknowledgement

Supported by : 한국연구재단

References

  1. K. Smith, L. Seligman, A. Rosenthal, C. Kurcz, M. Greer, C. Macheret, M. Sexton, and A. Eckstein, "Big Metadata: The Need for Principled Metadata Management in Big Data Ecosystems," Proc. of Workshop on Data analytics in the Cloud, ACM, pp. 1-4, 2014.
  2. R. Grunzke, J. Hesser, J. Starek, N. Kepper, S. Gesing, M. Hardt, and R. Jakel, "Device-driven Metadata Management Solutions for Scientific Big Data Use Cases," Parallel, Distributed and Network-Based Processing (PDP), 2014 22nd Euromicro International Conference, IEEE, pp. 317-321, 2014.
  3. U.-U Hassan, M. Bassora, A.-H. Vahid, S. O'Riain, and E. Curry, "A collaborative approach for metadata management for internet of things," 9th IEEE International Conference on Collaborative, pp. 593-598, 2013.
  4. ISO/IEC JTC1/SC32, ISO/IEC 11179 Metadata Registries (MDR) Part 3: Registry Metamodel and Basic Attributes, 3rd edition, 2013.
  5. S.-W. Ambler, "Mapping objects to relational databases: What you need to know and why," developer Works, pp. 1-11, 2000.
  6. F. Lodhi and M.-A. Ghazal, "Design of a simple and effective object-to-relational mapping technique," Proc. of the 2007 ACM symposium on Applied computing, pp. 1445-1449, 2007.
  7. W. Kuskorn and S. Lekcharoen, "An Adaptive Translation of Class Diagram to Relational Database," Information and Multimedia Technology, ICIMT'09. International Conference on IEEE, pp. 144-148, 2009.
  8. J.-W. Rahayu and D. Taniar, "Preserving aggregation in an object-relational DBMS," Advances in Information Systems, Springer, Berlin Heidelberg, pp. 1-10, 2002.
  9. W. Keller, "Mapping objects to tables," Proc. of European Conference on Pattern Languages of Programming and Computing, Vol. 206, 1997.
  10. M.-K. Awang and N.-L. Labadu, "Transforming Object oriented Data Model TO Relational Data Model," International Journal of New Computer Architectures and their Applications (IJNCAA), pp. 402-409, 2012.
  11. I. Wu and S.-H. Hsieh, "An UML-XML-RDB Model Mapping Solution for Facilitating Information Standardization and Sharing in Construction Industry," NIST Special Publication SP, pp. 317-322, 2003.
  12. J.-W. Rahayu, E. Chang, T.-S. Dillon, and D. Taniar, "Performance evaluation of the object-relational transformation methodology," Data & Knowledge Engineering, Vol. 38.3, pp. 265-300, 2001. https://doi.org/10.1016/S0169-023X(01)00026-X
  13. S. Lee, D. Jeong, J. Gim, and D.-K. Baik, "Canonical Sensor Ontology Builder Based on ISO/IEC 11179 for Sensor Network Environments: A Standardized Approach," International Journal of Distributed Sensor Networks, Vol. 2014, pp. 1-14, 2014.
  14. Y.-M. Joo, J. Kim, D. Jeong, and D.-K. Baik, "eMRA: Extension of MRA Considering the Relationships Between MDR Concepts," KIPS Transactions on Software and Data Engineering, Vol. 2, No. 3, pp. 161-172, 2013. (in Korean) https://doi.org/10.3745/KTSDE.2013.2.3.161
  15. Semantic MDR Project. [Online]. Available: https://github.com/srdc/semanticMDR
  16. ISO/IEC JTC1/SC32, ISO/IEC 11179 Metadata Registries (MDR) Part 1: Framework, 3rd edition, 2013.