Google Cloud Digital LeaderData and AI with Google CloudMedium
A global logistics company wants to optimize its supply chain by predicting potential delays and optimizing delivery routes. They need to analyze complex relationships between various entities such as warehouses, suppliers, transportation routes, and delivery schedules. The analytics require traversing these interconnected entities efficiently. Which type of database is best suited for this use case?
- ADocument Database
- BKey-Value Store
- CGraph Database
- DRelational Database
Show answer & explanationAnswer & explanation
Correct answer: C. Graph Database
A graph database is ideal for modeling and querying interconnected data, such as relationships in a supply chain. It excels at efficiently traversing complex networks to find paths, identify bottlenecks, and understand dependencies, which is perfect for route optimization and delay prediction.
Why the other options are wrong
- A. Document databases are good for flexible, semi-structured data, but not optimized for relationship traversal.
- B. Key-value stores are for simple data lookups, not complex relationship analysis.
- D. Relational databases struggle with complex, highly interconnected data due to expensive join operations.
Graph Database
A NoSQL database that uses graph structures for semantic queries with nodes, edges, and properties to represent and store data. It is optimized for managing highly connected data.
- Excels at modeling complex relationships between entities.
- Efficiently traverses connections for pathfinding and network analysis.
- Used for recommendation engines, fraud detection, social networks, and logistics.
Memory trick: For 'Graph' data, think of a 'Graph' of connections, like a spiderweb of relationships.