Search code examples
javamongodbneo4jjdonosql

Querying NoSQL from Java & Performance Differences Between Direct & Indirect Querying

I have just started researching NoSQL and would like to ask the following questions:

  1. Just like SQL is the direct query language for ALL RMDBS, then what is the direct query language for all NoSQL databases? If there isn't one direct language, then what query languages exist - a list of a few query languages will suffice.

  2. Similar to question 1. above, does Java have a standard query language for all NoSQL databases?

  3. Is there a significant peformance differentiation when using JDO/Datanucleus or Spring Data when compared with direct NoSQL queries on either MongoDB and/or Neo4J? For example, in terms of RMDBS, writing direct SQL via JDBC when compared to using JPA/ORM Tool, there is significant performance difference in favour of direct SQL.

The reason why I am asking these questions is to offset the advantages of cross-compatibility by using JDO/Datanucleus versus Performance loss or gains?

Thanks.

Solution

  • At this time, there are no standard in NoSQL.

    If you choose NoSQL for performance, adding any layer will likely impact it. For that reason, most NoSQL providers prefer providing 'drivers' per language that try to keep performance up and give you an easy way to access their data.

    There is a recent effort from 28io to create a language to query across many NoSQL databases. The language is called JSONiq.