|
▼ Actions
| |||
| MongoDB | MySQL | Oracle | |
|---|---|---|---|
| MongoDB | MySQL | Oracle (Database) | |
| Category | |||
| Preference | 44% votes | 28% votes | 28% votes |
| Website | www.mongodb.org | www.mysql.com | www.oracle.com/us/product…e/index.html |
| License | |||
| Design | |||
| Database model | |||
| Data storage | |||
| Embeddable | No | Yes | No |
| Features | |||
| Query language | |||
| Data types | ? | ||
| Conditional entry updates | Yes | Yes | Yes |
| Map and reduce | Yes | No | No |
| Unicode | Yes | Yes | Yes |
| TTL for entries | Yes | No | Conditional |
| Compression | No | Yes | Yes |
| Integrity | |||
| Integrity model | |||
| Atomicity | Conditional | Yes | Yes |
| Consistency | Yes | Yes | Yes |
| Isolation | No | Yes | Yes |
| Durability (data storage) | Yes | Yes | Yes |
| Transactions | No | Yes | Yes |
| Referential integrity | No | Yes | Yes |
| Revision control | No | No | Yes |
| Locking model | |||
| Indexing | |||
| Secondary Indexes | Yes | Yes | Yes |
| Composite keys | Yes | Yes | Yes |
| Full text search | Yes | Yes | Yes |
| Geospatial Indexes | Yes | Yes | Yes |
| Graph support | No | No | Yes |
| Distribution | |||
| Horizontal scalable | Yes | Yes | Yes |
| Replication | Yes | Yes | Yes |
| Replication mode | |||
| Sharding | Yes | Yes | No |
| Shared nothing architecture | Yes | Yes | No |
| Restrictions | |||
| Value size max. | 16 MB | ? | ? |
| System requirements | |||
| Operating system | |||
| Native driver | |||
| Memory minimum | ? | 11 MB | -78 B |
| Architecture | |||
| Programming language | |||
| More | |||
| Description | Document Oriented Database | Relational database system | Relational Database Management System |
| Multi-user system | Yes | Yes | Yes |
| Standard compliance | No | Yes | ? |
| Software distribution | ? | ||
| Object-Relational Mapping (ORM) | Yes | ? | Yes |
| Documentation level | ★★★★★ | ★★★★☆ | ★★★★★ |
| Distributed Counter | No | ? | Yes |
| Free to use | Yes | Yes | Conditional |
| Active | Yes | Yes | Yes |
| Database Connection Pooling | Yes | Yes | Yes |
| Real time analytics | Yes | Conditional | Yes |
| Web interface | No | No | ? |
| Online backup | Yes | Yes | Yes |
| Partial Index | No | No | ? |
| Function Based Index | No | No | Yes |
| Key length max | 255 | ? | ? |
| Log | Yes | ? | Yes |
| Download | www.mongodb.org/downloads | dev.mysql.com/downloads/ | www.oracle.com |
| Backup functionality | Basic | Good | Good |
| Query Cache | Yes | Yes | Yes |
| Ease of use | ★★★★☆ | ? | ? |
| In-Place Update | Yes | ? | ? |
| Free for commercial use | Yes | Yes | No |
| Sorts | Yes | Yes | Yes |
| Capped Collections | Yes | ? | ? |
| Tuneable write concerns | No | ? | ? |
| Read preferences | Yes | ? | Yes |
| Brand | ? | ||
| Lines of code | ? | 1 100 k | ? |
| Community Driven | ? | Good | ? |
| 360° Camera | ? | Yes | ? |
| WYSIWYG-Editor | ? | ? | Yes |
| + Add row | + | + | + |
| MongoDB | MySQL | Oracle | |
Just click a data cell to edit it.
Take part and share your knowledge with the world.