Text Categorization

MH_JD_SCORES Table

• I. Db Table

  MH_JD_SCORES
  Name	Type	Properties	Notes
  mh	VARCHAR(105)	Index, NOT NULL	Main heading (lower case)
  jid	VARCHAR(6)	Index, NOT NULL	Journal descriptor ID
  score	FLOAT		scores based on document count for main heading

• II. SQL Examples
  • Find scores for MH, "XXX"
    1. "xxx" = "XXX".toLowerCase( );
    2. SELECT jid, score FROM MH_JD_SCORES WHERE mh= 'xxx';