Re:Stay Ahead of Cyber Threats with Graph Databases
by cbsmith on Tuesday January 24, 2023 @09:31PM
(#34513649)
Except a lot of relational databases have something like "connect by" that do the job pretty well... and of course if you design your graph wrong, a graph database is going to perform poorly as well.
It is much simpler and more efficient to use a graph database especially to make a complex query where a leaf node circles back either to a "source" or to any intermediate node using the same or a new relationship. SQL will look nightmarish and will likely require manual hints to the query planner / optimiser.
Graph databases also allow to add (as well as delete) new relationships in an incremental and non-invasive fashion, as they become discovered – a useful feature for the analysis of a large or unknown dataset.
Graph databases require valid use cases, though, and they are not a generic substitute for a RDBMS (or for a random NoSQL database).