Time Series with Cassandra Single device per row Partitioning to limit row size adding data to the row...

Please Visit: http://ift.tt/1ajReyV

Time Series with Cassandra
Single device per row 
Partitioning to limit row size 
adding data to the row key to limit the amount of columns you get per device.
PRIMARY KEY (weatherstation_id,event_time),
Reverse order timeseries with expiring columns: rolling storage
WITH CLUSTERING ORDER BY (event_time DESC);

Insert USING TTL 20;
http://ift.tt/1c7L3py

Materialized Views
minimizing disk seeks at the cost of higher space consumption is a good tradeoff.
http://ift.tt/1coyzuz
create table sensor_entries ( 
sensorid uuid, time_taken timeuuid, reading text,  
primary key(sensorid, time_taken)) with compact storage;
http://ift.tt/1c7L0KD


from Public RSS-Feed of Jeffery yuan. Created with the PIXELMECHANICS 'GPlusRSS-Webtool' at http://gplusrss.com http://ift.tt/1coyxmz
via LifeLong Community

No comments:

Post a Comment