History[04][05]

SenseiDB was initially developed and employed by LinkedIn team in 2009. Engineers from both LinkedIn and Xiaomi were working on the project. It then became an open-source project that was contributed by many individuals. After three releases, SenseiDB has no longer updated or used since year 2013.

Checkpoints

Concurrency Control[06]

SenseiDB does not support concurrent operations . Only a single thread can run at a time. Besides, transactions are not supported as well.

Data Model[07]

SenseiDB is a relation database that are organized with tables. The users are able to index and retrieve the data with Browsing Query Language (BQL).

Indexes[08][05][09]

SenseiDB applies an indexing manager called Zoie, which is an independent searching and indexing engine built on Apache Lucene that uses inverted index to efficiently retrieve data. The biggest feature of Zoie is the support for real-time searches and updates.

Isolation Levels[06]

Joins[10]

Logging

Query Compilation

Query Execution[05]

Query execution is fulfilled by a query engine called Bobo, which uses the tuple-at-a-time model.

Query Interface[11][12]

Browsing Query Language (BQL) is supported by SenseiDB, which has the similar syntax to SQL. Besides those existing clauses in SQL, BQL introduces the "BROWSE BY" clause to support faceted search and navigation. This is the biggest feature of BQL.

Storage Architecture[03]

SenseiDB uses a disk-oriented distributed storage architecture.

Storage Model[07]

A SenseiDB instance is a table of data that is organized into columns. The attributes of a table is stored as metadata, and each column may belong to one of the supported types: string, int, long, short, float, double, char, date, text.

Stored Procedures

System Architecture[13]

The entire database is partitioned into a number of shards. Each shard is replicated across N nodes so that there might be more than one shards in a single node. There is not a master node in the system and each node is independent. Upcoming requests go through a separate load balancer to decide the nodes to request.

Views