Hi,
I've finished my first model and experiments with Cassandra with result I'm
pretty happy with - so I thought I'd move on to something harder.
We have a set of data that has a large number of entities (which is our
primary search key), for each of the entities we have a smallish (<100)
number of sets of data. Each set has a further set the contains column/vale
pairs.
The queries will be for an Entity, for one or more days for one or more of
the subsets. Conceptually I would like to model like it like this:-
Entity {
Day1: {
TypeA: {col1:val1, col2:val2, . . . }
TypeB: {col1:val1, col3:val3, . . . }
.
.
}
.
.
.
DayN: {
TypeB: {col3:val3, col5:val5, . . . }
TypeD: {col3:val3, col6:val6, . . . }
.
.
}
}
My understanding of the Cassandra data model is that I run out of map-dept
to do this in my simplistic approach as the Days are super columns, the
types are column and then I don't have a col/val map left for data.
Does anyone have advice on a good approach ?
thanks
--
*Franc Carter* | Systems architect | Sirca Ltd
<[email protected]>
[email protected] | www.sirca.org.au
Tel: +61 2 9236 9118
Level 9, 80 Clarence St, Sydney NSW 2000
PO Box H58, Australia Square, Sydney NSW 1215
