[Date Prev][Date Next]
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:
> 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
> dn: packet=wedding:roses-red:daisies-10:pinks-20,sn=Smith
> dn: packet=funeral:roses-red:daisies-50,sn=Smith
> [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?
> 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
> (Also remembering the matching criteria- being able to look for a match
> only one ldapsearch.)
> I would appreciate any suggestions. Thanks!