{"id":10349,"date":"2023-07-12T20:39:33","date_gmt":"2023-07-13T01:39:33","guid":{"rendered":"https:\/\/www.rushworth.us\/lisa\/?p=10349"},"modified":"2023-09-05T11:42:54","modified_gmt":"2023-09-05T16:42:54","slug":"neo4j-exploring-the-data","status":"publish","type":"post","link":"https:\/\/www.rushworth.us\/lisa\/?p=10349","title":{"rendered":"NEO4J: Exploring the Data"},"content":{"rendered":"

Since I seem to frequently acquire orphaned platforms with no documentation, I figure it would be good to figure out how to investigate an unknown NEO4J platform to see what it\u2019s got. \u201cSHOW\u201d is very useful in these cases. The full list of SHOW commands is:<\/p>\n

\"ALIAS\"\r\n\"ALIASES\"\r\n\"ALL\"\r\n\"BTREE\"\r\n\"BUILT\"\r\n\"CONSTRAINT\"\r\n\"CONSTRAINTS\"\r\n\"CURRENT\"\r\n\"DATABASE\"\r\n\"DATABASES\"\r\n\"DEFAULT\"\r\n\"EXIST\"\r\n\"EXISTENCE\"\r\n\"EXISTS\"\r\n\"FULLTEXT\"\r\n\"FUNCTION\"\r\n\"FUNCTIONS\"\r\n\"HOME\"\r\n\"INDEX\"\r\n\"INDEXES\"\r\n\"KEY\"\r\n\"LOOKUP\"\r\n\"NODE\"\r\n\"POINT\"\r\n\"POPULATED\"\r\n\"PRIVILEGE\"\r\n\"PRIVILEGES\"\r\n\"PROCEDURE\"\r\n\"PROCEDURES\"\r\n\"PROPERTY\"\r\n\"RANGE\"\r\n\"REL\"\r\n\"RELATIONSHIP\"\r\n\"ROLE\"\r\n\"ROLES\"\r\n\"SERVER\"\r\n\"SERVERS\"\r\n\"SETTING\"\r\n\"SETTINGS\"\r\n\"SUPPORTED\"\r\n\"TEXT\"\r\n\"TRANSACTION\"\r\n\"TRANSACTIONS\"\r\n\"UNIQUE\"\r\n\"UNIQUENESS\"\r\n\"USER\"\r\n\"USERS\"<\/pre>\n
The most useful ones for figuring out what you\u2019ve got \u2026 the \u201cshow databases\u201d command I know from MySQL\/MariaDB does what I expected \u2013 you can also include a specific database name, but \u201cshow database ljrtest\u201d doesn\u2019t appear to list any more information than the generic show databases command. .<\/p>\n
<\/p>\n
There\u2019s also a \u201cshow users\u201d command that outputs the users in the database \u2013 although I\u2019m using the community edition without authentication, so there isn\u2019t much interesting information being output here.<\/p>\n
<\/p>\n
And roles, if roles are being used, should be output with \u201cSHOW ALL ROLES\u201d \u2026 but mine just says \u201cUnsupported administration command\u201d<\/p>\n
Once you know what databases you\u2019ve got and who can log in and do stuff, we\u2019d want to look at the data. There are some built-in functions that will help us out here. The db.labels() function will list the labels in the selected database.<\/p>\n
<\/p>\n
You can also return a distinct list of labels along with the count of nodes with that label:<\/p>\n
<\/p>\n
Since a node can have multiple, comparing that total with a count of nodes would give you an idea if there are many more labels than nodes. In my case, either view shows 156 \u2026 so I know there are few (if any) nodes with multiple labels.<\/p>\n
<\/p>\n
To view the types of relationships defined in the selected database, use \u201cCALL db.relationshipTypes()\u201d<\/p>\n
<\/p>\n
Similarly, you can return the relationship types along with counts<\/p>\n
<\/p>\n
There is a function to list the property keys used within the data \u2013 interesting to note that keys that were used but the nodes using them were subsequently deleted \u2026 they still show up as property keys. Basically, anything that is there is on this list but some things on this list may not be there anymore. In this example, \u2018parentm\u2019 and \u2018parentf\u2019 were labels I used to build relationships programmatically.<\/p>\n
<\/p>\n
I\u2019ve found db.schema.nodeTypeProperties to be more useful in this regard \u2013 it does not appear to list properties that are not in use, and the output includes field types<\/p>\n
<\/p>\n
To see if there are any custom procedures or functions registered, look on the server(s). Use ps -efww to view the running command \u2013 there will be some folders listed after \u201c-cp\u201d \u2026 you could find procedures or plugins in any of those folders. In my case, the plugins are in \/plugins<\/p>\n
<\/p>\n
And the only \u201ccustom\u201d things registered are the APOC and APOC-Extended jar\u2019s<\/p>\n
<\/p>\n
 <\/p>\n","protected":false},"excerpt":{"rendered":"
Since I seem to frequently acquire orphaned platforms with no documentation, I figure it would be good to figure out how to investigate an unknown NEO4J platform to see what it\u2019s got. \u201cSHOW\u201d is very useful in these cases. The full list of SHOW commands is: “ALIAS” “ALIASES” “ALL” “BTREE” “BUILT” “CONSTRAINT” “CONSTRAINTS” “CURRENT” “DATABASE” …<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1896],"tags":[1902,1897],"class_list":["post-10349","post","type-post","status-publish","format-standard","hentry","category-neo4j","tag-cypher","tag-neo4j"],"_links":{"self":[{"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/posts\/10349","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=10349"}],"version-history":[{"count":1,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/posts\/10349\/revisions"}],"predecessor-version":[{"id":10362,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/posts\/10349\/revisions\/10362"}],"wp:attachment":[{"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=10349"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=10349"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=10349"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}