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

Shamil Salakhetdinov shamil at smsconsulting.spb.ru
Wed Feb 9 14:11:48 CST 2011


Hi Mark --

Yes, I did get it - that you're not suggesting to use DNN native full text
indexing instead of GooleDocs - but I do need both in a solution I'm working
on :) 

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: 9 ??????? 2011 ?. 19:05
To: Discussion concerning Visual Basic and related programming issues.
Subject: Re: [dba-VB] "Smart" fulltext search on large
documents(data)base...

Hi Shamil

I hope that was useful for you - just to be clear, I was not suggesting it
as an alternative to the Google solution you described - in fact I was
fascinated by that elegant solution to a search problem.  If it is useful to
you that will be an added bonus.

thanks

Mark


On 9 February 2011 11:55, Shamil Salakhetdinov
<shamil at smsconsulting.spb.ru>wrote:

> Hi Mark --
>
> I have checked my test web site - full text indexing seems to be done 
> not instantly for large texts of HTML modules but it's somehow 
> delayed: it works now for the html module, which it didn't work for 
> when I first saved that module's large text.
>
> Yes, I will try to ask about HTML modules' text indexing on DNN...
>
>
> 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: 9 ??????? 2011 ?. 13:52
> To: Discussion concerning Visual Basic and related programming issues.
> Subject: Re: [dba-VB] "Smart" fulltext search on large 
> documents(data)base...
>
> Hello Shamil,
>
> Off the top of my head, I do not know.  But as you probably already 
> know,the DNN forums are very friendly and helpful - I think I always 
> get an answer withing 24 hours.
>
> Does it not auto-reindex?  I do not know when or how it builds the 
> list of indexes but I would presume that the indexer needs to know 
> when  module is "dirty" and then goes ahead and re-indexes it ?
>
> Take a look at this table, and perhaps it supports some of my
presumptions.
>
> CREATE TABLE [dbo].[SearchItem](
> [SearchItemID] [int] IDENTITY(1,1) NOT NULL, [Title] [nvarchar](200) 
> NOT NULL, [Description] [nvarchar](2000) NOT NULL, [Author] [int] 
> NULL, [PubDate] [datetime] NOT NULL, [ModuleId] [int] NOT NULL, 
> [SearchKey]
> [nvarchar](100) NOT NULL, [Guid] [varchar](200) NULL, [HitCount] [int] 
> NULL, [ImageFileId] [int] NULL,
>
> Thanks
>
> Mark
>
>
>
> On 9 February 2011 01:08, Shamil Salakhetdinov
> <shamil at smsconsulting.spb.ru>wrote:
>
> > 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
> >
> > _______________________________________________
> > 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
>
> _______________________________________________
> 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