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 | |||||||||