Graph Database | Relational Database |
---|---|
Graph database store data as node. | Relational database uses tables to store data |
Graph database uses nodes with entities | Relational database uses schemas with nullables |
Graph database uses relations as the first class | Relational database uses relations with foreign keys |
Graph database relates to data fetching with a pattern | Relational database uses related data fetched with joins |
Graph Database | Document Database |
---|---|
Graph database stores data in nodes | Document database stores data in a document |
Graph database doesn't contain any schema | Document database doesn't contain schema |
Graph database perform relation has the first class citizens | Document database contains the relations with foreign keys or embedded |
Graph database contain related data fetched with a patterns | Document database related to data fetched with joins or embedded |
Work_For
. The black ones have the names Skilled_At
. The company that has these graphs is interesting in matching people with particular skills. An interesting query would would be one that follows a questions and that relationships contain properties that score in the Skill_AT
.
The top layer consists of nodes representing rights. These are bundled in the second layer, which are the security groups. The relationships within the groups and the rights are called Contains. People are on the third layer and can be in one or more groups by the relationship Has_Groups
. Which are also connected to individual right by the right grounded or are denied relationship.
Here is a product along an on the ground map which is atypical example of a graph. Stations are nodes with connections in between which are relationships. But relationships could contain a travel time. With a query it is possible to calculate the shortest route one station to other or determine a route based on other criteria.