Defining and Processing XML View of Relational Data with Publication Functions of SQL/XML

SQL/XML의 출판 함수를 이용한 관계 데이터의 XML 뷰 정의 및 처리

  • 이상욱 (중앙대학교 컴퓨터공학부 대학원) ;
  • 김진 (중앙대학교 컴퓨터공학부 대학원) ;
  • 강현철 (중앙대학교 컴퓨터공학부)
  • Received : 2009.10.23
  • Accepted : 2009.12.22
  • Published : 2009.12.31

Abstract

Since XML emerged as a standard for data exchange on the web, it has been widely used for applications like e-Commerce, CRM, and BI. However, it is common that most of business data is stored in relational database systems, and it is expected that business data management would still be centered around the relational database systems. As such, the technique of viewing relational data as XML and processing XML queries against it is required. To meet such a need, in the SQL/XML standard, the functions to publish relational data as XML are provided. In this paper, we propose the techniques of providing an XML view of relational data defined by an SQL/XML statement in DTD(Document Type Definition), and of processing XPath queries against the XML view by translating them into SQL/XML statements, and describe the validation of such techniques through implementation and tests.

Keywords

Acknowledgement

Supported by : 중앙대학교