RE: relational database ontology

Thanks Andrei.... That really helped a lot!

 

I am using the Relational database model part of it. 

I am confused as to how I can model the following in OWL.

 

I am trying to model not only the metadata for databases but also a few
instance data rows. So I have to link the rows with the appropriate
tables and the values in the rows with their appropriate columns.

 

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

 

For a clearer understanding here is a link to the actual document :

http://www.omg.org/docs/ad/01-02-01.pdf

Section 9.2.9

 

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?

 

Thanks,

Prajakta

 

  _____  

From: Andrei Lopatenko [mailto:lopatenko@inf.unibz.it] 
Sent: Monday, August 09, 2004 4:02 PM
To: Prajakta Nivargi
Cc: www-rdf-interest@w3.org; Andrei Lopatenko
Subject: Re: relational database ontology

 

I would recommend to use developed and used already industrial standards
to describe relational schema 

In particular CWM (Common Warehouse Model) from OMG which is built on
top of MOF 

http://www.omg.org/cwm/ 

I had been using it (my own implementation) for a few years in my
relational DBMS <-> RDF ETL tool. 

CWM is quite powerful to extend a wide set relational, OO, and XML
schema (support of datatypes, integrity constraints, etc) 

and quite flexible to extend it if you need features which are not
included into the current version of CWM/ 

As far as I remember it is supported by (or they intended to support)
Oracle products, IBM, Unisys, and other key players 

Andrei 

On Aug 9, 2004, at 11:41 PM, Prajakta Nivargi wrote: 

	 

	Hello, 

	 

	  

	 

	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/