Silverton provides an excellent description of the domain. However, I found his models to be more complex than reality. The power of an excellent model is that it captures reality in a pragmatic and flexible format. Because I am not a database engineer I am looking for a real database implementation of the model (a simple schema that illustrates the tables and their relationships). So far the database modeling part of my question. The second part of question deals with object modeling: party, organization, person and their respective roles. For this part of my question I am looking for a concrete illustration like an UML diagram (classes and their relationships). Because I am planning to use Coldfusion I will use CFC's for this part (person.cfc, organization.cfc etc.). Both a databaseschema showing the tables and relationships or a UML model showing the classes, properties and asociations are welcome.
Best, Vinny -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of robi sen Sent: woensdag 11 februari 2004 21:21 To: [EMAIL PROTECTED] Subject: RE: [CFCDev] party people organization and roles Well I have implemented it. I don't know what you mean by CFC schema. There are several good things on the web that talk about implementations but how you abstract it into CFML with CFC's well I don't think you will find anything and I can show you what we did since its under NDA. Ill see if I can dig up the data model though.. the actual scheme which I think is in a word doc. Ill look -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kairoh! Sent: Wednesday, February 11, 2004 2:36 PM To: [EMAIL PROTECTED] Subject: RE: [CFCDev] party people organization and roles I have Len Silverston's Data Model Resource Book Vol 1. Indeed an excellent description but I am looking for a practical translation of this model into a concrete databaseschema and a CFC schema. Vinny -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of robi sen Sent: woensdag 11 februari 2004 19:46 To: [EMAIL PROTECTED] Subject: RE: [CFCDev] party people organization and roles Google the party model. If you have a Barnes close by or a large book store with a good tech section they should have The Data Model Resource Book Vol1 which has a excellent description and information on the party model. Here is the book on amazon <http://www.amazon.com/exec/obidos/tg/detail/-/0471380237/qid=1076525019 //ref=sr_8_xs_ap_i1_xgl14/002-6965015-2640063?v=glance&s=books&n=507846> . My understand is that you want to convert your model in to a schema and that should show it. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kairoh! Sent: Wednesday, February 11, 2004 1:11 PM To: [EMAIL PROTECTED] Subject: [CFCDev] party people organization and roles I am looking for the proper way to create a database combined with set of related CFC's that matches the complexity and flexibility of the interrelationships between people and organizations. There are person roles, organization roles and organization units. Furthermore, organizations as well as people can have several roles at the same time (subsidiary, customer, supplier, employer, manager etc.). I recently discovered the party-people-organization data model. This model provides the flexibility I am looking for. However, the problem I am facing now is how to translate this abstract model into a concrete set of CFC's and a concrete databaseschema that are easy to implement, flexible and realistic. I have been searching the archives, read some interesting discussions on related topics (roles, type of and extends), but could not find a concrete implementation of this datamodel. I am looking for a basic, pragmatic illustration of this model: a compact databaseschema (tables and relationships) and a basic schema of CFC's and their interrelatedness (UML model with basic properties and methods). Anybody out there who can switch the light on? Thanks for taking the time Vinny ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at www.mail-archive.com/[EMAIL PROTECTED] ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at www.mail-archive.com/[EMAIL PROTECTED] ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at www.mail-archive.com/[EMAIL PROTECTED] ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at www.mail-archive.com/[EMAIL PROTECTED] ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at www.mail-archive.com/[EMAIL PROTECTED]
