Similar to the way in which you can annotate columns in a spreadsheet, you can also add ontology references to tables and columns in relational databases that support the COMMENT feature. This is supported in Oracle, and MySQL, and after a fashion in PostgreSQL.
Researchers often need to export a subset of data from a database and share that data with a colleague. Provenance is usually one of the first questions that the recipient has. So imagine if you could use the JDBC Query Metadata feature to extract the COMMENT fields, and embed those comments into the spreadsheet.
Similar to the way in which you can annotate columns in a spreadsheet, you can also add ontology references to tables and columns in relational databases that support the COMMENT feature. This is supported in Oracle, and MySQL, and after a fashion in PostgreSQL.
Researchers often need to export a subset of data from a database and share that data with a colleague. Provenance is usually one of the first questions that the recipient has. So imagine if you could use the JDBC Query Metadata feature to extract the COMMENT fields, and embed those comments into the spreadsheet.