DOCSEARCHbyAlgolia
Submit Docs

GridDB Documentation

website·Indexed 33 days ago

https://docs.griddb.net/

An open source time series database optimized for IoT and Big Data. The documentation covers installation on Ubuntu, CentOS, and Docker; TQL and SQL syntax; data modeling using Key-Container types; and client libraries for Java, Go, PHP, and Node.js. It includes technical specifications for the JDBC driver and guidance on cluster operations, user management, and time-series aggregation.

Tokens
132K
Snippets
571
Records
898
Agent score
55%

What's inside GridDB

  1. Overview of GridDB Time Series Database

    GridDB is an open-source time series database optimized for IoT and Big Data. It is designed to handle large quantities, high frequencies, and vast varieties of data. Its core architecture is built on four pillars: optimization for IoT, high performance, high scalability, and high reliability/availability.

  2. Overview of GridDB Community Edition API Interfaces

    GridDB v4.5 Community Edition (CE) provides two primary application programming interfaces for data interaction:

    1. NoSQL interface: Used for basic data access and TQL (TQL is the specific NoSQL interface described in the TQL reference documentation).
    2. NewSQL interface: Used for executing SQL queries that conform to the SQL92 standard.

  3. Overview of GridDB Operational Tools

    GridDB provides several tools for cluster management, node operations, and data manipulation:
    ToolDescription
    Service ManagementLinux service controls for starting/stopping GridDB nodes.
    gs_adminWeb-based Integrated Operation Management GUI.
    gs_shCUI tool for cluster operation management and data manipulation.
    Operational CommandsA suite of CLI tools (all starting with gs_) for specific operational tasks.
    Export/Import ToolsTools for moving data in and out of the cluster.

  4. Overview of GridDB Community Edition API Interfaces

    GridDB v4.5 Community Edition (GridDB CE) provides two primary application programming interfaces for data interaction: a NoSQL interface used for basic data access and TQL (TQL Query Language) execution, and a NewSQL interface used for executing SQL queries that conform to the SQL92 standard.

  5. Overview of GridDB Time-Series Database

    GridDB is a scale-out NoSQL time-series database optimized for IoT and big data. It is designed to handle high-frequency, diverse data streams while providing high performance, scalability, and reliability. It supports ACID transactions at the container level and uses a query language called TQL, which is similar to SQL.

  6. Overview of GridDB JDBC Driver

    The GridDB v4.5 JDBC (Java interface) provides an application interface for GridDB Community Edition (GridDB CE) that conforms to the SQL92 standard specification.

  7. Overview of GridDB Time Series Database

    GridDB is an open-source time series database specifically optimized for IoT and Big Data. It is designed to handle large quantities, high frequencies, and vast varieties of data while providing high scalability, performance, and reliability.

  8. Overview of GridDB Time Series Database

    GridDB is an open-source time series database optimized for IoT and Big Data. It is designed to handle large quantities, high frequencies, and vast varieties of data while providing high scalability, performance, and reliability. It combines features of NoSQL (scale-out architecture) with the data consistency and ACID transaction guarantees typical of Relational Databases (RDB).

  9. Overview of GridDB Time Series Database

    GridDB is a scale-out NoSQL time series database developed by Toshiba, optimized for IoT and big data. It combines the scalability of NoSQL with the data consistency and ACID transaction reliability typically found in relational databases (RDB). It is designed to handle high-frequency, diverse data streams and provides high performance through an in-memory oriented architecture.

  10. Retrieve index metadata using the #index_info metatable

    The #index_info metatable contains metadata about indexes, including the index name, type (TREE, HASH, or SPATIAL), and the specific columns associated with the index and their ordinal positions.
    -- Example: Find all indexes for a specific table
SELECT INDEX_NAME, INDEX_TYPE, COLUMN_NAME FROM "#index_info" WHERE TABLE_NAME = 'myTable';

  11. Query connection and socket information using the #sockets metatable

    The #sockets metatable provides metadata about active network connections. It allows developers to monitor service types, node addresses, and event counts to diagnose connection performance or identify clients waiting for execution.

    Column Definitions:

    • SERVICE_TYPE: Service type (e.g., SQL or TRANSACTION).
    • SOCKET_TYPE: The type of socket. Possible values include:
      • SERVER: TCP connection between servers.
      • CLIENT: TCP connection with a client.
      • MULTICAST: Multicasting socket.
      • NULL: Unidentified (e.g., during a connection attempt).
    • NODE_ADDRESS / NODE_PORT: Connection source address and port.
    • REMOTE_ADDRESS / REMOTE_PORT: Connection destination address and port.
    • APPLICATION_NAME: Name of the connecting application.
    • CREATION_TIME: Timestamp when the socket was generated.
    • DISPATCHING_EVENT_COUNT: Total number of times a request for event handling was started.
    • SENDING_EVENT_COUNT: Total number of times event transmission was started.

    Performance Tip: For CLIENT sockets, if DISPATCHING_EVENT_COUNT is greater than SENDING_EVENT_COUNT, there is a high probability that the connection experienced wait time before execution.

    -- Find client connections that likely experienced execution wait times
SELECT CREATION_TIME, NODE_ADDRESS, NODE_PORT, APPLICATION_NAME 
FROM "#sockets"
WHERE SOCKET_TYPE='CLIENT' AND DISPATCHING_EVENT_COUNT > SENDING_EVENT_COUNT;

  12. Retrieve table metadata using #tables

    The #tables meta-table provides detailed information about tables, including their type (COLLECTION/TIMESERIES), data affinity, expiration settings, compression methods, and partitioning configurations (type, column, interval values, and division counts).