What kind of storage should be used if temporary data slices are needed?

Question

Database

Healthy!
There is a task to store a model, say A, it has records of the record a1, a2 .... aN . Records appear gradually and can be processed, after processing they are marked as processed, during processing, records can change state and be in active processing or pending. The task is to be able to make slices, which records of model A at time point R were being processed and in what state they were at that moment, in active processing or in pending. A scenario is possible to select T slices from point K with an interval of 1s
. I understand how to do this on the RDBMS, but still it seems that there should be a tool designed specifically for this kind of task

Answer 1

Yes, such tool is called temporal DBMS. By the way, many modern RDBMS have extensions or mechanisms necessary for this.

Answer 2

Datomic