Hi! I'm studying Computer Science and I am italian. Actually I'm new to the NoSQL world, have a little experience with Google App Engine (DataStore/BigTable) and MongoDB… I need to create a social network website for the university. Well, only the data model scheme. A little one, of course. Nothing serious. The thing is, when someone visits the profile of other people, I need to register that. I thought about modelling it like this:
Track - datetime: [as the key] - visited_profile_id: - visitor_id: tracks: [{date_time: '', visited_profile_id: 1, visitor_id: 2}, {date_time: '', visited_profile_id: 2, visitor_id: 2}, {date_time: '', visited_profile_id: 3, visitor_id: 2}] But it seemed very RDMS. I thought then about: Profile - visitors: [a collection of keys] profile: { visitors: [1, 2, 3], name: "Thiago", bio: "...", id: 10 } It seemed more reasonable. But in the frontend sometimes I need to list all the profiles I've visited, sometimes all the users that visited mine. Should I then do something like: Profile - visitors: [collection of keys] // the profiles that visited me - visited: [collection of keys] // the profiles I visited profile: { visitors: [1, 2, 3], visited: [11, 15], name: "Thiago", bio: "...", id: 10 } So at the end it's like my first idea. What's the best way to do that? Thank you for your help! Thiago. -- You received this message because you are subscribed to the Google Groups "Google App Engine for Java" group. To post to this group, send email to google-appengine-java@googlegroups.com. To unsubscribe from this group, send email to google-appengine-java+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/google-appengine-java?hl=en.