Solved

Free text search

Posted on 1998-11-25
1
278 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SqlServer Table Triggers 3 28
SQL Query Task 11 43
Linked Server - SP with Param to VIew 7 21
MS SQL Server Management Studio R2 4 27
When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

762 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