Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

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


Copy link to this message
-
Re: HBASE help
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.
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB