Closed KonradHoeffner closed 3 years ago
The 218 citations without softwareproduct are probably connected to studies.
SELECT DISTINCT(?cit) ?study ?p
{
?cit a [rdfs:subClassOf hito:Citation].
?study ?p ?cit; a [rdfs:subClassOf hito:Study] .
}
Options
For now choose option 3, but maybe implement 1 or 2 later.
The SPARQL query in https://github.com/hitontology/database/blob/master/scripts/classes.py (see below) already only queries for citations with software products, so option 3 is already the case and this issue can be closed. Just have to pay attention to not delete the "study citations" when converting back from the database to the ontology.
SELECT
REPLACE(STR(?citation),".*/","") as ?suffix
REPLACE(STR(?uri),".*/","") as ?swp_suffix
STR(SAMPLE(?label)) AS ?label
STR(SAMPLE(?comment)) AS ?comment
CONCAT(UCASE(SUBSTR(?p_suffix, 1, 1)), SUBSTR(?p_suffix, 2)) AS ?type
{{
?uri a hito:SoftwareProduct;
?p ?citation.
?p rdfs:subPropertyOf hito:citation.
BIND(REPLACE(STR(?p),".*/","") AS ?p_suffix).
?citation rdfs:label ?label.
OPTIONAL {{?citation rdfs:comment ?comment.}}
As decided in #36, each citation needs to be connected to exactly one softwareproduct.
However there are citations which violate this:
Results
cit | callret-1 -- | -- http://hitontology.eu/ontology/Reporting | 4 http://hitontology.eu/ontology/completeTestResults | 2 http://hitontology.eu/ontology/medicationSelectionFromMenuInWichMedicationFromTheWardStockOrThePharmacyIsShown | 2 http://hitontology.eu/ontology/TopDiseasesReport | 2 http://hitontology.eu/ontology/automaticAndPaperlessOperations | 2 http://hitontology.eu/ontology/patientRegistration | 2 http://hitontology.eu/ontology/possibilityToContinuePrescribingWhileSafetyAlert | 2 http://hitontology.eu/ontology/bookingOfExaminations | 2 http://hitontology.eu/ontology/safetyAlertsInCaseOfAllergies | 2 http://hitontology.eu/ontology/readBarCodeLabel | 2 http://hitontology.eu/ontology/EvaluationsReport | 2 http://hitontology.eu/ontology/InjurySurveillanceSystemRegistrationReport | 2 http://hitontology.eu/ontology/safetyAlertsForAcceptedMedicationAreSeenByPharmacistsWhoCanContactPhysiciansOrNurses | 2 http://hitontology.eu/ontology/safetyAlertsInCaseOfOverdosing | 2 http://hitontology.eu/ontology/StockManagement | 2 http://hitontology.eu/ontology/medicationControlBasedOnNationalDrugDatabase | 2 http://hitontology.eu/ontology/safetyAlertsInCaseOfDrug-drugInteractions | 2 http://hitontology.eu/ontology/safetyAlertsInRealTime | 2 http://hitontology.eu/ontology/standardizedPrescriptionsAndMedicationProtocols | 2 http://hitontology.eu/ontology/speechRecognition | 2 http://hitontology.eu/ontology/patientAdministrationSystemPAS | 0 http://hitontology.eu/ontology/pictureArchivalAndCommunicationSystem | 0 http://hitontology.eu/ontology/PACSInterface | 0 http://hitontology.eu/ontology/emergencyTesting | 0 http://hitontology.eu/ontology/respiratoryTabs | 0 http://hitontology.eu/ontology/surgeryManagement | 0 http://hitontology.eu/ontology/waitingListForTheFinalOperationSchedule | 0 http://hitontology.eu/ontology/app | 0 http://hitontology.eu/ontology/cardiologyWard | 0 http://hitontology.eu/ontology/amountMedicationErrors | 0 http://hitontology.eu/ontology/analyticalTurnaroundTime | 0 http://hitontology.eu/ontology/compatibilityWithDataFormats | 0 http://hitontology.eu/ontology/implementationOfTheApplicationSystem | 0 http://hitontology.eu/ontology/patientWaitingTimes | 0 http://hitontology.eu/ontology/usersViewOnTraining | 0 http://hitontology.eu/ontology/usersViewOnUserSupport | 0 http://hitontology.eu/ontology/contentAnalysis | 0 http://hitontology.eu/ontology/demographicsSurvey | 0 http://hitontology.eu/ontology/descriptiveStatistics | 0 http://hitontology.eu/ontology/secondaryUseOfClinicalData | 0 http://hitontology.eu/ontology/administrativeStaff | 0 http://hitontology.eu/ontology/laboratoryStaff | 0 http://hitontology.eu/ontology/clerks | 0 http://hitontology.eu/ontology/EmergencyDepartmentInformationSystemEDIS | 0 http://hitontology.eu/ontology/computerizedProviderOrderEntrySystem | 0 http://hitontology.eu/ontology/automaticAlignmentOfBaselineAndFollow-upCTA | 0 http://hitontology.eu/ontology/drugDictionary | 0 http://hitontology.eu/ontology/onlineDataAcquisitionOfVitalSignsFromMonitoringDevices | 0 http://hitontology.eu/ontology/onlineDataAcquisitionOfVitalSignsFromOtherMedicalDevices | 0 http://hitontology.eu/ontology/recommendationPop-upWindow | 0 http://hitontology.eu/ontology/retrievalOfPatientRegisters | 0 http://hitontology.eu/ontology/reviewScreeningAndTestingOptions | 0 http://hitontology.eu/ontology/gynaecology | 0 http://hitontology.eu/ontology/gastroenterologyWard | 0 http://hitontology.eu/ontology/geriatryWard | 0 http://hitontology.eu/ontology/intensiveCareUnit | 0 http://hitontology.eu/ontology/universityHospital | 0 http://hitontology.eu/ontology/cancelledPrescriptions | 0 http://hitontology.eu/ontology/glycaemicControl | 0 http://hitontology.eu/ontology/jobSatisfaction | 0 http://hitontology.eu/ontology/socialRepercussions | 0 http://hitontology.eu/ontology/strengthsAndWeaknessesOfIntervention | 0 http://hitontology.eu/ontology/functionality | 0 http://hitontology.eu/ontology/surveyWithOpenQuestions | 0 http://hitontology.eu/ontology/informationTechnologyITManager | 0 http://hitontology.eu/ontology/surgeons | 0 http://hitontology.eu/ontology/RIS-PACSSystem | 0 http://hitontology.eu/ontology/electronicMedicalRecordSystem | 0 http://hitontology.eu/ontology/nursingDocumentationSystem | 0 http://hitontology.eu/ontology/ICNPAsClassificationSystem | 0 http://hitontology.eu/ontology/agreementManagement | 0 http://hitontology.eu/ontology/automaticSegmentationOfBaselineCTA | 0 http://hitontology.eu/ontology/patientAdministration | 0 http://hitontology.eu/ontology/supportForDigitalPhotography | 0 http://hitontology.eu/ontology/endocrinology | 0 http://hitontology.eu/ontology/psychiatryWard | 0 http://hitontology.eu/ontology/adherenceToRecommendations | 0 http://hitontology.eu/ontology/comparisionOfRemoteAndOnSiteConsultations | 0 http://hitontology.eu/ontology/comparisionOfWorkflow | 0 http://hitontology.eu/ontology/decreaseDecisionalConflict | 0 http://hitontology.eu/ontology/laboratoyTurnaroundTime | 0 http://hitontology.eu/ontology/softwareStability | 0 http://hitontology.eu/ontology/knowledgeQuestionnaire | 0 http://hitontology.eu/ontology/questionnaires | 0 http://hitontology.eu/ontology/computerizedDecisionAid | 0 http://hitontology.eu/ontology/appointmentLetters | 0 http://hitontology.eu/ontology/automatedCalculationOfVentilationTimes | 0 http://hitontology.eu/ontology/automatedCodingSemi-automatedCodingOfDiagnosesAndProceduresFromPreviouslyDocumentedClinicalDataAccorddingToGermanDRG | 0 http://hitontology.eu/ontology/consultationReferrals | 0 http://hitontology.eu/ontology/informationAboutTheOperationActivity | 0 http://hitontology.eu/ontology/tabletBasedApplication | 0 http://hitontology.eu/ontology/geneticCounseling | 0 http://hitontology.eu/ontology/pediatricIntensiveCare | 0 http://hitontology.eu/ontology/analyzeAccuracyAndInter-observerVariabilityOfNewTool | 0 http://hitontology.eu/ontology/clinicalUtility | 0 http://hitontology.eu/ontology/dataTransmissionSpeed | 0 http://hitontology.eu/ontology/patientCareDelivery | 0 http://hitontology.eu/ontology/availability | 0 http://hitontology.eu/ontology/questionnairesQuantitative | 0 http://hitontology.eu/ontology/scenarios | 0 http://hitontology.eu/ontology/survey | 0 http://hitontology.eu/ontology/nurses | 0 http://hitontology.eu/ontology/secretaries | 0 http://hitontology.eu/ontology/computerizedPrescribingSystem | 0 http://hitontology.eu/ontology/bedManagement | 0 http://hitontology.eu/ontology/bedsideCPOEForOrdersBetweenPhysiciansAndNurses | 0 http://hitontology.eu/ontology/operatingRoomModule | 0 http://hitontology.eu/ontology/operationTheaterActivities | 0 http://hitontology.eu/ontology/plannedActivities | 0 http://hitontology.eu/ontology/reportFunctionalities | 0 http://hitontology.eu/ontology/simplifiedLanguage | 0 http://hitontology.eu/ontology/infectiology | 0 http://hitontology.eu/ontology/dataEntriesInRealTime | 0 http://hitontology.eu/ontology/timeOfVentilation | 0 http://hitontology.eu/ontology/clinicalAudit | 0 http://hitontology.eu/ontology/clericalStaff | 0 http://hitontology.eu/ontology/frontOfficeOperators | 0 http://hitontology.eu/ontology/clinicalDocumentationSystem | 0 http://hitontology.eu/ontology/admissionOverview | 0 http://hitontology.eu/ontology/free-textNursingReportWriting | 0 http://hitontology.eu/ontology/in-patientAdmissionsAndDischarges | 0 http://hitontology.eu/ontology/pediatrics | 0 http://hitontology.eu/ontology/reductionOfPrescribingErrors | 0 http://hitontology.eu/ontology/timeForProducingImages | 0 http://hitontology.eu/ontology/userInteractionSatisfaction | 0 http://hitontology.eu/ontology/costAnalysis | 0 http://hitontology.eu/ontology/documentAnalysis | 0 http://hitontology.eu/ontology/performanceAnalysis | 0 http://hitontology.eu/ontology/observations | 0 http://hitontology.eu/ontology/physicians | 0 http://hitontology.eu/ontology/EmergencyDepartmentProviderElectronicDocumentationSystem | 0 http://hitontology.eu/ontology/computerizedPhysicianOrderEntrySystemWithBasicClinicalDecisionSupportCPOE-CDSS | 0 http://hitontology.eu/ontology/enterpriseWideResourcePlanningSystemERP | 0 http://hitontology.eu/ontology/bookingForm | 0 http://hitontology.eu/ontology/displayOfWarningsWhenAppropiate | 0 http://hitontology.eu/ontology/exportFunctionToTheBillingSystem | 0 http://hitontology.eu/ontology/importInterfacesForLaboratoryMicrobiologyRadiologyReports | 0 http://hitontology.eu/ontology/real-timeDataEntering | 0 http://hitontology.eu/ontology/someWarningsCanNotBeOverridden | 0 http://hitontology.eu/ontology/visualizationOfDiameterProgression | 0 http://hitontology.eu/ontology/Rheumatology | 0 http://hitontology.eu/ontology/comparisionWithOnSiteEchocardiographicMachines | 0 http://hitontology.eu/ontology/imageQuality | 0 http://hitontology.eu/ontology/usersViewOnUsefulness | 0 http://hitontology.eu/ontology/participationsInLearningSessions | 0 http://hitontology.eu/ontology/secondaryUseOfOperationalData | 0 http://hitontology.eu/ontology/interviews | 0 http://hitontology.eu/ontology/electronicMedication-administrationSystem | 0 http://hitontology.eu/ontology/electronicPrescribingSystem | 0 http://hitontology.eu/ontology/patientDataManagementSystemPDMS | 0 http://hitontology.eu/ontology/semi-automaticAortaDilatationQuantificationSoftware | 0 http://hitontology.eu/ontology/alteringPrescribingHabitsByAlternativeDrugs | 0 http://hitontology.eu/ontology/automaticDocumentationOfMedication | 0 http://hitontology.eu/ontology/creationAndStorageOfNursingDiagnosesAndNursingOutcomes | 0 http://hitontology.eu/ontology/followingOfThePerioerpativeProcess | 0 http://hitontology.eu/ontology/invoicingAndRegistrationOverview | 0 http://hitontology.eu/ontology/operatingRoomManagement | 0 http://hitontology.eu/ontology/outpatientAppointements | 0 http://hitontology.eu/ontology/retrievalOfAdministrativeData | 0 http://hitontology.eu/ontology/scanBarCodesOnThePatientsWristband | 0 http://hitontology.eu/ontology/pre-processing | 0 http://hitontology.eu/ontology/laboratory | 0 http://hitontology.eu/ontology/orthopedy | 0 http://hitontology.eu/ontology/radiology | 0 http://hitontology.eu/ontology/amountOfAdverseDrugEvents | 0 http://hitontology.eu/ontology/amountOfMedicationOrders | 0 http://hitontology.eu/ontology/costBenefit | 0 http://hitontology.eu/ontology/notInferiorToAConsultingVisit | 0 http://hitontology.eu/ontology/overridenWarningMessages | 0 http://hitontology.eu/ontology/userAcceptance | 0 http://hitontology.eu/ontology/decisionalConflictScale | 0 http://hitontology.eu/ontology/intentToTreatAnalysis | 0 http://hitontology.eu/ontology/processAnalysis | 0 http://hitontology.eu/ontology/qualityAssessmentOfCTScans | 0 http://hitontology.eu/ontology/pharmacists | 0 http://hitontology.eu/ontology/computerizedDecisionSupportSystemCDSS | 0 http://hitontology.eu/ontology/nursingInformationSystem | 0 http://hitontology.eu/ontology/PDMS | 0 http://hitontology.eu/ontology/medicationOrdersAppearOnThePatientsElectronicRecordOnceThePharmacistHasApprovedThem | 0 http://hitontology.eu/ontology/registrationOfInpatients | 0 http://hitontology.eu/ontology/semi-automaticAssessmentOfThoracicAortaDiameters | 0 http://hitontology.eu/ontology/translatedIntoSpanish | 0 http://hitontology.eu/ontology/Gastroenterology | 0 http://hitontology.eu/ontology/dermatology | 0 http://hitontology.eu/ontology/nephrology | 0 http://hitontology.eu/ontology/timeSpent | 0 http://hitontology.eu/ontology/timeToProduceTestResults | 0 http://hitontology.eu/ontology/userOpinion | 0 http://hitontology.eu/ontology/theatrePlanningManager | 0 http://hitontology.eu/ontology/radiologists | 0 http://hitontology.eu/ontology/technicians | 0 http://hitontology.eu/ontology/technologists | 0 http://hitontology.eu/ontology/electronicPatientRecordSystemEPR | 0 http://hitontology.eu/ontology/laboratoryInformationSystem | 0 http://hitontology.eu/ontology/dataReuseAndDataTransferForAccountingPurposesToTheAdministrationSubsystem | 0 http://hitontology.eu/ontology/electronicPatientWorklist | 0 http://hitontology.eu/ontology/informationSourroundingPatientAgeAndGestationalAgeToGuideTowardAvailableOptions | 0 http://hitontology.eu/ontology/listToTrackTheStatusOfPendingSamples | 0 http://hitontology.eu/ontology/nurseAlteringIfPatientsMedicationIsOverdue | 0 http://hitontology.eu/ontology/onlineDataAcquisitionOfCitalSignsFromVentilators | 0 http://hitontology.eu/ontology/planningSchedulingAndAnalysisOfOperations | 0 http://hitontology.eu/ontology/predifiningNursingProblemsGoalsAndTasks | 0 http://hitontology.eu/ontology/retrievalOfTheNationalCodingSystemForDiagnosisAndMedicalProcedures | 0 http://hitontology.eu/ontology/surgeryRequest | 0 http://hitontology.eu/ontology/viewOfTheStatusOfPatientsInOperation | 0 http://hitontology.eu/ontology/hospitals | 0 http://hitontology.eu/ontology/emergencyDepartment | 0 http://hitontology.eu/ontology/neonatalIntensiveCare | 0 http://hitontology.eu/ontology/rheumatologyWard | 0 http://hitontology.eu/ontology/decisionMaking | 0 http://hitontology.eu/ontology/qualityOfDocumentation | 0 http://hitontology.eu/ontology/qualityOfInformationProcessing | 0 http://hitontology.eu/ontology/qualityOfRealTimeSynchronizedViewing | 0 http://hitontology.eu/ontology/usersViewOnUsability | 0 http://hitontology.eu/ontology/timeMeasurement | 0 http://hitontology.eu/ontology/operationManagementSystem | 0 http://hitontology.eu/ontology/pointOfCareTestingDevicePOCT | 0 http://hitontology.eu/ontology/teleconsultationSystem | 0 http://hitontology.eu/ontology/decisionsSupportFunctions | 0 http://hitontology.eu/ontology/facilitatingCalculationsOfDrugDosesAndFluidBalances | 0 http://hitontology.eu/ontology/integrationOfPatientSpecificData | 0 http://hitontology.eu/ontology/interfacedToTheRIS | 0 http://hitontology.eu/ontology/nursingEvaluation | 0 http://hitontology.eu/ontology/schedulingAndResourceAllocation | 0 http://hitontology.eu/ontology/healthCenters | 0 http://hitontology.eu/ontology/surgery | 0 http://hitontology.eu/ontology/generalInternalMedicine | 0 http://hitontology.eu/ontology/generalInternalMedicineWard | 0 http://hitontology.eu/ontology/medicalCenter | 0 http://hitontology.eu/ontology/amountOfErrorsInOrderTranscription | 0 http://hitontology.eu/ontology/operationalPerformance | 0 http://hitontology.eu/ontology/shiftToShiftContinuity | 0 http://hitontology.eu/ontology/userAdoption | 0 http://hitontology.eu/ontology/workChanges | 0 http://hitontology.eu/ontology/dataAnalysisOutOfIntervention | 0 http://hitontology.eu/ontology/focusGroups | 0 http://hitontology.eu/ontology/inferentialStatistics | 0 http://hitontology.eu/ontology/womenOfReproductiveAge | 0Histogram