Neo4j 数据血缘分析可视化

为什么80%的码农都做不了架构师？>>>   

1. 用工具获取数据的血缘关系
2. 用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

•  结果展示

 

转载于:https://my.oschina.net/aubao/blog/2964224