Since HBase can have as many columns per row as you want, the need to go with a different table is not there, you can just put the 'children' in the row of the parent.
-ryan On Fri, Aug 20, 2010 at 4:46 AM, Shuja Rehman <[email protected]> wrote: > Hi All > > I am new to HBase and I have one question which can be best described by the > following scenario. > > Suppose I have three tables BaseCategory,Category and products. If i am > thinking in terms of RDBMS then the relationship amoung these tables are > > 1- One BaseCategory has Many categories > > 2- One Category has Many Products. > > Now i am thinking to convert it into HBase. can anybody help me how to map > these relations into HBase? I am thinking about this schema but not sure my > direction is right. > > > *Row Key* > > *Column Families* > > Base Category ID > > Base Category Info: > > Categories: > > > > Base Category Info:Name > > Base Category Info:Description > > Categories:catName > > > > > > > > > > > > > > *Row Key* > > *Column Families* > > Category Name > > Category Info: > > Product: > > > > Category Info:Name > > Category Info:Description > > Prodcut:Name > > Prodcut:Quantity > > Prodcut:Price > > > > > > > > > > > > > > > -- > Regards > Shuja-ur-Rehman Baig > http://pk.linkedin.com/in/shujamughal > Cell: +92 3214207445 >
