Re: data model advice needed

2013-02-28 Thread Michal Michalski
13 19:12 To: user@cassandra.apache.org Subject: Re: data model advice needed One possibility would be to use dynamic columns, with each column name being a composite made from a timestamp, and the value of each containing serialized json of the details. The host could be the key. Then you could

RE: data model advice needed

2013-02-27 Thread Sloot, Hans-Peter
19:12 To: user@cassandra.apache.org Subject: Re: data model advice needed One possibility would be to use dynamic columns, with each column name being a composite made from a timestamp, and the value of each containing serialized json of the details. The host could be the key. Then you could slice

Re: data model advice needed

2013-02-27 Thread Hiller, Dean
There are many different patterns in noSQL with 90% being different than an RDBMS. Check out this page for some things to get you thinking http://buffalosw.com/wiki/Patterns-Page/ If you ever consider playorm and you can figure out how to partition your data(perhaps by month), you can do querie

Re: data model advice needed

2013-02-27 Thread kadey
- From: "Hans-Peter Sloot" To: user@cassandra.apache.org Sent: Wednesday, February 27, 2013 1:01:24 PM Subject: data model advice needed Hi, I would like to get some advice on how to model columnfamilies for storing log of firewalls. The columns are listed further below. All the pos

data model advice needed

2013-02-27 Thread Sloot, Hans-Peter
Hi, I would like to get some advice on how to model columnfamilies for storing log of firewalls. The columns are listed further below. All the possibilities confuse me a bit (super columns, secondary indexes etc). My main question is how can I create the columnfamily in order to be able to get