Lucene Index an alternative to full text search

Helping businesses improve reliability and efficiency of SQL Server

Lucene IndexJust like the other days I was talking to a good friend of mine about performance issues he had lately. And, all of the sudden, seem like he recall something very important and he asked me, do you know any alternative to SQL Server Full Text Search? It should support wildcards and should be faster than SQL Server Full Text Search!! When he asked me this question, I understand it, immediately, he is upto introduce me somthing really interesting. The answer was – Lucene Index.  Let us try to understand little more about Lucene Index and how it works based on my discussion with my friend.

What is Lucene Index?

Lucene Index is simple and powerful Java Search library. It is open source project. Lucene can be used in many type of projects. Lucene is a high performance library used to index and search almost any kind of text. Lucene can be implemented for various sources like SQL, NoSQL a file system and many more. This is a product of Apache

How Lucene Index works?

Lucene Index work in a different way. Normally, a search is performed on a text whereas Lucene searches an Index. It exactly relates to a search we do in a physical book where we search for an word or key phrase in the Appendix section and jump directly to the page where it was written.  This type of index is called an inverted index.

Internally, it will create a Document which is the unit of search and index. Further, inside of this Document there are one more fields. This field contains the value.

 

Further Reading

I am still in reading more on this subject, but I thought it is a good idea to write a short note on this vary topic as it is really very interesting. It helped my friend improving search ability for his application he wrote in .Net. He mentioned that the outcome is far more better than what it was with Full Text Search. He gave me few links that I may read on Lucene Index, let me put them all here so that you can also read.

I hope you liked this blog post. It is a good idea to know if any one of you have already used Lucene and how your experience is?  Any input is greatly appreciated.Just in case, if you are in serch of Full Text Search service issue, you may want to read my blog post.

photo credit: Got Credit Index Key via photopin (license)

If you encounter such issues please refer to this article Resolving High CPU usage in SQL Server.