Re: Datastructure time tracking

2011-11-19 Thread RobinUs2
Thank you very much. This was very helpfull. I'll post an update here when I managed to finish my datastructure design. -- View this message in context: http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/Datastructure-time-tracking-tp7005672p7011370.html Sent from the cassandra-u...

Re: Datastructure time tracking

2011-11-18 Thread Tyler Hobbs
On Fri, Nov 18, 2011 at 1:59 PM, RobinUs2 wrote: > We should be able to: > - find all time records from all users within a given project (with > optionally a certain date range) > You'll need a timeline per project. I would use one row per day, week, or month, depending on the size. Your row k

Re: Datastructure time tracking

2011-11-18 Thread RobinUs2
We should be able to: - find all time records from all users within a given project (with optionally a certain date range) - find total time per task - find all time records from user X (with optionally a certain date range) As I understand from your answer this would require atleast 3 (or 5?) CF'

Re: Datastructure time tracking

2011-11-17 Thread Tyler Hobbs
On Thu, Nov 17, 2011 at 2:36 PM, RobinUs2 wrote: > We're currently developing a system with a time tracking part. We need to > store following details: > - user > - time (in minutes) > - description > - billable > - project > - task ID > > What would be a proper data structure for this in Cassand