incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bartosz KoƂodziej <bartosz.kolodz...@gmail.com>
Subject Need a little help with data model design
Date Fri, 02 Jul 2010 22:29:11 GMT
I'm new to cassandra, and I want use it to store:

loggers = { // (super)ColumnFamily ?
    logger1 : { // row inside super CF ?
        timestamp1 : {
            value : 10
        },
        timestamp2 : {
            value : 12
        }
        (many many many more)
    }
    logger2 : { //logger of diffrent type (in this example it logs 3 values
instead of 1)
        timestamp1 : {
            v : 300,
            c : 123,
            s : 12.13
        },
        timestamp2 : {
            v : 300
            c : 123
            s : 12.13
        }
        (many many many more)
    }
    (many many many more)
}

the only way i will be accesing this data is:
- example: fetch slice of data from logger2 ( start = 1278009131 (timestmap)
, end = 1278109131 )
     expecting sorted array of data.
- example: fetch slice of data from (logger2 and logger10 and logger20 and
logger1234) ( start = 1278009131 (timestmap) , end = 1278109131 )
     expecting map of sorted arrays of data. [it is basically N queries of
first type]

is this right definition of above: <ColumnFamily CompareWith="TimeUUIDType"
ColumnType="Super"
    CompareSubcolumnsWith="BytesType" Name="loggers"/> ?

what's the best way to model this data in cassadra (keeping in mind
partitioning and other important stuff) ?

Mime
View raw message