Concurrency Control

Multi-version Concurrency Control (MVCC)

Data Model

Object-Oriented

ObjectBox is object-oriented. Objects are stored directly without another layer of relational tables.

Foreign Keys

Supported

Foreign keys are maintained by relations in each entity. There are 2 kinds of relations: ToOne and ToMany. By combining the type of the relation and the type of the reverse relation, the user can define one-to-one, one-to-many, and many-to-many relations.

Indexes

B+Tree

B+ tree based with 3 different options: value, 32 bit hash, 64 bit hash (hashes for string values only)

Isolation Levels

Read Committed Snapshot Isolation

Joins

Index Nested Loop Join

Joins in ObjectBox is implemented using relations stored in each object. Each object stores reference to the other object(s) in the relation, which is similar to index nested loop join.

Query Compilation

Not Supported

A query builder "compiles" query objects by setting up using code pointers that check criteria

Query Interface

Custom API

ObjectBox provides builder APIs for creating queries. Created queries are reusable by setting different parameters.

Storage Architecture

Hybrid

Low-level mmap approach taking care of OS in-memory caches and ACID compliant disk storage

Storage Model

Custom

Storage Organization

Copy-on-Write / Shadow Paging

Stored Procedures

Not Supported

The DB itself don't have stored procedures, but it can be implemented using functions in the corresponding programming language when run as an embedded database.

System Architecture

Embedded

The DB runs on IoT and mobile devices and does not share disk or memory with other devices. However, the ObjectBox supports automatic synchronization of data with the backend server. When the server is unavailable (i.e. network failure), the synchronization will stop, and it is restored seamlessly when the server is available again.

Views

Not Supported