You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@ctakes.apache.org by se...@apache.org on 2014/11/04 17:09:12 UTC
svn commit: r1636630 - in /ctakes/sandbox/dictionarytool/resource: README.txt cachedbtemplate/ctakesumls.script memdbtemplate/ctakesumls.script

Author: seanfinan
Date: Tue Nov  4 16:09:11 2014
New Revision: 1636630

URL: http://svn.apache.org/r1636630
Log:
Templates updated for new multi-table database format

Modified:
    ctakes/sandbox/dictionarytool/resource/README.txt
    ctakes/sandbox/dictionarytool/resource/cachedbtemplate/ctakesumls.script
    ctakes/sandbox/dictionarytool/resource/memdbtemplate/ctakesumls.script

Modified: ctakes/sandbox/dictionarytool/resource/README.txt
URL: http://svn.apache.org/viewvc/ctakes/sandbox/dictionarytool/resource/README.txt?rev=1636630&r1=1636629&r2=1636630&view=diff
==============================================================================
--- ctakes/sandbox/dictionarytool/resource/README.txt (original)
+++ ctakes/sandbox/dictionarytool/resource/README.txt Tue Nov  4 16:09:11 2014
@@ -13,7 +13,8 @@ completely in JVM memory upon startup.  
 In-memory databases are significantly faster than those referenced disk-cached, but should not be used if
 the dictionary is significantly large. This may mean >> 1 million rows, but depends upon your available memory.
 
-Both databases are named cTakesUmls and are set up to contain one rare-word table named ctakes_umls.
+Both databases are named ctakesumls and are set up to contain one rare-word table named cui_terms, plus several property tables
+named tui, prefterm, rxnorm, etc.  The property tables each have two columns, the first being named cui and the second having the same name as the table.  
 The .properties file contains a line with readonly=false.  Leave this property as false (read/write) until you have
 finished populating the table, then set it to readonly=true, which (supposedly) increases lookup speed.
 

Modified: ctakes/sandbox/dictionarytool/resource/cachedbtemplate/ctakesumls.script
URL: http://svn.apache.org/viewvc/ctakes/sandbox/dictionarytool/resource/cachedbtemplate/ctakesumls.script?rev=1636630&r1=1636629&r2=1636630&view=diff
==============================================================================
--- ctakes/sandbox/dictionarytool/resource/cachedbtemplate/ctakesumls.script (original)
+++ ctakes/sandbox/dictionarytool/resource/cachedbtemplate/ctakesumls.script Tue Nov  4 16:09:11 2014
@@ -1,6 +1,18 @@
 CREATE SCHEMA PUBLIC AUTHORIZATION DBA
-CREATE CACHED TABLE CTAKES_UMLS(CUI VARCHAR_IGNORECASE(12),TUI VARCHAR_IGNORECASE(48),RINDEX INTEGER,TCOUNT INTEGER,TEXT VARCHAR_IGNORECASE(255),RWORD VARCHAR_IGNORECASE(48))
-CREATE INDEX IDX_CTAKES_UMLS ON CTAKES_UMLS(RWORD)
+CREATE MEMORY TABLE CUI_TERMS(CUI BIGINT,RINDEX INTEGER,TCOUNT INTEGER,TEXT VARCHAR(255),RWORD VARCHAR(48))
+CREATE INDEX IDX_CUI_TERMS ON CUI_TERMS(RWORD)
+CREATE MEMORY TABLE TUI(CUI BIGINT,TUI INTEGER)
+CREATE INDEX IDX_TUI ON TUI(CUI)
+CREATE MEMORY TABLE SNOMEDCT(CUI BIGINT,SNOMEDCT BIGINT)
+CREATE INDEX IDX_SNOMEDCT ON SNOMEDCT(CUI)
+CREATE MEMORY TABLE RXNORM(CUI BIGINT,RXNORM BIGINT)
+CREATE INDEX IDX_RXNORM ON RXNORM(CUI)
+CREATE MEMORY TABLE ICD9CM(CUI BIGINT,ICD9CM VARCHAR(48))
+CREATE INDEX IDX_ICD9CM ON ICD9CM(CUI)
+CREATE MEMORY TABLE ICD10PCS(CUI BIGINT,ICD10PCS VARCHAR(48))
+CREATE INDEX IDX_ICD10PCS ON ICD10PCS(CUI)
+CREATE MEMORY TABLE PREFTERM(CUI BIGINT,PREFTERM VARCHAR(255))
+CREATE INDEX IDX_PREFTERM ON PREFTERM(CUI)
 CREATE USER SA PASSWORD ""
 GRANT DBA TO SA
 SET WRITE_DELAY 10

Modified: ctakes/sandbox/dictionarytool/resource/memdbtemplate/ctakesumls.script
URL: http://svn.apache.org/viewvc/ctakes/sandbox/dictionarytool/resource/memdbtemplate/ctakesumls.script?rev=1636630&r1=1636629&r2=1636630&view=diff
==============================================================================
--- ctakes/sandbox/dictionarytool/resource/memdbtemplate/ctakesumls.script (original)
+++ ctakes/sandbox/dictionarytool/resource/memdbtemplate/ctakesumls.script Tue Nov  4 16:09:11 2014
@@ -1,6 +1,18 @@
 CREATE SCHEMA PUBLIC AUTHORIZATION DBA
-CREATE MEMORY TABLE CTAKES_UMLS(CUI VARCHAR_IGNORECASE(12),TUI VARCHAR_IGNORECASE(48),RINDEX INTEGER,TCOUNT INTEGER,TEXT VARCHAR_IGNORECASE(255),RWORD VARCHAR_IGNORECASE(48))
-CREATE INDEX IDX_CTAKES_UMLS ON CTAKES_UMLS(RWORD)
+CREATE MEMORY TABLE CUI_TERMS(CUI BIGINT,RINDEX INTEGER,TCOUNT INTEGER,TEXT VARCHAR(255),RWORD VARCHAR(48))
+CREATE INDEX IDX_CUI_TERMS ON CUI_TERMS(RWORD)
+CREATE MEMORY TABLE TUI(CUI BIGINT,TUI INTEGER)
+CREATE INDEX IDX_TUI ON TUI(CUI)
+CREATE MEMORY TABLE SNOMEDCT(CUI BIGINT,SNOMEDCT BIGINT)
+CREATE INDEX IDX_SNOMEDCT ON SNOMEDCT(CUI)
+CREATE MEMORY TABLE RXNORM(CUI BIGINT,RXNORM BIGINT)
+CREATE INDEX IDX_RXNORM ON RXNORM(CUI)
+CREATE MEMORY TABLE ICD9CM(CUI BIGINT,ICD9CM VARCHAR(48))
+CREATE INDEX IDX_ICD9CM ON ICD9CM(CUI)
+CREATE MEMORY TABLE ICD10PCS(CUI BIGINT,ICD10PCS VARCHAR(48))
+CREATE INDEX IDX_ICD10PCS ON ICD10PCS(CUI)
+CREATE MEMORY TABLE PREFTERM(CUI BIGINT,PREFTERM VARCHAR(255))
+CREATE INDEX IDX_PREFTERM ON PREFTERM(CUI)
 CREATE USER SA PASSWORD ""
 GRANT DBA TO SA
 SET WRITE_DELAY 10