ADOMETA

From Informatics

Jump to: navigation, search
  • What labs or how many are using ADOMETA?

    - Vitkup lab

  • Who is the main “database authority” for ADOMETA?

    - Lifeng Chen

  • What kind of database is it? (flat-file, relational, XML, etc)

    - relational

  • Size of database?

    - 250 MB

  • Anticipated yearly growth? (Megabytes/Gigabytes)

    - depends on how many new organisms are added each year

  • Backup procedures? How often?
    • Database backups (Hot, Cold, Both) [and/or]
    • Operating system backup

      - OS backup

  • What servers/operating systems are hosting them (IP addresses)
    • IP => 192.168.1.234 (ADSQL)
    • Red Hat Enterprise Linux AS release 3 (Taroon Update 6)
  • Approximately how many *active* users?
  • - N/A

  • How often is the database used? (Daily, Weekly, Monthly)

    - N/A

  • What platforms are being used? (Oracle, MySQL, PostgreSQL, etc)

    - MySQL version 3.23.58

  • What applications are using these databases?
    • Web interface?
    • Application (GUI)?
    • Command line interface (CUI)?
    • PHP web interface
  • Is it accessible from outside the firewall to public users?

    - YES (ADOMETA)

  • What is the primary purpose of the database & types of data stored?
    • ADOMETA is a bioinformatics resource designed to predict genes for orphan metabolic activities, which are known biochemical activities not currently assigned to genes in some or all organisms
    • ADOMETA returns a ranked list of genes likely to catalyze a given metabolic activity in a selected organism
    • ADOMETA currently provides computationally generated predictions of genes for orphan activities in the model bacteria Escherichia coli, B. subtilis, and bakers yeast S. cerevisiae
  • Are there any issues or problems with the database?
    • Specific error messages popping up?
    • Problems connecting from the application or web interface?
    • Performance issues (queries are slow, freezes at times, etc)
  • - no
  • Would they like help in administering the database?
  • - not at the moment
  • What additional features or changes would users like to see?
    • new tables or queries
    • additional screens on application or web interface
    • migrate to different database platform (i.e. MySQL to Oracle)
      • need to include many more organisms
         
Personal tools