W3C home > Mailing lists > Public > public-lod@w3.org > March 2013

Re: Ontology for Relational Database Metadata

From: Richard Cyganiak <richard@cyganiak.de>
Date: Tue, 26 Mar 2013 18:03:41 +0000
Cc: public-lod@w3.org
Message-Id: <5F6DF3DE-EFC3-493C-ABF8-DD0626D562D9@cyganiak.de>
To: Michael Schmidt <michael.schmidt@fluidops.com>
You could do worse than using a W3C Direct Mapping [1] representation of the INFORMATION_SCHEMA tables [2].

The Revelytix RDB Schema Ontology [3] comes close, but AFAIK doesn't cover everything you need (FKs, indexes).

Best,
Richard

[1] http://www.w3.org/TR/rdb-direct-mapping/
[2] http://en.wikipedia.org/wiki/Information_schema
[3] http://www.knoodl.com/ui/groups/Mapping_Ontology_Community/vocab/RDB_Schema_Ontology


On 26 Mar 2013, at 15:49, Michael Schmidt <michael.schmidt@fluidops.com> wrote:

> Dear LOD community,
> 
> we're currently looking for an ontology to describe relational database metadata. In the D2RQ vocabulary and in the R2RML standard, there are some simple concepts for representing databases and tables, yet what we're looking for goes far beyond what can be expressed with these vocabularies: we are looking for a schema allowing us to describe the internal structure of relational databases, including database meta information (database type, version number, ...), table names, attributes and associated datatypes, key and foreign key relationships, indizes, and the like.
> 
> If anyone is aware of ontologies covering this subject, we would be glad to get some pointers.
> 
> Best regards,
> Michael Schmidt
> 
Received on Tuesday, 26 March 2013 18:03:55 UTC

This archive was generated by hypermail 2.3.1 : Wednesday, 7 January 2015 15:16:31 UTC