Advanced SQL-based freetext search (case study)
Lukas Smith (26.May.2009)
Talk at International PHP Conference Spring 09 (English - US)
This case study presents the search back end 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
Quicklink: https://joind.in/489
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?
