Generating nested XML document from hierarchical query dataset in RDBMS
Ling Gan · Jisuanji gongcheng yu sheji · 2008
In relational database application system,there are a lot of data whose structure obviously shows the characteristic of hierarchy,it is a common task to generating nested XML documents that properly reflect the hierarchical structure.The mechanism of generating such XML documents in Oracle 9i DBMS is discussed.By applying hierarchical query and Oracle XML DB technology,a solution to the problem is proposed,it can easily handle the complex hierarchical structure.Case study shows that the method is easy and suitable for generating nested hierarchical XML documents with high performance.