{"id":790,"date":"2019-06-08T21:19:37","date_gmt":"2019-06-08T21:19:37","guid":{"rendered":"http:\/\/marcel-jan.eu\/datablog\/?p=790"},"modified":"2019-06-09T09:34:58","modified_gmt":"2019-06-09T09:34:58","slug":"loading-rocket-data-in-a-graph-database-neo4j","status":"publish","type":"post","link":"https:\/\/marcel-jan.eu\/datablog\/2019\/06\/08\/loading-rocket-data-in-a-graph-database-neo4j\/","title":{"rendered":"Neo4J: Loading rocket data in a graph database"},"content":{"rendered":"<p>When I first learned about graph databases, like Neo4J, I didn&#8217;t get it. That&#8217;s how I always start with new technology: not getting at all why people getting so enthusiastic about them. Then I read &#8220;Seven Databases in Seven Weeks, 2nd edition&#8221; (<a href=\"https:\/\/marcel-jan.eu\/datablog\/2019\/01\/05\/book-review-seven-databases-in-seven-weeks\/\">as reviewed in January<\/a>). It describes Neo4J as a &#8220;whiteboard friendly&#8221;. Any diagram with boxes and lines you could draw on a whiteboard, can be stored in Neo4J. After reading the first paragraphs about Neo4J, I totally got why graph databases are very interesting.<\/p>\n<p>As usual, I started following a course on Neo4J to get acquainted with the product. Well there was a course on Neo4J on Udemy.com and I followed it. But it was 3 years old and some of the code it teached, is already obsolete. So the less I say about that, the better. But I did learn some Cypher, the language used in Neo4J, and I later learned the more modern versions of the commands to get stuff done.<\/p>\n<p>Next phase: do a project with it. It took me some time to think of interesting astronomy or space related data in it. Eventually I stumbled on a dataset that has been around and maintained for a long time. At least since I discovered when I just got on the Internet around 1993. It&#8217;s called <a href=\"https:\/\/planet4589.org\/space\/\">Jonathan&#8217;s Space Page<\/a> now. And the maintainer, Jonathan McDowell, still keeps the <a href=\"https:\/\/planet4589.org\/space\/log\/launch.html\">list of orbital space launches<\/a> and <a href=\"https:\/\/planet4589.org\/space\/log\/satcat.txt\">list of satellites<\/a> ever launched quite up to date.<\/p>\n<p>And eventually I did manage to load this data in Neo4J and here is my video about that:<\/p>\n<p><iframe loading=\"lazy\" title=\"Loading rocket data in Neo4J\" width=\"750\" height=\"422\" src=\"https:\/\/www.youtube.com\/embed\/JhECZExouFQ?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<p>You can download Neo4J Desktop here:<\/p>\n<p>https:\/\/neo4j.com\/download-center\/#desktop<\/p>\n<p>You can find my Python and Cypher code here:<\/p>\n<p><a href=\"https:\/\/github.com\/Marcel-Jan\/neo4j_satellites\">https:\/\/github.com\/Marcel-Jan\/neo4j_satellites<\/a><\/p>\n<p>Let me know if you want me to go in depth on the code used in this video.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>When I first learned about graph databases, like Neo4J, I didn&#8217;t get it. That&#8217;s how I always start with new technology: not getting at all why people getting so enthusiastic about them. Then I read &#8220;Seven Databases in Seven Weeks, 2nd edition&#8221; (as reviewed in January). It describes Neo4J as [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[165,55,102],"tags":[190,188,189,173,166],"class_list":["post-790","post","type-post","status-publish","format-standard","hentry","category-active-learning","category-howto","category-nosql","tag-cypher","tag-graph-database","tag-jonathans-space-page","tag-neo4j","tag-seven-databases-in-seven-weeks"],"_links":{"self":[{"href":"https:\/\/marcel-jan.eu\/datablog\/wp-json\/wp\/v2\/posts\/790","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/marcel-jan.eu\/datablog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/marcel-jan.eu\/datablog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/marcel-jan.eu\/datablog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/marcel-jan.eu\/datablog\/wp-json\/wp\/v2\/comments?post=790"}],"version-history":[{"count":5,"href":"https:\/\/marcel-jan.eu\/datablog\/wp-json\/wp\/v2\/posts\/790\/revisions"}],"predecessor-version":[{"id":803,"href":"https:\/\/marcel-jan.eu\/datablog\/wp-json\/wp\/v2\/posts\/790\/revisions\/803"}],"wp:attachment":[{"href":"https:\/\/marcel-jan.eu\/datablog\/wp-json\/wp\/v2\/media?parent=790"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/marcel-jan.eu\/datablog\/wp-json\/wp\/v2\/categories?post=790"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/marcel-jan.eu\/datablog\/wp-json\/wp\/v2\/tags?post=790"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}