There is also this small section in our book: http://hbase.apache.org/book/schema.html It refers to a useful paper by Ian Varley on modelling in non-rdbms dbs. Sounds like it would be good preparatory reading for the project you've just started.
St.Ack On Sat, Mar 19, 2011 at 9:30 AM, Ted Yu <yuzhih...@gmail.com> wrote: > 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 >> >> >
