Apache IoTDB

Collection, storage and analysis of time series data sit in one system with Apache IoTDB, a database shaped by industrial internet of things workloads, where millions of low-power devices write continuously and the accumulated dataset still has to answer complex queries.

Storage builds on TsFile, a columnar file format designed for time series, which is how the project reaches a high compression ratio on disk and keeps hardware cost down. The system runs on Windows, macOS and Linux and requires Java 17 or newer, with versions up to 25 verified.

The design answers a handful of recurring industrial problems.

• Flexible deployment: a one-click installer for cloud platforms or terminal devices, plus a tool that synchronizes data between the two.
• Directory structure: time series from complex device hierarchies organize efficiently, with fuzzy search across a large catalog of series.
• Query semantics: time alignment across devices and measurements, frequency domain transformation and aggregation over the time dimension.
• Familiar interfaces: a SQL-like language, the standard JDBC API, a command-line client and CSV import and export tools.
• Ecosystem integration: Hadoop and Spark for analysis, Grafana for visualization.

Before starting a node, raise the maximum open file count to 65535 and, on Linux, set somaxconn to the same value, or the server may fail to start or log connection resets. Docker users apply those limits on the host machine. Building from source additionally needs Maven 3.6 or later. The project is developed at the Apache Software Foundation, with issues tracked in Jira.