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

RE: relational database ontology

From: Prajakta Nivargi <Prajakta.Nivargi@asu.edu>
Date: Wed, 11 Aug 2004 18:00:01 -0700
To: www-rdf-interest@w3.org
Message-id: <9EAE2E44897BC749ACB3A62683B2C8D10455A606@ex4.asurite.ad.asu.edu>
Thank you everyone for your help. Now I have a better idea of class
associations.

 

Prajakta

 

  _____  

From: Andrei Lopatenko [mailto:lopatenko@inf.unibz.it] 
Sent: Tuesday, August 10, 2004 3:32 AM
To: Andrei Lopatenko
Cc: Prajakta Nivargi; www-rdf-interest@w3.org
Subject: Re: relational database ontology

 

	 

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 Thursday, 12 August 2004 01:00:54 UTC

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