hbase-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sean Bigdatafun <sean.bigdata...@gmail.com>
Subject Re: Schema Design
Date Tue, 28 Dec 2010 23:38:24 GMT
1. customer_table:
row_key --> column_family : (customer --> contract)

An example row,
row_key   ||  CF: Contract
---------------------------------------------------------------------
valter        || 'C11' | info_for_11 | 'C12' | info_for_12
----------------------------------------------------------------------


2. contract_table:
row_key --> column_family (contract_id --> installment)

An example row,
row_key   ||  CF: Installment
-----------------------------------------------------------------------------------------
C11           || 'I_1001' | info_for_1001 | 'I_1002' | info_for_1002
----------------------------------------------------------------------------------------


On Tue, Dec 28, 2010 at 3:26 PM, Valter Nogueira <vgnogueira@gmail.com>wrote:

> I have a small JAVA system using relational database.
>
> Basically, the app have 3 entities: CUSTOMER has many CONTRACTs and each
> CONTRACT has many INSTALLMENTS
>
> Very classic.
>
> I am figuring out what is the best approach to convert it to HBASE.
>
> One way is to create a schema that mimics the relational schema.
>
> Other is saving INSTALLMENTS into the CONTRACT table.
>
> I would like some advice on doing this.
>
> Thanks,
>
> Valter
>



-- 
--Sean

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