W3C home > Mailing lists > Public > public-dxwg-wg@w3.org > July 2020

Re: [dxwg] Question: how to catalog relational database data in DCAT? (#1240)

From: zeginis via GitHub <sysbot+gh@w3.org>
Date: Fri, 03 Jul 2020 07:23:21 +0000
To: public-dxwg-wg@w3.org
Message-ID: <issue_comment.created-653395645-1593761000-sysbot+gh@w3.org>
Hi @dominik-s0 , @andrea-perego 
I work for the EU project CYBELE (https://www.cybele-project.eu/). At the prohect we are using DCAT to create metadata for the data that will be inserted to the platform we build.  The data will be stored at a relational database while the metadata are stored at Virtuoso triple store. We are using these metadata in order to search for data (e.g. based on the geographical coverage) but we need also some info to link the metadata with the database and the actual table where the data are stored. The aim is to be able to query the actual data by using the information gathered from the metadata.

We plan to use the dcat:DataService and some of its properties to represent such info. Use `dcat:endpointURL` for the jdbc connection and `dct:identifier` for the table name.

```
a:Dataset a dcat:Dataset ; 
  dcat:distribution [ a dcat:Distribution ;
    dcat:accessService [ a dcat:Service ;
      dcat:endpointURL "jdbc:oracle:thin:@​hostname:1521:my-database";
      dct:identifier  THE_TABLE_NAME
  ]
] .
```

-- 
GitHub Notification of comment by zeginis
Please view or discuss this issue at https://github.com/w3c/dxwg/issues/1240#issuecomment-653395645 using your GitHub account
Received on Friday, 3 July 2020 07:23:23 UTC

This archive was generated by hypermail 2.4.0 : Friday, 3 July 2020 07:23:24 UTC