上海农作物种质资源数据库的设计和构建

随着农作物种质资源数量的不断增加,种质资源交流的日益频繁以及种质资源利用的逐步深入,农作物种质资源数据库的建设对农作物的应用研究和基础性研究至关重要。上海市农业生物基因中心借助于本中心保存的近21万份种质资源的信息,开发了一套上海农作物种质资源数据库,本文主要阐述了该数据库设计和构建的目的、原则和数据库的架构、运行环境以及主要功能模块。上海农作物种质资源数据库采用了B/S结构,平台系统利用多层逻辑架构实现了对农作物种质资源数据信息的收集、存储、查询、统计分析等功能。外部用户通过浏览器即可访问平台系统,浏览查询种质资源信息。内部管理员可使用平台的受限功能,需要认证成功后才可使用后台管理功能,实现对整个平台数据的管理。注册用户还可通过基因资源数据库提交引种申请,管理员结合管理信息系统实现对外供种全流程的网络化,借此可提高工作效率,增加工作流程的透明度。

Design and Construction of Shanghai Crop Germplasm Resource Database

With the increase of crop germplasm resources,the increasingly frequent exchange of germplasm resources and the gradual deepening of the utilization of germplasm resources,the construction of crop germplasm resources database is very important for the application research and basic research of crops.Shanghai Agricultural Biological Gene Center has developed a set of Shanghai crop germplasm resources database,based on the information of nearly 210000 crop germplasm preserved by the Center.This paper mainly describes the purpose and principle of the database design and construction,architecture of the database,running environment and main function modules.The database of Shanghai Crop Germplasm Resources inadopts B/S structure,and the platform system realizes the collection,storage,query,statistical analysis and other functions of crop germplasm resources data using multi-layer logical structure.External users can access the platform system through browser,browse and query germplasm resources information.The internal administrator can use the limited function of the platform and manage the whole platform data,when the authentication is successful.Registered users can also submit the introduction application through the gene resource database,and administrators can carry out network management for the whole process of external supply.This can improve work efficiency and increase the transparency of workflow.