The first post on StackOverflow, but I have always viewed this site as an excellent source of general knowledge, and I am very happy to see what arises from this question.
Since I feel like I have now reached the limits of what I can do with SQL indexes, statistics, and full-text search, I'm currently looking for a search library that can provide us with the functionality we need. I don't mind writing it myself (and opening it if I can get the boss’s approval), but I would rather find something open that already exists, natch.
What we need is a search engine that can provide statistics on results that are matched when a user searches for a specific keyword. Say, for example, that we are talking about a database of products in an online store. We need to be able to return statistics on how many products exist according to a given set of keywords (and also be able to filter this result by price, category, etc.), as well as the total number of products in stock (assuming that this stored in a field in the product table). All the search engines that I found return the first n results, and if you need statistics on the size of the result set, you need to list the entire set. Even if you have not done so, you still need to do this in order to get the total number of products in stock.
Is there anything that anyone knows that this is possible for this function? As I said, I'm glad that my hands are dirty, either create yourself or change the functionality of something like Lucene, but I could not find something suitable on Google.
Thanks in advance guys!
Mike source
share