Checkpoints

Not Supported

Compression

Bit Packing / Mostly Encoding

SequoiaDB uses BSON (binary JSON) format to encode and store JSON format data.

Concurrency Control

Not Supported

SequoiaDB implements transactions, but does not support concurrency control options. Transactions are limited to only include record insert, delete, update, and query (read) operations. Other database operations such as creating new index are not supported in transactions and will not be logged as part of the transaction.

Data Model

Document / XML

SequoiaDB supports relational, semi-structured (e.g. JSON), and unstructured (e.g. POSIX file) data models. Data model in storage is JSON.

Indexes

B+Tree

Indexes in SequoiaDB use conventional B-trees. An index has a unique name for the index on the data collection and a JSON object that defines the indexing criteria and direction. Indexes can be unique or non-unique. If an index is unique, it can be null-able or non-null-able.

In addition to regular indexes, SequoiaDB supports full-text searching via Elasticsearch.

Isolation Levels

Read Uncommitted Read Committed Read Stability

SequoiaDB supports three levels of isolation - read uncommitted, read committed, and read stability. By default, the system is configured as read uncommitted.

Logging

Logical Logging

The system implements logical logging and log replay to support data consistency across distributed replicas.

Parallel Execution

Intra-Operator (Horizontal)

Parallel query execution is supported via individual query configuration.

Query Interface

SQL HTTP / REST Command-line / Shell

Storage Architecture

Disk-oriented

If the system is deployed on distributed clusters, it can be configured with either range-based or hash-based sharding.

Storage Model

Custom

SequoiaDB uses a JSON format record as a unit of data storage. These records are stored in collections. Collections are stored in "collection spaces".

Stored Procedures

Supported

SequoiaDB supports creating and executing custom procedures via JavaScript-like syntax in SequoiaDB Shell.

System Architecture

Shared-Disk

The system is configurable to deploy on a single node or on multiple distributed nodes. In a distributed environment, coordination nodes and catalog nodes share disk space, while storage nodes are given separate disk space. The storage nodes can be configured to share disk or each to be given nonshared disk.