incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From JKnight JKnight <beukni...@gmail.com>
Subject Best practice with Column
Date Tue, 08 Dec 2009 07:42:50 GMT
Dear all,

I have a lot data with the same key.
Ex,
Contact{
    userId{
        "tel":...,
        "phone": ...
    }

Info{
    userId{
        "birthday": ...,
        "sex":...,
        "nationality": ...
    }
}

Address{
    userId{
        "street": ...,
        "address": ...,
        "city": ...,
        "province": ...
    }
}

We have 2 way to design Data data model:
1- Use 3 Column Family
<ColumnFamily CompareWith="" Name="Contact"/>
<ColumnFamily CompareWith="" Name="Address"/>
<ColumnFamily CompareWith="" Name="Info"/>

2- Use 1 super Column Family:
<ColumnFamily CompareWith="" Name="User" ColumnType="Super"
CompareSubcolumnWidth=""/>

Which one is better?

Thank a lot for support.
-- 
Best regards,
JKnight

Mime
View raw message