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
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