W3C home > Mailing lists > Public > www-rdf-interest@w3.org > August 2004

Re: relational database ontology

From: Andrei Lopatenko <lopatenko@inf.unibz.it>
Date: Tue, 10 Aug 2004 12:07:58 +0200
Message-Id: <27E308F2-EAB5-11D8-A21C-000A95E59614@inf.unibz.it>
Cc: www-rdf-interest@w3.org, Andrei Lopatenko <lopatenko@inf.unibz.it>
To: Prajakta Nivargi <Prajakta.Nivargi@asu.edu>
> -The following are classes – column, row, columnSet, rowSet,
>  -columnSet consists of one or more columns
> -rowSet consists of one or more rows
> -rowSet is owned by a columnSet or a derived class of columnSet
> -table and view classes will be subclasses of columnSet
> -Row inherits from Object. Its structure is defined by the 
> corresponding ColumnSet and its Columns. Each
> Row is divided into ColumnValues, which match the value of a 
> relational table, at the intersection of a row and a column.
> -A row is associated with a particular column with a “slot” association
> -columnValue is associated with the “slot”
> What I do not understand is how do I map the row with the column via 
> the slot association in OWL.
> Or in more general terms how do I model associations between classes. 
> Does anybody have an idea?
>
In general you can use UML to OWL mappings. A plenty of research was 
done in this area.
In this particular situation...
As far as I understand you want to model in OWL  data sets (and not 
only schema information)
I think that each particular dataset must be a RDF object, but not a 
OWL class. That object must be an instance of Rowset class
Class Rowset
    have a slot "rows" with range Row and cardinality 0..*
Class Row
    have a slot "slots" with range Slot  and cardinality  0..*
Class Slot
   have a slot "ColumnValue" range Object cardinality 0..1
   have a slot "Column" range Column  cardinality 1

If you need I can give an example encoded directly in OWL + RDF
Andrei


>
>  
>
>  
>
> I an trying to create an ontology for relational databases. This is 
> like a meta ontology and not for any particular database. I have 
> created an ontology which has classes like – table, fields, records 
> etc and certain properties.
>
>  
>
> My aim is to target different levels or types of data i.e. open data, 
> confidential data etc.
>
>  
>
> Is anyone aware of any such existing ontology with which I could 
> verify mine?
>
>  
>
>  
>
>  
>
> Thanks,
>
>  
>
> Prajakta
>
>  
>
> Andrei Lopatenko
>
>  Research Assistant
>
>  Free University of Bozen-bolzano
>
>  PhD Student
>
>  The University of Manchester
>
> +39 (0471) 315-644
>
>  http://www.inf.unibz.it/~lopatenko/
>
Andrei Lopatenko
Research Assistant
Free University of Bozen-bolzano
PhD Student
The University of Manchester
+39 (0471) 315-644
http://www.inf.unibz.it/~lopatenko/
Received on Tuesday, 10 August 2004 10:08:26 UTC

This archive was generated by hypermail 2.3.1 : Wednesday, 5 February 2014 07:14:57 UTC