Mailing-List: contact user-help@hbase.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hbase.apache.org
Received-SPF: softfail (athena.apache.org: transitioning domain of
 saiprabhur@gmail.com does not designate 216.139.236.26 as permitted sender)
Date: Sun, 27 Oct 2013 22:42:30 -0700 (PDT)
From: saiprabhur <saiprabhur@gmail.com>
To: user@hbase.apache.org
Message-ID: <1382938950272-4052238.post@n3.nabble.com>
Subject: HBASE help
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

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.