![]() Like most technologies that support full-text indexing, we took advantage of the open-source Lucene technology. We just had to teach SingleStore to understand this new kind of index. SingleStore is a system that understands the notion of an index, so integrating FTS into SingleStore was relatively straightforward. How is Full-Text Search integrated with SingleStore? how-is-full-text-search-integrated-with-single-store The combination of the inverted index data structure, stemming capabilities and relevance scoring are why Full-Text Searching is advantageous over searching strings using regular database queries. This allows you to sort the results showing the most relevant results first. Relevance tells you not just whether there is a match but also how good the match is. Secondly, your search might have a lot of matches. So when you search for Canada, the system can quickly determine if the word Canada appears in the document and how many times. What you need is a different kind of index that keeps track of all the words in the document and how often they appear. You could use a LIKE query or a regular expression, but that is going to be pretty slow with a regular database index, no matter how fast your database is. Specifically, suppose you wanted to find all the documents that talk about “Canada”. For example, if you want to see a list of mystery books you would ask the database to find all the books with a subject of “Mystery”, easy! But what if you have many documents, each with a lot of words in it, and you don’t know what information the documents contain. Sometimes when you search for text you know exactly what you are looking for. Full-Text Search is different than querying for a string value in two ways. You might be thinking, “SingleStore is pretty fast at searching things and they already support large strings, so why do they need to add anything?” So let’s start with a description of Full-Text Search (FTS). What is Full-Text Search? what-is-full-text-search Thanks to customer feedback, we are delighted to make it available for all companies building real-time applications. Today, we are sharing that SingleStore now has Full-Text Search, a highly requested feature, built into the product. ![]()
0 Comments
Leave a Reply. |