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


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