Re: relational database ontology

> -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/