hbase-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ted Yu <yuzhih...@gmail.com>
Subject Re: Newbie question concerning schema design
Date Sat, 19 Mar 2011 16:30:58 GMT
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
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message