Enhancing ThingsBoard Integration with IoTDB 2.X Table Mode
This project implements a new storage backend for ThingsBoard using Apache IoTDB 2.X's table mode. It introduces new DAO implementations (IoTDBTableTimeseriesDao, IoTDBTableLatestDao, IoTDBTableBaseDao) built on ITableSession, using Tablet-based writes and standard SQL queries. The design adopts a single generic table with TAG columns for tenant, entity, and key filtering, supports direct SQL aggregation via date_bin(), and relies on native TTL for data retention. The approach has been validated through a working proof of concept (https://github.com/PDGGK/thingsboard-iotdb-table-poc), tested against IoTDB 2.0.5 with all proposed access patterns. Deliverables include the full DAO implementation, Docker-based integration tests, performance benchmarks, and migration documentation.
Project details
Technologies
Not listed in the archive