0

Organisation dealing with HR data (60 GB+ every day).

How to query Organisation hierarchical data in efficient manner. Suppose want to query -

a) At which level, a person is there in an organisation tree? b) How many direct reportees and indirect reportees are there for a person e.g. A has 2 direct reportees (B and C) and B/C has 10 direct reportees each. Then in this case, Total indirect reportees for A = 20 and Total reportees for A = 22

Which framework will be best for this? Should we go for Neo4j which provides Cypher Query Language, Spark GraphX, Spark GraphDF etc.?

Some quick example code will help a lot.

Bhavuk Chawla
  • 212
  • 1
  • 10

1 Answers1

1

Use cypher for both -

a) To find out where the employee is in the organization relative to the top boss: 

MATCH (e:Employee {empid: "ID"})-[r:REPORTS_TO*]->(boss:Employee)
return e, r, boss

b) To find the employees that are direct and indirect reports of an employee: 

MATCH (e:Employee {empid: "ID"})<-[r:REPORTS_TO*1..2]-(sub:Employee)
return e, r, sub
Tim Kuehn
  • 3,201
  • 1
  • 17
  • 23