| 军字一号数据库索引的应用与维护探讨 |
| |
| 引用本文： | 刘志敏,张震江.军字一号数据库索引的应用与维护探讨[J].医疗设备信息,2006,21(7):24-26,23. |
| |
| 作者姓名： | 刘志敏 张震江 |
| |
| 作者单位： | 解放军总医院计算机室,北京100853 |
| |
| 摘 要： | 军字一号医院信息系统是一个典型的数据库应用系统,其中使用了大量的索引对象,如何正确地使用和维护,关系到整个系统的性能.本文首先介绍了索引的作用及其优缺点,同时根据Oracle数据库的特点,提出了应用中建立索引应当掌握的原则,并针对应用中索引使用可能存在的问题,结合实际例句,阐述了如何合理使用索引,最后还根据军字一号的应用,简要介绍了索引的维护管理方案.
|
| 关 键 词： | 医院信息系统 数据库 索引 |
| 文章编号： | 1007-7510（2006）07-0024-03 |
| 收稿时间： | 2006-04-17 |
| 修稿时间： | 2006-04-17 |
Application and maintenance of the database indexes on hospital information system |
| |
| LIU Zhi - min,ZHANG Zhen -jiang.Application and maintenance of the database indexes on hospital information system[J].Information of Medical Equipment,2006,21(7):24-26,23. |
| |
| Authors: | LIU Zhi - min ZHANG Zhen -jiang |
| |
| Institution: | Computer Department of PLA General Hospital, Beijing 100853, China |
| |
| Abstract: | Hospital information system is a typical database application,in which a large number of tables and indexes are applied.To apply and maintain these tables and indexes correctly is relative to the whole system's performance.This article introduces the functions,merits and demerits of indexes.According to the features of Oracle databases,the rules that should be mastered to create indexes in applications are provided.Meanwhile,some examples are given to explain how to use indexes rationally.A solution on how to maintain and manage indexes is briefly described finally. |
| |
| Keywords: | hospital information system database index |
| 本文献已被 CNKI 维普 等数据库收录！ |
|
