Cypher Queries

Cypher Query to Load the CSV file and to create the Concept graph

LOAD CSV WITH HEADERS FROM "https://s3.ap-south-1.amazonaws.com/knowledge-hub/SpringFrameworkOntology.csv" AS row CREATE (:Concept {Id1: row.identity, name: row.name,parent_id: row.parentId,relation:row.parentRelation,type: row.type, context: row.context,classType: row.type});

match (child:Concept) where not ((child)-[:subconceptOf]->()) with (child) match (parent:Concept) where parent.parent_id = child.Id1 create (parent)-[:subconceptOf]->(child)

Cypher Query to Load the CSV file and to create the Intent graph

TrialLevel.csv

LOAD CSV WITH HEADERS FROM "https://s3.ap-south-1.amazonaws.com/knowledge-hub/TrialLevel.csv" AS row CREATE (:Level {id2: row.identity, name: row.name, parent_id: row.parentId, type: row.type, parent_node_type: row.parentNodeType})

TrialLevel.csv (relationship)

MATCH (parent:Level) MATCH (child:Level) WHERE parent.parent_id = child.id2 create (parent)-[:levelOf]->(child)

TrialTerm.csv

LOAD CSV WITH HEADERS FROM "https://s3.ap-south-1.amazonaws.com/knowledge-hub/TrialTerm2.csv" AS row CREATE (:Terms {id3: row.identity, name: row.name, parent_id: row.parentId, type: row.type, parent_node_type: row.parentNodeType,weight: row.weight,relationship:row.parentRelation})

Connect Intent and Term graph

MATCH (child:Level) MATCH (parent:Terms) WHERE parent.parent_id = child.id2 create (parent)-[:termsOf]->(child)