Full-text search in NoSQL databases

database full-text-search nosql couchdb riak
unj2 picture unj2 · Mar 28, 2011 · Viewed 29.9k times · Source
  • Has anyone here have any experience deploying a real online system that had a full text search in any of the NoSQL databases?
  • For example, how does the full-text search compare in MongoDB, Riak and CouchDB?
  • Some of the metric that I am looking for is ease of deployment and maintaince and of course speed.
  • How mature are they? Are they any replacement for the Lucene infrastructure?

Answer

Andreas Jung picture Andreas Jung · Mar 28, 2011

None of the existing "NoSQL" database provides a reasonable implementation of something that could be named "fulltext search". MongoDB in particular has barely nothing so far (matching using regular expressions is not fulltext search and searching using $in or $all operators on a keyword word list is just a very poor implementation of a "fulltext search"). Using Solr, ElasticSearch or Sphinx is straight forward - an implementation and integration on the application level. Your choice widely depends on you requirements and current setup.

Related questions

Performance of like '%Query%' vs full text search CONTAINS query

I have a situation where I would like to search a single word. For that scenario, which query would be good from a performance point of view? Select Col1, Col2 from Table Where Col1 Like '%Search%' or Select …

Read More
What is faceted search?

What exactly is faceted search in the context of full-text search? I even read about it from Wikipedia, but I couldn't completely understand the use/benefit of it. Hope the community can answer/expand and explain with some good examples. …

Read More
mysql query - contains?

how can i search for a particular string in mysql? I tried using contains- gives me error: SELECT r.name , r.network , r.namestring , i.name , r.rid , i.id , d.dtime , d.ifInOctets , d.description FROM router AS r …

Read More