Stephen Louie Week 9 - Revision history

Slouie: added notification

2013-10-25T06:59:17Z

added notification

2013-10-25T06:56:33Z

‎Visual Inspection

2013-10-25T06:53:59Z

‎OriginalRowCounts Comparison

2013-10-25T06:50:10Z

‎TallyEngine

2013-10-25T06:43:29Z

‎OriginalRowCounts Comparison

2013-10-25T06:37:14Z

‎Using XMLPipeDB match to Validate the XML Results from the TallyEngine

2013-10-25T06:36:33Z

added to Gene Database testing report

2013-10-25T06:23:43Z

added to lab journal

← Older revision		Revision as of 06:59, 25 October 2013
Line 72:		Line 72:

	Note: Export started around 11 am; ended 3:17:55 pm.		Note: Export started around 11 am; ended 3:17:55 pm.
		+
		+	Note: Wiki seems to have trouble uploading files. Will make links available as they are uploaded.

	==TallyEngine==		==TallyEngine==

@@ Line 109: / Line 109: @@
 * Look at the Systems table. Is there a date in the Date field for all gene ID systems present in the database?
 * Open the UniProt, RefSeq, and OrderedLocusNames tables. Scroll down through the table. Do all of the IDs look like they take the correct form for that type of ID?
 Note:

@@ Line 100: / Line 100: @@
 Copy the OriginalRowCounts table and paste it here:
-[[Image: Capture.PNG.2.Slouie]]
+[[Image: Capture.PNG.2.Slouie.PNG]]
 Note:

← Older revision		Revision as of 06:50, 25 October 2013
Line 76:		Line 76:

	Run the TallyEngine in GenMAPP Builder and record the number of records for UniProt and GO in the XML data and in the PostgreSQL databases (or you can upload and link to a screenshot of the results).		Run the TallyEngine in GenMAPP Builder and record the number of records for UniProt and GO in the XML data and in the PostgreSQL databases (or you can upload and link to a screenshot of the results).
		+
		+	[[File:Capture.PNG.4.Slouie.PNG]]

	== Using XMLPipeDB match to Validate the XML Results from the TallyEngine==		== Using XMLPipeDB match to Validate the XML Results from the TallyEngine==

← Older revision		Revision as of 06:43, 25 October 2013
Line 97:		Line 97:

	Copy the OriginalRowCounts table and paste it here:		Copy the OriginalRowCounts table and paste it here:
		+
		+	[[Image: Capture.PNG.2.Slouie]]

	Note:		Note:

@@ Line 82: / Line 82: @@
 Are your results the same as you got for the TallyEngine?  Why or why not?
 '''The results are the same.  This is because XMLPipeDB Match and TallyEngine were given the same search prerequisites for ID tags in VC and VCA.
 '''
 == Using SQL Queries to Validate the PostgreSQL Database Results from the TallyEngine==

@@ Line 49: / Line 49: @@
 Version of GenMAPP Builder:
-Computer on which export was run:
+Computer on which export was run:Keck lab computer
 Postgres Database name:vc_slouie_20131022-gmb2b70
@@ Line 57: / Line 57: @@
 * Time taken to import:8.27 minutes
-GO OBO-XML filename:
+GO OBO-XML filename:go_daily-termdb-slouie-20131022.obo.xml
 * GO OBO-XML version (The version information can be found in the file properties after the file downloaded from the [http://beta.geneontology.org/page/download-ontology GO Download page] has been unzipped):
 * Time taken to import: 18.64 minutes
@@ Line 82: / Line 82: @@
 Are your results the same as you got for the TallyEngine?  Why or why not?
+'''The results are the same.  This is because XMLPipeDB Match and TallyEngine were given the same search prerequisites for ID tags in VC and VCA.
 == Using SQL Queries to Validate the PostgreSQL Database Results from the TallyEngine==

← Older revision		Revision as of 06:23, 25 October 2013
Line 32:		Line 32:
	#Right click on file and use 7zip to extract the contents of the file		#Right click on file and use 7zip to extract the contents of the file

		+	===PostgreSQL===
		+
		+	#Create a new database.
		+	#In the SQL editor, click on "Open File" in the toolbar and select the gmbuilder.sql from wherever you extracted the GenMAPP Builder package.
		+	#Click on the execute command to load the data tables.