NIH | National Cancer Institute | NCI Wiki  

Versions Compared

Old Version 49

changes.mady.by.user Unknown User (kanjamalapp)

Saved on

compared with

New Version 50

changes.mady.by.user Unknown User (kanjamalapp)

Saved on

Key

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

...

Step

Action

1. Configure Database Management System properties

We provide examples of MySQL and PostgreSQL configurations to optimize a database for LexEVS.

Note
titleNote

It is considered beyond the scope of these install instructions to address database setup and administration. However, proper database configuration is critical to the performance and long-term health of the LexEVS environment. System administrators should consult the MySQL or PostgreSQL documentation to determine settings that are appropriate to the host machine and environment. Tuning should be performed prior to loading vocabularies. At a minimum, users must create a target database (see the next step) on the database server and provide user credentials for creating, deleting, and writing to tables.

2. Create a database

LexEVS does not create a database for you. You must do this as the administrator of your database management system.

Consult database management system documentation. We provide an example and a recommendation for MySQL. LexEVS must have access to a user with rights to create, update and delete tables.

3. Make sure the JDBC driver is in place

The java software interface for a given supported database must be available in the <install-root>/runtime/sqlDrivers directory

  • Check {LEXEVS_HOME}\runtime\sqlDrivers to see if the appropriate driver for your database is there. Licensing restrictions prevent some drivers, like those from MySQL, from being shipped with LexEVS.
  • MySQL driver can be downloaded from MySQL downloads.

4. Modify the LexEVS configuration file

Update the LexEVS service properties file {LEXEVS_HOME}/resources/config/lbconfig.propswith connection and database settings

Note
titleNote

This file contains properties controlling the behavior of the LexEVS Local Runtime. You must at least adjust the database configuration values for LexEVS within this file.

The lbconfig.props file has the latest documentation embedded inside of it. lbconfig.props should be considered authoritative if there is a difference between the documentation written here and that contained in lbconfig.props.
You may open that file now and use the documentation within it to configure LexEVS.
The following link describes all of the property settings available for configuring LexEVS. It may have additional descriptive information beyond that found within lbconfig.props. It is useful but not necessary to a successful install.
LexEVS 6.x Local Runtime Configuration File Settings

5. Set DB_PRIMARY_KEY_STRATEGY

Take extra care to consider this parameter in the configuration file. The value for the parameter may not be optimal for loading terminologies. You must change its value before any LexEVS operations. Once there have been any operations you can not reset this parameter without deleting the database and recreating it.

See the parameter settings documentation for more information.

...