Inflection Tables

  • Tables:

    Inflection
    NameTypePropertiesNotes
    ifTermLCCHAR(105)PRIMARY KEYLowercase of Inflected Term
    ifTermCHAR(105).Inflected Term
    termCatINT.Category
    termInflLONG.Inflection
    euiCHAR(8)NOT NULL, IndexedEUI: Unique ID
    unTermCHAR(105).Uninflected Term
    unTermLCCHAR(105)IndexedLowercase of Uninflected Term
    ctTermCHAR(105).Citation Term

    Notes:
    The maximum length for ifTerm, ifTerm is 103. We use CHAR(105) for those columns.
    The maximum length for unTerm, ifTerm is 103. We use CHAR(105) for those columns.

  • SQL Examples:

    • Find inflected terms for "XXX"
      1. SELECT * FROM Inflection WHERE ifTermLC = "xxx"
      2. Filter out records if EUIs are duplicated
      3. SELECT * FROM Inflection WHERE eui = "xxxeui" AND unTerm = "xxxunTerm
      4. Add the ifTerms from all records.
      5. If none found, use trie (rules).

    • Find uninflected terms for "XXX"
      1. SELECT * FROM Inflection WHERE ifTermLC = "xxx"
      2. Add the unTerm if it does not exist in the output list.
      3. If none found, use trie (rules).

    • Find EUI of a term for "XXX"
      1. SELECT EUI FROM Inflection WHERE ifTermLC = "xxx"

    • Find EUI of an uninflected term for "XXX"
      1. SELECT EUI FROM Inflection WHERE unTerm = "xxx"

    • Find citation terms for "XXX"
      1. SELECT * FROM Inflection WHERE ifTermLC = "xxx"
      2. Add the ctTerm if it does not exist in the output list.