Use of Full text Search and relation with Index server for textse

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pallavi Kulkarni. - 20 Jul 2005 12:46 GMT

Hello,
I have to implement Search engine for one website,which will be capabale of
finding text from HTML,DOcs,and Db,
For HTML and DOC search I am currently using Index server for FREE TEXT
SEARCH.
Now I need help about how to search text from SQL tables,whether FULL TEXT
will help me,to find contents from table.

I am totally unawear of Full Text Search of SQL,so please gide me the same

Reply to this Message

Hilary Cotter - 20 Jul 2005 13:34 GMT

Have a look at this to help you get started.

http://www.indexserverfaq.com/SQLFTIWizard.htm

to query your full text indexed tables have a look at CONTAINS and FREETEXT
in BOL.

Signature

Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

> Hello,
> I have to implement Search engine for one website,which will be capabale of
[quoted text clipped - 5 lines]
>
> I am totally unawear of Full Text Search of SQL,so please gide me the same

Reply to this Message

Pallavi Kulkarni. - 20 Jul 2005 14:09 GMT

Hell Sir,
Thanks for this...
I even want to know.whether Index server and Free text search using SQL
server are related ..aur both use for same purpose..
Could you plezz tell me URL where i can get procedure to implement Free text
search for my website..in detail..

Thank in advance.

> Have a look at this to help you get started.
>
[quoted text clipped - 13 lines]
> >
> > I am totally unawear of Full Text Search of SQL,so please gide me the same

Reply to this Message

John Kane - 20 Jul 2005 14:46 GMT

Pallavi,
Yes, the Indexing Service (new name for "Index Server" since its was
incorporated in the OS starting with Windows 2000 Server) and SQL Server
Full-Text Search (FTS) are related. However, both differ in purpose:

1) The Indexing Service is used to Full-text Index files on disk.
2) SQL Server FTS is used to Full-text Index text and files in a SQL Server
table.

URL for procedure to implement Free Text Search via Indexing Service (using
ASP.NET and VB.NET)
How to use an ASP.NET application to query an Indexing Service catalog by
using Visual Basic .NET
http://support.microsoft.com/default.aspx?scid=kb;en-us;820105

URL for procedure to implement Free Text Search via SQL Server Full-text
Search:
Full Text Search using SQL Server 2000/ASP.NET (w/ Tutorial)
http://www.freevbcode.com/ShowCode.asp?ID=4224 and download:
source/full_text_search.zip Unzip the file and review "Tutorial for Full
Text Index.htm" and see "CREATE PROCEDURE freetext_rank_proc" for details.

Hope that helps!
John

Signature

SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/

> Hell Sir,
> Thanks for this...
[quoted text clipped - 22 lines]
> > >
> > > I am totally unawear of Full Text Search of SQL,so please gide me the same

Reply to this Message

Pallavi Kulkarni. - 21 Jul 2005 06:07 GMT

thanks a lot Sir...I have gone thru the docs...
I have to implement search engine for one website which will exract searched
items from ASPX's,HTML,XLs,DOCs,Db for which I am using Index Server and FTS
SQL server,Reg that I have following query
1] I am not able to exract contents which are binded in server tags (Text
inside asp:Label tag is not searchable) but aspx is accessable...(Eg.If I
search for "AAA" text,so if it is inside HTML tag then that ASPX comes in
search result,but on the other hand if I bind in ASP LAbel tag,then AAA
search will not give that ASPX in result set.)
2] Will it be possible via Full text server to find cotents from multiple
table for one text.
3] Can it be possible to get data of FTS in Dataset.
4] How to combine result of Index server which will be inside Dataset,and
result of FTS so as to display both results on same ASPX Page.

> Pallavi,
> Yes, the Indexing Service (new name for "Index Server" since its was
[quoted text clipped - 52 lines]
> > > > I am totally unawear of Full Text Search of SQL,so please gide me the
> same

Reply to this Message

Hilary Cotter - 21 Jul 2005 11:10 GMT

1) you can only index some html tags (i.e. title, Author, custom metatags)
and what is in the body tags. Indexing Services is not able to render the
aspx code.
2) not unless you union all the tables you are interested in
3) through an openquery to a linked server using the MSIDXS provider and
unioning this with your SQL FTS querys
4) See 3

Signature

Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

> thanks a lot Sir...I have gone thru the docs...
> I have to implement search engine for one website which will exract searched
[quoted text clipped - 67 lines]
> > > > > I am totally unawear of Full Text Search of SQL,so please gide me the
> > same

Reply to this Message

Pallavi Kulkarni. - 21 Jul 2005 06:42 GMT

Can it be possible to exract SQL table contains as search result Using Index
Server,??

> Pallavi,
> Yes, the Indexing Service (new name for "Index Server" since its was
[quoted text clipped - 52 lines]
> > > > I am totally unawear of Full Text Search of SQL,so please gide me the
> same

Reply to this Message

Pallavi Kulkarni. - 25 Jul 2005 07:26 GMT

Thanks a lot....
Now I am able to display contents from SQL table,
Now Client wants to display corresponding ASPX which displayes searched
contents incase of normal flow,so could you please suggest some scheme via
which I can disply,I got one but dont know whether it is write and how to
implement .The sceme is :

Maintain one table which will store all contents of perticular page,and
then after details of searched element is found out search page for those
details and then pass pageid along with parameters on which the display is
dependent and display page...will it be the feasible soln,or there is some
way by which INDEX server itself will do that..??

> Hello,
> I have to implement Search engine for one website,which will be capabale of
[quoted text clipped - 5 lines]
>
> I am totally unawear of Full Text Search of SQL,so please gide me the same

Reply to this Message