"

From 2012.igem.org

Contents 1 brief introduction 2 7.18 3 7.19 4 7.20

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), and show 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 database of an iGEM software team （求网址）at first. The database, which was contained parts of data of the website, included 13 tables, whose structure was different from the website, so it's inconvenient to search parts and get detailed result. Through several days "struggle", our group succeeded in loading data from xml which was provided by partsregistry.org and saved as sql file.
We chose mysql as database for its search functions.

7.18

For the division of work had been decided, members of databases 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 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 were devoted ourselves to select data from several tables, save it in a mutable array and show 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.