search

hitontology / database

Schema, diagram and SPARQL import and export of the HITO software product PostgreSQL database.
Creative Commons Zero v1.0 Universal
2 stars 1 forks source link

Load Software Products into Database #8

Closed KonradHoeffner closed 4 years ago

KonradHoeffner commented 4 years ago

Do we use CSV2RDF or do load it over SPARQL?

KonradHoeffner commented 4 years ago

There are 22 software products in the endpoint right now: SELECT ?s STR(?label) as ?label {?s a hito:SoftwareProduct; rdfs:label ?label.}

s label
http://hitontology.eu/ontology/Bahmni Bahmni
http://hitontology.eu/ontology/GnuHealth GNU Health
http://hitontology.eu/ontology/Orthanc Orthanc
http://hitontology.eu/ontology/AGFA_PACS_IMPAX AGFA PACS IMPAX
http://hitontology.eu/ontology/AGFA_RIS_Elefante AGFA RIS Elefante
http://hitontology.eu/ontology/Abbott_i-Stat Abbott i-Stat
http://hitontology.eu/ontology/CSC_MedChart CSC Med Chart
http://hitontology.eu/ontology/CernerMilleniumPowerOrders Cerner Millenium Power Orders
http://hitontology.eu/ontology/Cerner_FirstNet Cerner First Net
http://hitontology.eu/ontology/Cerner_Soarian_CPOE_platform Cerner Soarian CPOE platform
http://hitontology.eu/ontology/Eclipsys_Continuum_2000_CDS Eclipsys Continuum 2000 CDS
http://hitontology.eu/ontology/GE_Patchspecd_PACS GE Patchspecd PACS
http://hitontology.eu/ontology/HNA_Millenium HNA Millenium
http://hitontology.eu/ontology/Medicator Medicator
http://hitontology.eu/ontology/Metavision Metavision
http://hitontology.eu/ontology/PIK PIK
http://hitontology.eu/ontology/SAP_R3_Business_Process_Control_System_software SAP R3 Business Process Control System software
http://hitontology.eu/ontology/Sysmex_XS_1000i_haematology_analyser Sysmex XS 1000i haematology analyser
http://hitontology.eu/ontology/TeleDICOM Tele DICOM
http://hitontology.eu/ontology/Theriak Theriak
http://hitontology.eu/ontology/eChasqui e Chasqui
http://hitontology.eu/ontology/e_Doc e Doc
KonradHoeffner commented 4 years ago

Checking the first ones if they are as tables on Google Drive but there is no table for:

They are in hito.ttl instead, so we need to download the software products from the SPARQL endpoint.

KonradHoeffner commented 4 years ago
KonradHoeffner commented 4 years ago

Done with fb8208acbfffc1eb8f778ca6650ac923c09e937a

KonradHoeffner commented 4 years ago

Citations fehlen noch:

KonradHoeffner commented 4 years ago 
ERROR:  insert or update on table "citation" violates foreign key constraint "citation_classified_suffix_fkey"
DETAIL:  Key (classified_suffix)=(SupportForCommunicationBetweenOrganizations) is not present in table "classified".
Importing swp_has_child from https://hitontology.eu/sparql
DELETE 0
INSERT 0 1
Importing swp_has_interoperabilitystandard from https://hitontology.eu/sparql
DELETE 0
INSERT 0 5
Importing swp_has_language from https://hitontology.eu/sparql
DELETE 0
INSERT 0 3
Importing swp_has_license from https://hitontology.eu/sparql
DELETE 0
ERROR:  insert or update on table "swp_has_license" violates foreign key constraint "swp_has_license_license_suffix_fkey"
DETAIL:  Key (license_suffix)=(GNU_General_Public_License) is not present in table "license".
Importing swp_has_operatingsystem from https://hitontology.eu/sparql
DELETE 0
INSERT 0 9
Importing swp_has_programminglanguage from https://hitontology.eu/sparql
KonradHoeffner commented 4 years ago
KonradHoeffner commented 4 years ago

Options

  1. Add Dickinson to https://github.com/hitontology/csv2rdf
  2. Change the scripts to download catalogues from the endpoint instead of from the CSV.

I prefer option 2 because then we are free from CSV2RDF altogether and can just release the scripts alongside a SPARQL dump and unify the script code base.

KonradHoeffner commented 4 years ago

All errors are fixed.

KonradHoeffner commented 4 years ago