Re: How to store weather station Details along with monitoring data efficiently?

2015-01-24 Thread Srinivasa T N
Let me try to pictorially what I understood: [image: Inline image 1] Is it correct? Regards, Seenu. On Sat, Jan 24, 2015 at 2:37 AM, Jan cne...@yahoo.com wrote: The model you are using seems OK. Your question: This forces me to enter the wea_name and wea_add for each new row, so how to

Re: How to store weather station Details along with monitoring data efficiently?

2015-01-23 Thread Jan
The model you are using seems OK.  Your question: This forces me to enter the wea_name and wea_add for each new row, so how to identify a new row has been created? Answer:    You do 'not'  need to add the wea_name or wea_address during inserts for every new row.    Your insert could only

How to store weather station Details along with monitoring data efficiently?

2015-01-23 Thread Srinivasa T N
Hi All, I was following the TimeSeries data modelling in PlanetCassandra by Patrick McFadin. Regarding that, I had one query: If I need to store the weather station name also, should it be in the same table, say: create table test (wea_id int, wea_name text, wea_add text, eventday timeuuid,

Re: How to store weather station Details along with monitoring data efficiently?

2015-01-23 Thread Srinivasa T N
I forgot, my task at hand is to generate a report of all the weather station's along with the sum of temperatures measured each day. Regards, Seenu. On Fri, Jan 23, 2015 at 2:14 PM, Srinivasa T N seen...@gmail.com wrote: Hi All, I was following the TimeSeries data modelling in