Cassandra Table design for Historical state information -


my requirement design table historical state information (not time-series). ex: have devices connecting , disconnecting management platform. want know details such (name, mac address, os, image, etc.) devices connected management platform in given interval (start , end time).

any on table design use-case?

if want know if connected during interval, should work in traditional time series approach:

create table device_state( deviceid, timeofevent, state, details, primary key (deviceid, timeofevent, state)  select details device_state    timeofevent > '2001-01-01 12:01:01.000'    , timeofevent < '2001-01-01 12:15:59.000'    , state = 'connected'; 

if want know if device connected entire time, need implement client side logic.


Comments

Popular posts from this blog

Payment information shows nothing in one page checkout page magento -

tcpdump - How to check if server received packet (acknowledged) -