See: http://search-hadoop.com/m/zbKmE14o0Js/wide+tall+hbase+table&subj=Re+Parent+child+relation+go+vertical+horizontal+or+many+tables+
You can also search for related discussion on tall vs. wide tables. On Sat, Mar 19, 2011 at 8:53 AM, Niels Nuyttens <niels.nuytt...@gmail.com>wrote: > Hi all, > > I'm need a database scaled for large datasets and high throughput. HBase > seemed like the way to go. However, while designing my database schema I > started to doubt my choice, due to the conversion of the current > relational schema to a NoSQL variant. I can't get my head around the > efficient implementation of many-to-many relations. > > For example: Users and Roles. How would you model that for HBase. I was > thinking about storing associated roles in a column of a user row, and > vice versa. > > Furthermore there are lots of one-to-many relations that also need > converting. > > So, in conclusion, my question is: is it possible to convert a > relation-oriented schema to a nosql one? If so, how can this modeling be > done efficiently? > > Lots of thanks, > > Niels > >
