Problematic :
Starting with Datafari 2.0, users have the possibility to store pointers to documents shown in results list.
In the following document, “likes” corresponds to the functionality where a connected user can like or unlike a document, and “favorites” corresponds to the functionality where a connected user can save a pointer to a document he found in the results list.
Technically wise, we use Apache Cassandra for saving all the likes and favorites and Solr for saving the counters of likes of each document.
Using Cassandra, we cannot use standard relational db schemas, like the following:
Modeling with Nosql in mind:
For our nosql modeling, we took our inspiration from this article http://docs.mongodb.org/manual/tutorial/aggregation-with-user-preference-data/ .
Applied to our problematic, we get the following :
That means we have dedicated to likes and favorites (which is distinct from the collection dedicated to user authentication and authorization).