Sql query to mongodb?

Question

After viewing this image: http://2.bp.blogspot.com/_T-uXeKcGTnM/TIdoKBGwk9I/AAAAAAAAABcs/CLW3_cRlN78/s1600/tumblr_kxovt0VLZy1qappj8.png I wonder if there is any tool for translating SQLD query Map reduce query?

Larger view: http://rickosborne.org/download/SQL-to-MongoDB.pdf

Answer 1

Simple anwser? No.

A slightly more complex anwser is that some people are fortunate enough to translate more complex SQL into Mapreduce functions ...

http://rickosborne.org/blog/index.php/2010/02/08/playing-around-with-mongodb-and-mapreduce-functions/

http://rickosborne.org/blog/index.php/2010/02/19/yes-virginia-thats-automated-sql-to-mongodb-mapreduce/

However, that said ... generally speaking, you could also study mapreduce well, because if the data is already in MongoDB already ... you really need to know how to properly query MongoDB to get something meaningful!

MongoDB has wonderful and helpful docs http://www.mongodb.org/display/DOCS/Advanced+Queries

As an easy to use online tutorial: http://try.mongodb.org/

Answer 2

Update the question asked in January 2011:

Now there are several sites for converting sql to mongodb.

Convert MySQL queries to MongoDB Syntax http://www.querymongo.com/

and

Convert sql to mongodb http://klaus.dk/sqltomongodb/

Answer 3

The simple answer is yes. Hibernate OGM - JPA for NoSQL.

JPA is a Java API for mapping objects to data stores.
It includes JPQL , a query language similar to SQL that adds OOP concepts. It is not SQL, but you do not need pure SQL that was designed for the relational paradigm.

Hibernate OGM proposes to simplify the programming model by combining APIs and JPA / Hibernate semantics for storing data in NoSQL stores such as the JBoss Enterprise Data Grid, instead of the traditional RDBMS. ( source )

Also see this Hibernate OGM: JPA for NoSQL , says Hardy Ferenczyk

Answer 4

I recently happened to see this website mongoquery.com , you can try it.

Answer 5

Just to add to the last comment

re:The simple answer: Yes. Hibernate OGM - JPA for NoSQL. JPA is Java API for mapping objects to data stores. It includes JPQL, a query language similar to SQL which adds the OOP concepts. It not SQL, but you don't want pure SQL - that was designed for the relational paradigm. 

There is a company called UnityJDBC that has released the JDBC driver for Mongo, which allows you to run SQL queries against mongo in any Java application that supports JDBC.

you can download this driver for free http://www.unityjdbc.com/mongojdbc/mongo_jdbc.php

hope this helps

Answer 6

You can also http://teiid.org , which provides a full range of SQL-based access to MongoDB. You can use SQL via JDBC / ODBC or use REST / ODATA access on MongoDB. Teiid uses the MongoDB aggregation structure to provide an extended query query for MongoDB SQL.