I am new to graph databases in general, I played around with DGraph a bit and I am currently looking into ES X-Pack plugin which gives graph-like functionalities.
My requirement is something like this:
I have an account, a permission_set and bunch of roles. Each account is assigned a specific permission set and each permission set has got bunch of enabled roles.
A role could be an aggregate role, meaning, it could have bunch of roles under them.
Act001 --> PSet001
PSet001 --> List[R1, R2, R3*]
R3 --> List[R6*, R7]
R6 --> [R9, R22]
When I query with account id - Act001 - I would need to pull all the roles per account(including the aggregated roles).
ie: List[R1, R2, R3, R6, R7, R9, R22]
I was able to achieve it with Dgraph and Dgraph way of storing data is different compared to ES.
Is this possible with elasticsearch graph API?