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

@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