Re: Cassandra data model for financial data

2010-04-29 Thread Andrew Nguyen
When making rough calculations regarding the potential size of a single row, what sort of overhead is there to consider? In other words, for a particular column, what else is there to consider in terms of memory consumption besides the value itself? On Apr 29, 2010, at 8:49 AM, Mark Jones wrot

Re: Cassandra data model for financial data

2010-04-29 Thread Andrew Nguyen
What is the upper limit on the number of super columns? Is it pretty much the same as for columns in general? On Apr 28, 2010, at 10:09 PM, Schubert Zhang wrote: > key : stock ID, e.g. AAPL+year > column family: closting price and valume, tow CFs. > colum name: timestamp LongType > > AAPL+201

Best way to store millisecond-accurate data

2010-04-23 Thread Andrew Nguyen
Hello, I am looking to store patient physiologic data in Cassandra - it's being collected at rates of 1 to 125 Hz. I'm thinking of storing the timestamps as the column names and the patient/parameter combo as the row key. For example, Bob is in the ICU and is currently having his blood pressu