STMT - HSqlDb Files

I. Database Tables

The preprocessed files are loaded to HSqlDb tables for DB query to reduce the Java VM size and increase performance. These DB tables include:

II. Run Program

• Make sure Lvg is installed under ${PROJECTS}
• Deploy tables from Table Files
  shell> cd ${STMT_DIR}/PreProcess/bin
shell> 3.DeployTables
STMT data year (the release year, 2018, ...)
table type
  
  • 1 (AA), 2 (Ascii), 3(AB)

• Link ${STMT}/data/tables to the specified version:
  • tables.${YEAR}AA
  • tables.${YEAR}Ascii
  • tables.${YEAR}AB)
  
  shell> ln -sf tables.2015AA tables
shell> ln -sf tables.2015Ascii tables
shell> ln -sf tables.2015AB tables

• Load Db tables
  shell> cd ${STMT_DIR}/PreProcess/bin
shell> 4.LoadDb
Db Year (2015AA|2015AB|2015Ascii)
STMT release (the release year, 2018, ...)
1, 2, 3: for all three tables
  1: analysis
  • make sure max. length of all fields in all DB tables are OK
  
  2: load
  • Update db.config.${TABLE_TYPE} in ${STMT_PRE_PROCESS}/data/HsqlDb/config/
  
  3: check
  • Add readonly=true in ${HSQLDB}/HSqlDb.${DbYear}/stmt${DbYear}.properties
  • check above 3 tables:
    • CUI table: disease => C0012634
    • EUI table: disease => E0023270
    • CUI_PT table: C0012634 => Disease

• zip the HSqlDb files
  • shell>cd ${STMT_PREPROC_DIR}/data/HSqlDb
  • shell>tar -czvf HSqlDb.${VERSION}.tgz HSqlDb.${VERSION}
  • shell>mv HSqlDb.${VERSION}.tgz ${BACKUP_DIR}/Releases/STMT/daa/HsqlDb

• Update documents

III. Version

Directory: ${STMT_DIR}/PreProcess/data/HSqlDb/