Research on Processing Method of Tree Structure Information in Relational Database
Hongtao Deng · Journal of Jianghan University · 2010
This paper introduces the conception and characteristics of tree structure,discusses the structure design proposal of relational tables,compares the storage methods of tree structure information in relational database,provides the design of the table structure which making use of autocorrelation mapping,and gives an example of processing the tree structure information with CTE in SQL Server 2005.