hbase-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Stack <st...@duboce.net>
Subject Re: Newbie question concerning schema design
Date Sat, 19 Mar 2011 18:46:50 GMT
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 <yuzhihong@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.nuyttens@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
>>
>>
>

Mime
View raw message