sql查询到mongodb? [英] sql query to mongodb?

问题描述

看到此图像后: http://2.bp.blogspotcom. /_T-uXeKcGTnM/TIdoKBGwk9I/AAAAAAAABcs/CLW3_cRlN78/s1600/tumblr_kxovt0VLZy1qappj8.png 我想知道是否存在任何将SQL查询转换为MongoDB映射/减少查询模型的工具?

图片的更高版本: http://rickosborne.org/download/SQL- to-MongoDB.pdf

解决方案

简单的答案? 否 .

稍微复杂一些的答案是有人运气将更复杂的SQL转换为Mapreduce函数...

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/

但是，这样说...一般而言，您最好还是正确学习mapreduce，因为如果数据已经在MongoDB中了...您真的需要知道如何正确查询MongoDB才能完成有意义的工作！

MongoDB具有出色而有用的文档 http://www.mongodb.org/display/DOCS/高级+查询

以及易于使用的在线教程: http://try.mongodb.org/

After seeing this image: http://2.bp.blogspot.com/_T-uXeKcGTnM/TIdoKBGwk9I/AAAAAAAABcs/CLW3_cRlN78/s1600/tumblr_kxovt0VLZy1qappj8.png I wonder is exists any tool for translating SQL querys into MongoDB map/reduce query model??

Larger version of the image: http://rickosborne.org/download/SQL-to-MongoDB.pdf

解决方案

The simple anwser? No.

The slightly more complex anwser is some people have had luck translating more complex SQL to 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 might as well learn mapreduce properly because if the data is in MongoDB already ... you'll really need to know how to properly query MongoDB to get anything meaningful done!

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

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

这篇关于sql查询到mongodb?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！