- From: Richard H. McCullough <rhm@pioneerca.com>
- Date: Fri, 21 Aug 2009 15:44:22 -0700
- To: "Jesse Wang" <JesseW@vulcan.com>, <semantic-web@w3.org>
mKR/mKE is a language/program [http://mkrmke.org/] which will serve your needs. User-defined methods give you full flexibility in defining your transformations. You can prototype using mKR, and implement any time-critical methods in Unicon [http://unicon.sourceforge.net/]. Dick McCullough http://mkrmke.org ----- Original Message ----- From: "Jesse Wang" <JesseW@vulcan.com> To: <semantic-web@w3.org> Sent: Wednesday, August 19, 2009 2:14 PM Subject: Ontology recommendation for Object-Relationship Mapping > Dear all - > > I am a beginner in ontology world, and I am looking for a good ontology > for general object relationship mapping, i.e., mapping properties/fields > in tables, forms, templates, or objects in general. By "good" I mean: it > is simple (relative to expressive power), easy to use, easy to understand, > and popular (say other people are using it or at least know something > about). I don't want to invent something of my own:). > > The user scenarios generally involves mapping between template or > form-generated objects. For example: > > Having a "Member" form and we want to define a mapping to > translate/transform it into a "Person" form. > > The fields in "Member" and "Person" will be different, containing a "Name" > (can be a whole field or separate fields such as First, Middle, Last names > etc.) and phone numbers (such as mobile, work, home phone numbers etc.) > and so on. > > I want to be able to map, say Person.FirstName + <space> + Person.LastName > ==> Member.(Full)Name, and Member.BusinessPhone ==> Person.DayTimePhone, > Member.HomePhone ==>Person.EveningPhone or "Person.PhoneList[1]", > Person.PhoneList[2] as an array. I also want to specify which fields are > optional vs. mandatory; and it'll be nice to support structure (hierarchy) > and meta-data mapping or conversion, say from a "Date" type to a > "DateTime" type conversion or to a "String" type coercion, and so on. One > thing I need or at least prefer is to support "functions" in converting, > mapping the fields, as in the example above of name, it can also be > parsing a full US address into separate components such as street, city, > state, postal code and so on... so the function is a mapping predicate in > this scenario. > > A more involved scenario will be the capability to specify some rules or > restrictions such as cardinality and/or priority to map fields, e.g., from > all phone numbers (i.e. a list of Person's phone numbers) to one phone > number, with priority fill the first non-empty number in a the list. But > this is only something nicer to have. > > I found > http://www.fedora-commons.org/definitions/1/0/fedora-relsext-ontology.rdfs > meets some of my requirements in that it describes the relationship > between objects, but it is more for _describing_ the relationship than > mapping or construction. OWL and RDFS to me only for describing too, at an > even more abstract and theoretic level to be useful. > > If you have any questions on why I need it and what I need do, please feel > free to ask me. > > Any tips or comments are appreciated. > > Jesse Wang > Vulcan Inc. > 505 5th Ave. S, Suite 900 > Seattle, WA 98104 > Direct Phone: (206) 342-2306 > Direct Fax: (206) 342-3306 > Mobile: (206) 295-6316 > > > > > > >
Received on Friday, 21 August 2009 22:45:57 UTC