Gus3.5DevelopmentNotes

GUS 3.0 Invalid Superclasses:

• tess.sbcgrecognition
• rad3.biomaterial
• core.workflownode
• dots.aasequence
• dots.aafeature
• dots.nasequence
• dots.nafeature

From 3.0 Schema Generation:

From CBILBLD Schema Generation:

09:20:54,934  WARN SchemaReader:237 - Index against a generic column SMALLSTRING1 in index RAD3_SPOTFAMILY_IND01.  Skipped.
09:20:55,341  WARN SchemaReader:237 - Index against a generic column TINYSTRING1 in index SAGETAG_IND01.  Skipped.
09:20:55,922  WARN SchemaReader:237 - Index against a generic column CHAR1 in index SPOT_IND01.  Skipped.
09:20:56,098  WARN SchemaReader:237 - Index against a generic column TINYSTRING1 in index SHORTOLIGO_IND01.  Skipped.
09:21:39,291  WARN SchemaReader:237 - Index against a generic column STRING2 in index AASEQUENCEIMP_IND08.  Skipped.
09:21:41,234  WARN SchemaReader:237 - Index against a generic column STRING1 in index EPITOPEFEATURE_IND01.  Skipped.
09:21:41,359  WARN SchemaReader:237 - Index against a generic column INT1 in index AAFEATUREIMP_IND06.  Skipped.
09:21:43,297  WARN SchemaReader:237 - Index against a generic column STRING1 in index AASEQUENCEIMP_IND04.  Skipped.
09:21:58,884  WARN SchemaReader:237 - Index against a generic column STRING5 in index NAFEATUREIMP_IND09.  Skipped.
09:21:59,395  WARN SchemaReader:237 - Index against a generic column STRING14 in index NAFEATUREIMP_IND06.  Skipped.
09:21:59,546  WARN SchemaReader:237 - Index against a generic column STRING1 in index NAFEATUREIMP_IND07.  Skipped.
09:22:01,300  WARN SchemaReader:237 - Index against a generic column STRING1 in index NASEQUENCEIMP_IND01.  Skipped.
09:22:01,720  WARN SchemaReader:237 - Index against a generic column INT1 in index NASEQUENCEIMP_IND07.  Skipped.
09:22:02,004  WARN SchemaReader:237 - Index against a generic column STRING4 in index NASEQUENCEIMP_IND09.  Skipped.
09:22:02,095  WARN SchemaReader:237 - Index against a generic column INT1 in index NASEQUENCEIMP_IND10.  Skipped.
09:22:02,165  WARN SchemaReader:237 - Index against a generic column STRING2 in index NASEQUENCEIMP_IND13.  Skipped.
09:22:09,403  WARN SchemaReader:248 - Index against a housekeeping column ROW_ALG_INVOCATION_ID in index SIMILARITY_IND08.  Skipped.
09:23:22,274 ERROR SchemaReader:457 - tableinfo row doesn't exist for AFFYMETRIXANNOTATION
09:23:23,037 ERROR SchemaReader:457 - tableinfo row doesn't exist for TEMP_ARRAYVIEWER_INTENSITY
09:23:24,620 ERROR SchemaReader:457 - tableinfo row doesn't exist for GUSLINKTEMP2
09:23:32,797 ERROR SchemaReader:457 - tableinfo row doesn't exist for ASSAYGROUP
09:23:33,513 ERROR SchemaReader:457 - tableinfo row doesn't exist for ELEMENTASSEMBLY_MV
09:23:33,667 ERROR SchemaReader:457 - tableinfo row doesn't exist for ELEMENTASSEMBLYACCESSION_MV
09:23:34,539 ERROR SchemaReader:457 - tableinfo row doesn't exist for COMPOSITEELEMENTASSEMBLY_MV
09:23:35,842 ERROR SchemaReader:457 - tableinfo row doesn't exist for SEQUENCEFEATURERELATION
09:23:38,255 ERROR SchemaReader:457 - tableinfo row doesn't exist for ActivityGeneRegulation
09:23:38,571 ERROR SchemaReader:457 - tableinfo row doesn't exist for SEQUENCEFEATURE
09:23:39,081 ERROR SchemaReader:457 - tableinfo row doesn't exist for PREDICTIONRESULT
09:23:39,580 ERROR SchemaReader:457 - tableinfo row doesn't exist for MODELRESULT
09:23:40,603 ERROR SchemaReader:457 - tableinfo row doesn't exist for SBCGRECOGMULTIOBS
09:23:49,085 ERROR SchemaReader:457 - tableinfo row doesn't exist for RNARNACATEGORY
09:23:53,438 ERROR SchemaReader:457 - tableinfo row doesn't exist for ASSEMBLYSEQUENCE_NEW
09:24:10,114 ERROR SchemaReader:457 - tableinfo row doesn't exist for ASSAYGROUP
09:24:10,227 ERROR SchemaReader:457 - tableinfo row doesn't exist for ANALYSISGROUP
09:24:10,367 ERROR SchemaReader:457 - tableinfo row doesn't exist for ANATOMYMOTERM

CBIL Clean Up

These items affect GUS only by virtue that CBIL's database has served as the official schema up until this release. As a consequence these items affect the new administrative tool and are noted here.

• Coalesce various comments table into single Comment table
• Remove space from column names: RAD3.TEMP_ARRAYVIEWER_INTENSITY -- "normalized log value", "dots id"

• Tables without Core.TableInfo entries:

  • RAD3.TEMP_ARRAYVIEWER_INTENSITY
  • TESS.SEQUENCEFEATURE (delete per Schug)
  • TESS.SEQUENCEFEATURERELATION (delete per Schug)
  • RAD3.COMPOSITEELEMENTASSEMBLY_MV
  • APP.ANATOMYMOTERM (delete per EJT)
  • RAD3.GUSLINKTEMP2 (delete per EJT)
  • RAD3.AFFYMETRIXANNOTATION (delete per EJT)
  • DOTS.ASSEMBLYSEQUENCE_NEW
  • CORE.VIEWCOLUMNINFO
  • RAD3.ELEMENTASSEMBLY_MV
  • RAD3.PROCESSIOELEMENT_MV (delete per EJT)
  • APP.ANALYSISGROUP
  • COREVER.VIEWCOLUMNINFOVER
  • RAD3.ELEMENTASSEMBLYACCESSION_MV (delete per EJT)
  • RAD3.PROCESSIOCOMPELEMENT_MV (delete per EJT)
  • RAD3.ASSAYGROUP (move to radq per EJT)
  • APP.ASSAYGROUP (move to radq per EJT)