树型层次结构数据中遍历子树结点的方法

Method of Traversing Subtree Nodes in Data of Tree-Level Structure

复杂关系数据的处理在数据库存储技术中具有重要的意义。在储层建模过程中高效的复杂数据处理方法将会大大提高建模的速度和准确性。阐述了存储过程和用户自定义函数相关概念,并以河流相随机游走储层建模相关数据为例,提出了通过使用存储过程和用户自定义函数对树型层次结构数据进行子结点递归遍历查询、存储的新方法,以便达到更高效的数据查询处理能力,最后通过SQL编程加以实现。实践表明,该方法具有很好的效果。

Complex relational data processing has the vital significance in the database storage technology. The highly effective complex relations data processing method will greatly enhance the speed and the accuracy in the reservoir modeling process. As an example of random walk reservoir modeling relevant data, through the using of server stored procedures and user- defined functions, proposed a new method that inquire and store data of subtree nodes of tree structure in order to make the more highly effective database inquiryability. Finally, through realization of the programming and relevant application, this method has the very good effect.