[confluence] MongoDB > MongoDB, CouchDB, MySQL Compare Grid

70 views
Skip to first unread message

nor...@mongodb.onconfluence.com

unread,
Jan 22, 2013, 4:21:00 PM1/22/13
to mongodb...@googlegroups.com

MongoDB, CouchDB, MySQL Compare Grid

Page edited by Sam Kleinman


Changes (2)

pending... {redirect:http://www.10gen.com/products/mongodb}
|| || CouchDB \\ || MongoDB \\ || MySQL \\ ||
| Data Model \\ | Document-Oriented ([JSON|http://www.json.org/]) \\ | Document-Oriented ([BSON|http://blog.mongodb.org/post/114440717/bson]) \\ | Relational \\ |
| Data Types \\ | string,number,boolean,array,object | string, int, double, boolean, date, bytearray, object, array, others \\ | [link|http://dev.mysql.com/doc/refman/5.0/en/data-types.html] |
| Large Objects (Files) \\ | Yes (attachments) \\ | Yes ([GridFS|DOCS:Storing Files]) \\ | Blobs |
| Horizontal partitioning scheme \\ | CouchDB Lounge \\ | [Auto-sharding|Sharding] | [Partitioning|http://dev.mysql.com/doc/refman/5.6/en/partitioning-overview.html] \\ |
| Replication \\ | Master-master (with developer supplied conflict resolution) \\ | Master-slave and [replica sets|DOCS:Replica Sets]\\ | Master-slave, [multi-master, and circular replication|http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-replication-multi-master.html] |
| Object(row) Storage \\ | One large repository \\ | Collection-based \\ | Table-based \\ |
| Query Method \\ | Map/reduce of javascript functions to lazily build an index per query \\ | Dynamic; object-based query language \\ | Dynamic; SQL \\ |
| Secondary Indexes \\ | Yes | Yes | Yes |
| Atomicity | Single document \\ | Single document \\ | Yes - advanced \\ |
| Interface \\ | REST \\ | [Native drivers|DOCS:Drivers] ; REST [add-on|http://www.snailinaturtleneck.com/blog/2010/02/22/sleepy-mongoose-a-mongodb-rest-interface/] \\ | Native drivers \\ |
| Server-side batch data manipulation \\ | ? | Map/Reduce, server-side javascript \\ | Yes (SQL) \\ |
| Written in \\ | Erlang \\ | C+\+ | C+\+ \\ |
| Concurrency Control | MVCC | Update in Place | |
| Geospatial Indexes \\ | [GeoCouch|http://vmx.cx/cgi-bin/blog/index.cgi/geocouch-the-future-is-now:2010-05-03:en,CouchDB,Python,Erlang,geo] \\ | [Yes|DOCS:Geospatial Indexing] | [Spatial extensions|http://dev.mysql.com/doc/refman/5.0/en/spatial-extensions.html] \\ |
| [Distributed Consistency Model|http://blog.mongodb.org/post/475279604/on-distributed-consistency-part-1] | Eventually consistent (master-master replication with versioning and version reconciliation) | Strong consistency.  Eventually consistent reads from secondaries are available. \\ | Strong consistency.  Eventually consistent reads from secondaries are available. |

h3. See Also

* [DOCS:Comparing Mongo DB and Couch DB]

Full Content

Redirection Notice
This page should redirect to http://www.10gen.com/products/mongodb.

nor...@mongodb.onconfluence.com

unread,
Jan 22, 2013, 4:21:00 PM1/22/13
to mongodb...@googlegroups.com
Reply all
Reply to author
Forward
0 new messages