How to model mongodb collections for Cassandra database (migration)? <p>I am new to Cassandra and trying migrate my App from MongoDB to Cassandra</p> <p>I have the following collections in MongoDB</p> <pre><code>PhotoAlbums [ {id: oid1, title:t1, auth: author1, tags: ['bob', 'fun'], photos: [pid1, pid2], views:200 } {id: oid2, title:t2, auth: author2, tags: ['job', 'fun'], photos: [pid3, pid4], views: 300 } {id: oid3, title:t3, auth: author3, tags: ['rob', 'fun'], photos: [pid2, pid4], views: 400 } .... ] Photos [ {id: pid1, cap:t1, auth: author1, path:p1, tags: ['bob','fun'], comments:40, views:2000, likes:0 } {id: pid2, cap:t2, auth: author2, path:p2, tags: ['job','fun'], comments:50, views:50, likes:1, liker:[bob] } {id: pid3, cap:t3, auth: author3, path:p3, tags: ['rob','fun'], comments:60, views: 6000, likes: 0 } ... ] Comments [ {id: oid1, photo_id: pid1, commenter: bob, text: photo is cool, likes: 1, likers: [john], replies: [{rep1}, {rep2}]} {id: oid2, photo_id: pid1, commenter: bob, text: photo is nice, likes: 1, likers: [john], replies: [{rep1}, {rep2}]} {id: oid3, photo_id: pid2, commenter: bob, text: photo is ok, likes: 2, likers: [john, bob], replies: [{rep1}]} ] </code></pre> <p><strong>Queries:</strong></p> <ul> <li><p>Query 1: Show a list of popular albums (based on number of likes)</p></li> <li><p>Query 2: Show a list of most discussed albums (based on number of comments) </p></li> <li><p>Query 3: Show a list of all albums of a given author on user's page </p></li> <li><p>Query 4: Show the album with all photos and all comments (pull album details, show photo thumbnails of all photos in the album, show all comments of selected photo </p></li> <li><p>Query 5: Show a list of related albums based on the tags of current album</p></li> </ul> <p><strong>Given the above schema and requirements, how should I model this in Cassandra?</strong></p>