About Product - Karsa Fulltext Search Manager

Karsa Fulltext Search Manager is a desktop application thanks to which you can increase efficiency, reduce errors, and work faster when creating fulltext search. The desktop manager serves for setting the search and subsequent generating of saved procedures on the MS SQL Server. You therefore don’t need to register any dlls or input the .net code on the SQL Server, because the standard T-SQL script is run and the wide possibilities of the SQL Server iFTS are used every time.

Creating a script of several hundred lines is very time-consuming, not to mention its subsequent adjustments based on a/b testing and evaluation of logs. Karsa Fulltext Search Manager therefore uses “search patterns”. A search pattern can be for example

contains([LongDescription], ' "Bike" and "mountains" ') 

contains([LongDescription], ' "Bike" or "mountains" ') 

contains([LongDescription], ' FORMSOF(INFLECTIONAL, bikes near mountains ) ' ) 

Predefined search patterns

• There are 9 search patterns predefined in total.You can therefore set the search without any knowledge of T-SQL.
  
  
  
  
  
  
  
  
  
  

There are 9 search patterns predefined in total. You can therefore set the search without any knowledge of T-SQL. You can also create custom search patterns. Each search pattern can be assigned its weight that will be added to the resulting internal SQL rank. You can assign any number of search patterns to the column in your table. The search results will thus reflect if the value in the column for the entry contains for example an exact match for the search term "Mountains bike GR50"

contains([LongDescription], ' "Bike" and "mountains" and "GR50" ') 

contains(LongDescription, ' "bike" and ("mountain" OR "GR50") ')

To increase relevance it is however necessary to take into account if the search term was found for example in the product name, description, or another table such as product forum. That is why search patterns can be assigned to every column and global weight can be set for them that will take into account the preferred column in the result (if the search term occurred e.g. in the product name, its rank will be higher). Search patterns can also be assigned to tables which have relational links to the primary table. This allows creating complex connections based on database diagrams.

For tables you can also define parameters for result products filtering, sorting columns, and global conditions for the given table (standard WHERE clause).

The integrated SQL search debugger

• The integrated SQL search debugger is a very useful tool, allowing you to instantly test the set weights and patters and see the exact values of assigned ranks based on the defined patterns.
  
  
  
  
  
  
  

The parameters for filtering are a very strong tool for creating filters above the search result. After displaying the search results, the entries can be further filtered using parameters such as stock status, location, and price, where only the parameters with some matching entries are offered for each search. This eliminates situations when the user enters a wrong combination of parameters and now results are displayed.

The result entries can be sorted for example based on name, price, and stock status, using selected sorting columns.

The resulting generated saved procedure contains the selected parameters, sorting columns, parameters in the WHERE clause, set weights, and search patterns. This saved procedure can be accessed from your application using the supplied library or directly the standard exec call.

Karsa Fulltext Manager also automatically creates support scripts for creating a fulltext catalogue and indexes.

For more information on language selection, saved procedure prefixes, or dynamic weight setting (personalized search) see the detailed manual.

1.Key search functions

• Precise options for setting of weights for individual indexed fields.
• Results found by the fulltext search can be further sorted as per selected parameters!
• Declension in the course of result search.
• Extensive language support.
• Clear desktop manager for administration.
• .Net API. Ajax framework for easier installation into web applications.

2.Who is the search application meant for?

For all owners/developers who want to install a quality fulltext search function with a follow-up parameter filtering option into a web or desktop application. Examples of application:

• Electronic shops
• Web presentations, Portals
• CRM
• Accounting software

3.The installation contains

• Fulltext search Manager
  Creates stored procedures that search in the database. You can set weights for individual columns, parameters for sorting, columns for filtration, debugging of search results.
• .Net web components
  Serve to display search results on web pages. It has very fast ajax downloading of results of searching, their sorting, filtration, history of searching. It also supports flying effect.
• Sample .Net web search projects
  Demonstrates use of search in a web application with the support of ajax even without
• Documentation, .Net API
  Manual to the manager, developer's guide.

4.Requirements for Karsa search application

• Microsoft SQL Server 2005, 2008 or MS SQL Express Advanced Services 2008 (required fulltext search service)
• .Net framework 3.5