apache / apache/iotdb

Question: Storing last value only and storing static data.

Open
#2,528 2 comments 0 reactions 0 assignees View on GitHub
Dominant language
Java
Stars
6.4k
Forks
1.2k
Avg merge
1d 23h
Merged PRs (30d)
115

Description

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?

Contributor guide

Open the contributing guide

Research direction

No source files, tests, or entry points are named. Start by reviewing IoTDB's existing support for static measurements, latest-value retention, TTL behavior, and update or delete/insert operations. Done would be a documented, decided approach covering both requested storage cases and data-loss concerns.

Written by the indexing model from the issue text.

Assessment

Domain
databases
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
20/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.