hbase-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ramasubramanian Narayanan <ramasubramanian.naraya...@gmail.com>
Subject Re: How to de-nomarlize for this situation in HBASE Table
Date Fri, 18 Jan 2013 04:16:42 GMT
Hi Sonal,

1. will fetch all demographic details of customer based on client ID
2. Fetch the particular type of address along with other demographic for a
client.. for example, HOME Physical address or HOME Telephone address or
office Email address etc.,

regards,
Rams

On Fri, Jan 18, 2013 at 9:29 AM, Sonal Goyal <sonalgoyal4@gmail.com> wrote:

> 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 <
> ramasubramanian.narayanan@gmail.com> 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
> >
>

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