Question: Storing last value only and storing static data.
- 主要语言
- 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