Advanced SQL-based freetext search (case study)
Lukas Smith (20.Mar.2009)
Talk at PHPCon Italia 2009 (English - US)
This case study presents the search backend of the phonebook application developed by Liip for the Raiffeisen Bank Switzerland. Build on top of Linux, Apache, PHP and MS SQL Server it implements an SQL based freetext search interface optimized to deliver in-depth search capabilities at high performance in real time. While SQL Server was used, the bulk of the solution leverages standard SQL. Among the features that will be presented are:
* Search touching 20+ tables efficiently
* Adaptive SQL based on the search criteria, the users rights and workgroup
* Fuzzy name matching
* Different indexing approaches
* Search results provide a summary and a list of reasons for each match
By clicking this button you are declaring that you are the speaker responsible for it and a claim request will be sent to the administrator of the event.
If the claim is approved you will be able to edit the information for this talk.
Are you sure?