Hacker News Reader

HNHacker News

Top New Best Ask Show Jobs

Comment by jcgrillo | Hacker News Reader

Parent Full thread

jcgrillo·

Are there any? My experience so far with graph databases is a resounding failure.

View on HN

I'm using Neo4j to build a CMDB and it is awesome.

That's good to hear, how large is the graph you're building (nodes, edges) and how do queries perform?

The big issue we have had with Neo4J was with replication, when we do MASSIVE updates. For the rest, it handles the charge reasonably well.

What constitutes a massive update?

Not very big since it is only used internally at my company. 5 digit node count and high 6 digit relationships count. Queries are usually very fast unless you try to do something stupid that ends up having to search the entire graph. indexing critical high-cardinality properties and thinking of relationships as a kind of index help a lot with query performance. I have been meaning to test how fast memgraph is.

What is a "CMDB"?

A Configuration Management Database (CMDB) is a centralized repository that stores information about Configuration Items (CIs), including their attributes and relationships. It's a key component of IT service management (ITSM), providing visibility into the components that make up IT services, like hardware, software, and documentation

Interesting!

It can be incredibly useful. One example is to have every every process linked to the VM it is running on and the host the VM is running on and the TCP port the process is listening on. If you have all the correct relationships defined then you can write a query like this to find every process on every VM listening on port 80 on a given VM host.

MATCH p = (host:VMHOST {name: 'your_host_name'})-[:RUNS]->(vm)-[:HAS_SERVICE]->(service)-[:EXPOSES_PORT]->(port:TCPPORT {port: 80}) RETURN p

This can save a absurd amount of time for analyzing the impacts of failures and security isolation compliance.

In OSS or generally?

Either, tbh?

Reply on news.ycombinator.com