| 对象关系数据库索引机制的实现 |
| |
| 引用本文： | 阮宏一.对象关系数据库索引机制的实现[J].培训与研究,2007,24(8):16-18. |
| |
| 作者姓名： | 阮宏一 |
| |
| 作者单位： | 湖北第二师范学院计算机科学与工程系 武汉430205 |
| |
| 摘 要： | 对象关系数据库系统PostgreSQL提供的索引类型有:B-tree,R-tree,GiST和Hash。每种索引提供了适合不同查询类型的最优算法,而其中在大多数情况下都能适用,尤其适用于已经排好序的数据上的等值查询和范围查询。本文以最常用的B树索引为例,对PostgreSQL系统索引机制的建立进行了分析和探讨。
|
| 关 键 词： | 索引机制 B树索引 |
| 文章编号： | 1007-1687（2007）08-0016-03 |
| 修稿时间： | 2007-04-10 |
The Implementation of Index Mechanism in Object Relational Database |
| |
| RUAN Hong-yi.The Implementation of Index Mechanism in Object Relational Database[J].Training and Research-Journal of Hubei College of Education,2007,24(8):16-18. |
| |
| Authors: | RUAN Hong-yi |
| |
| Institution: | Department of Computer Science and Engineering, Hubei University of Education, Wuhan 430205, China |
| |
| Abstract: | The object relational database system PostgreSQL provides the following index types: B-tree,R-tree,GiST,and Hash.Different index types provide the most optimised methods for different query types.Most of them are suitable to many situations,especially to equal query and range query on ordered data.This paper investigates and analyses the index mechanism in PostgreSQL system based on the most common B-tree index. |
| |
| Keywords: | PostgreSQL |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
