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:32:21 +0200
Message-Id: <8FE5CE09-EAB8-11D8-A21C-000A95E59614@inf.unibz.it>
Cc: Prajakta Nivargi <Prajakta.Nivargi@asu.edu>, www-rdf-interest@w3.org
To: Andrei Lopatenko <lopatenko@inf.unibz.it>
>
Encoded as triples.
RDF encoding is straighforward

> RowSet  rdf:type owl:Class

Row  rdf:type owl:Class
Slot   rdf:type owl:Class
Slot rdfs:subClassOf  x
x rdf:type owl:Restriction
x owl:onProperty columnValue
x owl:maxCardinality 1
Slot rdfs:subClassOf  y
y rdf:type owl:Restriction
y owl:onProperty column
y owl:cardinality 1
Column rdf:type owl:Class
rows rdf:type  owl:ObjectProperty
rows rdfs:range  Row
rows rdfs:domain RowSet
slots rdf:type  owl:ObjectProperty
slots rdfs:range Slot
slots rdfs:domain Row
columnValue rdf:type  owl:ObjectProperty
columnValue rdfs:domain Slot
column     rdf:type owl:ObjectProperty
column     rdfs:range Column
column     rdfs:domain Slot

then
ssi rdf:type Column
name rdf:type Column

employees rdf:type RowSet
row1 rdf:type Row
row2 rdf:type Row
slot1 rdf:type Slot
slot2 rdf:type Slot
slot3 rdf:type Slot
slot4 rdf:type Slot
slot1 column ssi
slot2 column name
slot3 column ssi
slot4 column name
slot1 columnValue xxxx
slot2 columnValue John Smith
slot3 columnValue yyyy
slot4 columnValue Sherlock Holmes
row1 slots slot1
row1 slots slot2
row2 slots slot3
row2 slots slot4
employees rows row1
employees rows row2

> 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/
>
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:32:48 UTC

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