I am trying to find out if Cassandra will fill my needs.
I have a data model similar to below.
Users = {
//ColumnFamily
user1 = {
//Key for Users ColumnFamily
message1 = {
//Supercolumn
text: hello
//Column
type: html
//Column
rating: 88
//Column
}
...
messageN
}
...
CountryN
}
Imagine there can be billions of users and hundreds of thousands of messages
per user.
After a message entry it will not be updated.
I want to do queries such as:
* Get all messages for user1 with type = HTML
* Get top 100 message for user1, order by rating.
1) Is this possible with cassandra?
2) Do I have the right datamodel? Can it be optimized?
