(str :value-type cdata :initarg :str :reader str)
(lrl :value-type fixnum :initarg :lrl :reader lrl)
(stt :value-type string :initarg :stt :reader stt)
- (s#so :reader s#atom :subobject (find-uso-cuisui cui sui))
+ (s#so :reader s#so :subobject (find-uso-cuisui cui sui))
(s#sat :reader s#sat :subobject (find-usat-ui cui lui sui))
(s#cxt :reader s#cxt :subobject (find-ucxt-cuisui cui sui)))
(:metaclass hyperobject-class)
(ignore-errors (sql-execute "drop table USRL" conn)))
(sql-execute "create table USRL (sab varchar(80), srl integer)" conn)
(dolist (tuple (mutex-sql-query
- "select distinct SAB,SRL from MRSO order by SAB asc"))
+ "select distinct SAB,SRL from MRCONSO order by SAB asc"))
(sql-execute (format nil "insert into USRL (sab,srl) values ('~a',~d)"
(car tuple) (ensure-integer (cadr tuple)))
conn)))
(insert-ustats-count conn "Concept Count" "MRCONSO" "distinct CUI" "KCUILRL" srl)
(insert-ustats-count conn "Term Count" "MRCONSO" "distinct KCUILUI" "KCUILRL" srl)
(insert-ustats-count conn "Distinct Term Count" "MRCONSO" "distinct LUI" "KLUILRL" srl)
- (insert-ustats-count conn "String Count" "MRCONSO" "*" "LRL" srl)
- (insert-ustats-count conn "Distinct String Count" "MRCONSO" "distinct SUI" "LRL" srl)
+ (insert-ustats-count conn "String Count" "MRCONSO" "*" "KSUILRL" srl)
+ (insert-ustats-count conn "Distinct String Count" "MRCONSO" "distinct SUI" "KSUILRL" srl)
(insert-ustats-count conn "Context Count" "MRCXT" "*" "KSRL" srl)
(insert-ustats-count conn "Co-occuring Concept Count" "MRCOC" "*" "KLRL" srl)
(insert-ustats-count conn "Definition Count" "MRDEF" "*" "KSRL" srl)
+ #+ignore
(insert-ustats-count conn "Locator Count" "MRLO" "*" "KLRL" srl)
(insert-ustats-count conn "Rank Count" "MRRANK" "*" "KSRL" srl)
(insert-ustats-count conn "Relationship Count" "MRREL" "*" "KSRL" srl)
(insert-ustats-count conn "Semantic Type Count" "MRSTY" "*" "KLRL" srl)
(insert-ustats-count conn "Simple Attribute Count" "MRSAT" "*" "KSRL" srl)
- (insert-ustats-count conn "Source Count" "MRSO" "*" "SRL" srl)
+ (insert-ustats-count conn "Source Abbreviation Count" "MRSAB" "*" "SRL" srl)
(insert-ustats-count conn "Word Index Count" "MRXW_ENG" "*" "KLRL" srl)
(insert-ustats-count conn "Normalized Word Index Count" "MRXNW_ENG" "*" "KLRL" srl)
- (insert-ustats-count conn "Normalized String Index Count" "MRXNS_ENG" "*" "KLRL" srl)
- (insert-ustats-count conn "Bonus Attribute Name Count" "BONUS_ATN" "*" nil srl)
- (insert-ustats-count conn "Bonus Relationship Count" "BONUS_REL" "*" nil srl)
- (insert-ustats-count conn "Bonus Source Abbreviation Count" "BONUS_SAB" "*" nil srl)
- (insert-ustats-count conn "Bonus Term Type Count" "BONUS_TTY" "*" nil srl))
+ (insert-ustats-count conn "Normalized String Index Count" "MRXNS_ENG" "*" "KLRL" srl))
(sql-execute "create index USTATS_SRL on USTATS (SRL)" conn))
(find-ustats-all))