Note
If you are looking for a quick ( non-detailed ) summary of relational and graph models, you are in the right place.
Database Model
It’s a conceptual representation of a database, describing the structure, relationships, constraints, and rules that govern the data stored in it.
Relational Database Model
- It's the most popular and widely used model.
- Data organized in form of tables ( rows-columns structure ).
- Data has a fixed schema.
- Components are Tables (rows/columns), Relations ( keys ).
- Database composed of multiple tables.
- Each table represents an entity.
- Those tables are connected by relationships ( using referring keys between them ).
- Table columns describe the properties of this entity.
- Table rows are instances of this entity.
Graph Database Model
- It's one of the most powerful models.
- It's based on the "Graph Theory".
- Data has no fixed schema, it's flexible.
- Data organized in form of Nodes ( Vertices ) and Edges ( Relationships )
- Components are Nodes and Edges
- Each component belongs to a specific category ( entity or relationship )
- Nodes represent instances of entities.
- Edges represent instances of relationships.
- Those nodes/entities connected by the Edges/relationships.
Top comments (0)