| Previous | [ 1] | [ 2] | [ 3] | [ 4] | [ 5] | [ 6] | [ 7] | [ 8] | [ 9] | [ 10] | [ 11] | [ 12] | [ 13] | [ 14] | [ 15] | [ 16] | [ 17] | [ 18] |
¡@
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.
Received February 24, 2010; revised July 6, 2010; accepted September 28, 2010.
Communicated by Jorng-Tzong Horng.