摘要
军字一号医院信息系统是一个典型的数据库应用系统,其中使用了大量的索引对象,如何正确地使用和维护,关系到整个系统的性能。本文首先介绍了索引的作用及其优缺点,同时根据Oracle数据库的特点,提出了应用中建立索引应当掌握的原则,并针对应用中索引使用可能存在的问题,结合实际例句,阐述了如何合理使用索引,最后还根据军字一号的应用,简要介绍了索引的维护管理方案。
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.
出处
《医疗设备信息》
2006年第7期24-26,23,共4页
Information of Medical Equipment
关键词
医院信息系统
数据库
索引
hospital information system
database
index
