NIH | National Cancer Institute | NCI Wiki  

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Scrollbar
iconsfalse

Question: Do I need to create an empty database prior to caArray or other LSD tool installations?

Topic: caArray Installation and Upgrade

Release: Up to caArray 2.X

Date entered: 01/09/2009

Answer

It depends. The LSD installation guide (pages 8 and 9) recommends setting up an empty database prior to any LSD tool installation, except for those tools that do not require a database (see table below).

caArray, however, has a different database requirement based on the caArray version being installed.

caArray Release 2.1.1 and above

An empty database has to be created before commencing the caArray Installation.

...

It is worth mentioning: there is no need to pre-create any database table for caArray, since the installer will drop all existing caArray tables during caArray installation process.

Prior to caArray Release 2.1.1

There is no need to create an empty database before beginning the installation of caArray 2.1.0 or older. The installer would ask for the root user/admin-level user credentials and create the caArray DB and execute the DDL SQL for caArray schema.

Summary of Database Requirements for LSD Tools

Summary of Database Requirements for LSD Tools

Tools

Use database?

Pre-installed Database Required?

caArray

Y

Y for version 2.1.1 and above
N for older version

caIntegrator2

Y

Y

caGwas

Y

Y

caTissues

Y

Y

CTODs

Y

Y

geWorkbench

N/A

N/A

LSD Browser

N/A

N/A

NCIA

Y

Y

UPT

Y

Y

Have a comment?

Please leave your comment in the caArray End User Forum.

...