WORD_JD_SCORES Table

  • I. Db Table

    WORD_JD_SCORES
    NameTypePropertiesNotes
    wordVARCHAR(50)Index, NOT NULLWords from Journals (lower case)
    jidVARCHAR(6)Index, NOT NULLJournal descriptor ID
    wordScoreFLOAT scores based on word frequency
    documentScoreFLOAT scores based on document count for words

  • II. SQL Examples
    • Find scores for WORD, "XXX"
      1. "xxx" = "XXX".toLowerCase( );
      2. SELECT jid, wordScore, documentScore FROM WORD_JD_SCORES WHERE word= 'xxx';