title: database management for item recommendation
body: <p>I am collecting user review from my site. Review can have 1,2,3,4,5 rate.</p>
  
  <p>From each review I am collceting list of adjectives. So I will have good, nice, great, excellent etc scrapped from these reviews.</p>
  
  <p>Currently I am taking adjectives from review and storing into table. I append each new set of adjectives coming from reviewa with previous list. </p>
  
  <p>Then I have seperate function call to which counts occurrence of each word and store into another table.</p>
  
  <p>What I want:</p>
  
  <p>I want to create review recommendation which grade the recommendation system based on adjective occurrence. </p>
  
  <p>Depending on how many adjectives (good, great,nice etc) count review has, it will be ranked. <code>Good</code> in 4 star review has more value then good in 3 star review.</p>
  
  <p>means displaying the best review (4-5 star) having maximum positive adjectives.</p>
  
  <p>I am wondering how should I manage my database so that I can get rid of this in faster way.</p>
  
  <p>any thought would be highly apprecited.</p>
  
  <p>review </p>