Bioprotocols / container-ontology

Container ontology for use with PAML (Protocol Activity Markup Language)
Apache License 2.0
3 stars 3 forks source link

Possible path to integration with relational databases #37

Open rpgoldman opened 2 years ago

rpgoldman commented 2 years ago

@photocyte Asked about working from a relational database. We could do this in a two step process:

  1. Add a SPARQL RDF database to the container server. fuseki.
  2. Use the rewriter in the Owlery server to unpack ontology-related attributes for SPARQL queries for the RDF database.
  3. Incorporate a SPARQL to SQL translator for information we want to pull from a relational database. Possibly sparqlify

This would let us use the OWL container (or labware) ontology in a way that would have maximum flexibility to pull from sources such as online catalogs and lab databases of equipment on hand (I don't know to what extent labs have such databases).