describe relation between LDAP entries

Started by Rakotomandimby Mihaminaabout 16 years ago2 messagesgeneral
Jump to latest
#1Rakotomandimby Mihamina
mihamina@gulfsat.mg

Manao ahoana, Hello, Bonjour,

I have LDAP entries, and SQL tables are the relation between them.
There are only relations between 2 entries.

There are "modem" and "customers" entries in the LDAP directory

I need advice on optimizing the way I store relations.
For example (This is on MySQL, just for the example)

SELECT * FROM customer_has_modem;
+-----------------+----------------+
| customer | modem |
+-----------------+----------------+
| a=aa,b=bb,c=ccc | d=dd,e=ee,f=ff |
+-----------------+----------------+

Is it OK?

Have you another way to do it?
- splitting the comma separated fields?
- whatever?

There might later be be a "date" field in this table to trace the modem
movements.

Misaotra, Thanks, Merci.

--
Architecte Informatique chez Blueline/Gulfsat:
Administration Systeme, Recherche & Developpement
+261 34 29 155 34 / +261 33 11 207 36

#2Rakotomandimby Mihamina
mihamina@gulfsat.mg
In reply to: Rakotomandimby Mihamina (#1)
Re: describe relation between LDAP entries

Mihamina Rakotomandimby <mihamina@gulfsat.mg> :
Have you another way to do it?
- splitting the comma separated fields?

I mean:

customer_cn|customer_sn| customer_uid|modem_cn|modem_sn|modem_uid|
staff | (null) | (null) |staff | (null)| (null) |
Joe M | Mudd | joem |Joe M | Mudd | joem |

--
Architecte Informatique chez Blueline/Gulfsat:
Administration Systeme, Recherche & Developpement
+261 34 29 155 34 / +261 33 11 207 36