摘要
数据库应用系统中相当多的数据都呈现出相应的层次特征,对这类数据,常常需要生成元素间保持层次特征的XML文档,用一般的查询机制来解决这个问题比较繁琐,以Oracle9i数据库第2版为例,应用层次查询,并结合OracleXMLDB,对层次查询结果相对应的保持层次特征的XML文档的生成机制进行了研究,并将其应用于税务信息综合查询系统之中。结果表明,该方法简单、效率高、应用效果良好。
In relational database application system, there are a lot ofdata whose structure obviously shows the characteristic ofhierarchy, 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.
出处
《计算机工程与设计》
CSCD
北大核心
2008年第21期5588-5590,5594,共4页
Computer Engineering and Design