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 <sonalgoy...@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.naraya...@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 > > >