묵시적 참조 무결성을 고려한 관계형 스키마 모델의 XML 스키마 모델 변환 알고리즘

An Algorithm for Translation from RDB Schema Model to XML Schema Model Considering Implicit Referential Integrity

  • 발행 : 2006.10.15

초록

XML 데이타의 효율적인 저장을 위한 가장 대표적인 접근방법은 XML 데이타를 관계형 데이타베이스에 저장하는 것으로 대부분의 데이타가 여전히 관계형 데이타베이스에 저장되어 있다는 현실적 상황을 쉽게 수용할 수 있다는 장점을 지닌다. 이러한 접근 방법은 XML 데이타를 관계형 데이타로 혹은 관계형 데이타를 XML 데이타로 변환 과정이 필수적으로 요구하며, 변환 과정에서 가장 중요한 점은 관계형 스키마 모델의 구조적, 의미적 관계 정보를 XML 스키마 모델에 정확히 반영하는 것이다 지금까지 많은 변환 방법들이 제안되었으나 구조적 의미를 반영하지 못하거나 단순히 명시적으로 정의된 참조 무결성 관계(Referential Integrity Relations)만을 지원하는 문제점을 지닌다. 이 논문에서는 관계형 스키마 모델의 XML 스키마 모델로의 변환 시 초기 관계형 데이타베이스의 묵시적 참조 무결성 관계를 자동적으로 추출하여 이를 변환에 반영할 수 있는 알고리즘을 제안한다. 제안된 알고리즘은 초기 관계형 데이타베이스에 명시적으로 정의되어 있는 참조 무결성 관계는 물론 묵시적인 참조 무결성 관계까지 변환 과정에 반영함으로써 보다 정확한 XML 데이타 모델 생성을 가능하게 한다.

The most representative approach for efficient storing of XML data is to store XML data in relational databases. The merit of this approach is that it can easily accept the realistic status that most data are still stored in relational databases. This approach needs to convert XML data into relational data or relational data into XML data. The most important issue in the translation is to reflect structural and semantic relations of RDB to XML schema model exactly. Many studies have been done to resolve the issue, but those methods have several problems: Not cover structural semantics or just support explicit referential integrity relations. In this paper, we propose an algorithm for extracting implicit referential integrities automatically. We also design and implement the suggested algorithm, and execute comparative evaluations using translated XML documents. The proposed algorithm provides several good points such as improving semantic information extraction and conversion, securing sufficient referential integrity of the target databases, and so on. By using the suggested algorithm, we can guarantee not only explicit referential integrities but also implicit referential integrities of the initial relational schema model completely. That is, we can create more exact XML schema model through the suggested algorithm.

키워드

참고문헌

  1. T. Bray, J. Paoli, and M. Cavary, Extensible Markup Language (XML) 1.0, 2nd Edition, W3C Recommendation, October 2000
  2. ISO / IEC JTC 1 SC 34, ISO / IEC 8839:1986: Information processing-Text and office systems - Standard Generalized Markup Language (SGML), August 2001
  3. R. Elmasri, and S. Navathe, Fundamental of Database Systems, 4th Edition, Addison-Wesley, 2003
  4. W. Fan and J. Simeon, 'Integrity Constraints for XML,' ACM PODS, Dallas, TX, May 2000 https://doi.org/10.1145/335168.335172
  5. D. Lee, M. Mani, F. Chiu, and W. W. Chu, 'Nesting-based Relational-to-XML Schema Translation,' Int'l Workshop on the Web and Databases (WebDB), Santa Barbara, CA, May 2001
  6. J. Naughton, D. DeWitt, D. Maier, 'The Niagara Internet Query System,' IEEE Data Engineering Bulletin, Vol. 24, No.2, pp. 27-33, 2001
  7. M. Fernandez, W. Tan, and D. Suciu, 'SilkRoute: Trading between Relations and XML,' Int'l World Wide Web Conf. (WWW), Amsterdam, Netherlands, May 2000 https://doi.org/10.1016/S1389-1286(00)00061-X
  8. M. Carey, D. Floirescu, Z. Ives, Y. Lu, J. Shanmugasundaram, E. Shekita, and S. Subramanian. 'XPERANTO: Publishing Orbject-Relational Data as XML,' Int'l Workshop on the Web and Databases (WebDE), Dallas, TX, May 2000
  9. V.Turau. 'Making Legacy Data Accessible for XML Applications,' 1999. http://www.informatik.fhwiesbaden.de/-tarau/veroeff.html
  10. C. Kurt, H. David, Beginning XML, 2nd Edition, John Wiley & Sons Inc, 2001
  11. G. Jaeschke and H. J. Schek, 'Remarks on the Algebra of Non First Normal Form Relations,' ACM PODS, Los Angeles, CA, Vol. 5, pp. 124-138, Los Angeles, March 1982 https://doi.org/10.1145/588111.588133
  12. D. Lee, M. Mani, F.Chit, and W. W. Chu, 'Effective Schema Conversions between XML and Relational Models,' European Conference on Artificial Intelligence (ECAI), Knowledge Transformation Workshop (ECAI-OT), Lyon, France, July 2002
  13. D. Lee, M. Mani, F. Chiu, and W. W. Chu, 'NeT&CoT: Translating Relational Schemas to XML Schemas using Semantic Constraints,' 11th ACM Int'l Conference on Information and Knowledge Management (CIKM). McLean, VA, USA, November 2002
  14. J. Goodson, 'Using XML with Existing Data Access Standards,' Enterprise application Integration Knowledge Base (EAD Journal, pp. 43-45, March 2002
  15. J. Widom, 'Data Management for XML: Research Directions,' IEEE Data Engineering Bulletin, pp. 44-52. September 1999
  16. L. Seligman and A. Rosenthal.: XML's Impact on Databases and Data Sharing. IEEE Computer, Vol. 34, No.6, pp. 59-67, June 2001 https://doi.org/10.1109/2.928623
  17. A. Witkowski, S. Bellamkonda, T. Bozkaya, N. Folkert, A. Gupta, J. Haydu, L. Sheng, and S. Subramanian, 'Advanced SQL Modeling in RDBMS,' ACM Transactions on Database Systems,' Vol. 30, No.1, pp. 83-121, March 2005 https://doi.org/10.1145/1061318.1061321
  18. A. C. Duta, K. Barker, R, Alhajj, 'ConvRel: Relationship Conversion to XML Nested Structures,' SAC '04, Nicosia, Cyprus, March 14-17, 2004 https://doi.org/10.1145/967900.968046
  19. Transaction Processing Performance Councill, Http://www.tpc.org/tpch/spec/h130.pdf
  20. J. Hainaut, J.Henrard, D.Roland, V.Englebert, and J. Hick, 'Structure Elicitation in Database Reverse Engineering,' IEEE, the 3rd Working Conference on Reverse Engineering (WCRE 96), pp. 131-140, Monterey, CA, USA, November 1996 https://doi.org/10.1109/WCRE.1996.558891
  21. J. M. Anderson, 'Extracting an Entity Relationship Schema from a Relational Database through Reverse Engineering,' the 13th Int. Conf. on ERA, Springer-Verlag, LNCS 881, pp. 387-401, December 1994
  22. J. Hainaut, M. Chandelon, C. Tonneau, and M. joris, 'Transformation of Requirement Specifications Expressed in Natural Language into an EER Model,' the 12th Int. Conf. on ERA, EIR Institute and Springer-Verlag, LNCS 823, pp. 206-217, Arlington, Texas, USA, December, 1993