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: Andrea Perego via GitHub <sysbot+gh@w3.org>
Date: Wed, 15 Jul 2020 07:49:27 +0000
To: public-dxwg-wg@w3.org
Message-ID: <issue_comment.created-658606396-1594799366-sysbot+gh@w3.org>
@zeginis , making a database a subclass of `dcat:Distribution` have some issues.

Formally speaking, a database is a service from which a distribution is available. The approach you describe conflicts with the pattern defined in DCAT where, in such cases, the service should be pointed to from a distribution, and not described itself as a distribution. This also leads to interoperability issues. 

You may consider revising your approach as follows:

````turtle
a:dataset-001 a dcat:Dataset ;
  dct:title "Dataset about YYY"@en ;
  dcat:distribution [ a dcat:Distribution ;
    dct:title "..."@en ;
    ex:accessDatabase a:database-001 ] .

a:dataset-002 a dcat:Dataset ;
  dct:title "Dataset about ZZZ"@en ;
  dcat:distribution [ a dcat:Distribution ;
    dct:title "..."@en ;
    ex:accessDatabase a:database-001 ] .

a:database-001 a ex:Database ;
                  ex:connectionString "jdbc:oracle:thin:@​hostname:1521:my-database";
                  ex:accessTable [ a ex:Table ;
                                  ex:tableName "Table1";
                                  dct:subject a:dataset-001] ; 
                 ex:accessTable [ a ex:Table ;
                                  ex:tableName "Table2"
                                  dct:subject a:dataset-002] .
````

-- 
GitHub Notification of comment by andrea-perego
Please view or discuss this issue at https://github.com/w3c/dxwg/issues/1240#issuecomment-658606396 using your GitHub account
Received on Wednesday, 15 July 2020 07:49:29 UTC

This archive was generated by hypermail 2.4.0 : Wednesday, 15 July 2020 07:49:30 UTC