WORD_ST_SCORES Table
- I. Db Table
WORD_ST_SCORES Name Type Properties Notes word VARCHAR(50) Index, NOT NULL Words from Journals (lower case) tui VARCHAR(5) Index, NOT NULL Semantic Types ID wordScore FLOAT scores based on word frequency documentScore FLOAT scores based on document count for words - II. SQL Examples
- Find scores for WORD, "XXX"
- "xxx" = "XXX".toLowerCase( );
- SELECT tui, wordScore, documentScore FROM WORD_ST_SCORES WHERE word= 'xxx';
- Find scores for WORD, "XXX"
- III. Notes
- When load data of this table into HSqlDb, the cache data file size is exceed the limit (> 2GB). To fix this problem, we should change the cache file value in the HSqlDb configuration file as follows:
- under HSqlDb/tc${YEAR}.properties
- hsqldb.cache_file_scale=1 (default, 2GB) to hsqldb.cache_file_scale=8 (8 Gb)
- When load data of this table into HSqlDb, the cache data file size is exceed the limit (> 2GB). To fix this problem, we should change the cache file value in the HSqlDb configuration file as follows: