Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
HBase >> mail # user >> How to de-nomarlize for this situation in HBASE Table


Copy link to this message
-
Re: How to de-nomarlize for this situation in HBASE Table
What are your data access patterns?

Best Regards,
Sonal
Real Time Analytics for BigData <https://github.com/sonalgoyal/crux>
Nube Technologies <http://www.nubetech.co>

<http://in.linkedin.com/in/sonalgoyal>
On Fri, Jan 18, 2013 at 9:04 AM, Ramasubramanian Narayanan <
[EMAIL PROTECTED]> wrote:

> Hi,
>
> I have the following relational tables.. I want to denormalize and bring it
> all into single HBASE table... Pls help how it could be done..
>
>
> 1. Client Master Table
> 2. Physical Address Table (there might be 'n' number of address that can be
> captured against each client ID)
> 3. Email Address Table (there might be 'n' number of address that can be
> captured against each client ID)
> 4. Telephone Address Table (there might be 'n' number of address that can
> be captured against each client ID)
>
>
> For the tables 2 to 4, there are multiple fields like which is the Address
> type (home/office,etc), bad address, good address, communication address,
> time to call etc.,
>
> Please help me to clarify the following :
>
> 1. Whether we can bring this to a single HBASE table?
> 2. Having fields like phone number1, phone number 2 etc. is not an good
> approach for this scenario...
> 3. Whether we can have in the same table by populating these multiple rows
> for the same customer with different rowkey?
>    For e.g.
>    For Client Records      - Rowkey can be Client Number + DOB
>    For Physical Address  - Rowkey can be Client Number + "PHYSICAL" + Type
> of Address
>    For Email Address      - Rowkey can be Client Number + "EMAIL" + Type of
> Address
>    For Telephone Address      - Rowkey can be Client Number + "TEL" + Type
> of Address
>
> regards,
> Rams
>
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB