摘要
大多数关系数据库应用系统的结构体系和查询要求都呈现很强的层次特征。在进行数据库查询过程中,用一般的查询机制来查询具有层次结构的数据是较为繁琐的。目前Oracle9i及以上版本和SQLServer2005都引入了层次树查询机制,层次树查询是一种针对关系数据库中层次结构数据查询的树型解决方案,可较好地解决此类复杂的层次查询问题。以Ora-cle9i数据库为例,结合某公司的部门组织结构,对层次树查询机制进行了实例分析与研究。
In most relational database application system, it＇s structure and query obviously shows the characteristic of hierarchy. While in the database query, it is very cumbersome to query the hierarchical data structure by using the normal query function. Now the oraclegi and the above version, SQL server 2005 brought in a new method of hierarchical tree query- Hierarchical tree query. Hierarchical tree query is a solution to the problem of the hierarchical data query in the relation database, it can easily handle the complex hierarchical query. The case of the department structure of a company is taken to research and the mechanism of this new method is analyzed based on Oracle9i.
出处
《计算机工程与设计》
CSCD
北大核心
2006年第18期3454-3456,共3页
Computer Engineering and Design
