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 Plain View
HBase >> mail # user >> HBASE help


+
saiprabhur 2013-10-28, 05:42
+
Asaf Mesika 2013-10-28, 17:34
+
James Taylor 2013-10-28, 15:57
+
Jay Vyas 2013-10-28, 15:55
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.
>
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