NewB Qs: Classification advice please + many2many relationships
Hi Coming from the Java / RDMS world, I'm not sure how best to lay out my new project in Zope. I have Events, and Businesses, both of which have a hierarchy of types (e.g. Events/Entertainment/Films and Business/Entertainment/Theatre, etc.) The events have venues, which are instances of Businesses. My question is: how should I classify my objects, and once I've done that, how do I maintain many-to-many relationships, e.g. all the Events happening at Business X? Any suggestions would be greatly appreciated. Thanks Felix. ____________________________________________________________ Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie
=?iso-8859-1?q?Felix=20Ulrich?= writes:
My question is: how should I classify my objects, and once I've done that, how do I maintain many-to-many relationships, e.g. all the Events happening at Business X? I can not answer your first question.
But the second is simple. Many-to-many relationsships are a bit difficult in RDB because the data types are all atomic, no lists or other aggregates (this changed with SQL 3). In Zope, you can have list valued properties. I would use any of the list value property types (tokens, list) to make the classification. Then I would use a ZCatalog's keyword index to search for related objects based on this classification. Dieter
participants (2)
-
Dieter Maurer -
Felix Ulrich