History[04]

Toshiba started development of GridDB in 2011. Its first commercial release was in 2013. The community edition (CE) was open-sourced in 2016. Compared with CE, the standard version has better software support and more administrative tools.

Concurrency Control[05]

GridDB adopts MVCC to realize READ_COMMITTED. It improves throughput as multiple transactions can access data that is prior to the update concurrently.

Data Model[04]

The data model of GridDB is key-container model which extends typical NoSQL Key-Value store. Containers are comparable to tables in Relational Database and consist of two types: Collection Container for general purpose; and TimeSeries Container for time series data where each tuple in the container is associated with a timestamp as ROWKEY.

Indexes[06]

GridDB has three types of index: hash index (HASH), tree index (TREE) and space index (SPATIAL). Hash index is used in equivalent-value search and tree index is used in comparison such as range search. The data structure of tree index is B+Tree.

Isolation Levels[05]

GridDB supports READ_COMMITTED as transaction isolation level. In READ_COMMITTED, dirty read is impossible as data is only updated when the transaction is committed. However, non-repeatable read may happen as within the same transaction, if the data is read again, it may be updated by a committed transaction between the two reads and return different result from the previous read.

Joins[07]

GridDB does not support JOIN operation. All JOIN operations have to be implemented in the application.

Query Interface[08][09][10]

GridDB has a Web-application GUI (gs_admin) and command line tool (gs_sh) that integrates cluster operations.

For queries, GridDB supports TQL, a custom subset of SQL for GridDB that includes search and aggregation. Although TQL does not support some SQL clauses such as GROUP_BY and JOIN, it has additional operations for time-series data.

GridDB provides C and Java API for TQL.

Storage Architecture[04]

GridDB has "Memory first, Storage second" structure where frequently accessed data is stored in memory. The rest data is moved to disks.

Stored Procedures

System Architecture[08]

GridDB has a master-slave architecture. All nodes in the cluster contain partitioned data and one node acts as the master. If the master node fails, an election is held and another node is promoted to be the master.

Views