| 关系数据库层次树查询机制浅析 |
| |
| 引用本文： | 赵爱芹,陈和平,熊健驰.关系数据库层次树查询机制浅析[J].计算机工程与设计,2006,27(18):3454-3456. |
| |
| 作者姓名： | 赵爱芹 陈和平 熊健驰 |
| |
| 作者单位： | 武汉科技大学,信息科学与工程学院,湖北,武汉,430081;哈尔滨工业大学,实验学院,黑龙江,哈尔滨,150001 |
| |
| 摘 要： | 大多数关系数据库应用系统的结构体系和查询要求都呈现很强的层次特征.在进行数据库查询过程中,用一般的查询机制来查询具有层次结构的数据是较为繁琐的.目前Oracle 9i及以上版本和SQL Server 2005都引入了层次树查询机制,层次树查询是一种针对关系数据库中层次结构数据查询的树型解决方案,可较好地解决此类复杂的层次查询问题.以Oracle 9i数据库为例,结合某公司的部门组织结构,对层次树查询机制进行了实例分析与研究.
|
| 关 键 词： | 关系数据库 Oracle 层次树结构 层次树查询 SQL |
| 文章编号： | 1000-7024（2006）18-3454-03 |
| 收稿时间： | 2005-07-12 |
| 修稿时间： | 2005-07-12 |
Hierarchical tree queries mechanism in relation database system |
| |
| ZHAO Ai-qin,CHEN He-ping,XIONG Jian-chi.Hierarchical tree queries mechanism in relation database system[J].Computer Engineering and Design,2006,27(18):3454-3456. |
| |
| Authors: | ZHAO Ai-qin CHEN He-ping XIONG Jian-chi |
| |
| Affiliation: | 1. College of Information Science and Engineering, Wuhan University of Science and Technology, Wuhan 430081, China ;2. Department of Experiment, Harbin Institute of Technology, Harbin 150001, China |
| |
| Abstract: | 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 oracle9i 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. |
| |
| Keywords: | Oracle SQL |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
|
