|
▼ Actions
| |||
| Berkeley DB | MSSQL | + Add column | |
|---|---|---|---|
| Berkeley DB | Microsoft SQL Server 2012 | ||
| Category | |||
| Preference | (47% global votes) | (72% global votes) | |
| Website | www.oracle.com/database/b…b/index.html | www.microsoft.com/sqlserver/ | |
| License | |||
| Design | |||
| Database model | |||
| Data storage | |||
| Embeddable | Yes | Yes | |
| Features | |||
| Query language | |||
| Data types | ? | ||
| Conditional entry updates | Yes | Yes | |
| Map and reduce | No | ? | |
| Unicode | Yes | Yes | |
| TTL for entries | No | Yes | |
| Compression | Yes | Yes | |
| Integrity | |||
| Integrity model | |||
| Atomicity | Yes | Yes | |
| Consistency | Yes | Yes | |
| Isolation | Yes | Yes | |
| Durability (data storage) | Yes | Yes | |
| Transactions | No | Yes | |
| Referential integrity | No | Yes | |
| Revision control | ? | Yes | |
| Indexing | |||
| Secondary Indexes | Yes | Yes | |
| Composite keys | Yes | Yes | |
| Full text search | Yes | Yes | |
| Geospatial Indexes | No | Yes | |
| Graph support | No | No | |
| Distribution | |||
| Horizontal scalable | Yes | No | |
| Replication | Yes | Yes | |
| Replication mode | |||
| Sharding | Yes | Yes | |
| Restrictions | |||
| Value size max. | 64 TB | 2 GB | |
| System requirements | |||
| Operating system | |||
| Native driver | ? | ||
| Memory minimum | ? | 256 MB | |
| Architecture | |||
| Programming language | |||
| More | |||
| Description | key/value database | Relational database | |
| Multi-user system | Yes | Yes | |
| Documentation level | ★★★★☆ | ★★★★★ | |
| Distributed Counter | Yes | ? | |
| Free to use | Yes | Conditional | |
| Active | Yes | Yes | |
| Log | Yes | Yes | |
| Download | www.oracle.com/technetwor…iteId=ocomen | www.microsoft.com/sqlserver | |
| Free for commercial use | No | ? | |
| Sorts | Yes | ? | |
| Brand | ? | ||
| Database Connection Pooling | ? | Yes | |
| Online backup | ? | Yes | |
| Function Based Index | ? | Yes | |
| Backup functionality | ? | Good | |
| Ease of use | ? | ★★★★☆ | |
| + Add row | + | + | |
| Berkeley DB | MSSQL | ||
Just click a data cell to edit it.
Take part and share your knowledge with the world.