atom feed8 messages in com.freebase.data-modelingRe: [Data-modeling] Organization type...
FromSent OnAttachments
robert cookSep 27, 2007 12:42 am 
Paul LindnerSep 27, 2007 4:01 am 
Jeff PrucherSep 27, 2007 10:28 am 
Robert CookSep 27, 2007 12:00 pm 
Jeff FrySep 27, 2007 5:51 pm 
Kirrily RobertSep 27, 2007 6:08 pm 
Robert CookSep 29, 2007 1:09 pm 
Jeff PrucherOct 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.

marklogic user conference