UMLS Load Scripts

• Original Release Format
• Rich Release Format

Please note: These scripts require MySQL 5.

Instructions for MySQL Users:

• If you are running MetamorphoSys in a Windows environment, in your output directory (after running MetamorphoSys with the "Write MySQL Load Script" box checked) you should see a batch file script called "populate_mysql_db.bat".  This script can be used to load your subset into a MySQL database.   The directory will also contain an SQL script for creating the tables, and an SQL script for creating the indexes..
• Edit the script and configure the four parameters at the top of the script.  These are:
  
• Set MYSQL_HOME=<path to MYSQL_HOME>
    set user=<username>
    set password=<password>
    set db_name=<db_name>
  
• MYSQL_HOME should be set to the installation directory of your local MySQL server.  This is likely to be something like "C:\Program Files\MySQL\MySQL Server 5.0".  Remember to enclose the value in quotes if the directory name contains spaces.   After configuring these four parameters, this section of your script may look something like the following.
  
• set MYSQL_HOME="C:\Program Files\MySQL\MySQL Server 5.0"
  set user=myuser
  set password=p4ssw0rd
  set db_name=umls
  
• You are now ready to run the script.  To do so, navigate to your subset directory using the Windows explorer and double-click on the "populate_mysql_db.bat" file you just finished editing.
  
• Click here for more detailed instructions as well as other operating systems

• Original Release Format
• Rich Release Format

Instructions for Oracle Users:

• Create a schema specifically for this data.
• Set tablespace at unlimited, or high enough to ensure the amount of space available is what is needed by the data. Granting UNLIMITED TABLESPACE is acceptable as long as "AUTOEXTEND" is turned on to allow for unlimited table space growth.
• Create synonyms for tables or only access tables using the same login used to create them.
• Do not use the SYS/SYSTEM account to load data into the database since the default table space is SYSTEM, which is reserved for the data dictionary.
• Use MTH or another account to insert data into the database; do not use "AS SYSDBA" to see the tables. Setting the proper grants from the beginning will solve this problem.
• The loader script must be changed to SCHEMA.TABLE format to insert data into the proper tables if the SYS/SYSTEM account is used.
• The database must use the UTF-8 character set.