[Date Prev][Date Next] [Chronological] [Thread] [Top]

Help with database structure



> Here's an imagined case, which corresponds to my real situation:
> 
> Florist gets flower deliveries all the time. He wants to store 
> information about flower packets in the LDAP database.
> The packets are labeled something like this:
> 
> packet for Smith:
> packet=weddind:roses=red,daisies=10,pinks=20,price=100
> 
> The thing is that LDAP should add new packet only if it differs from
> already stored
> ones. (let's say that price doesn't matter in matching)
> so how does he organize the database?? would it have to be something like
> this:
> 
> dn: packet=wedding:roses-red:daisies-10:pinks-20,sn=Smith
> price:100
> 
> dn: packet=funeral:roses-red:daisies-50,sn=Smith
> price:120
> .
> .
> 
> [or what ever characters are allowed in order to separate the objects??]
> 
> now before adding, he can operate 
> ldapsearch -b "packet=wedding:roses-red:daisies-10:pinks-20,sn=Smith"... 
> to check if packet already exists.. right?
> 
> Question:
> Can anyone think of any other reasonable way to organize the base?
> Is it possible to make just "sn=Smith" as dn and put packet objects as
> attributes and somehow still relate these attributes to a specific
> packet???
> (Also remembering the matching criteria- being able to look for a match
> with 
> only one ldapsearch.) 
> I would appreciate any suggestions. Thanks!
>