【正文】 I 摘 要 生物信息學(xué)是當(dāng)今最重要、最前沿的科學(xué)發(fā)展領(lǐng)域之一，已被廣泛用于基因序列數(shù)據(jù)的獲取、處理、分析和管理等許多方面，對于分子生物學(xué)和生物醫(yī)學(xué)研究的深入發(fā)展發(fā)揮了巨大作用。 隨著 生物數(shù)據(jù)庫的更新速度不斷加快，數(shù)據(jù)量呈指數(shù)增長趨勢，數(shù)據(jù)庫使用頻率增長更快 ，如何有效存儲和管理生物序列數(shù)據(jù)是生物信息學(xué)需要解決的重要問題之一。 基因數(shù)據(jù)庫綜合管理系統(tǒng)在生物信息領(lǐng)域是非常重要的資源管理手段 。 基于以上背景，開發(fā)一個簡單易用的基因數(shù)據(jù)庫綜合管理系統(tǒng)顯得很有必要。我們選擇B／ S 結(jié)構(gòu)，即 Browser／ Server(瀏覽器，服務(wù)器 )結(jié)構(gòu)，設(shè)計 開發(fā)了 基于 PHP 和 MySQL 的基因數(shù)據(jù)庫綜合管理系統(tǒng) ， 該系統(tǒng)可 實現(xiàn)對基因信息的讀取，查詢，注釋等操作。 基于 數(shù)據(jù)庫系統(tǒng) 設(shè)計的目的 在于 解決 研究中 產(chǎn)生 的大量 有待分析的基因組序列的有效存儲和管理問題 ，所以 本系統(tǒng) 的 所具有的功能是 可以進(jìn)行 DNA,RNA，蛋白質(zhì)序列信息的的錄入，查詢，查看相關(guān)注釋；并且具有序列格式轉(zhuǎn)換功能，轉(zhuǎn)化為標(biāo)準(zhǔn)的 FASTA 格式 等 。 本次畢業(yè)設(shè)計 以 Dreamweaver 為 工具 構(gòu)建 系統(tǒng) 的前臺工作 網(wǎng)站 ， 以 MySQL 作為后臺數(shù)據(jù)庫，以 Apache 為 HTTP 服務(wù)器，用 PHP 語言 構(gòu)建 了 基因信息的 數(shù)據(jù)庫系統(tǒng) 。 本系統(tǒng)實現(xiàn)了 高效、簡單、快速的 PHP 操作平臺 管理 基因數(shù)據(jù)庫的功能 ， 后臺 MySQL 數(shù)據(jù)庫 靈活 易于維護(hù)，更加 穩(wěn)定 、 安全。 【關(guān)鍵詞】 基因數(shù)據(jù)庫管理系統(tǒng) PHP MySQL Apache II ABSTRACT Biological informatics is one of the most important and advanced scientific frontiers now. It has been widely applied in many aspects such as the analysis, management of the gene sequence data and proved it‘s key role in the research of molecular biology and the pace of updating biological database, is growing speedily, the amount of gene data is exponentially growing, the frequency of database using is increasing faster, how to effectively storage data and manage biological sequences data is one of the important problems need to solve for bioinformatics. Geic database prehensive management system is very important resource management in biological information field. Based on the above background, developing an easytouse database prehensive management system is very necessary .We using B/S structure, namely the Browser/Server (browsers) structure, designing a prehensive management system for database of genes based PHP and MySQL . The system can realize the load of geic information, query, notes, etc. The design of database is aimed to effectively storage and management problems of the genome sequences that are generated largely and ready to be analysed. So this system can record the information of DNA, RNA, protein sequences, and related annotation to query, also the conversion function can format sequence into standard FASTA format. The graduation design is constructed geic database management system website with the framework for the Dreamweave. Geic information database system constructs with MySQL as backend database, with Apache for server, using PHP language. This system is simple, quick and efficient geic database management platform operated of the PHP,The backend MySQL database, more flexible and easy to maintain stability and security. 【 Key words】 geic database management system PHP MySQL Apache III 目 錄 前 言 .................................................................................................................................................. 1 1．課題提出背景 ......................................................................................................................... 1 2．本研究的目的與意義 ............................................................................................................. 1 第一章 開發(fā)環(huán)境介紹 ........................................................................................................................ 3 語言簡介 ........................................................................................................................... 3 PHP 運行環(huán)境 .................................................................................................................. 4 數(shù)據(jù)庫簡介 .................................................................................................................. 5 第二章 系統(tǒng)結(jié)構(gòu)與需求分析 ............................................................................................................ 7 B/S 結(jié)構(gòu)的簡介 ................................................................................................................ 7 1 .B/S 結(jié)構(gòu)的概念 ................................................................................................................. 7 ................................................................................................................. 8 ........................................................................................................................ 9 .......................................................................................................................... 10 第三章 系統(tǒng)概要設(shè)計 ...................................................................................................................... 11 .............................................................................................................................. 11 .......................................................................................................................... 11 3. 數(shù)據(jù)庫概念結(jié)構(gòu)設(shè)計 ............................................................................................................ 12 第四章 系統(tǒng)詳細(xì)設(shè)計 ...................................................................................................................... 15 一．系統(tǒng)設(shè)計方案 ..................................................................................................................... 15 二．創(chuàng)建數(shù)據(jù)表 ......................................................................................................................... 15 信息表的創(chuàng)建： ..................................................................................................... 15 信息表的創(chuàng)建： ..................................................................................................... 16 信息表的創(chuàng)建： ............................................................................................. 17 三．主要模塊設(shè)計 ..................................................................................................................... 18 ...................................................................................... 18 IV .....................