Nanguiano Individual Assessement

Statement of Work

On my project, I completed a successful export of V. cholerae which solved the problems I had faced in the initial export I had attempted. To perform the export, I modified an existing GO OBO-XML DTD schema to work with a new OBO-XML file that used a schema that no longer worked with GenMAPP Builder. I ran xsd2db on the manually edited DTD file to obtain files that could be used in GenMAPP Builder. I ran GODB Post Processor on the specified HBM and SQL files to allow them to be properly added to GenMAPP Builder. I replaced the old files in GenMAPP Builder with the new files generated by xsd2db and GODBPostProcessor, and overwrote GMBuilder.sql with the contents of the schema.sql file that was edited by GODB Post Processor so that it could build the proper table initially. I wrote documentation on how to perform updates to GMBuilder in the event of an OBO-XML schema change in the future. Following all of this, I performed an export of V. cholerae, which completed successfully. Then I performed quality assurance on the export, the details of which can be found in the

Report

. Following this, I converted the XMLPipeDB website to Jekyll, and moved it to a gh-pages branch on github, giving it a new github domain. The primary website was redirected to the github site link. Following this, I ran SchemaSpy on the database, the results of which can be found here for uniprotdb, here for godb, and here for gmbuilder. I also wrote up documentation on how to use SchemaSpy for future reference.