Back-end Database

The back-end database that holds the genetic marker data is a MySQL relational database. The storage of the Map is broken up into 5 layers. The relationship between 2 layers next to each other is a one-to-many relationship. The layers are the following.

1. Species
2. Mapset
   • This is what is uploaded to YouGenMap. A Mapset is comprised of a set of Maps that are similar in some nature and are expected to all be under the same species. When a Mapset is uploaded, it is expected to have a unique name.
3. Map
4. Feature
5. Feature Alias and Attributes
   • This last layer is really comprised of two different layers that are both under the Feature layer. A feature may have multiple aliases as well as it may have multiple attributes (GeneBank ID, Unigene ID, etc).