ontolog-forum
[Top] [All Lists]

Re: [ontolog-forum] Ontology-based database integration

To: "'[ontolog-forum] '" <ontolog-forum@xxxxxxxxxxxxxxxx>
From: "Ian Bailey" <ian@xxxxxxxxxxxxxxxx>
Date: Thu, 22 Oct 2009 09:25:34 +0100
Message-id: <000901ca52f1$3b62d810$b2288830$@com>
Hi Erick,    (01)

I can think of a couple of projects, and I think Chris Partridge has some
examples from the financial industries also.      (02)

One involved an oil company (a big one !) that I'm not allowed to name, but
the chap who ran the project follows this forum, so I expect he'll contact
you offline. The project had two threads - one was around having a common
foundation for all the data models across their downstream business. The
other was an implementation to integrate the dictionaries of various ERP
systems.    (03)

The other project I can think of is much smaller, but interesting
nonetheless. An issue emerged about country codes and identifiers in NATO -
it seems NATO has three different country codifications (STANAG 1059, MOE,
and another I can't remember the name of). Only the 1059 STANAG is similar
to the ISO 3166 standard, but even then is only 80% common. On top of this,
there are three ISO3166 identifiers (number, two letter, three letter) and
the US Federal FIPS-10 spec (which is still in use - e.g. in the CIA World
Factbook). There was also the issue that each of the NATO countries used
different languages. So...we used the naming pattern from IDEAS
(www.ideasgroup.org) to re-engineer all this data into a structure of
geopolitical areas, and their various names - object-space and name-space in
philosopher-speak. We also pulled in some data around shared borders. The
combined data set provides a means for de-conflicting country codes and
descriptions between nations. There is a limited demo of this at:    (04)

http://www.modaf.com/file_download/37/OntoDemo.zip    (05)

It's a Quick&Dirty demo (the whole thing, implementation and data
integration took less than 20 days), and there are some errors in the
structure. The Google-Maps integration is a bit flaky too, as Google seems
to assume every place is in the USA, even if you tell it it's not. It runs
on a PC-Windows platform, and we implemented the ontology in (gasp!) MS
Access, so you'll need to install their (free) JET engine if you don't have
Access. There are some slides on this also at:    (06)

http://www.ideasgroup.org/file_download/3/MOD+Ontology.pdf%3E%3Cspan%20class
=    (07)

PS - before the tirade starts about a) how we couldn't possibly be doing
ontology if we used an RDBMS and b) how dare we use something that isn't
open source, I will clarify. First of all, we only hard-code the foundation
of the ontology in the database tables (i.e. the top-level ontic categories)
this allows us to build whatever ontology we like without ever having to
rebuild the database or re-compile code in the API. Secondly, Access is
ubiquitous in companies and Govt. Love it or hate it, there's a better
chance of a user being to install it on their locked-down work PC than MySQL
(or similar). Also, for single-user applications Access is pretty fast.
We're working on a FireBird SQL version of the engine at the moment, but
it's taking a while.    (08)

Cheers
--
Ian    (09)

-----Original Message-----
From: ontolog-forum-bounces@xxxxxxxxxxxxxxxx
[mailto:ontolog-forum-bounces@xxxxxxxxxxxxxxxx] On Behalf Of Erick Antezana
Sent: 22 October 2009 08:01
To: [ontolog-forum]
Subject: Re: [ontolog-forum] Ontology-based database integration    (010)

Hi,    (011)

  I have been trying to follow this thread (Ontology-based database
integration) so that I could find some pointers towards examples of
data that have been ("successfully") integrated using ontologies
and/or software solutions (e.g. DBMSs, integrated solutions such as
ONTOTEXT [1], ...). I am in particular interested in biological data
integration, nonetheless, having a few examples in any field would be
nice to have. Any suggestions?    (012)

thanks.
Erick
[1] http://www.ontotext.com/    (013)


