Re: Correct data model for Cassandra

2010-04-30 Thread Oleg Ivanov
Thanks Ellis, so the common scenario is to store data in one CF and any index (inverted?) in another CF? 2010/4/30 Jonathan Ellis > the correct data model is one where you can pull the data you want out > as a slice of a row, or (sometimes) as a slice of sequential rows. > usually this involv

Correct data model for Cassandra

2010-04-28 Thread Oleg Ivanov
Hello, our company has a huge table in a relational database which keeps statistics of some financional operations. It looks like the following: SERVER_ID - server, which served the transaction ACCOUNT_FROM - account1 ACCOUNT_TO - account2 HOUR - time range for this statistics row (from 0 minutes