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

Mark Breen marklbreen at gmail.com
Wed Feb 9 10:04:48 CST 2011


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
>
>



More information about the dba-VB mailing list