Database and Software Development

MGD的生物导向功能和用户界面是一个复杂的信息系统，包括无数的数据库结构和软件组件。核心1的目的是维护这个信息系统，同时开发和部署新的功能和数据类型，以支持本计划项目的目标。 MGD的中心是一个可扩展的关系数据库。它的大小约为11 GB，包含180多个表以及其他组件，如视图、存储过程和触发器。 此外，超过54 GB的序列数据存储在关系数据库之外。我们估计关系数据库和外部序列数据的倍增期约为18个月。 目前MGD系统的软件分为133个不同的定制软件组件，包括9，400多个源文件和830，000多行代码。这些组件部署在5个主要Unix服务器上;其中两个服务器支持公众访问，平均每月超过200万次网络点击（超过46次点击/分钟）。 在截至2005年10月的当前授权期间，我们已经发布了17个公共软件和数据库。这些变化的亮点包括改变MGD以处理大型结构化词汇表，如哺乳动物表型（MP）本体论和基因本体论（GO），改造小鼠表型和疾病模型，并将序列数据和基因组坐标与其他MGD数据整合在一起。我们还重新设计了Web界面的“外观”，以更紧凑的显示方式提供更多信息，更好的导航和简单的“单字段”搜索工具。

Underlying MGD's biologically-oriented functionality and user interface is a complex information system comprising myriad database structures and software components. The purpose of Core 1 is to maintain this information system while simultaneously developing and deploying new features and data types in support of the aims of this Program Project. At the center of MGD is a Sybase relational database. It is approximately 11 GB in size and contains over 180 tables as well as other components such as views, stored procedures, and triggers. Additionally, over 54 GB of sequence data are stored outside the relational database. We estimate the doubling period of the relational database and external sequence data to be around 18 months. The software of the current MGD system is organized into 133 distinct custom software components comprising over 9,400 source files with over 830,000 lines of code. These components are deployed across 5 main Unix servers; two of these servers support public access with an average over 2 million web hits per month (over 46 hits/minute). In the current granting period through October, 2005 we have had 17 public software and database releases. Highlights of these changes include changing MGD to handle large structured vocabularies like the Mammalian Phenotype (MP) Ontology and the Gene Ontology (GO), revamping mouse phenotypes and disease models, and integrating sequence data and genome coordinates in with other MGD data. We also redesigned the web interface "look and feel" to provide more information in more compact displays, better navigation, and an easy "one-field" search tool.