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
Jay Vyas 2013-10-28, 15:55
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.