Because of a lapse in government funding, the information on this website may not be up to date, transactions submitted via the website may not be processed, and the agency may not be able to respond to inquiries until appropriations are enacted. The NIH Clinical Center (the research hospital of NIH) is open. For more details about its operating status, please visit cc.nih.gov. Updates regarding government operating status and resumption of normal operations can be found at OPM.gov.

Text Categorization

Load To TC Database

There are 2 steps to load data from files to Database for STI. They are detailed as follows:

  • Setup input data:
    • Directory:
      • Source: /nfsvol/crfiler-lex/Development/TC/2008a/data/2008X
    • Files:
      • ${TC_DIR}/data/Jdi/MhJdTable.txt
      • ${TC_DIR}/data/Jdi/ShJdTable.txt
      • ${TC_DIR}/data/Jdi/WordJdTable.txt

      • ${TC_DIR}/data/Sti/WordStTable.txt

      • ${TC_DIR}/data/Config/tc.properties
        Use DB_NAME to specify the database name

  • Load data from files to Database:
    • Directory:
      • cd ${TC_DIR}/bin/loadDb
    • Procedures:
      • Step 1: Create database
        1.CreateDb
      • Step 2: Increase cache size
        Modify "hsqldb.cache_file_scale=8" in ${TC_DIR}/data/HSqlDb/tc${YEAR}.properties
      • Step 3: Load Data to database
        3.LoadDb &{YEAR}
        • 1: 10 Min.
        • 2: 1 min.
        • 3: 30 Sec.
        • 4: 90 Min.
      • Step 4: Change to read only
        Modify "readonly=true" in ${TC_DIR}/data/HSqlDb/tc${YEAR}.properties

  • Backup database:
    • Backup database:
      • cd ${TC_DIR}/data
      • gtar -czvf /nfsvol/crfiler-lex/Development/TC/2008a/HSqlDbs/HSqlDb.${YEAR}.tgz HSqlDb.${YEAR}
    • Move Data Files:
      • cd ${TC_DIR}/data/HSqlDb.${YEAR}
      • mv * /export/home/lu/Projects/TC/tc2009/data/HSqlDb/.
      • cd ..
      • rm -f HSqlDb.${YEAR}