Solved

Free text search

Posted on 1998-11-25
1
275 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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

747 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now