Hey,
If my data is relational (publishers-authors-books, associations-teams-players), can we use NoSQL system like HBase or MongoDB to store the data?
(I know it may sound like a stupid question but I'm just learning :))
+2
A:
Yes, you can store any type of data in NoSQL datastores. The kind of information you describe should be very adequate for NoSQL.
However, be aware that in a typical NoSQL solution, you would be trading some/many features that are taken for granted in SQL databases, such as transactions, strong consistency, rich queries, ad-hoc queries, etc, mainly in favour of simpler models that can scale horizontally very easily.
Daniel Vassallo
2010-09-18 03:29:25
Currently I'm reading about HBase, I'm not sure how to create a relationship between rows (a team and a player for example).
El Gusto
2010-09-18 03:38:11
@El: No experience with HBase, but it is typical in NoSQL solutions that you have no relationships between "tables". It's a completely different paradigm from the relational model.
Daniel Vassallo
2010-09-18 03:53:15
+1
A:
One of the Digg engineers working on Cassandra (another NoSQL solution) wrote a very good post about data models and NoSQL (specifically Cassandra).
This may help you start thinking in column oriented data structures.
Stephen Holiday
2010-09-22 00:42:15