"
Team:SUSTC-Shenzhen-A/Notebook/search result
From 2012.igem.org
Contents |
brief introduction
Search result group includes six members. The main goal of this group is to create an interface to accept the result(part name) of bio-brick searching (which is sent by the SE group),showing the details of this part.
In this part, database was the most important thing and five members were successively working on it.
Our members used a database of an iGEM software team （求网址）at first. Though the database consist of 13 tables, it still cannot include all the data of the website. Also since its different structure, the utility of the whole database is with doubt. After days of struggle, our group succeeded in loading data from xml which was provided by partsregistry.org and saved as sql file.
We chose MYSQL as our database management system for its search functions.
7.18
Once the division on the whole project was decided, the team in charge of the database started to analyse the mysql files and collect all the titles. By comparing the database and the website, we found that the database was incomplete, which didn't contain the description written by different authors, and the structure was totally different from the website. In order to build a part-name-based search result, we needed to search the whole database again when SE returned us the part name and collected the result.
7.19
Considering there were a lot of data titles and some of them contained few data, we tried to pick only necessary parts out. This day we devoted ourselves to select data from several tables, save it in a mutable array and show the result as table form.
7.20
Our instructor Dr. He gave us the xml form data which was provided by partsregistry.org itself. Therefore our focus of work changed to "analyzing the xml file and saving it as a sql file".We test two methods: used Excel to load the xml file, saved as xls file, then changed it to mysql;directly used load function of mysql to get data from xml file and saved in sql.
