Sub-Term Mapping Tools

NormInflvar_EUI Table

  • I. Db Table

    NormInflvarEui
    NameTypePropertiesNotes
    normInflvarVARCHAR(120)Index, NOT NULLNormalized inflectional variants
    euiVARCHAR(8)NOT NULLEntry Unique Identifier

  • II. SQL Examples
    • Find EUI for term, "XXX"
      1. normXxx = LexItemNorm("XXX")
      2. SELECT eui FROM NormInflvarEui WHERE normInflvar= 'NormXxx';

  • III. Data

    File: ${STMT_DIR}/data/tables/normInflvarEui.data

    • Unicode Lexicon (used in lsf, mt)
      Meta Version (AA/AB)Rows
      Lexicon-2024907,871
      Lexicon-2023904,386
      Lexicon-2022899,356
      Lexicon-2021892,616
      Lexicon-2020883,929
      Lexicon-2019874,906
      Lexicon-2018860,202
      Lexicon-2017846,444
      Lexicon-2016832,666
      Lexicon-2015818,931
      Lexicon-2014804,657
      Lexicon-2013791,470
      Lexicon-2012775,340
      Lexicon-2011749,738

    • ASCII Lexicon (used in MetaMap, the only table in ASCII DB)
      Meta VersionRows
      Lexicon-2024-ASCII899,974
      Lexicon-2023-ASCII896,489
      Lexicon-2022-ASCII891,472
      Lexicon-2021-ASCII884,744
      Lexicon-2020-ASCII876,132
      Lexicon-2019-ASCII867,149
      Lexicon-2018-ASCII852,650
      Lexicon-2017-ASCII839,427
      Lexicon-2016-ASCII825,801
      Lexicon-2015-ASCII812,272
      Lexicon-2014-ASCII798,698
      Lexicon-2013-ASCII785,755
      Lexicon-2012-ASCII769,883
      Lexicon-2011-ASCII745,033