Database and Software Development

数据库和软件开发

• 批准号: 8150370
• 负责人: JOEL E. RICHARDSON
• 金额: $ 237.97万
• 依托单位: JACKSON LABORATORY
• 依托单位国家: 美国
• 资助国家: 美国
• 起止时间: 至
• 项目状态: 未结题
• 来源: https://reporter.nih.gov/project-details/8150370
• 关键词: Biological; Code; Communities; Complex; Computer software; Custom; Data; Databases; Development; Disease model; Documentation; Electronic Mail; Evolution; Future; Genes; Genome; Grant; Individual; Information Systems; Internet; Maintenance; Mission; Mus; Ontology; Performance; Phenotype; Procedures; Process; Production; Research; Research Infrastructure; Resources; Services; Software Engineering; Source; Structure; System; Time; Vocabulary; data modeling; database structure; design; improved; programs; relational database; software development; software systems; system architecture; tool; web interface; web site

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.

基础MGD的以生物学为导向的功能和用户界面是一个复杂的信息系统，其中包括无数数据库结构和软件组件。 Core 1的目的是在同时开发和部署新功能和数据类型的同时维护此信息系统，以支持该计划项目的目标。 在MGD的中心是Sybase关系数据库。它的尺寸约为11 GB，包含超过180个表以及其他组件，例如视图，存储过程和触发器。 此外，超过54 GB的序列数据存储在关系数据库之外。我们估计关系数据库和外部序列数据的加倍时期约为18个月。 当前MGD系统的软件被组织成133个不同的自定义软件组件，其中包含9,400多个源文件，其中包含超过830,000行代码。这些组件分布在5个主要的UNIX服务器中；这些服务器中的两台服务器平均每月平均超过200万个网络击中（超过46次击中/分钟）。 在当前截至2005年10月的授予期内，我们有17个公共软件和数据库发布。这些变化的亮点包括更改MGD，以处理大型结构化词汇量，例如哺乳动物表型（MP）本体论和基因本体论（GO），对小鼠表型和疾病模型进行了改造，以及将序列数据和基因组坐标整合到中的其他MGD数据。我们还重新设计了Web界面“外观和感觉”，以在更紧凑的显示器，更好的导航和简单的“单场”搜索工具中提供更多信息。