2026年国产时序数据库盘点：格局嬗变下的多模态融合实践路径

# 1. 下载安装包（2026最新稳定版）
wget https://dlcdn.apache.org/iotdb/1.3.0/apache-iotdb-1.3.0-all-bin.zip
# 2. 解压并进入目录
unzip apache-iotdb-1.3.0-all-bin.zip && cd apache-iotdb-1.3.0-all-bin
# 3. 启动服务
./sbin/start-server.sh
# 4. 连接客户端
./sbin/start-cli.sh -h 127.0.0.1 -p 6667 -u root -pw root

-- 创建存储组（适配设备层级）
CREATE STORAGE GROUP root.sg_industrial;
-- 创建时序表（设备传感器数据）
CREATE TIMESERIES root.sg_industrial.dev001.temperature WITH DATATYPE=FLOAT, ENCODING=PLAIN;
CREATE TIMESERIES root.sg_industrial.dev001.pressure WITH DATATYPE=FLOAT, ENCODING=PLAIN;
-- 插入时序数据
INSERT INTO root.sg_industrial.dev001(timestamp, temperature, pressure) 
VALUES (1736486400000, 25.6, 1.02), (1736486460000, 25.8, 1.03);
-- 查询数据
SELECT temperature, pressure FROM root.sg_industrial.dev001 
WHERE time >= 1736486400000 AND time <= 1736486520000;

# 1. 安装RPM包（CentOS）
curl -L https://get.taosdata.com/taos.repo -o /etc/yum.repos.d/taos.repo
yum clean all && yum makecache
yum install -y tdengine
# 2. 启动服务
systemctl start taosd
# 3. 连接客户端
taos

-- 创建数据库（设置保留策略）
CREATE DATABASE industrial_db KEEP 365 DAYS 10 BLOCKS 6;
USE industrial_db;
-- 创建超级表（模板表）
CREATE STABLE device_data (ts TIMESTAMP, temperature FLOAT, pressure FLOAT) 
TAGS (device_id NCHAR(32), factory NCHAR(64));
-- 创建子表（对应单设备）
CREATE TABLE dev001 USING device_data TAGS ('DEV001', '福建船舶设备厂');
-- 批量插入数据
INSERT INTO dev001 VALUES 
('2026-01-10 08:00:00', 25.6, 1.02),
('2026-01-10 08:01:00', 25.8, 1.03);
-- 聚合查询
SELECT AVG(temperature), MAX(pressure) FROM dev001 
WHERE ts BETWEEN '2026-01-10 08:00:00' AND '2026-01-10 09:00:00';

# 1. 启动KingbaseES服务
systemctl start kingbase8d
# 2. 连接数据库（使用sys_kingbase用户）
ksql -U sys_kingbase -d testdb -h 127.0.0.1 -p 54321
# 3. 启用时序插件
CREATE EXTENSION timeseries;
# 验证插件状态
\dx

-- 1. 创建关系型设备台账表（业务数据）
CREATE TABLE device_info (
    device_id VARCHAR(32) PRIMARY KEY,
    device_name VARCHAR(64),
    factory VARCHAR(64),
    install_time TIMESTAMP
);

-- 2. 创建时序表（启用时间分区优化）
CREATE TABLE device_sensor_ts (
    device_id VARCHAR(32),
    collect_time TIMESTAMP NOT NULL,
    temperature FLOAT,
    pressure FLOAT,
    PARTITION BY RANGE (collect_time) (
        PARTITION p202601 VALUES LESS THAN ('2026-02-01'),
        PARTITION p202602 VALUES LESS THAN ('2026-03-01')
    )
) WITH (TIMESERIES = ON);

-- 3. 事务化写入多类型数据
BEGIN;
INSERT INTO device_info VALUES 
('DEV001', '船舶GPS终端', '福建船舶设备厂', '2025-12-01'),
('DEV002', '电网监测传感器', '国家电网设备厂', '2025-11-15');
INSERT INTO device_sensor_ts VALUES 
('DEV001', '2026-01-10 08:00:00', 25.6, 1.02),
('DEV001', '2026-01-10 08:01:00', 25.8, 1.03),
('DEV002', '2026-01-10 08:00:00', 22.3, 0.98);
COMMIT;

-- 4. 时序与关系数据跨表关联查询
SELECT 
    di.device_name,
    dst.collect_time,
    dst.temperature
FROM device_sensor_ts dst
JOIN device_info di ON dst.device_id = di.device_id
WHERE di.factory = '福建船舶设备厂'
  AND dst.collect_time BETWEEN '2026-01-10 08:00:00' AND '2026-01-10 08:05:00';