Re: Table design for historical data

2015-04-01 Thread Firdousi Farozan
I will be writing an event when device connects. Probably a device never disconnects till current time, and I want to return that device for that time range. Device disconnect is used to mark the end time; Any query beyond that time should not return that device. Queries can have adhoc start and e

Re: Table design for historical data

2015-04-01 Thread Eric R Medley
Firdousi, What kind of events would be stored in the table? Will you be writing an event when a device connects and another when it disconnects or will you write a single event after the device finally disconnects? Also, for your queries, do you want ad-hoc start and end times or do you have a

Table design for historical data

2015-04-01 Thread Firdousi Farozan
Hi, My requirement is to design a table for historical state information (not exactly time-series). For ex: I have devices connecting and disconnecting to the management platform. I want to know the details such as (name, mac, os, image, etc.) for all devices connected to the management platform i