Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
HBase >> mail # user >> HBASE help


Copy link to this message
-
Re: HBASE help
w.r.t. virtual meetup, there is Strata / Hadoop World this week.
So some people wouldn't be able to make it.
On Mon, Oct 28, 2013 at 8:55 AM, Jay Vyas <[EMAIL PROTECTED]> wrote:

> I'm actually trying to do the same thing, and your data model is a great
> starting place.
>
> I would like to do a Google hangout to discuss this .
>
> Anyone else in the hbase community willing to do a virtual meetup to go
> though relational to multimap based storage and lookup in hbase?
>
> > On Oct 28, 2013, at 1:42 AM, saiprabhur <[EMAIL PROTECTED]> wrote:
> >
> > Hi Folks,
> >
> > New to NOSQL designing data model for primary care system. i have
> normalized
> > sample DB relationship model e.g. HBASE-0.94.0
> >
> > Patient table:
> > ===========> > 1) Patient_id - PK
> > 2) Added_BY
> > 3) Gender
> > 4) Usual_GP
> >
> > Patient Name table: [One to many relationship with patient [One]
> Name[Many]]
> > 1) Name_id
> > 2) Patient_id - FK
> > 3) Name_type
> > 4) First name
> > 5) Last Name
> > 6) Middle name
> >
> > Patient address table: [One to many relationship with patient [One]
> > address[Many]]
> > 1) Address_id
> > 2) Patient_id - FK
> > 3) Address_type
> > 4) Line1
> > 5) Line2
> > 6) Line 3
> > 7) Line 4
> > 8) Line 5
> >
> > Patient Phone table: [One to many relationship with patient [One]
> > Phone[Many]]
> > 1) Phone_id
> > 2) Patient_id - FK
> > 3) PhoneType
> > 4) Phoneno
> > 5) ext
> >
> > Medication and other details
> > 1)Entry_id
> > 2)Patient_id - FK [One to many relationship with patient [One]
> > Medication[Many]]
> > 3)Start_date
> > 4)End_date
> > 5)Code
> > 6)Medicine description
> > 7)Dosage details
> > 8) Number of authorised
> > 9) Number issued
> >
> > For above Normalised data model i have created sample NoSQL data model
> > below, i Hope data model works for Document base NOSQL. Need to convert
> > below Data model in to HBASE column based data model, pls help me.
> >
> > Patient :{Patient_id:22,
> >          Added_by:Doctor1,
> >          Gender:Male,
> >          UsualGP: Doctor2,
> >          PatName:[
> >          {NameType:Usual, FirstName:Hari, LastName:prasad,Middlename:'
> '},
> >          {NameType:Other,
> FirstName:John,LastName:prasad,Middlename:kenndy}
> >          ]
> >          PatAddr:[
> >          {AddType:Usual, Line1:2, Line2:Harrington road, Line3: near
> central,
> > Line4:Newyork,Line5:NY008},
> >          {AddType:Tmp, Line1:2, Line2:Mylapore road, Line3: near Zoo,
> > Line4:WashingtonDC,Line5:WA00098}
> >          ]
> >          PatPhone:[
> >          {PhoneType:Usual, Phoneno:4453443344, ext:099},
> >          {PhoneType:Tmp, Phoneno:9198332342343, ext:}
> >          ]
> >          PatMedication:[
> >          {MedStardate:'01/01/2013', MedEndDate:'', Code:'Snomode',
> > MedDesc:'Paracetmol', DosDet:'Take 2 daily', Noauth: 5, Issue: 3},
> >          {MedStardate:'01/05/2013', MedEndDate:'01/05/2013',
> Code:'readcode',
> > MedDesc:'Avil', DosDet:'Take 1 daily', Noauth: 3, Issue: 1},
> >          {MedStardate:'01/10/2013', MedEndDate:'24/10/13',
> Code:'readcode',
> > MedDesc:'Metacin', DosDet:'Take 2 daily', Noauth: 5, Issue: 3},
> >          ]
> >         }
> >
> >
> >
> > --
> > View this message in context:
> http://apache-hbase.679495.n3.nabble.com/HBASE-help-tp4052238.html
> > Sent from the HBase User mailing list archive at Nabble.com.
>