GridDB is a distributed key-value DBMS built by Toshiba. It has Key-Container data model and time-series functions which are designed specifically to target large data generated by IoT devices. It can be accessed by C and Java APIs, or TQL, a custom SQL-like query language.
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.
Multi-version Concurrency Control (MVCC)
GridDB adopts MVCC to realize READ_COMMITTED. It improves throughput as multiple transactions can access data that is prior to the update concurrently.
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.
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.
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.
GridDB does not support JOIN operation. All JOIN operations have to be implemented in the application.
Custom API SQL HTTP / REST Command-line / Shell
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.
GridDB has "Memory first, Storage second" structure where frequently accessed data is stored in memory. The rest data is moved to disks.
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.
C, C++, Go, Java, Perl, PHP, Python, Ruby