| From | Sent On | Attachments |
|---|---|---|
| robert cook | Sep 27, 2007 12:42 am | |
| Paul Lindner | Sep 27, 2007 4:01 am | |
| Jeff Prucher | Sep 27, 2007 10:28 am | |
| Robert Cook | Sep 27, 2007 12:00 pm | |
| Jeff Fry | Sep 27, 2007 5:51 pm | |
| Kirrily Robert | Sep 27, 2007 6:08 pm | |
| Robert Cook | Sep 29, 2007 1:09 pm | |
| Jeff Prucher | Oct 1, 2007 10:16 am |
| Subject: | Re: [Data-modeling] Organization type question | |
|---|---|---|
| From: | Paul Lindner (lind...@inuus.com) | |
| Date: | Sep 27, 2007 4:01:37 am | |
| List: | com.freebase.data-modeling | |
On Thu, Sep 27, 2007 at 12:43:08AM -0700, robert cook wrote:
Once I was made aware of the requests, I took a look at the organization type. I first added the "date founded" and "date dissolved" properties which are uncontroversial.
Ah, very nice!
Paul said:
I'd also like to identify leaders of organizations based on terms. I'm placing UN agencies here and would like to say, identify the secretary general of various orgs..
Right now there is a property called "key people" in the organization type which directly links to type /people/person. Paul's request is a reasonable one -- that this shouldn't be a direct relationship between organizations and people, but a mediated one that holds the position title and the beginning and end dates of the term.
This matches exactly the pattern we use for the /business/employer type which can be used as a co-type for companies, universities or any other topic that employes people. Type /business/employer expects a CVT (mediator) of type "employment tenure", which includes properties for "employee", "job title", "start date" and "end date".
One obvious choice would be to co-type any organization with "employer" and fill in the key people under the "employees" property along with their title/position and begin and end dates.
However, many people in organizations are not employees. Is there a key distinction in organizations between employees and volunteers? Should they get separate properties? Or should there be a property called "unpaid personnel" or "volunteers" that points to a CVT with person, position/title, start date and end date (that looks just like the "employment tenure" CVT)?
So the proposal might be: if the organization has employees, co-type it with employer and use the "employees" property just like you would with a company. If the organization has volunteers, you put them into a "volunteers" property that's part of the organization type.
Ah, the joys of data modeling! So much to balance, so little time. Remember: simpler is better. Lump by default, split only when necessary.
I think the Employer/Employee relationship makes sense for almost all Organizations. I'm not sure about Volunteer as a type -- it's an employee relationship without compensation.
For the organizations I was looking at one might consider the test type 'Governmental Body'. This would be a good fit for UN Organizations, NGOs, Trade Unions, etc. This might allow for crossover with types in the Politics/Government area.
I used the Governmental Body type on the ITU
http://www.freebase.com/view/international_telecommunication_union
and it fits well.
-- Paul Lindner ||||| | | | | | | | | | lind...@inuus.com






