JISE


  [1] [2] [3] [4] [5] [6] [7] [8] [9] [10] [11] [12] [13] [14] [15] [16] [17] [18]


Journal of Information Science and Engineering, Vol. 27 No. 4, pp. 1283-1302


The SQL Function XMLNEST to Generate Recursive XML Values from Relational Data


SUNG-CHUL PARK AND YOUNG-CHUL PARK+
School of Computer Information 
Yeungjin College 
Daegu, 702-721 Korea 
+School of Computer 
Kyungpook National University 
Daegu, 702-701 Korea


    SQL standard provides SQL/XML publishing functions to publish the result of an SQL query as XML values but it does not provide any SQL/XML publishing function that can publish the result of a recursive SQL query as recursively structured XML values. Therefore, to publish transitively connected relational tuples as recursively structured XML values with the use of appropriate SQL/XML publishing functions, we have to write a nested SQL query. Writing that query, however, is not easy provided that the depth of the connections is deep even if we know the depth of them and is not possible once the depth of the connections is not known in advance. To solve the problem, we propose a new SQL function XMLNEST that can publish the result of a recursive SQL query as recursively structured XML values. Both the recursive structure and the order of sibling XML elements of the XML values can be specified in the invocation of XMLNEST. Our experiments show that the proposed scheme will be the unique reasonable solution to the problem.


Keywords: XML schema graph, XQuery, SQL/XML publishing function, recursive query, nested query, recursive XML values, SQL aggregate function, XMLNEST

  Retrieve PDF document (JISE_201104_06.pdf)