IC Bioinfs/Project1/toydatabase

From OpenWetWare
Jump to navigationJump to search

Toy Database

An SQL database created from the DAS and FASTA output of the MIT Parts Registry.


Online Database

The toy database has been established on codon.

  • Database name: msc_09_das
  • Username/password: as above.
  • Host name: db-bss.lesc.doc.ic.ac.uk

Access Via Codon

Login to your codon account, then enter the following command at the prompt:

mysql msc_09_das -u msc_09_das -p

Access via Other Servers

At the prompt:

mysql msc_09_das -u msc_09_das -p -h db-bss.lesc.doc.ic.ac.uk


Versions

Please make sure to use the latest version of the database schema, and associated data.

Version 2

Created week of 08/02/2010

Changes

  • New internal identifiers for each table
  • Shifting of columns between tables
  • The feat_info table is now non-redundant

Files

Tables

Schema v2.jpg

Version 1

Created week of 01/02/2010

Files