hbase-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Asaf Mesika <asaf.mes...@gmail.com>
Subject Re: HBASE help
Date Mon, 28 Oct 2013 17:34:56 GMT
How much data do you that you need NoSQL db?

On Monday, October 28, 2013, saiprabhur 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.
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message