| Feature | Open Source | Professional | Enterprise |
|---|---|---|---|
Client API |
|||
| - .NET API | ✓ | ✓ | ✓ |
| - Java API | ✓ | ||
| - Node.js | ✓ | ||
| - REST API | ✓ | ||
Data Model |
|||
| - JSON Documents | ✓ | ✓ | ✓ |
| - Normalized Data Model | ✓ | ✓ | ✓ |
| - Primary Key Support | ✓ | ✓ | |
| - Embedded Data Model | ✓ | ||
| - Expiration Strategy | ✓ | ||
| - Attachments | ✓ | ||
| - CLR Triggers | ✓ | ||
| - CLR User Defined Functions (UDF) | ✓ | ||
Clustered (Sharded) Databases |
|||
| - Stand-alone Database | ✓ | ✓ | ✓ |
| - Sharded Database (no replication) | ✓ | ✓ | ✓ |
| - Sharded Database (with replication) | ✓ | ||
| - Stand-alone to Sharded DB Migration | ✓ | ||
| - Hash Based Sharding | ✓ | ||
| - Range Based Sharding | ✓ | ||
Collections |
|||
| - Single-Shard Collections | ✓ | ✓ | ✓ |
| - Capped Single-Shard Collections | ✓ | ||
| - Multi-Sharded Collections | ✓ | ||
| - Move Single-Shard Collection Tool | ✓ | ✓ | ✓ |
High Availability |
|||
| - Self-Healing Dynamic Cluster | ✓ | ✓ | ✓ |
| - Configuration Manager (stand-alone) | ✓ | ✓ | ✓ |
| - Configuration Manager (clustered) | ✓ | ||
| - Shard Replicas (dedicated & shared) | ✓ | ||
| - State Transfer Across Shards | ✓ | ||
| - Journaling (for data consistency) | ✓ | ||
| - Multi-Data Center Support | ✓ | ||
| - NosDB Upgrade without Downtime | ✓ | ||
Performance & Scalability |
|||
| - Multiple Shards | ✓ | ✓ | ✓ |
| - DB Server In-Memory Caching | ✓ | ✓ | ✓ |
| - DB Client In-Memory Caching (NCache) (with InProc Client Cache) |
✓ | ||
| - Reads also Run on Replicas | ✓ | ||
| - Async Operations (with Fire & Forget) | ✓ | ||
| - Multiple NIC Binding | ✓ | ||
| - Bulk Operations | ✓ | ✓ | ✓ |
SQL Support |
|||
| - Basic SQL (SELECT, INSERT, UPDATE, DELETE) |
✓ | ✓ | ✓ |
| - Advanced SQL (JSON, Joins, Sub Queries etc.) | ✓ | ||
| - LINQ | ✓ | ||
| - Database Management (DDL) | ✓ | ✓ | ✓ |
| - Indexing (Basic) | ✓ | ✓ | ✓ |
| - Indexing (Compound) | ✓ | ||
| - Sql Dependency (DB Notifications on Updates) |
✓ | ||
Big Data Processing |
|||
| - MapReduce | ✓ | ||
| - Aggregator | ✓ | ||
Admin & Monitoring |
|||
| - NosDB Management Studio (with SQL Studio) |
✓ | ✓ | |
| - NosDB Monitor (GUI) | ✓ | ||
| - PerfMon Counters | ✓ | ✓ | ✓ |
| - Windows Event Logs | ✓ | ✓ | ✓ |
| - PowerShell Integration | ✓ | ✓ | ✓ |
| - Server Management API (.NET, Java, REST) | ✓ | ||
| - Full Backup/Restore | ✓ | ✓ | ✓ |
| - Differential Backup/Restore | ✓ | ||
| - Import/Export | ✓ | ✓ | ✓ |
Security |
|||
| - Windows Authentication | ✓ | ✓ | ✓ |
| - NosDB Authentication | ✓ | ||
| - Authorization | ✓ | ✓ | ✓ |
| - Custom Security Roles | ✓ | ||
| - SSL Support | ✓ | ||
| - Encryption | ✓ | ||
Third-Party Integrations |
|||
| - Visual Studio 2013/2015 | ✓ | ||
| - Entity Framework Core | ✓ | ||
| - Microsoft Power BI (Analytics) | ✓ | ||
| - ADO.NET Provider | ✓ | ✓ | ✓ |
| - NuGet Package | ✓ | ✓ | ✓ |
Installation Package |
|||
| - Windows Installer Client & Server (.msi) | ✓ | ✓ | ✓ |
| - Java Client Installer (.msi, .tar.gz) | ✓ | ||
| - Node.js npm Package | ✓ | ||