ArrayExpress

From Informatics

Jump to: navigation, search

ArrayExpress

 

  • What labs or how many are using ArrayExpress?

    - 0 (not accessible at the moment)

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

    - Manjunath

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

    - relational

  • Name/Size of database?

    - ArrayExpress

    - 1.85 GB

  • Anticipated yearly growth? (Megabytes/Gigabytes)

    - 0 MB (not being used now, as it was replaced by caArray 1.3.1 for MAGNeT)

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

      - Hot/online Oracle backups

  • What servers/operating systems are hosting them (IP addresses)
    • ADORA
    • IP =>
    • Windows 2003 Server
  • Approximately how many *active* users?

    • - no active users

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

    - not used

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

    - Oracle9i R2 (9.2.0.5)

  • What applications are using these databases?
    • Web interface?
    • Application (GUI)?
    • Command line interface (CUI)?
    • no user +interface except Enterprise Manager for DBA
    • NOTE: geWorkbench is capable of connecting to ArrayExpress through the code, but it is not available from the GUI interface
  • Is it accessible from outside the firewall to public users?

    - NO

  • What is the primary purpose of the database & types of data stored?
    • to store and analyze microarray data
    • MIAME compliant
    • based on MAGE-OM model
  • 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)
 
  • Would they like help in administering the database?
  • Backup Exec automates the backup and recovery
  • 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)
  • May I access the database and if so, what is the login info?

    - YES, I was given an admin account to the web interface and read-only privileges to connect via SSH to view the underlying database/tables

Retrieved from "http://wiki.c2b2.columbia.edu/informatics/index.php/ArrayExpress"
Personal tools