Solved

Free text search

Posted on 1998-11-25
1
277 Views
Last Modified: 2010-03-19
Hi,

I would like to do free text searching on text/imagecolumns holding different documents (word,rtf,html etc) in SQL 6.5. Does anyone know of any good 3rd party search engine that would index text/imagecolumns and let me search them through APIs? Also, I think I read something about this being included in SQL 7.0, is this true?

Thanks,
pivar
0
Comment
Question by:pivar
1 Comment
 
LVL 2

Accepted Solution

by:
aliciaam earned 100 total points
ID: 1091978
The ability to search just against file system data already exists today in Index Server 2.0.  
This capability is further enhanced by the SQL Server 7.0 Distributed Query Processor which, in conjunction with the Microsoft OLE DB Provider for Index Server 2.0, can be used to issue both property and full-text searches against data in the file system and to join the results with data in the database.

Different Scenarios, Different Solutions
Below are three examples that highlight the different scenarios for using either Microsoft Index Server or Microsoft Site Server.
 1.      A customer who has data on one Microsoft Internet Information Server (IIS) Web site and only wishes to query across file system files should use Microsoft Index Server.
       2.      A customer who needs searches to occur on more than one Web server, file server files, databases, Exchange public folders or specified Internet sites, should use Microsoft Site Server.
       3.      Distributed Capability: Site Server can be distributed among different servers to provide distributed crawling and searching for a multinational corporation. The processing may be distributed to reduce bandwidth consumption, provide redundancy, or to optimize performance when there are slow connections between subsidiaries. In the example below, there is a crawler in the United States and in the United Kingdom headquarters. The multinational crawls locally and propagates the resulting catalogs to every server worldwide that offers Search capabilities. This enables local searching of multinational content.
        
Common Search Engine
Since both Index Server and the Search feature in Site Server use the same underlying powerful engine, you can find the following functionality in both products:
·      Querying:
·      Supports full-text and property querying.
·      Supports Boolean, proximity, word stemming, vector space, and free-text queries.
·      Queries can use Structured Query Language (SQL): The query capabilities include SQL syntax, which supports Microsoft ActiveX® scripting and can be used in Microsoft Visual Basic® development system, Java, and C++ applications. Or SQL syntax can be used in an ASP, using Visual Basic Scripting Edition or JScript™ development software to create dynamic, customized queries. With this, application developers can view the file system as another OLE-DB data source.
 
·      Extensible and Compatible Filter Architecture: Filters allow the extraction of text and properties from documents of various formats.
·      Security: Windows NT security enabled on filtering and searching.
·      Powerful Scripting: Compatible scripting language with minor differences.
·      Multiple Language Support: Supports indexing and searching of documents in several different languages, including English, French, German, Japanese, Dutch, Spanish, Italian, and Swedish, without making any changes to the files or the search engine.
      
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have a large data set and a SSIS package. How can I load this file in multi threading?
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to shrink a transaction log file down to a reasonable size.

825 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question