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 sonalgoyal4@gmail.com
 designates 209.85.223.174 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAHxBGfKKdHK4hmH==cUDAgh+ZrvazKy4gaKYTrfTSH9WKm+DBA@mail.gmail.com>
References: 
 <CAHxBGfKChL_8wAfeS9MNx9PjZjfiAK5Od7uiDSRjDYf5d1M5oQ@mail.gmail.com>
	<CAKTawb+Rb9kGEyfQPZ08BDtZm_EYpSeKhCrZ=1ae6qujtp-pbQ@mail.gmail.com>
	<CAHxBGfKKdHK4hmH==cUDAgh+ZrvazKy4gaKYTrfTSH9WKm+DBA@mail.gmail.com>
Date: Fri, 18 Jan 2013 10:00:45 +0530
Message-ID: 
 <CAKTawbJ_jTkMsZ+MUDBQXBbM95TX7NrjaA=o9wvnVnV5Sqf4PQ@mail.gmail.com>
Subject: Re: How to de-nomarlize for this situation in HBASE Table
From: Sonal Goyal <sonalgoyal4@gmail.com>
To: user@hbase.apache.org
Content-Type: multipart/alternative; boundary=e89a8f839ca138a8f304d3889380

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

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
> > >
> >
>

--e89a8f839ca138a8f304d3889380--