Neo4j 数据血缘分析可视化

用工具获取数据的血缘关系用Neo4j可视化 添加节点   

CREATE (PRODUCT:TABLES {title:'PRODUCT', tagline:'once upon a time'})

CREATE (PROFIT_RATE_89:TABLE1 {name:'PRODUCT', id_:89,column_name:'PROFIT_RATE'})

CREATE (PROFIT_RATE_75:TABLE2 {name:'TMP_TABLE', id_:75,column_name:'PROFIT_RATE'})

CREATE (COST_50:TABLE3 {name:'RESULT_OF_FHJ', id_:50,column_name:'COST'})

CREATE (PROFIT_49:TABLE3 {name:'RESULT_OF_FHJ', id_:49,column_name:'PROFIT'})

CREATE (TOTAL_COST_41:TABLE4 {name:'FACT_BILL', id_:41,column_name:'TOTAL_COST'})

CREATE (TOTAL_COST_38:TABLE4 {name:'FACT_BILL', id_:38,column_name:'TOTAL_COST'})

CREATE (TURNOVER_39:TABLE4 {name:'FACT_BILL', id_:39,column_name:'TURNOVER'})

 添加关系  

CREATE

(TOTAL_COST_38)-[:FLOW]->(PROFIT_49),

(TURNOVER_39)-[:FLOW]->(PROFIT_49),

(PROFIT_49)-[:FLOW]->(PROFIT_RATE_75),

(PROFIT_RATE_75)-[:FLOW]->(PROFIT_RATE_89),

(TOTAL_COST_41)-[:FLOW]->(COST_50),

(COST_50)-[:FLOW]->(PROFIT_RATE_75),

(PROFIT_RATE_89)-[:FLOW]->(PRODUCT)

 查询 MATCH (a)-[:FLOW]->(m) RETURN a,m  结果展示