index_words, index_rel
Words-table and word-relation table. Almost self-explanatory. For the index_rel table some fields require explanation:
count
- Field
- count
- Description
- Number of occurrences on the page
first
- Field
- first
- Description
- How close to the top (low number is better)
freq
- Field
- freq
- Description
- Frequency (please see source for the calculations. This is converted from some floating point to an integer)
flags
- Field
- flags
- Description
-
Bits, which describes the weight of the words:
8th bit (128) = word found in title,
7th bit (64) = word found in keywords,
6th bit (32) = word found in description,
Last 5 bits are not used yet, but if used they will enter the weight hierarchy. The result rows are ordered by this value if the "Weight/Frequency" sorting is selected. Thus results with a hit in the title, keywords or description are ranked higher in the result list.