Time based data management¶
you have data with a timestamp column
the time stamp matches more or less with when the data is inserted into sqream/ and when the event that generated that data happened (e.g. you are inserting new event data every hour or every day)
you want to keep x months or years of data in sqream to query. so e.g. you delete the oldest month of data every month, by this timestamp column
you often query over a range on this timestamp, e.g. a specific hour, day or month.
the sqream chunk/extent system, the insert implementation, and the free cheap metadata system will all support this kind of process extremely effectively