One especially important type of graph is the property graph. This is the type of graph to be used in a “detective” web application where users can help build a case against the global oligarchy.
The first major decision to make is what database to use. A graph database provides much faster traversing than a typical RDBMS. Neo4j.
Sample SQL schemas from police dbs. These are good starting points for a relational database.
A simple “whiteboard” representation of the data I was looking at:
Can use a class/fractal approach.
People are members of Organizations are members of Organizations
Register:
Validation:
Success:
Login:
Validation:
Success:
Home Page:
Other Users:
Change PW:
PW Validation:
Success:
Change Email:
Email Validation:
Success:
All nodes:
One node:
2nd degree:
3rd degree:
Node connection:
New node:
Labels:
?:
One node:
?:
?:
?:
New node:
Labels:
?:
?:
?:
?:
?: