/* TITLE: upload_triplets.sql DESCRIPTION: upload DBFOntoMaestro data INSERT TRIPLETS */ USE DBFOntoMaestro ; SET TRANSACTION READ WRITE ; START TRANSACTION ; -- predicate: isMemberOfActor ------------------------------------------------------- -- INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('PrimaryStakeholder', 'isMemberOfActor', 'Owner', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('PrimaryStakeholder', 'isMemberOfActor', 'ProjectExecutive', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('SecondaryStakeholder', 'isMemberOfActor', 'Consultant', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('SecondaryStakeholder', 'isMemberOfActor', 'Investor', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('SecondaryStakeholder', 'isMemberOfActor', 'Managing', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('SecondaryStakeholder', 'isMemberOfActor', 'SeniorSupplier', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('SecondaryStakeholder', 'isMemberOfActor', 'SeniorUser', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('SecondaryStakeholder', 'isMemberOfActor', 'TeamManager', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('TertiaryStakeholder', 'isMemberOfActor', 'TeamMember', '', '', '', '') ; -- predicate: usesDocument ------------------------------------------------------- -- INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('FinalStage', 'usesDocument', 'DailyLog', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('FinalStage', 'usesDocument', 'EndProjectReport', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('FinalStage', 'usesDocument', 'EndStageReport', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('FinalStage', 'usesDocument', 'ExceptionReport', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('FinalStage', 'usesDocument', 'HighlightReport', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('FinalStage', 'usesDocument', 'IssueRegister', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('FinalStage', 'usesDocument', 'LessonsLearnedReport', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('FinalStage', 'usesDocument', 'LessonsLog', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('FinalStage', 'usesDocument', 'ProductChecklist', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('InitiationStage', 'usesDocument', 'BaselinePlan', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('InitiationStage', 'usesDocument', 'CommunicationManagementApproach', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('InitiationStage', 'usesDocument', 'DailyLog', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('InitiationStage', 'usesDocument', 'DeliveryApproachPlan', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('InitiationStage', 'usesDocument', 'ExceptionManagementPlan', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('InitiationStage', 'usesDocument', 'HighlightReport', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('InitiationStage', 'usesDocument', 'IssueRegister', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('InitiationStage', 'usesDocument', 'LessonsLog', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('InitiationStage', 'usesDocument', 'LongtermPlan', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('InitiationStage', 'usesDocument', 'Product', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('InitiationStage', 'usesDocument', 'ProductRoadmapPlan', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('InitiationStage', 'usesDocument', 'ProjectInitiationDoc', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('InitiationStage', 'usesDocument', 'ProjectManagementTeamStructure', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('InitiationStage', 'usesDocument', 'ProjectPlan', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('InitiationStage', 'usesDocument', 'ProjectProductDescription', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('InitiationStage', 'usesDocument', 'QualityManagementApproach', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('InitiationStage', 'usesDocument', 'QualityPlan', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('InitiationStage', 'usesDocument', 'RiskManagementApproach', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('PostprojectStage', 'usesDocument', 'BenefitsReviewPlan', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('PostprojectStage', 'usesDocument', 'LessonsLearnedReport', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('PreprojectStage', 'usesDocument', 'ProjectBrief', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('PreprojectStage', 'usesDocument', 'ProjectInitiationDocHIGHLEVEL', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('SubsequentStage', 'usesDocument', 'Backlog', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('SubsequentStage', 'usesDocument', 'DailyLog', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('SubsequentStage', 'usesDocument', 'DeliveryApproachPlan', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('SubsequentStage', 'usesDocument', 'EndStageReport', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('SubsequentStage', 'usesDocument', 'ExceptionReport', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('SubsequentStage', 'usesDocument', 'HighlightReport', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('SubsequentStage', 'usesDocument', 'IssueRegister', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('SubsequentStage', 'usesDocument', 'IssueReport', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('SubsequentStage', 'usesDocument', 'LessonsLog', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('SubsequentStage', 'usesDocument', 'LongtermPlan', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('SubsequentStage', 'usesDocument', 'Product', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('SubsequentStage', 'usesDocument', 'ProductDescription', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('SubsequentStage', 'usesDocument', 'ProductRoadmapPlan', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('SubsequentStage', 'usesDocument', 'ProductStatusAccount', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('SubsequentStage', 'usesDocument', 'QualityRegister', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('SubsequentStage', 'usesDocument', 'RiskRegister', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('SubsequentStage', 'usesDocument', 'StagePlan', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('SubsequentStage', 'usesDocument', 'WorkPackage', '', '', '', '') ; -- predicate: stageFulfillmentBy ------------------------------------------------------- -- INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('FinalStage', 'stageFulfillmentBy', 'ProductDeliveryManaging_process', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('FinalStage', 'stageFulfillmentBy', 'ProjectClosing_process', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('FinalStage', 'stageFulfillmentBy', 'ProjectDirecting_process', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('FinalStage', 'stageFulfillmentBy', 'StageBoundaryManaging_process', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('FinalStage', 'stageFulfillmentBy', 'StageControlling_process', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('InitiationStage', 'stageFulfillmentBy', 'ProjectDirecting_process', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('InitiationStage', 'stageFulfillmentBy', 'ProjectInitiating_process', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('PostprojectStage', 'stageFulfillmentBy', 'ProjectClosing_process', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('PreprojectStage', 'stageFulfillmentBy', 'ProjectStartingUP_process', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('SubsequentStage', 'stageFulfillmentBy', 'ProductDeliveryManaging_process', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('SubsequentStage', 'stageFulfillmentBy', 'ProjectDirecting_process', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('SubsequentStage', 'stageFulfillmentBy', 'StageBoundaryManaging_process', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('SubsequentStage', 'stageFulfillmentBy', 'StageControlling_process', '', '', '', '') ; -- predicate: createsReport ------------------------------------------------------- -- INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('Delivering', 'createsReport', 'EndProjectReport', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('Delivering', 'createsReport', 'EndStageReport', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('Delivering', 'createsReport', 'ExceptionReport', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('Delivering', 'createsReport', 'HighlightReport', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('Delivering', 'createsReport', 'IssueReport', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('Delivering', 'createsReport', 'LessonsLearnedReport', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProgrammManager', 'createsReport', 'EndProjectReport', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProgrammManager', 'createsReport', 'EndStageReport', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProgrammManager', 'createsReport', 'ExceptionReport', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProgrammManager', 'createsReport', 'HighlightReport', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProgrammManager', 'createsReport', 'LessonsLearnedReport', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProjectAssuranceManager', 'createsReport', 'EndProjectReport', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProjectAssuranceManager', 'createsReport', 'EndStageReport', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProjectAssuranceManager', 'createsReport', 'ExceptionReport', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProjectAssuranceManager', 'createsReport', 'HighlightReport', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProjectAssuranceManager', 'createsReport', 'LessonsLearnedReport', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProjectExecutive', 'createsReport', 'ExceptionReport', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProjectExecutive', 'createsReport', 'HighlightReport', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProjectManager', 'createsReport', 'EndProjectReport', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProjectManager', 'createsReport', 'EndStageReport', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProjectManager', 'createsReport', 'ExceptionReport', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProjectManager', 'createsReport', 'HighlightReport', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProjectManager', 'createsReport', 'IssueReport', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProjectManager', 'createsReport', 'LessonsLearnedReport', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('TeamManager', 'createsReport', 'ExceptionReport', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('TeamManager', 'createsReport', 'IssueReport', '', '', '', '') ; -- predicate: reportCreatedBy ----------------------------------------------------- -- INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('EndProjectReport', 'reportCreatedBy', 'Delivering', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('EndStageReport', 'reportCreatedBy', 'Delivering', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ExceptionReport', 'reportCreatedBy', 'Delivering', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('HighlightReport', 'reportCreatedBy', 'Delivering', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('IssueReport', 'reportCreatedBy', 'Delivering', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('LessonsLearnedReport', 'reportCreatedBy', 'Delivering', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('EndProjectReport', 'reportCreatedBy', 'ProgrammManager', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('EndStageReport', 'reportCreatedBy', 'ProgrammManager', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ExceptionReport', 'reportCreatedBy', 'ProgrammManager', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('HighlightReport', 'reportCreatedBy', 'ProgrammManager', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('LessonsLearnedReport', 'reportCreatedBy', 'ProgrammManager', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('EndProjectReport', 'reportCreatedBy', 'ProjectAssuranceManager','', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('EndStageReport', 'reportCreatedBy', 'ProjectAssuranceManager','', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ExceptionReport', 'reportCreatedBy', 'ProjectAssuranceManager','', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('HighlightReport', 'reportCreatedBy', 'ProjectAssuranceManager','', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('LessonsLearnedReport', 'reportCreatedBy', 'ProjectAssuranceManager','', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ExceptionReport', 'reportCreatedBy', 'ProjectExecutive', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('HighlightReport', 'reportCreatedBy', 'ProjectExecutive', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('EndProjectReport', 'reportCreatedBy', 'ProjectManager', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('EndStageReport', 'reportCreatedBy', 'ProjectManager', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ExceptionReport', 'reportCreatedBy', 'ProjectManager', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('HighlightReport', 'reportCreatedBy', 'ProjectManager', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('IssueReport', 'reportCreatedBy', 'ProjectManager', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('LessonsLearnedReport', 'reportCreatedBy', 'ProjectManager', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ExceptionReport', 'reportCreatedBy', 'TeamManager', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('IssueReport', 'reportCreatedBy', 'TeamManager', '', '', '', '') ; -- predicate: analyzesIssue ------------------------------------------------------- -- INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProgrammManager', 'analyzesIssue', 'Issue', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProjectExecutive', 'analyzesIssue', 'Issue', '', '', '', '') ; -- predicate: assignsIssue ------------------------------------------------------- -- INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProgrammManager', 'assignsIssue', 'Issue', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProjectExecutive', 'assignsIssue', 'Issue', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProjectExecutive', 'assignsIssue', 'Issue', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProjectManager', 'assignsIssue', 'Issue', '', '', '', '') ; -- predicate: closesIssue ------------------------------------------------------- -- INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProjectManager', 'closesIssue', 'Issue', '', '', '', '') ; -- predicate: detectsIssue ------------------------------------------------------- -- INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProgrammManager', 'detectsIssue', 'Issue', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProjectAssuranceManager', 'detectsIssue', 'QualityIssue', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProjectExecutive', 'detectsIssue', 'Issue', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProjectExecutive', 'detectsIssue', 'Issue', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProjectManager', 'detectsIssue', 'Issue', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('Stakeholder', 'detectsIssue', 'CommunicationIssue', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('Stakeholder', 'detectsIssue', 'ContractIssue', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('TeamManager', 'detectsIssue', 'DependencyIssue', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('TeamManager', 'detectsIssue', 'ResourceIssue', '', '', '', '') ; -- predicate: escalatesIssue ------------------------------------------------------- -- INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProjectExecutive', 'escalatesIssue', 'Issue', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProjectManager', 'escalatesIssue', 'Issue', '', '', '', '') ; -- predicate: logsIssue ------------------------------------------------------- -- INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProjectManager', 'logsIssue', 'Issue', '', '', '', '') ; -- predicate: escalatesIssue ------------------------------------------------------- -- INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProgrammManager', 'escalatesIssue', 'Issue', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProjectExecutive', 'escalatesIssue', 'Issue', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('Stakeholder', 'escalatesIssue', 'CommunicationIssue', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('Stakeholder', 'escalatesIssue', 'ContractIssue', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('Stakeholder', 'escalatesIssue', 'Issue', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('TeamManager', 'escalatesIssue', 'Issue', '', '', '', '') ; -- predicate: mitigatesIssue ------------------------------------------------------- -- INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProjectAssuranceManager', 'mitigatesIssue', 'QualityIssue', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('TeamManager', 'mitigatesIssue', 'ResourceIssue', '', '', '', '') ; -- predicate: monitorsIssue ------------------------------------------------------- -- INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProgrammManager', 'monitorsIssue', 'Issue', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProjectExecutive', 'monitorsIssue', 'Issue', '', '', '', '') ; -- predicate: preventsIssue ------------------------------------------------------- -- INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProgrammManager', 'preventsIssue', 'Issue', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProjectExecutive', 'preventsIssue', 'Issue', '', '', '', '') ; -- predicate: resolvesIssue ------------------------------------------------------- -- INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProjectAssuranceManager', 'resolvesIssue', 'QualityIssue', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProjectManager', 'resolvesIssue', 'Issue', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('TeamManager', 'resolvesIssue', 'DependencyIssue', '', '', '', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('TeamManager', 'resolvesIssue', 'ResourceIssue', '', '', '', '') ; -- predicate: contributesInDocument & subject data property ------------------------------------------------------- -- INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('Consultant', 'contributesInDocument', 'CommunicationManagementApproach', 'contributingLevel', '', '0.2', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('Consultant', 'contributesInDocument', 'ProjectInitiationDoc', 'contributingLevel', '', '0.1', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('Consultant', 'contributesInDocument', 'ProjectPlan', 'contributingLevel', '', '0.05', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('Consultant', 'contributesInDocument', 'QualityManagementApproach', 'contributingLevel', '', '0.4', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('Consultant', 'contributesInDocument', 'QualityPlan', 'contributingLevel', '', '0.5', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('Consultant', 'contributesInDocument', 'RiskManagementApproach', 'contributingLevel', '', '0.1', '') ; -- predicate: documentApprovedBy & subject data property ------------------------------------------------------- -- INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('Backlog', 'documentApprovedBy', 'ProjectManager', 'approvingCompetenceAt', '', '0.8', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('BaselinePlan', 'documentApprovedBy', 'Board', 'approvingCompetenceAt', '', '0.5', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('BaselinePlan', 'documentApprovedBy', 'Managing', 'approvingCompetenceAt', '', '0.6', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('BenefitsReviewPlan', 'documentApprovedBy', 'Board', 'approvingCompetenceAt', '', '0.5', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('BenefitsReviewPlan', 'documentApprovedBy', 'BusinessLayer', 'approvingCompetenceAt', '', '0.4', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('BenefitsReviewPlan', 'documentApprovedBy', 'Managing', 'approvingCompetenceAt', '', '0.3', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('CommunicationManagementApproach', 'documentApprovedBy', 'Board', 'approvingCompetenceAt', '', '0.3', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('CommunicationManagementApproach', 'documentApprovedBy', 'Managing', 'approvingCompetenceAt', '', '0.4', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('DailyLog', 'documentApprovedBy', 'ProjectManager', 'approvingCompetenceAt', '', '1.0', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('DeliveryApproachPlan', 'documentApprovedBy', 'Board', 'approvingCompetenceAt', '', '0.8', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('DeliveryApproachPlan', 'documentApprovedBy', 'BusinessLayer', 'approvingCompetenceAt', '', '0.4', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('DeliveryApproachPlan', 'documentApprovedBy', 'Managing', 'approvingCompetenceAt', '', '0.3', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('EndProjectReport', 'documentApprovedBy', 'Board', 'approvingCompetenceAt', '', '0.8', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('EndProjectReport', 'documentApprovedBy', 'BusinessLayer', 'approvingCompetenceAt', '', '0.4', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('EndStageReport', 'documentApprovedBy', 'Managing', 'approvingCompetenceAt', '', '0.5', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('EndStageReport', 'documentApprovedBy', 'ProjectManager', 'approvingCompetenceAt', '', '0.8', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ExceptionManagementPlan', 'documentApprovedBy', 'Managing', 'approvingCompetenceAt', '', '0.3', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ExceptionReport', 'documentApprovedBy', 'Board', 'approvingCompetenceAt', '', '0.6', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ExceptionReport', 'documentApprovedBy', 'BusinessLayer', 'approvingCompetenceAt', '', '0.5', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ExceptionReport', 'documentApprovedBy', 'Managing', 'approvingCompetenceAt', '', '0.5', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('HighlightReport', 'documentApprovedBy', 'ProjectManager', 'approvingCompetenceAt', '', '0.8', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('IssueRegister', 'documentApprovedBy', 'Managing', 'approvingCompetenceAt', '', '0.9', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('IssueReport', 'documentApprovedBy', 'ProjectManager', 'approvingCompetenceAt', '', '0.8', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('LessonsLearnedReport', 'documentApprovedBy', 'Board', 'approvingCompetenceAt', '', '0.8', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('LessonsLog', 'documentApprovedBy', 'Board', 'approvingCompetenceAt', '', '0.2', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('LessonsLog', 'documentApprovedBy', 'Managing', 'approvingCompetenceAt', '', '0.3', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('LongtermPlan', 'documentApprovedBy', 'Board', 'approvingCompetenceAt', '', '0.4', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProductChecklist', 'documentApprovedBy', 'Managing', 'approvingCompetenceAt', '', '0.8', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProductChecklist', 'documentApprovedBy', 'ProjectAssuranceManager', 'approvingCompetenceAt', '', '0.9', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProductChecklist', 'documentApprovedBy', 'ProjectManager', 'approvingCompetenceAt', '', '0.9', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProductDescription', 'documentApprovedBy', 'Board', 'approvingCompetenceAt', '', '0.8', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProductDescription', 'documentApprovedBy', 'Managing', 'approvingCompetenceAt', '', '0.8', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProductRoadmapPlan', 'documentApprovedBy', 'Board', 'approvingCompetenceAt', '', '1.0', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProductRoadmapPlan', 'documentApprovedBy', 'BusinessLayer', 'approvingCompetenceAt', '', '0.4', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProductRoadmapPlan', 'documentApprovedBy', 'Managing', 'approvingCompetenceAt', '', '0.3', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProductStatusAccount', 'documentApprovedBy', 'Managing', 'approvingCompetenceAt', '', '0.4', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProjectBrief', 'documentApprovedBy', 'Board', 'approvingCompetenceAt', '', '1.0', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProjectInitiationDoc', 'documentApprovedBy', 'Board', 'approvingCompetenceAt', '', '0.8', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProjectInitiationDocHIGHLEVEL', 'documentApprovedBy', 'BusinessLayer', 'approvingCompetenceAt', '', '0.6', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProjectManagementTeamStructure', 'documentApprovedBy', 'ProjectManager', 'approvingCompetenceAt', '', '1.0', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProjectPlan', 'documentApprovedBy', 'Board', 'approvingCompetenceAt', '', '1.0', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProjectPlan', 'documentApprovedBy', 'Managing', 'approvingCompetenceAt', '', '0.5', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProjectPlan', 'documentApprovedBy', 'ProjectManager', 'approvingCompetenceAt', '', '0.8', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProjectProductDescription', 'documentApprovedBy', 'BusinessLayer', 'approvingCompetenceAt', '', '0.8', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('QualityManagementApproach', 'documentApprovedBy', 'Managing', 'approvingCompetenceAt', '', '0.8', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('QualityManagementApproach', 'documentApprovedBy', 'ProjectAssuranceManager', 'approvingCompetenceAt', '', '0.9', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('QualityManagementApproach', 'documentApprovedBy', 'ProjectManager', 'approvingCompetenceAt', '', '0.9', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('QualityPlan', 'documentApprovedBy', 'Managing', 'approvingCompetenceAt', '', '0.8', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('QualityPlan', 'documentApprovedBy', 'ProjectAssuranceManager', 'approvingCompetenceAt', '', '0.9', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('QualityPlan', 'documentApprovedBy', 'ProjectManager', 'approvingCompetenceAt', '', '0.9', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('QualityRegister', 'documentApprovedBy', 'ProjectAssuranceManager', 'approvingCompetenceAt', '', '0.9', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('Register', 'documentApprovedBy', 'ProjectManager', 'approvingCompetenceAt', '', '0.75', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('RiskManagementApproach', 'documentApprovedBy', 'ProjectAssuranceManager', 'approvingCompetenceAt', '', '0.7', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('RiskManagementApproach', 'documentApprovedBy', 'ProjectManager', 'approvingCompetenceAt', '', '0.8', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('RiskRegister', 'documentApprovedBy', 'Managing', 'approvingCompetenceAt', '', '0.9', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('RiskRegister', 'documentApprovedBy', 'ProjectManager', 'approvingCompetenceAt', '', '0.75', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('StagePlan', 'documentApprovedBy', 'Managing', 'approvingCompetenceAt', '', '0.8', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('StagePlan', 'documentApprovedBy', 'ProjectManager', 'approvingCompetenceAt', '', '0.9', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('WorkPackage', 'documentApprovedBy', 'ProjectAssuranceManager', 'approvingCompetenceAt', '', '0.4', '') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('WorkPackage', 'documentApprovedBy', 'ProjectManager', 'approvingCompetenceAt', '', '0.9', '') ; -- predicate: documentCreatedBy & subject data property & object data property ------------------------------------------------------- -- INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProjectBrief', 'documentCreatedBy', 'Owner', 'documentAsActorsContribution', 'actorsEffortAtDocumentCreation', 'MEDIUM', '0.4') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProjectBrief', 'documentCreatedBy', 'ProjectExecutive', 'documentAsActorsContribution', 'actorsEffortAtDocumentCreation', 'HIGH', '0.5') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProjectBrief', 'documentCreatedBy', 'SeniorUser', 'documentAsActorsContribution', 'actorsEffortAtDocumentCreation', 'LOW', '0.1') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProjectInitiationDoc', 'documentCreatedBy', 'Owner', 'documentAsActorsContribution', 'actorsEffortAtDocumentCreation', 'MEDIUM', '0.2') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProjectInitiationDoc', 'documentCreatedBy', 'ProjectExecutive', 'documentAsActorsContribution', 'actorsEffortAtDocumentCreation', 'MEDIUM', '0.35') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProjectInitiationDoc', 'documentCreatedBy', 'ProjectManager', 'documentAsActorsContribution', 'actorsEffortAtDocumentCreation', 'HIGH', '0.3') ; INSERT INTO TRIPLETS (subject_IRI, predicate_IRI, object_IRI, subject_data_property_IRI, object_data_property_IRI, subject_data_property_value, object_data_property_value) VALUES ('ProjectInitiationDoc', 'documentCreatedBy', 'SeniorUser', 'documentAsActorsContribution', 'actorsEffortAtDocumentCreation', 'LOW', '0.15') ; COMMIT ; /* end of upload_triplets.sql */