Selecting the Right Edition

Purchase Method

Per User

Per User or Per Core

Per User or Per Core

Hardware Supported

Up to 4 cores

Up to 8 cores

OS Limit

Available Cache

Up to 128 MB

Up to 1024 MB

OS Limit

Maximum Database Size

10 GB

100 GB

OS Limit

Sophisticated Key/Value Pair data access

Flexible Record Schema

User-defined data types

Primary and secondary indexes

Multithreaded engine

Full client and partial server source code

ACID Transactions

Automatic Aggregation

Automatic Purging

Automatic Timestamps

Table Marks - group files to simplify file open/close with large quantities of files

JSON

JavaScript NAV API

Python NAV API

REST API

Hot Alter Table

Full-text Search

In-Memory data files

Server-to-server communication

Partition Files

Alternate Collating Sequences

Users and groups with authority definitions

Triggers

Stored Procedures (.NET and Java)

User Defined Functions

Interactive/Scriptable SQL interface

Multiple interfaces (ADO.NET, JDBC, ODBC, Python, Delphi)

Multiple Record Type (MRT) Support

Advanced Dynamic SQL Partitioning (FILESET)

Multiple Record Type (MRT) Support

Hot Alter Table

Full-text Search

Truncate file support

Nodename/Process ID used to identify the application using the ODBC drive

PHP PDO support

Python SQL Alchemy

Automatically add tables to SQL Dictionary (sqlize)

Basic Transaction control: full disk, full recovery, no grouping

Tunable transaction Commit Delay control for ultra-high speed data I/O applications

Two-phase commit

Deferred durability: delay flushing of transaction logs

Quiesce operation for hot snapshot

Full real-time backup support

Point in time backup/restore

VSS backup support

Real-time replication for Failover, DR, read/write scalability

May be purchased

May be purchased

Read Only Server

Basic Security/Data Camouflage

Advanced Security

Data Encryption

TLS (Transport Layer Security)

Multi-Level File Authentication [ File Password ]

Row-level Security

LDAP Support

Secure OEM Client/Server Handshake/OEM Builds

AWS Secrets Manager

Support > 32,000 file opens per Server (current limit is 1,000,000 and can be increased further)

4 TB Sort Memory

Huge Columns (Maximum column size increased to 65,500)

Huge Columns to Tables (columns per table 2,500)

Huge Temporary Table Size (128TB)

Basic Cache Management

Basic Cache Management

Advanced Cache Management

Cache Priming

Dedicated File Cache

Index Management

Basic Index Management

Conditional Indexes

Advanced Index Management

Deferred Indexes

Deferred Data Handler

Advanced I/O Operations

Direct I/O [Peripheral-specific file I/O implementation]

Partial Record Reads/Writes

Enable shared memory performance enhancement for all Unix platforms

Extend leaf node read lock optimization to moving right or left at leaf level

Prevent server‑wide delays opening / closing files

Scriptable & Graphical Server Administration and Logging Tools

Web Browser-based GUI tools

HTTP App Server

Plug-in support for easily enhancing database with custom features

Full-text Search

Target Usage

• Redistribution by ISVs Targeting Small Companies

•  ISVs with SaaS Business Models

• Hosted Applications

• Redistribution by ISVs Targeting Small/Medium Companies

• Mission Critical

• High Throughput

•  ISVs with SaaS Business Models

•  Hosted Applications

•  Redistribution by ISVs Targeting Medium/Large Companies