Re: SV: Using Cassandra for storing measurement data

2010-08-03 Thread Stefan Kaufmann
Thank you very much for those impulses. I see, that I'm still thinking to much in RDMS. I'll try thoses out. Stefan On Tue, Aug 3, 2010 at 11:44 AM, Aaron Morton wrote: > As Justus said, you need to consider the way you want to get the data back > and then denormalise to suit. Do you need to sup

Re: SV: Using Cassandra for storing measurement data

2010-08-03 Thread Aaron Morton
As Justus said, you need to consider the way you want to get the data back and then denormalise to suit. Do you need to support ad-hoc queries or will you know how you want to query ahead of time?Some different approaches may beStandard CF to hold the measurements taken, grouped by day{device_id/20

SV: Using Cassandra for storing measurement data

2010-08-03 Thread Thorvaldsson Justus
It sounds to me that it's an good idea to use Cassandra in your case, I figure I help you as we Europeans need to cooperate some even though I only worked with Cassandra for a month. =) 1: What is the query you want to use when charting the data? Use it to decide how to storage and sort your da