osclass/OSClass — Issue #58: SEO improvements
Author: juanramon
Created: 2011-11-29 10:20:07+00:00
State: open
Labels: Idea

First of all, the structure of the table:

* s_original_text
* s_anchor_text
* s_normalized_text (*)
* s_md5 (**)
* fk_i_category_id [fk to the category table]
* fk_i_city_id [fk to the city table]

s_original_text -> is the original search text query
s_normalized_text -> is the same input value as s_original_text but after apply some filter we describe below
s_anchor_text -> can be the same as s_original_text
s_md5 -> see (**)

process to get s_normalized_text:

* convert string into lowercase
* remove stopwords (there are in the language file)
* delete words with less than 3 letters
* (**) how we generate md5
- remove accents
- order words alphabetically
- generate md5
-> why? this way we aren't able to repeat keywords. eg: buy house new york // buy new york house
* raw_url_encode (*) we get the normalized text

All this is basic to get the keyword system