Browse > Article
http://dx.doi.org/10.5391/JKIIS.2007.17.3.430

XSTAR: XQuery to SQL Translation Algorithms on RDBMS  

Hong, Dong-Kweon (계명대학교 컴퓨터공학과)
Jung, Min-Kyoung (계명대학교 컴퓨터 공학과 대학원)
Publication Information
Journal of the Korean Institute of Intelligent Systems / v.17, no.3, 2007 , pp. 430-433 More about this Journal
Abstract
There have been several researches to manipulate XML Queries efficiently since XML has been accepted in many areas. Among the many of the researches majority of them adopt relational databases as underlying systems because relational model which is used the most widely for managing large data efficiently. In this paper we develop XQuery to SQL Translation Algorithms called XSTAR that can efficiently handle XPath, XQuery FLWORs with nested iteration expressions, element constructors and keywords retrieval on relational database as well as constructing XML fragments from the transformed SQL results. The entire algorithms mentioned in XSTAR have been implemented as the XQuery processor engine in XML management system, XPERT, and we can test and confirm it's prototype from "http ://dblab.kmu.ac.kr/project.jsp".
Keywords
XML query; SQL translation; full-text retrieval; intermediate results; element constructors;
Citations & Related Records
연도 인용수 순위
  • Reference
1 Meier, W., 'eXist open source native XML database,' http://eXist.sourceforge.net/
2 Chen, C., Chio, B., Gapeyev, V., 'Galax XML DB release0.5.0' http://www.galaxquery.org
3 Oracle Home page 'Oracle 109 SQL/XML' http://www.oracle.com/technology/products/database/application_development/sqlxml/index.html
4 Dehaan, D., Toman, D. Consens, M., Ozsu, T., 'A Comprehensive XQuery to SQL Translation using Dynamic Interval Encoding' SIGMODE 2003
5 Buxton, S., Rys, M., 'XQuery and XPath Full-Text Requirements' http://www.w3c.org/TR/xquery-full-text-requirements/
6 Stylus Studio homepage http://www.stylusstudio.com/xmLdownload.html
7 Jung, M.K, Hong, D.K, 'Design and Implementation of XQuery Processor on the RDBMS' 정보처리학회 추계학술대회 2005, 11월
8 Jung, M.K, Hong, D.K, Kim, KY., 'XPERT: XML Query Processing System using Relation Databases' APIS conferentce 2006
9 Jung, M.K., Hong, D.K, 'Design and Implementation of XQuery Processor on the RDBMS using Dewey order' 정보처리학회 춘계학술대회 2005. 5월
10 Rotterdam, J., Veen, M., ed., 'X-Hive/DB' http://www.x-hive.com/ 2004년 10월 검색
11 'XQuery 1.0 Grammar Test Page' http://www.w3.org/2005/04/qt-applets/xqueryApplet.html
12 Jung, M.K, Hong, D.K., Nam, J,Y., 'Design and Implementation of XML Analyzer on RDBMS' 정보과학회 춘계학술대회 2005, 7월
13 Grust, T., Sakr, S., Teubner, J., 'XQuery on SQL Hosts' VLDB Conference 2004
14 SQL Sever Home page 'SQL Server 2000 XML Overview' http://www.microsoft.com/technet/prodtech-nollsqll2000/evaluate/xmlsql.mspx 2005년 7월 검색
15 Jung, M.K, Hong, D.K, Kim, K.Y., 'Developing an XML query processing system using a relation database' ALPIT conference 2005, 6월
16 XPath axes http://www.w3.org/TR/xpath#axes