Hello all,<br><br>After having a talk with Maarten, a few emails with Laurence, seen the GLUE 1.3 LDAP implementation on <a href="http://lcg-bdii.cern.ch">lcg-bdii.cern.ch</a> and though about it thoroughly, I have come to the next idea for implementing Foreign Keys on LDAP:<br>

<br>Having an object ObjectA related to object ObjectB and being the relationship ObjectA 0..* - 0..* ObjectB,<br>- ObjectA will contain the attribute ObjectAObjectBFK pointing to ObjectB&#39;s DN<br>- ObjectB will contain the attribute ObjectBObjectAFK pointing to ObjectA&#39;s DN<br>

- In case the multiplicity was 1..X, with X between 1 and *, ObjectYObjectZFK will be mandatory<br>- In case the multiplicity was 1 or 0..1, ObjectYObjectZFK will be SINGLE-VALUE<br>- In case the relationship was Object A 0..* - 1 Object B, ObjectA will be the only one holding the ForeignKey<br>

<br>Since LDAP is not relational, there are a few pitfalls with LDAP:<br>- ObjectYObjectZFK is not checked to be the correct<br>- The duality ObjectAObjectBFK and ObjectBObjectAFK is not checked to have the relation stated in both directions<br>

- Moving between relations is done in the client and not the server, which is not optimal<br><br>These should be checked in an external client at appropriate invertals to ensure the integrity of the LDAP server plus all the specifcations done in GLUE 2.0 that can not be covered in LDAP (types, maximum range, etc.).<br>

<br>I would like to have an approval of 1 or 2 people before starting with it. So, do you like it this way? :)<br><br>Regards,<br>David<br clear="all"><br>-- <br>David Horat<br>Software Engineer specialized in Grid and Web technologies<br>

IT Department – Grid Deployment Group<br>CERN – European Organization for Nuclear Research » Where the web was born<br>Phone +41 22 76 77996<br><br><a href="http://davidhorat.com/">http://davidhorat.com/</a><br><a href="http://cern.ch/horat">http://cern.ch/horat</a><br>

<a href="http://www.linkedin.com/in/davidhorat">http://www.linkedin.com/in/davidhorat</a><br>