[dba-VB] "Smart" fulltext search on large documents(data)base...

Shamil Salakhetdinov shamil at smsconsulting.spb.ru
Tue Feb 8 19:08:07 CST 2011


Hi Mark --

Thank you for your notes.

How to make DNN (re-)indexing a page?
There should be special DNN page options to include/exclude a certain page
from full text indexing?

Thank you.

--
Shamil
 
-----Original Message-----
From: dba-vb-bounces at databaseadvisors.com
[mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of Mark Breen
Sent: 5 ??????? 2011 ?. 13:43
To: Discussion concerning Visual Basic and related programming issues.
Subject: Re: [dba-VB] "Smart" fulltext search on large
documents(data)base...

Hello Gustav and Shamil

Here are a set of tables from DNN

SearchCommonWords
SearchIndexer
SearchIndexer
SearchItem
SearchItemWord
SearchItemWordPosition
SearchWord


You can almost guess the columns that they include, basically, they seem to
create a record for each word in each item and link them back through
relational database model.  I described it as heavy lifting, as I would have
assumed the more abstract ways to achieve this are available.  I never used
SQL Server Full Text Search but I suppose that is on option.  Perhaps the
DNN guys can demonstrate their heavy lifting is quick, fast and efficient,
but I was rather surprised to see their model.

Probably for a portal with 300 - 400 pages, the set of words used is rather
narrow and this approach may be useful.

I have not look at the code that builds the indexes, but I am imagine it.

I was not proposing this as an alternative to Shamil's choice - just
mentioned it as it was the same week I saw both options.

Mark


On 4 February 2011 09:34, Gustav Brock <Gustav at cactus.dk> wrote:

> Hi Mark
>
> What do you mean with ""heavy lifting" way"? Is it ugly or smart or what?
>
> >>> marklbreen at gmail.com 04-02-2011 10:10 >>>
> Hello Shamil
>
> Just FYI, I happened to look yesterday at the DNN Keyword search 
> tables,
>
> you may find them interesting also.  I was surprised to see such 
> "heavy lifting" way of providing search.
>
> Mark
>
>
> _______________________________________________
> dba-VB mailing list
> dba-VB at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-vb
> http://www.databaseadvisors.com
>
>
_______________________________________________
dba-VB mailing list
dba-VB at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-vb
http://www.databaseadvisors.com




More information about the dba-VB mailing list