| NexusDB V1 | NexusDB V2 Developer |
NexusDB V2 Enterprise |
Oracle 10g Standard |
MS SQL Server 2000 |
MySQL 4.1 (MyIsam) |
Advantage 7.1 | DBIsam 4.14 |
||
| Deployment Options | |||||||||
| Embedded | x | x | x | - | - | - | x | x | |
| Client/Server Standalone | x | x | x | x | x | x | x | -² | |
| Client/Server + Embedded mixed | x | x | x | - | - | - | x | - | |
| Windows Service | x | x | x | x | x | x | x | x | |
| No BDE, No DLLs | x | x | x | - | - | - | - | x | |
| SQL | |||||||||
| SQL:2003 Core SQL | - | x | x | - | - | - | - | - | |
| SQL:2003 Additional Features | - | x | x | - | - | - | - | - | |
| ANSI SQL92 + | x | x | x | x | x | - | x | x | |
| SQL/PSM Procedure Language | - | x | x | x | x | - | - | - | |
| SQL Triggers | - | x | x | x | x | - | x | - | |
| SQL Stored Procedures | - | x | x | x | x | - | - | - | |
| Declare Cursor in SQL/PSM | - | - | x | x | x | - | - | - | |
| SQL User Defined Functions | - | x | x | x | x | - | - | - | |
| Local SQL Temporary Tables | x | x | x | x | x | - | - | x | |
| Global SQL Temporary Tables | - | x | x | x | x | - | - | - | |
| .NET SQL User Defined Functions | - | x | x | - | - | - | - | - | |
| SQL Transaction Support | - | x | x | x | x | - | x | x | |
| Multi-Database support in Queries | - | x | x | x | x | - | x | x | |
| SQL Views | - | x | x | x | x | x | x | - | |
| SQL Roles | - | - | x | x | x | x | x | - | |
| DDL | x | x | x | x | x | x | x | x | |
| Core Features | |||||||||
| Full Source Code included | x | x | x | - | - | - | - | x | |
| Full Threaded Core engine | x | x | x | x | x | - | x | - | |
| Optimized Memory Manager | x | x | x | x | ? | - | ? | - | |
| Optimized Cache Manager | x | x | x | ? | ? | - | ? | - | |
| Interchangable Data Transports | x | x | x | - | - | - | - | - | |
| Client Specific Temporary/Memory Tables | x | x | x | - | - | - | x | - | |
| Global Temporary Memory Tables | x | x | x | x | - | - | - | x | |
| Server Monitors/Extenders | x | x | x | - | - | - | - | x | |
| Server Plugins | x | x | x | - | - | - | - | - | |
| Server Side Data Monitoring and Interception | x | x | x | x | x | - | x | x | |
| Custom Sub-Engines (Exchangable Engine parts) | x | x | x | - | - | - | - | - | |
| Login/Security/Rights | x | x | x | x | x | x | x | x | |
| Automatic Table/Record Locking | x | x | x | x | x | x | x | x | |
| Advanced Data Types | x | x | x | x | x | x | x | x | |
| Data Encryption | x | x | x | x | x | - | x | x | |
| Read/Write Data Compression | - | x | x | x | x | x | x | - | |
| Fulltext Engine (single word) | - | x | x | x | x | x | x | x | |
| Variable Length Records | - | x | x | x | x | - | x | - | |
| Field Validatation Objects | - | x | x | - | - | - | - | - | |
| Conditional Indices | - | x | x | x | x | - | x | - | |
| Variable Length Keys | - | - | x | x | x | - | x | - | |
| Extended Logging | - | x | x | x | x | - | - | - | |
| Referential Integrity | x | x | x | x | x | - | x | - | |
| Self Referencing Referential Integrity | - | x | x | x | x | - | - | - | |
| Visual RI Editor | - | x | x | - | - | - | x | - | |
| Sub-Tables | - | x | x | x | - | - | - | - | |
| Fulltext Engine (expressions) | - | - | x | x | x | x | x | - | |
| Bulk Index Operations | - | - | x | - | - | - | - | - | |
| AutoInc engine re-using deleted keys | - | - | x | - | - | - | - | - | |
| Advanced
User Security (Database/Table/Record/Field - level) |
- | - | x | x | x | x | x | - | |
| Live Backup Scheduling | - | - | x | x | - | - | - | - | |
| Database Replication | - | - | x | x | x | x | x | - | |
| Data Auditing | - | - | x | x | x | - | - | - | |
| Transactions | |||||||||
| Basic Transactions | x | x | x | x | x | - | x | x | |
| Fail-Safe Transactions | x | x | x | x | x | - | x | - | |
| Snapshot Transactions | x | x | x | x | - | - | - | - | |
| Nested Transactions | x | x | x | x | x | - | x | - | |
| TDataset Layer | |||||||||
| TDataset compatible | x | x | x | x | x | x | x | x | |
| Batch/Block Read | x | x | x | - | - | - | x | x | |
| Batch/Block Move | x | x | x | x | x | - | x | x | |
| Batch/Block Write | x | x | x | - | - | - | x | - | |
| Cached Updates (IProvider) | x | x | x | x | x | - | - | - | |
| SQL Support in TDataset.Filter | - | x | x | - | - | - | x | - | |
| RecNo support | - | x | x | - | - | - | x | x | |
| Enhanced Live Dataset Support | - | x | x | - | - | - | x | x | |
| Flip Index Order for Navigation | - | x | x | - | - | - | - | - | |
| Native Cached Datasets | - | x | x | - | - | - | - | - | |
| Transports | |||||||||
| Transport Encryption | x | x | x | x | x | - | x | x | |
| Transport Compression | x | x | x | - | x | - | x | x | |
| Secured Transports | x | x | x | x | x | x | - | x | |
| Messaging System | x | x | x | - | - | - | - | - | |
| C/S/C Messaging and events | - | - | x | - | - | - | - | - | |
| Tools | |||||||||
| Online Backup | x | x | x | x | x | - | - | - | |
| Enterprise Manager | x | x | x | x | x | x | x | x | |
| Data Importers | x | x | x | x | x | x | x | x | |
| Source Converter Assistant | x | x | x | - | - | - | - | - | |
| Detailed Server User Interface | x | x | x | x | x | x | x | x | |
| Remote Server Configuration | - | - | x | x | x | - | - | - | |
| Remote Server Statistics | - | - | x | x | x | x | x | - | |
| .NET (optional add-ons from manufacturer) | |||||||||
| ADO.NET Compatible | x | x | x | x³ | x³ | x³ | x | - | |
| Delphi IDE Integration/Wizard | x | x | x | x³ | x³ | x³ | x | - | |
| VS.NET Integration/Wizard | x | x | x | x³ | x³ | x³ | x | - | |
| Server
Extensions in .NET lanugages (e.g. C#, Chrome, Delphi.NET) |
- | x | x | - | x³ | - | - | - | |
| VS.NET ServerExplorer Integration | - | x | x | x³ | x³ | x³ | - | - | |
| .NET
Direct Data Access Classes (similar to TDataset) |
- | - | x | - | - | - | - | - | |
| Borland ECO II support | - | x | x | x³ | x³ | x³ | x | - | |
| Borland BDP Provider | - | x | x | x³ | x³ | x³ | x | - | |
| Connectivity (optional add-ons from manufacturer) | |||||||||
| ADO.NET Provider | x | x | x | x | x | x | x | - | |
| ODBC Driver | x | x | x | x | x | x | x | x | |
| COM based direct Cursor access | x | x | x | - | - | - | - | - | |
| DBExpress Driver | x | x | x | x | x | x | x | - | |
| PHP Interface | - | x | x | x | x | x | x | - | |
| Borland BDP Provider | - | x | x | x | x | x | x | - | |
| Support (Manufacturer provided) | |||||||||
| Free mail support | x | x¹ | x¹ | - | - | - | - | x | |
| Free newsgroup support | x | x | x | - | - | x | x | x | |
| Free chat support | x | x | x | - | - | - | - | - | |
| Priority Support Contracts Available | - | x | x | x | x | x | - | x | |
| SLA Support Available | - | x | x | x | - | - | - | x | |
| x) supported | |||||||||
| -) not supported | |||||||||
| ?) unknown | |||||||||
| ¹) 3 incidents included in product price | |||||||||
| ²) filesharing multiusers mode available | |||||||||
| ³) included in IDE | |||||||||