Query Interface

SQL

Views

Virtual Views

Ignite has some built-in views that contain information about cluster nodes.

Concurrency Control

Multi-version Concurrency Control (MVCC)

MVCC now is released as beta versions in Ignite version 2.7 In MVCC, Ignite will create a logical snapshot of data for each transaction. The snapshot is consistent throughout the transaction and the transaction can only view and modify data in this snapshot. If an entry is read by transaction A and updated by transaction B when transaction A tries to update the entry again, Ignite will throw an exception and transaction A will need to be retried.

Logging

Logical Logging

Ignite uses a write-ahead log which logs logical database modifications and page changes.

Joins

Not Supported

Storage Model

N-ary Storage Model (Row/Record)

Isolation Levels

Read Committed Serializable Repeatable Read

Ignite supports the following three isolation levels: READ_COMMITTED, REPEATABLE_READ, and SERIALIZABLE.

Stored Procedures

Supported

Ignite support access to the contents of the result generated by batches and stored procedures.

Indexes

B+Tree

Ignite uses internal B+tree data structures to store regular indexes. Ignite supports primary and secondary indexes, but it will only enforce the uniqueness of primary indexes.

Storage Architecture

Disk-oriented In-Memory

Apache Ignite is a memory-centric distributed database. However, there is a native persistence option in Ignite. If you turned it off, it is a pure in-memory store. When the option is turned on, it stores both data and indexes on disk. In this mode, a subset of data is stored in memory. Additionally, one benefit of this mode is that the indexes don't need to be rebuild when the system restarts since they are persisted on the disk.

Checkpoints

Consistent Fuzzy

According to Ignite's confluence page, consistent checkpointing has been implemented in the system. The fuzzy checkpointing may be implemented in future releases.

Foreign Keys

Not Supported

Ignite does not support foreign key constraints.

Data Model

Key/Value

Ignite uses a key-value store. And Ignite determines the location of the data using a pluggable hashing algorithm. It means every client can determine where the value is stored by plugging the key into a hashing function.

System Architecture

Shared-Nothing

Ignite is a memory-centric distributed database, caching, and processing platform. Ignite uses a shared-nothing, node-based cluster architecture. The nodes Ignite nodes can automatically discover each other. This helps to scale the cluster when needed, without having to restart the whole cluster.