2009/10/22 John F. Sowa <sowa@xxxxxxxxxxx>:
> Rich,
>
> Wittgenstein was opening up a way of looking at language that was
> radically different from the way logicians and linguists had been
> thinking about it.
>
> RC> Is there a good reference you would recommend for describing
>  > the details of common linguistic games?  Anything automated that
>  > would identify games based on corpora?
>
> There has been a lot written, but there's no consensus, and
> no systematic software.  It's still an area where finding
> good paradigms is still an open-ended research problem.
>
> One point that I believe is significant is that Ludwig W. wrote
> his first book (which presented his views based on earlier
> reading and discussions with Frege and Russell).  After he
> published that, he decided to go teach elementary school
> in an Austrian mountain village.
>
> He didn't say much about the several years he spent teaching, but
> some of his later examples seem to be influenced by that time.
>
> On a somewhat related point, I recently came across the
> following story about how school children react to the
> "game" of solving arithmetic problems.
>
> John
>
> ----- Original Message -----
> From: Elart von Collani
> To: hans kuijper...
> Sent: Wednesday, October 21, 2009 4:07 PM
> Subject: Re: UNCERTAINTY
>
> Dear Hans,
>
> the questions remind me of an experiment that was performed only
> recently in an elementary school in Germany.
>
(http://www.focus.de/wissen/wissenschaft/talent/tid-15667/talent-8-macht-sch
ule-auf-dauer-duemmer_aid_439869.html)
> The third year children had to answer the following questions:
>
> 1. A skipper is carrying 17 sheep and eleven goats on his boat. How old
> is the skipper?"
>
> 2. A 27 years old shepherd has 25 sheep and 10 goats. How old is the
> shepherd?
>
> 3. The class consists of 13 boys and 15 girls. How old is the teacher?
>
> All the children calculated seriously a result by adding and subtracting
> the given numbers, even for the second question that contains the
> explicit answer. The boy Sebastian was subsequently asked about his
> solutions. The following dialogue is reported:
>
> Sebastian: I know it. A 27 years old shepherd, then it is necessary to
> add the 25. And the 10 goats, they do not run away.
> Teacher: They do not run away?
> Sebastian: No, that's what I have written!
> Teacher: Because the goats don't run away?
> Sebastian: Yes.
> Teacher to Dennis: What is your opinion?
> Dennis: They run away! He does not look after them!
>
> Similar results were obtained in other studies. The authors conclude
> that the children consider mathematics as a kind of game with artificial
> rules that have no relation what so ever with reality. In an subsequent
> study the following dialogue was reported:
>
> Teacher: You have 10 pencils and 20 coloured pencils. How old are you?
> Julia: 30 years old!
> Teacher: But I guess you know very well that you are not 30 years old?
> Julia: Yes, but I am not to blame for that. You gave the wrong numbers!
>
> Warm regards from a cold but sunny Wuerzburg, yours Elart
>
>
> _________________________________________________________________
> Message Archives: http://ontolog.cim3.net/forum/ontolog-forum/
> Config Subscr: http://ontolog.cim3.net/mailman/listinfo/ontolog-forum/
> Unsubscribe: mailto:ontolog-forum-leave@xxxxxxxxxxxxxxxx
> Shared Files: http://ontolog.cim3.net/file/
> Community Wiki: http://ontolog.cim3.net/wiki/
> To join: http://ontolog.cim3.net/cgi-bin/wiki.pl?WikiHomePage#nid1J
> To Post: mailto:ontolog-forum@xxxxxxxxxxxxxxxx
>
>    (014)

_________________________________________________________________
Message Archives: http://ontolog.cim3.net/forum/ontolog-forum/  
Config Subscr: http://ontolog.cim3.net/mailman/listinfo/ontolog-forum/  
Unsubscribe: mailto:ontolog-forum-leave@xxxxxxxxxxxxxxxx
Shared Files: http://ontolog.cim3.net/file/
Community Wiki: http://ontolog.cim3.net/wiki/ 
To join: http://ontolog.cim3.net/cgi-bin/wiki.pl?WikiHomePage#nid1J
To Post: mailto:ontolog-forum@xxxxxxxxxxxxxxxx    (015)



_________________________________________________________________
Message Archives: http://ontolog.cim3.net/forum/ontolog-forum/  
Config Subscr: http://ontolog.cim3.net/mailman/listinfo/ontolog-forum/  
Unsubscribe: mailto:ontolog-forum-leave@xxxxxxxxxxxxxxxx
Shared Files: http://ontolog.cim3.net/file/
Community Wiki: http://ontolog.cim3.net/wiki/ 
To join: http://ontolog.cim3.net/cgi-bin/wiki.pl?WikiHomePage#nid1J
To Post: mailto:ontolog-forum@xxxxxxxxxxxxxxxx    (016)

<Prev in Thread] Current Thread [Next in Thread>