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


Comments are closed.