Combining Neo4j and Elasticsearch

This is a bit of an opinion-based question because it doesn't have a "right" answer, so prepare for the SO no-fun hammer to come crashing down... but I've been thinking that a one-two (Elasticsearch then Neo) punch is the best way to handle this: index properties in Elasticsearch, perform a full-text search to get possible IDs, then build a Cypher match that limits results to returned IDs.

In Cypher, you can use IN [] to return records that match within an array. So you could do MATCH (u:Student { age: 30 }) WHERE ID(u) IN [1, 2, 3, 4] RETURN u. The trick of integrating Elasticsearch with Neo, then, is to make it easy to build Cypher queries around ES results. I don't really have tips on doing that cause it will depend on your language and driver.

In Neo4j.rb, I'm thinking about trying to automate this so you can do this:

student.lessons(:l).where(name: 'Chris').to_a

...and it'll know that the Lesson model is using Elasticsearch, do the query, and then change the query for the user so it is effectively this:

student.lessons(:l).where('ID(l) IN {elasticsearch_results}').params(elasticsearch_results: [1, 2, 3, 4]).to_a`

I've been using Searchkick for full-text search with Neo and it's been going well. I think this is doable. Not a solution to your problem but it's how I'm thinking through it, so maybe it'll give you some ideas.

It's worth noting that Neo does have fuzzy search using =~, it just doesn't use indexes so there may be a performance hit. This might not be a problem, though, since you can filter the number of nodes and properties Cypher has to inspect by adding more information to other parts your query. You should do some benchmarks with your data to figure out if the added overhead of Elasticsearch and more complicated queries are necessary.

I am also looking for Neo4J & Elasticsearch integration. I have seen "Neo4j River Plugin for ElasticSearch". But i don't know how to use it. If you guys will find any information about integrating with "Neo4j River Plugin for ElasticSearch", please let me know, will be really helpful.