- From: Chamindra de Silva <chamindra@opensource.lk>
- Date: Thu, 7 Aug 2008 16:13:50 +0530
- To: "Mandana Sotoodeh" <mandanas@ece.ubc.ca>
- Cc: public-xg-eiif <public-xg-eiif@w3.org>
- Message-ID: <20eab7c50808070343t50ce2e99qf23b472ac12b3f30@mail.gmail.com>
Hi Mandana, Sorry for my delay sending this. But here is the Sahana schema filtered by the tables relevant to the Sahana 3W (called Organization Registry in the system). I attach the well commented SQL script file and I hope this is OK to work with. If you need to get more information on how the data work in Sahana I can recommend the demo site at http://demo.sahana.lk. Let me know if you need it in another format. On Mon, Aug 4, 2008 at 12:56 PM, Mandana Sotoodeh <mandanas@ece.ubc.ca>wrote: > Paola and all, > > Sounds like in OCHA schema, Organization is more of a conceptual entity > than physical entity (ie physically located). Offices are the ones involved > directly in the activities and indirectly link OrgPerson to the > organization. However we should consider the situations where local agencies > help with response activities, for example, or where volunteers are part of > the task force. Offices work in general sectors (ie provide general > services) but they have specific responsibilities in the context of a given > activities. I agree that some naming don't represent the concepts very > well. It would be more helpful, if you could be more specific. As we get > other schemas, we will refine the concepts too. > > Regards, > Mandana > > > > *From:* paola.dimaio@gmail.com > *Sent:* Friday, August 01, 2008 8:03 PM > *To:* Mandana Sotoodeh <mandanas@ece.ubc.ca> > *Cc:* public-xg-eiif <public-xg-eiif@w3.org> > *Subject:* Re: Requirement for 3W interop standard > > Mandana, Paolo > > Great great thanks for starting this up, it looks like there are some > conceptual challenges ahead > > I am looking at the diagram on the fly (did not study in depth), and have a > few questions > > 1. I can see no link between organisation and orgperson, should there be a > relationship there? I am not sure if orgperson main relation should be > office, sound weak > > 2. does Location not have any attributes? should there be something written > in the box > > 3. service links to orgperson with relationship -hasobjectives- not sure I > understand, a few other relations seem brittle > > 4. I wonder if there is a rule as to how to name in the singular/plural the > entities and the relationships and attributes (sing or plu, should be > constant?), as well as the choice of names for them, if should be made more > logical and consistent as much as possible > I wonder if the relationships whould have names more semantically alighed > with the entities they relate to, less ambiguous kind of thing > > will study further > > thanks again > > best > > PDM > > > On Fri, Aug 1, 2008 at 6:54 PM, Mandana Sotoodeh <mandanas@ece.ubc.ca>wrote: > >> Hello everyone, >> >> Please find the main concepts derived from OCHA schema here: >> >> http://www.w3.org/2005/Incubator/eiif/wiki/images/7/71/W3-Model.pdf >> >> Renato kindly organized them graphically. >> >> Paolo, thank you for providing the documents. >> >> Your feedback is appreciated: if you have any specific scenario in >> mind (in the boundary of W3) that you think the model may not address well; >> such as volunteers or activities for day to day emergency operations (like >> drug abuse) as opposed to emergency response (like evacuation), or any >> suggestions for naming of concepts (ex. office or emergency). As we get >> other schemas/models, we will revise it accordingly. >> >> Thanks very much, >> >> Mandana >> >> >> >> *From:* Renato Iannella <renato@nicta.com.au> >> *Sent:* Wednesday, July 09, 2008 4:29 PM >> *To:* public-xg-eiif <public-xg-eiif@w3.org> >> *Cc:* Vincent Lalieu <lalieu@un.org> >> *Subject:* Re: Requirement for 3W interop standard >> >> >> On 9 Jul 2008, at 18:46, Paul Currion wrote: >> >> The 3W / W3 schema can be found at >> http://www.humanitarianinfo.org/imtoolbox/02_Standard_Products/01_W3/3W_Tool/3wSchema2_0.pdf >> >> >> Thanks Paul. >> This is a good opportunity to review the Use Case [1] against the OCHA >> Schema and determine any gaps. >> Then look at the outcome and move towards defining the *core8 elements of >> a W3/3W "standard". >> Any volunteers to take this on? >> >> Cheers... Renato Iannella >> NICTA >> >> [1] <http://www.w3.org/2005/Incubator/eiif/wiki/WWWWCoord> >> >> > > > -- > Paola Di Maio > School of IT > www.mfu.ac.th > ********************************************* >
Attachments
- text/x-sql attachment: sahana-3w-person-schema.sql
Received on Thursday, 7 August 2008 10:44:30 UTC