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: Thu, 09 Jul 2020 14:14:55 +0000
To: public-dxwg-wg@w3.org
Message-ID: <issue_comment.created-656153431-1594304093-sysbot+gh@w3.org>
We are thinkig of using this approach
```
a:Dataset a dcat:Dataset ; 
  dcat:distribution [ a dcat:Distribution ;
    ex:accessDatabase [ a ex:Database ;
      ex:connectionString "jdbc:oracle:thin:@​hostname:1521:my-database";
      ex:tableName "THE_TABLE_NAME"
  ]
] .
```

Or Alternatively can we define the Database to be the Distribution?
In this case define 
- `ex:Database rdfs:subClassOf dcat:Distribution` and
- ` ex:hasDatabase rdfs:subPropertyOf  dcat:distribution`

Then we can use:
```
a:Dataset a dcat:Dataset ; 
 ex:hasDatabase [ a ex:Database ;
      ex:connectionString "jdbc:oracle:thin:@​hostname:1521:my-database";
      ex:tableName "THE_TABLE_NAME"
  ]
] .
```


-- 
GitHub Notification of comment by zeginis
Please view or discuss this issue at https://github.com/w3c/dxwg/issues/1240#issuecomment-656153431 using your GitHub account
Received on Thursday, 9 July 2020 14:14:56 UTC

This archive was generated by hypermail 2.4.0 : Thursday, 9 July 2020 14:14:57 UTC