Create the data model for mapping the RDB to RDF

EOSC-LOFAR / LTA

Documentation and data related to the LOFAR LTA DBView

Apache License 2.0

0 stars 0 forks source link

Create the data model for mapping the RDB to RDF #8

Open elboyran opened 6 years ago

elboyran commented 6 years ago

[x] Obtain the most recent schema of the database (related to #9)
[x] Find the most relevant tables or views for mapping to vocabs/ontologies
[x] Export the tables or views into CSV file
[x] Transform the CSV file into RDF graph(s) using OpenRefine (prototyping)
[ ] Transform the database tables or views into RDF using RDB2RDF (R2RML) (production)

lbogaardt commented 6 years ago

Added CSV excerpts of all tables here.

lbogaardt commented 6 years ago

The database schema or dictionary does not seem to conform to the one described in the LOFAR MeasurementSet document (page 29, Fig.1: ER diagram)

elboyran commented 6 years ago

Message from Laurens on Slack: The most relevant terms, written in "Hanno Spreeuw Ontology" are: Epoch Spectral Window Pointing FWHM Duration This sort of maps to: time channelWidth the entire Pointing Table duration

elena [10:28 AM] What does FWHM mean? What does it map to? lbogaardt [10:29 AM] Full width half maximum. I haven't found anything similar in our tables, so it seems to map to nothing... It's a measure of precision / error

vmaccatrozzo-zz commented 6 years ago

FWHM is the ratio between the wavelength and the largest baseline (distance between two stations).

elboyran commented 6 years ago

Pipeline team has figured out the following model. ltamodel