hbase-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From SingoWong <singoch...@gmail.com>
Subject About HBase schema design
Date Sat, 15 May 2010 12:57:03 GMT
Hi,

I begin HBase schema design, but now i face some confused.

In RDBMS, my design is 3 tables:
*

Courses

id

pk

name

type


Students

id

pk

curses_id

fk => Courses.id

name

gender

age
*
*
*

In HBase, i think my design is

*row***

*Column families*

*Info:***

*Student_name:***

*Student_gender:*

<course_id>

Info:name

Student_name:<student_id>

Student_gender:<student_id>

Info:type



Is it my design correct?
but if design like this, when i want to find how many students under one
course, i dont know how to filter.
if i design as two table in hbase, is it normalization?

Thanks & Regards,
Singo

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message