菌物标本管理系统的研发与实践
发布时间:2009年07月28日 作者:黄满荣
黄满荣 邓 红
摘 要 鉴定历史与异名的处理是标本管理区别于其它事务管理的特点。从这两个特点出发,作者设计了一个专业性和实用性强的菌物标本数据库,本文对该数据库的设计思路进行了简单的介绍。
关键词 标本数据库 鉴定历史 异名
Development of Mycological Specimen Manager System
Huang Manrong Deng Hong
Abstract Two major differences between specimen manager and other transactions, i.e. determine history and synonyms, are analyzed, and based on which a new professional and practical mycological specimen manager database was developed. To avoid data redundancy and save storage space, the information of each specimen were decomposed into basic tables, which were bound with primary and foreign keys. Views, procedures and functions were used to translate the abstract data in basic tables into easily understandable data. Rules, triggers, programming and default values were extensively applied to keep the security, validity and integrality of data. Two special tables, viz. determine history table and synonym table, were introduced in the database to deal with the problems of determine history and synonyms respectively.
Key words specimen database, determine history, synonym
《菌物学报》,2007 26 (增刊),507-51