Previous [ 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 (July 2011)

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

Full Text () Retrieve PDF document (201107_06.pdf)

Received February 24, 2010; revised July 6, 2010; accepted September 28, 2010.
Communicated by Jorng-Tzong Horng.