Text Categorization

WORD_JD_SCORES Table

• I. Db Table

  WORD_JD_SCORES
  Name	Type	Properties	Notes
  word	VARCHAR(50)	Index, NOT NULL	Words from Journals (lower case)
  jid	VARCHAR(6)	Index, NOT NULL	Journal descriptor ID
  wordScore	FLOAT		scores based on word frequency
  documentScore	FLOAT		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';