apache / apache/iotdb

Question: Storing last value only and storing static data.

未关闭
#2,528 2 条评论 0 个 reaction 已指派 0 人 在 GitHub 查看
主要语言
Java
星标
6.4k
派生
1.2k
平均合并
1 天 23 小时
30 天内合并 PR
115

描述

I am collecting IT infrastructure metrics - cpu, ram, network I/O etc. which fits nicely in iotDB since I need to track this over time.

I am also collecting infrastructure detail such as up time, host operating system etc.

As the uptime (as a long integer) is always increasing I dont need to keep the data in a timeseries and I am only interested in the last value as such I am storing this in a relational database along with other static data such as host OS name which should never change. The data is collected ever 5 minutes but is unlikely to change so I just do an "update" statement in the RDBMS.

I would like to store this in iotDB if possible to avoid having to support 2 databases.

Is there a way to;

1. Store static information which does not change?
2. Store a long integer but only keep the last value?

Should I use TTL to limit the amount of data? I only see reference to TTL at the storage group level. Im guessing TTL isnt the answer since all data may disappear if the host stops sending data.

Should I delete and insert every time? Will this affect performance?

贡献指南

打开贡献指南

调研方向

未指定源文件、测试或入口点。首先检查 IoTDB 对静态测量值、最新值保留、TTL 行为以及更新或删除/插入操作的现有支持。完成标准是形成一份有文档记录且已确定的方案,涵盖所请求的两种存储情况以及对数据丢失的担忧。

由索引模型根据 Issue 内容生成。

评估

领域
databases
Issue 类型
功能
难度
5/5
预计耗时
一周以上
活跃度
停滞
描述清晰度
需要澄清
新手友好度
20/100

把新 issue 发到你的邮箱

精选适合新手参与的 GitHub issue 摘要。