1 / 12

MITIAS Database Management System

MITIAS aims to streamline Dr. Lori Baker's mitochondrial DNA data storage and analysis processes. It involves decoding old databases, migrating data, permissions management, logging, and database normalization.

arich
Télécharger la présentation

MITIAS Database Management System

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. MITias final presentation By: BINF 4360

  2. Purpose of MITIAS • The purpose of MITIAS is to provide Dr. Lori Baker with a better system to store and analyze her mitochondrial DNA data, giving her more control and streamlining her work processes.

  3. Database Diagram

  4. Database Issues • Decoding old MOMA and LIMS databases • Migrating data from MOMA/LIMS into MITIAS • Figuring out how to link MOMA and LIMS • User/Project/Sample permissions issues • Logging • Production database

  5. Normalization • UP_UserPermission table is in BCNF because 3NFLJDP decomposition produces a single table in which us_username, pr_projectid is a super key and the only Functional Dependency. Therefore, this table is in BCNF • All other tables are in 5NF because the 3NFLJDP decomposition produces a single table in which there is only one candidate key, which is also a simple key. Therefore, these tables are in 5NF

  6. Admin • Add/Edit/Delete user • View statistics • Archive files • An administrator has full control over all users and projects. • Add video to demonstrate specific admin abilities.

  7. User • Edit profile • Change password • Create project (assuming admin permission) • Add video

  8. Project • Create/Delete project • Option to make private • Add description • Add/Modify/Delete users for project • Add/Delete samples for project • Add video demo

  9. Sample • Add sample • Analysis of samples • Video demo

  10. Analysis • Build contig from fragment • Find consensus sequences • Alignment • Video demo

  11. Query • Sequence name • Project name/id • Date • Sample Type • Sample ID • Case # • Agency • Mutation Type/Position • Video demo

  12. Future Work

More Related