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 <[email protected]> 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 >
