Re: Indexed words

Alexander Barkov wrote:
> [email protected] wrote:
>>
>> Many thanks Alexander.
>>
>> Is there a way to classify the words by "tag" (in the mnogosearch 
>> sense of the word)?
> 
> To get a list of URLs with their tags you can do this query:
> 
> 
> select url.rec_id, url.url tag
> from url, server
> where url.server_id=server.rec_id;

Sorry, the correct query is:


select url.rec_id, url.url, tag
from url, server
where url.server_id=server.rec_id;


> 
> Unfortunately, there is no a way to classify the words by tag.
> 
> Possible solutions:
> 
> 1. Put each tag into a separate database,
> and use two DBAddr command in search template,
> to merge results from both.
> 
> 
> 2. Create index for a database part using tag limit:
> 
> a. Run "indexer -Eblob -t a", to create word index for tag "a",
> then classify the words (or do whatever you need with the words)
> 
> b. Then repeat the same for the tag "b":
> 
> "indexer -Eblob -t b"
> 
> and classify the words for tag "b".
> 
> 
> 
> 
>>
>> Best regards,
>>
>> Philippe
>>
>>
>>
>>
>>
>>
>>
>> *Alexander Barkov <[email protected]>*
>>
>> 28/06/2011 08:18
>>
>>     
>> To
>>     [email protected]
>> cc
>>     [email protected]
>> Subject
>>     Re: Indexed words
>>
>>
>>     
>>
>>
>>
>>
>>
>> Hi,
>>
>> [email protected] wrote:
>>  >
>>  > Hello,
>>  >
>>  > is it possible to retrieve indexed words from a mnogosearch 
>> dictionary,
>>  > to create a tag cloud?
>>  >
>>  > Many thanks.
>>
>> This query should do for DBMode=blob :
>>
>> SELECT word, sum(length(intag)) AS freq
>> FROM bdict GROUP BY word ORDER by freq DESC;
>>
>>  >
>>  > Philippe
>>  > *
>>  > P** In order to preserve the environment, please do not print this
>>  > message unless it is necessary.*
>>
>>
>>
>> *
>> P** In order to preserve the environment, please do not print this 
>> message unless it is necessary.*
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]