Mailing-List: contact user-help@hbase.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hbase.apache.org
Received-SPF: pass (athena.apache.org: domain of
 ramasubramanian.narayanan@gmail.com designates 209.85.223.171 as permitted
 sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAKTawbJ_jTkMsZ+MUDBQXBbM95TX7NrjaA=o9wvnVnV5Sqf4PQ@mail.gmail.com>
References: 
 <CAHxBGfKChL_8wAfeS9MNx9PjZjfiAK5Od7uiDSRjDYf5d1M5oQ@mail.gmail.com>
	<CAKTawb+Rb9kGEyfQPZ08BDtZm_EYpSeKhCrZ=1ae6qujtp-pbQ@mail.gmail.com>
	<CAHxBGfKKdHK4hmH==cUDAgh+ZrvazKy4gaKYTrfTSH9WKm+DBA@mail.gmail.com>
	<CAKTawbJ_jTkMsZ+MUDBQXBbM95TX7NrjaA=o9wvnVnV5Sqf4PQ@mail.gmail.com>
Date: Fri, 18 Jan 2013 10:09:30 +0530
Message-ID: 
 <CAHxBGfKJ9_UGz7YZR0RxufbcDxqOj=E7k3DDO62Kx7MCgmvH_Q@mail.gmail.com>
Subject: Re: How to de-nomarlize for this situation in HBASE Table
From: Ramasubramanian Narayanan <ramasubramanian.narayanan@gmail.com>
To: user@hbase.apache.org
Content-Type: multipart/alternative; boundary=e89a8f2347cf86e1e604d388b2e8

--e89a8f2347cf86e1e604d388b2e8
Content-Type: text/plain; charset=ISO-8859-1

Hi Sonal,

In that case, the problem is how to store multiple physical address sets in
the same column family.. what rowkey to be used for this scenario..

A Physical address will contain the following fields (need to store
multiple physical address like this):
Physical address type : Home/office/other/etc
Address line1:
..
..
Address line 4:
State :
City:
Country:

regards,
Rams


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

> How about client id as the rowkey, with column families as physical
> address, email address, telephone address? within each cf, you could have
> various qualifiers. For eg in physical address, you could have home Street,
> office street etc.
>
> 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:46 AM, Ramasubramanian Narayanan <
> ramasubramanian.narayanan@gmail.com> wrote:
>
> > 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
> > > >
> > >
> >
>

--e89a8f2347cf86e1e604d388b2e8--