Searching structured data in a database (Fulltext + query)
===

In the application i work i need to search the database for text (full text search) and prioritize the result based on other columns. Which kind of datastore is best here by considering performance? I need to search the structured data and prioritize the result.

Is it RDBMS or document store (Couch, Mongo) or any other NoSQL database? Or should i use batch processing tools such as Hadoop and prepare the data for search? 

I am looking for directions. Thanks in advance.




