hbase-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From francesco.tangari....@gmail.com
Subject help with schema
Date Wed, 01 Feb 2012 07:51:19 GMT
Suppose i have a relationship 1 to N, for example 
Student , College. 
Student Attributes: 
Name,Surname,CollegeFKey,
College attributes:
CollegeKey,Other,Other.

Suppose that i have a program which read  students and Exams from a plain text file.
And  on this file i have duplicated Colleges and Duplicated Studens. 
Like in denormalized tabels:
CollegeId,Other,Other,Name,Surname,CollegeFkey.
1,x,y,Mike,M,1
1,x,y,R,P,1
...
...

you see i have to check in this case always that in my normalized db, i have still not inserted
in the Table College
2 times the key 1,   how can i solve this in Hbase ? i mean if i have 1000.. tables and rows
i dont want check
for every Primary Key  and then for every Fk if it was inserted ok ?
how can i solve that ? 
 


-- 
francesco.tangari.inf@gmail.com
Inviato con Sparrow (http://www.sparrowmailapp.com/?sig)


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