Learning Neo4j 3.x - Second Edition

Which applications are used in which buildings?

Let's say that we would like to use the graph model to determine which applications are used in specific locations/buildings of our corporation. Then, our Cypher query would look something as follows:

MATCH (app:Application)<-[:USES]-(proc:Process)-[:USED_BY]->(bl:BusinessLine)-[:LOCATED_IN]->(b:Building) RETURN DISTINCT app.name AS Application , b.name AS Building ORDER BY app.name ASC;

Note that this is quite an expensive query to run as it does not use any specific starting points in our graph traversals--it is a global query. However, the result comes back quickly for this dataset.

Results ...